Page 1 of 2

error on adding task

Posted: 19 Dec 2017, 12:30
by fahmisalim
Database Error: 1054 - Unknown column 'e.field_2245' in 'order clause'
Query: select e.* from app_entity_88 e where e.id>0 order by e.field_2245 asc
Page: /index.php?module=reports/prepare_add_item&reports_id=8160

Re: error on adding task

Posted: 19 Dec 2017, 13:20
by support
Go to "Entities List" page and fin Entity id 88
Then go to "Default Filters" page and set sort order by ID for example.

Re: error on adding task

Posted: 19 Dec 2017, 13:58
by fahmisalim
thank you for response, actually it happen after I have done for import data and bind it. and now my data crash. please help me to resolve it. I will make donation for this help. please...

I will email you for detail login, cpanel and everything you need

Re: error on adding task

Posted: 19 Dec 2017, 14:20
by fahmisalim
by doing this:
support wrote:Go to "Entities List" page and fin Entity id 88
Then go to "Default Filters" page and set sort order by ID for example.
It keep give message as below:
Database Error: 1054 - Unknown column 'e.field_2245' in 'order clause'
Query: select e.* from app_entity_88 e where e.id>0 order by e.field_2245 asc
Page: /index.php?module=reports/prepare_add_item&reports_id=8160

I'm using 1 entity with some task and subtask, this error happen when I would like to add sub task in one of task

Re: error on adding task

Posted: 19 Dec 2017, 14:30
by support
ok, email me login to your app and I will look.

Re: error on adding task

Posted: 19 Dec 2017, 14:35
by fahmisalim
I have email you

thank you

regards,
fahmi salim

Re: error on adding task

Posted: 19 Dec 2017, 16:03
by fahmisalim
Have you receive my email?

Re: error on adding task

Posted: 19 Dec 2017, 16:23
by support
Yes, please check now.

I just set field "Termin Pembayaran" as Heading for Entities > ListJOB - DIVISI > FINANCE CONTROLER
(you can set other heading if it needs)

The issue was system lost heading field. At the moment I can't say how it happened but setting heading field fixed issue.

Re: error on adding task

Posted: 19 Dec 2017, 16:25
by support
And don't forget about backup before manipulations with data:)

Re: error on adding task

Posted: 19 Dec 2017, 16:32
by fahmisalim
Dear Sergey

Thank you for your best and great support...thank you so much...I will do for donation near minute

Thank you

Regards,
Fahmi Salim