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