Json errors

Discuss MySQL Ajax Table Editor

Json errors

Postby jchintall » Fri Aug 21, 2020 9:47 am

Hello,

I am new to this forum and this software package would provide a tremendous help to my applications. But The following message keeps occurring. Any help would be greatly appreciated!!!


Loading...


Invalid json sent back from server. Error: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
Server sent:
( ! ) Fatal error: Uncaught Exception: An error occurred in script C:\wamp64\www\MySQLAjaxTableEditor\mate-free-4.2\php\AjaxTableEditor.php on line 2616: <br /><br />There was an error executing the following query: <br />select `details`.`iddetailscol`, `details`.`filename`, `details`.`information`, `details`.`FKmaster_id`, date_format(hire_date,"%d %M %Y") as `details_entrydate` from details order by `iddetailscol` asc limit 0, 20<br /><br />PDO error:<br /> "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hire_date' in 'field list'" on line: 335 in C:\wamp64\www\MySQLAjaxTableEditor\mate-free-4.2\Common.php on line 26
( ! ) Exception: An error occurred in script C:\wamp64\www\MySQLAjaxTableEditor\mate-free-4.2\php\AjaxTableEditor.php on line 2616: <br /><br />There was an error executing the following query: <br />select `details`.`iddetailscol`, `details`.`filename`, `details`.`information`, `details`.`FKmaster_id`, date_format(hire_date,"%d %M %Y") as `details_entrydate` from details order by `iddetailscol` asc limit 0, 20<br /><br />PDO error:<br /> "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hire_date' in 'field list'" on line: 335 in C:\wamp64\www\MySQLAjaxTableEditor\mate-free-4.2\Common.php on line 26
Call Stack
# Time Memory Function Location
1 0.0001 413112 {main}( ) ...\CkEditor.php:0
2 0.0002 442968 CkEditor->__construct( ) ...\CkEditor.php:181
3 0.0006 479632 AjaxTableEditor->main( ) ...\CkEditor.php:155
4 0.0006 479632 AjaxTableEditor->handleFlow( ) ...\AjaxTableEditor.php:481
5 0.0006 479536 AjaxTableEditor->updateHtml( ) ...\AjaxTableEditor.php:592
6 0.0006 479536 AjaxTableEditor->displayTable( ) ...\AjaxTableEditor.php:1969
7 0.0059 527976 AjaxTableEditor->displayTableHtml( ) ...\AjaxTableEditor.php:2096
8 0.0060 528232 AjaxTableEditor->doQuery( ) ...\AjaxTableEditor.php:2616
9 0.0065 539592 CkEditor->logError( ) ...\AjaxTableEditor.php:350


Back To Examples
jchintall
 
Posts: 1
Joined: Fri Aug 21, 2020 9:23 am

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 9 guests

cron