New Database Model ZXDB
Moderator: druellan
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update was released!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
BTW the "availability" status in ZXDB is updated automatically now.
It means: when you upload a playable file for a certain title in ZXDB, you don't need to worry anymore about updating availability to "Available". Just wait for the next archive update, and it should happen automatically.
It means: when you upload a playable file for a certain title in ZXDB, you don't need to worry anymore about updating availability to "Available". Just wait for the next archive update, and it should happen automatically.
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB release is now available!
Re: New Database Model ZXDB
Thanks @Einar Saukas. I will update the site this evening.
-
- Manic Miner
- Posts: 401
- Joined: Fri Jan 03, 2020 10:00 am
Re: New Database Model ZXDB
Does the new version support different versions and releases of the same programs, and full zip archives of original author's releases?
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
It depends on what you mean. Perhaps like this?Alone Coder wrote: ↑Mon Aug 01, 2022 6:27 pm Does the new version support different versions and releases of the same programs
https://spectrumcomputing.co.uk/entry/7 ... Beta_Basic
https://spectrumcomputing.co.uk/entry/6 ... ure_Writer
Again, it depends on what you mean.
It's technically possible to store a full zip archive with everything. However we try to avoid it except in special cases like this:
https://spectrumcomputing.co.uk/entry/2 ... ition_2011
The reason is, it's easier for users to have files organized separately, so they can take a quick look with online emulation with a single click, read instructions with another single click, etc.
However if it's important to store a full ZIP for a certain entry, then we can have both: the full ZIP, and again the playable file stored separately. Or we can store both the playable file, and a link to the author's repository where he can organize everything himself/herself, like this:
https://spectrumcomputing.co.uk/entry/3 ... um/Che-Man
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
BTW a new ZXDB release is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is available!
Re: New Database Model ZXDB
Thanks @Einar Saukas,
I will update the site this coming weekend.
I will update the site this coming weekend.
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB version is available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is available now!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB release is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB release is available!
Re: New Database Model ZXDB
I get an error when importing ZXDB_help_search.sql
ERROR 1062 (23000) at line 17: Duplicate entry 'saghib�-38506' for key 'PRIMARY'
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Please check if you are using the latest version of "ZXDB_help_search.sql". I uploaded a fix a few minutes after updating ZXDB. Also check if you are loading "ZXDB_help_search.sql" as UTF8.
If it still doesn't work for you, a quick fix is to run this SQL before running "ZXDB_help_search.sql":
Code: Select all
update contents set alias=null where entry_id=38506
Re: New Database Model ZXDB
It is indeed the row from 'contents' for this id that makes it fail.
Change the alias from 'Saghibú' -> to 'Saghibù' also makes the script work again.
UPDATE `contents` SET `alias` = 'Saghibù' WHERE `contents`.`container_id` = 37941 AND `contents`.`media_seq` = 0 AND `contents`.`media_side` = 'A' AND `contents`.`prog_seq` = 5;
Change the alias from 'Saghibú' -> to 'Saghibù' also makes the script work again.
UPDATE `contents` SET `alias` = 'Saghibù' WHERE `contents`.`container_id` = 37941 AND `contents`.`media_seq` = 0 AND `contents`.`media_side` = 'A' AND `contents`.`prog_seq` = 5;
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB update is available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB is available! FINALLY!!!
My apologies for the delay. Now that the FIFA World Cup is over, we are back to normal...
My apologies for the delay. Now that the FIFA World Cup is over, we are back to normal...
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
Another ZXDB update is now available!
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: New Database Model ZXDB
A new ZXDB version is now available!
This time there were a few (minor) changes in the database structure. If you have a web site or application using ZXDB, please read this:
This time there were a few (minor) changes in the database structure. If you have a web site or application using ZXDB, please read this:
- ZXDB now stores information about magazine publisher(s) for each individual magazine issue, instead of magazine publisher(s) for the entire magazine. Technically there are now 2 new columns called "issues.label_id" and "issues.label2_id". The old columns "magazines.label_id" and "magazines.label2_id" still exist (therefore updating to this new version of ZXDB won't break anything!), but please don't use them anymore because these old columns will be removed in a future ZXDB update.
- If you also use script "ZXDB_help_search.sql" (that's part of ZXDB distribution), now there's a new table called "search_by_magazines". This table collects all publishers for each magazine. Therefore this table can be used to replace the old columns mentioned above.
- Also in script "ZXDB_help_search.sql", table "aux_issues" will be replaced by "search_by_issues". Both tables exist now, but the old table will be removed in a future ZXDB update so please change your code to use the new table instead.
- Also in script "ZXDB_help_search.sql", table "aux_origintypes" will be replaced by "origintypes". Both tables exist now, but the old table will be removed in a future ZXDB update so please change your code to use the new table instead.