Gary had a problem with his SQLite database - so I'm starting this thread to handle trouble shooting for those using the SQLite database option.
Information on TransTRBO's Databases
Documentation for the TransTRBO Databases can be downloaded from here: http://www.transtrbo.com/files/MySQL_Creates.doc
SQLite - Vn 3
SQLite is Freeware and open source and can be found at http://www.sqlite.org. It is compiled into the base application and thus it is "built in" to TransTRBO.
You can download their utilities from their website or from this link to a zip file that also contains my *.bat Files (I use them 'cos I'm lazy - you just have to replace my database file name with yours in the *.bat files. BTW: the good part is if you do that you can double click go.bat file in Explorer and it will automatically start the Command Line Window).
Steps for Maintenance
- Determine where the existing Database is stored
- Start TransTRBO & log in
- Select Configure System
- Select Database Settings
- Press the database browse button
(If you know how - you can select all of the File Path, copy it to clipboard , save it to Notepad and Exit from TransTRBO)
- Press the symbol pointed at by the Yellow indicator to see where the SQLite folder is and take a note of the path
- Take a note of the path and also the *.DB file which is the SQLite database file.
- Cancel out from here and Exit TransTRBO
- In Windows Explorer find the Database folder and make a backup copy of the database file
- Download the SQLite utility files
- Copy the sqlite3.exe file (unzip if required) to the Database Folder containing your database file (from above)
- Start a Command Line Window in the same Database Folder (google it - if need be)
- In the Command Line type: sqlite3 your-database-name
(In my case I type the following)
Code: Select all
- At the sqlite> prompt: type each line and press Enter (see screenie)
Code: Select all
drop table GpsRequestLineTable;
drop table GpsRequestHeaderTable;
- Press Ctrl-C to exit
- Restart TransTRBO and try to create a Poll List again
Well hopefully that will give you a bit of an idea - most SQL command lines are very similar - all those "drop" commands really just delete those tables and they'll be recreated when TransTRBO starts again