Author Topic: Error 1054 in search view and in book view  (Read 504 times)

Offline k.rasheva

  • Coccinella
  • *
  • Posts: 9
  • Karma: +0/-0
Error 1054 in search view and in book view
« on: 09 July 2021, 22:23:25 »
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!

Vox Populi(x) forum

Error 1054 in search view and in book view
« on: 09 July 2021, 22:23:25 »

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.069
  • Karma: +2/-0
Re: Error 1054 in search view and in book view
« Reply #1 on: 23 September 2021, 12:56:52 »
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.
http://www.antivirushelp.it
stacca la spina!

Vox Populi(x) forum

Re: Error 1054 in search view and in book view
« Reply #1 on: 23 September 2021, 12:56:52 »