handesk icon indicating copy to clipboard operation
handesk copied to clipboard

Unknown column 'q' in 'field list'

Open agenge opened this issue 7 years ago • 3 comments

An error occurred while creating a new lead:

(2/2) QueryExceptionSQLSTATE[42S22]: Column not found: 1054 Unknown column 'q' in 'field list' (SQL: insert into leads (name, company, username, email, phone, address, city, country, postal_code, body, q, updated_at, created_at) values (test, test, admin, [email protected], 15112112343, hehloi, SG, SG, 123456, , /leads, 2018-07-07 08:46:59, 2018-07-07 08:46:59))

How can I solve this problem? Thanks!

agenge avatar Jul 07 '18 09:07 agenge

Quite strange, when does it happen? from the api or from the web?

BadChoice avatar Jul 10 '18 12:07 BadChoice

It happened to me as well but for ticket_types table. It was also not finding the 'q' column which value was '/thrust/thrustTypes/' I've altered ticket_types table and add 'q' column with varchar(255) and now it is possible to create without an error. However I noticed that deletion of created item finishes with error, but in the end in the web side it disappears. However when I check ticket_types table it is still there.

gerorymo avatar Jul 22 '20 12:07 gerorymo

is it possible that you send the Q from to the api? this is a non existing field..

BadChoice avatar Oct 05 '20 10:10 BadChoice