Error while creating MySQL-tables
Brought to you by:
jorib
Menu
▾
▴
#1 Error while creating MySQL-tables
Hello,
I've downloaded Forerunner X01 (ver.0.95) and tried
to install it. However I get this error whenever I
try to create the MySQL-tables:
$ ./install_gpsdata_db install
Creating new database...
Upgrading database to version 1.
ERROR 1060 (42S21) at line 29: Duplicate column
name 'lappoint'
All done!
Any suggestions? (looks to me like there's something
wrong with the db/*.sql files... but I'm no expert in
SQL...).
I'm using MySQL 4.1.15 on a Kubuntu(Dapper)-machine.
Thanks for your help
Cheers,
Olaf
Logged In: YES
user_id=49362
I've looked into it some more:
Deleting line 29(alter table track add column lappoint
smallint default 0;) in gpsdata_upd1.sql and then executing
# mysql -u gpsuser -p < gpsdata_db.sql
# mysql -u gpsuser -p < gpsdata_upd1.sql
# mysql -u gpsuser -p < gpsdata_upd2.sql
sets up the database correctly.
readTrackData seems to work now, too :-)
Thanks for the great software!