The result is currently (2024-02-26) like this:
The list of all your votes [User: ZXSpectrum128]
Error: SELECT e.id, e.title, e.library_title as lib, e.language_id as lang, m.text as machine, coalescer.release_year,q.date_year) as release_year, coalesce(z.orig_pubs, z.orig_comps) as publisher FROM entries e INNER JOIN sc_entries z ON e.id = z.id INNER JOIN releases r on e.id = r.entry_id AND r.release_seq = 0 LEFT JOIN search_by_origins q on e.id = q.entry_id LEFT JOIN machinetypes m on e.machinetype_id = m.id
Unknown column 'e.library_title' in 'field list'
votes_per_user.php (41)
A fix would be nice indeed.
Vielen Dank im Voraus!
The latest ZXDB update will be applied this evening at 1800 BST. The update takes around 30 minutes, and the site goes down whilst this happens.
List of all votes of a logged in user is broken.
- ZXSpectrum128
- Drutt
- Posts: 7
- Joined: Mon Jul 13, 2020 11:12 am
- Location: Reckenthal, Germany
List of all votes of a logged in user is broken.
<Dalek snarl> All hail the mighty Speccy! </Dalek snarl>
Re: List of all votes of a logged in user is broken.
Hi @ZXSpectrum128,
Thanks for the report. I see you are referring to the show all votes link on the individual entries page.
There have been some field changes in ZXDB. When I have a chance I will take a look.
Thanks
Peter
Thanks for the report. I see you are referring to the show all votes link on the individual entries page.
There have been some field changes in ZXDB. When I have a chance I will take a look.
Thanks
Peter
- Einar Saukas
- Bugaboo
- Posts: 3190
- Joined: Wed Nov 15, 2017 2:48 pm
Re: List of all votes of a logged in user is broken.
Fixed. Thanks for reporting it!