Romcenter

Add new rom path
Add rom path <MyPath>
Loading 508 files in DB
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 384
s
Invalid token

GDS Code: 335544569Error Code: 249
200 files loaded
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 392
N
Invalid token

GDS Code: 335544569Error Code: 249
400 files loaded
508 files loaded
Analyse new files
Updating games status
Status updated for 109 items.
Green games : 89, yellow games : 0, red games : 20
Updating fileslist
  Query Paths list
Execution time: 0h 0m 15s

Created a new database from the attached datafile [attachment=0]Commodore Amiga - Firmware (TOSEC-v2006-06-25_CM).zip[/attachment]

While adding a path with various files in it (also contained many files irrelevant to the datafile), i received the following error in the log:

[code]Add new rom path
Add rom path <MyPath>
Loading 508 files in DB
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 384
s
Invalid token

GDS Code: 335544569Error Code: 249
200 files loaded
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 392
N
Invalid token

GDS Code: 335544569Error Code: 249
400 files loaded
508 files loaded
Analyse new files
Updating games status
Status updated for 109 items.
Green games : 89, yellow games : 0, red games : 20
Updating fileslist
Query Paths list
Execution time: 0h 0m 15s
[/code]

EDIT: After some tests, I found out it was caused by a single quote in a filename.