New Database Model ZXDB

This is the place for general discussion and updates about the ZXDB Database. This forum is not specific to Spectrum Computing.

Moderator: druellan

User avatar
Einar Saukas
Bugaboo
Posts: 3029
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

Another ZXDB version is available!
User avatar
PeterJ
Site Admin
Posts: 6819
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: New Database Model ZXDB

Post by PeterJ »

Einar Saukas wrote: Mon Feb 12, 2024 9:43 pm Another ZXDB version is available!
Thanks Einar,

I will update in the next couple of days.
User avatar
SkoolKid
Manic Miner
Posts: 403
Joined: Wed Nov 15, 2017 3:07 pm

Re: New Database Model ZXDB

Post by SkoolKid »

Einar Saukas wrote: Mon Feb 12, 2024 9:43 pm Another ZXDB version is available!
This version fails to build the database from ZXDB_sqlite.sql. It gives the following error:

Code: Select all

Parse error near line 565472: near "CHARACTER": syntax error
  TABLE IF NOT EXISTS prefixes (   text varchar(10) CHARACTER SET utf8 COLLATE u
                                      error here ---^
Parse error near line 565478: no such table: prefixes
Parse error near line 565508: near "CHARACTER": syntax error
   IF NOT EXISTS prefixexempts (   text varchar(50) CHARACTER SET utf8 COLLATE u
                                      error here ---^
Parse error near line 565514: no such table: prefixexempts
I got it working by removing "CHARACTER SET utf8 COLLATE utf8_unicode_ci" from the two offending CREATE TABLE statements.

The previous version (1.0.183) built OK, so something must have changed in this area.
SkoolKit - disassemble a game today
Pyskool - a remake of Skool Daze and Back to Skool
User avatar
Einar Saukas
Bugaboo
Posts: 3029
Joined: Wed Nov 15, 2017 2:48 pm

Re: New Database Model ZXDB

Post by Einar Saukas »

SkoolKid wrote: Tue Feb 13, 2024 12:46 pm This version fails to build the database from ZXDB_sqlite.sql.
Merge request approved. Thank you!
Post Reply