The latest ZXDB database update will be applied at 1530 BST today. The site will go down for around 30 minutes 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: 6876
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: 3102
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