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.

Broken link? Feature request? Anything related to the Spectrum Computing website here.
Post Reply
User avatar
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.

Post by ZXSpectrum128 »

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!
<Dalek snarl> All hail the mighty Speccy! </Dalek snarl>
User avatar
PeterJ
Site Admin
Posts: 6938
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: List of all votes of a logged in user is broken.

Post by PeterJ »

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
User avatar
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.

Post by Einar Saukas »

Fixed. Thanks for reporting it!
Post Reply