GPS Request List - ** SOLVED **

Please start a new thread for each new bug detected. This will allow for easy tracking and hopefully, contributions by others.
Forum rules
Please state the Version number of TransTRBO, the Database type (Registry, SQLite or MySQL) that you are using.
This will help in tracking any bugs
Post Reply
User avatar
Administrator
Site Admin
Posts: 379
Joined: Mon Jul 21, 2014 5:48 am

GPS Request List - ** SOLVED **

Post by Administrator »

First bug report:
TransTRBO Vn 0.1.0.2
SQLite
GPS Request list entries not being saved. :oops:
Geriatrics Generate Methane.
Grafitti Clifton Hill 1974
Living proof 2021
User avatar
Administrator
Site Admin
Posts: 379
Joined: Mon Jul 21, 2014 5:48 am

Re: GPS Request List

Post by Administrator »

Well - I've found the problem - a fix should be in the next release - atm I'm trying to think of an any easy work around.
Will B
Geriatrics Generate Methane.
Grafitti Clifton Hill 1974
Living proof 2021
User avatar
Administrator
Site Admin
Posts: 379
Joined: Mon Jul 21, 2014 5:48 am

Re: GPS Request List - ** SOLVED **

Post by Administrator »

Hi guys,

A work around:-
1. Exit TT if it's running.
2. You will need to determine the directory/folder where the SQLite Database is stored.
(Default: ?:\CVS_Projects\TransTRBO\SQLite)
3. Determine your Radio's Serial Number
4. Download the SQLite command line utility - sqlite3.exe, from their site or here http://www.transtrbo.com/files/sqlite3.exe
(copy the sqlite3.exe tothe SQLite database folder #2)
5. Open a Windows Command box in that folder
6. Type the following in the command window (xxxxxx - is your radio serial number):

Code: Select all

sqlite3.exe TT_xxxxxx.DB
7. At the "sqlite>" prompt - type:

Code: Select all

drop table gpsrequestheadertable;
.exit
Open TT and check that you can now create a GPS Request list.

cheers
Will B
Open a Windows Command box in that folder
Geriatrics Generate Methane.
Grafitti Clifton Hill 1974
Living proof 2021
krioux
Posts: 13
Joined: Sun Aug 31, 2014 5:30 pm

Re: GPS Request List - New error

Post by krioux »

Using SQL Lite and trying to add a new list:
Error screen
Error screen
2014-10-02 23_24_36-TransTRBO.png (30.09 KiB) Viewed 9933 times
TransTRBO 1.0.3

Works well with registry

I am quite sure the fix above will fix this issue...
User avatar
Administrator
Site Admin
Posts: 379
Joined: Mon Jul 21, 2014 5:48 am

Re: GPS Request List - ** SOLVED **

Post by Administrator »

Hi Karl,

Did you try the work-around suggested in the post just prior to yours ?

cheers
Will
Geriatrics Generate Methane.
Grafitti Clifton Hill 1974
Living proof 2021
krioux
Posts: 13
Joined: Sun Aug 31, 2014 5:30 pm

Re: GPS Request List - ** SOLVED **

Post by krioux »

I did and it worked!
Post Reply