Error 1054 in search view and in book view

Started by k.rasheva, 09 July 2021, 22:23:25

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

k.rasheva

Hello! I have made a search view button and got this error:

1054
Unknown column 'use_book' in 'order clause' SQL=SELECT CONCAT(a.lastname, " ", a.name) AS author, a.id AS idauthor, a.alias,CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slugauthor FROM wfmyp_abbookauth AS b INNER JOIN wfmyp_abauthor AS a ON a.id = b.idauth WHERE b.idbook = 2 ORDER BY use_book


How to fix this problem? Thank you in advance!

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

Where this error appears? Administrator side or public side?

Which abook version are you using?
Which PHP version are you using?
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]