RomCenter 3.41 on Windows 7 64-bit

[cibomatto2002]

I get this Log error on Romcenter 3.14 with Windows 7 64-bit


Error ynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 396
Invalid token
Error Code: 249
Error ynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 398
Invalid token
Error Code: 24


Welcome to RomCenter 3.41
Database Engine WI-V6.3.5.13206 Firebird 2.0
Template database version = 3.439
Checking new romcenter version...
Error: File C:\Users\Jason\Documents\mameuifx32 v0.136.rdt not found. I know why I get this error I delete the file when I make a new one
No updates found.
Ready
Copy Database template
Open new db
Loading database C:\Users\Jason\Documents\MameUI32 v0.137.rdt
MameUI32 v0.137 database version = 3.439
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Extracting xml from [C:\Users\Jason\Desktop\New folder\MameUI32\MameUI32.exe] to [c:\users\jason\appdata\local\temp\rc_tmpdat.dat]
Extracting xml from [C:\Users\Jason\Desktop\New folder\MameUI32\MameUI32.exe] to [c:\users\jason\appdata\local\temp\rc_tmpdat.dat]
Rom mode : split
Bios mode : split
Sample mode : merged
10000 lines loaded
20000 lines loaded
30000 lines loaded
40000 lines loaded
50000 lines loaded
60000 lines loaded
70000 lines loaded
80000 lines loaded
90000 lines loaded
100000 lines loaded
110000 lines loaded
120000 lines loaded
130000 lines loaded
140000 lines loaded
150000 lines loaded
160000 lines loaded
170000 lines loaded
Import datas
10000/128068 lines added
20000/128068 lines added
30000/128068 lines added
40000/128068 lines added
50000/128068 lines added
60000/128068 lines added
70000/128068 lines added
80000/128068 lines added
90000/128068 lines added
100000/128068 lines added
110000/128068 lines added
120000/128068 lines added
Done. 128068 roms added.
170848 lines loaded
Rom mode : split
Bios mode : split
Sample mode : merged
Reindexing.
pass 1/5
pass 2/5
pass 3/5
pass 4/5
pass 5/5
Remove temp files
Rebuilding and reordering database. Please wait...
Execution time: 0h 2m 51s
Close C:\Users\Jason\Documents\MameUI32 v0.137.rdt
Open C:\Users\Jason\Documents\MameUI32 v0.137.rdt
Loading database C:\Users\Jason\Documents\MameUI32 v0.137.rdt
MameUI32 v0.137 database version = 3.439
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Loading gameslist
8604 games loaded.
Updating games status
Status updated for 13776 items.
Green games : 1, yellow games : 18, red games : 8585
Updating fileslist
Query Paths list
Ready
Add new rom path
Add rom path [C:\Emultors and Roms\MAMEFX 0.136\roms\]
Loading 2499 files in DB
200 files loaded
Error ynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 396
Invalid token
Error Code: 249
Error ynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 398
Invalid token
Error Code: 249
400 files loaded
600 files loaded
800 files loaded
1000 files loaded
1200 files loaded
1400 files loaded
1600 files loaded
1800 files loaded
2000 files loaded
2200 files loaded
2400 files loaded
2499 files loaded
Analyse new files
Updating games status
Status updated for 13776 items.
Green games : 2459, yellow games : 61, red games : 6084

[RomCenter]

I fixed a similar problem in the next version.
It occurs when a comment in a zip contains a quote. Check your zip comments and remove this quote.

[Wanderer]

Sorry for reviving this old post but i'm facing the same problem processing some dats. The problem occurs when adding a rom path which contains a zip having either a ' in its filename or a ' in the name of a file inside it.

RC 3.71. Can something be done about it please?

P.S.: ...or maybe not. Maybe the comments are the problem, i'm not sure. In any case, since this happens in many files, can something be done about it? Perhaps a parsing of the comment-string and the removal/escaping of any ' before saving it to DB (if that's the case)?

[RomCenter]

I don't know a tool who can remove comments.
For rc v3, I will not update these versions anymore, as I'm working every day on v4.

[Wanderer]

For rc v3, I will not update these versions anymore

as I'm working every day on v4.

Do you think you could post some details on how things are progressing? I'm very curious on how you have designed RC4. Will it work with multiple dat files or still a single one? OK, maybe this is not the proper post to do this discussion. I hope we'll see something soon in the News forum.

[RomCenter]

Things are going nicely, but not as fast as I want. I can spend no more than 2 hours a day (week days) on the project.
I will post some news soon, with some pictures maybe.

[Wanderer]

I will post some news soon, with some pictures maybe.

Very nice to hear.