Error running Example Script "Multiple Tables in Page"

Installation Problems And Solutions

Error running Example Script "Multiple Tables in Page"

Postby aemandler » Tue Dec 08, 2015 7:55 pm

I can run all the other Example Scripts fine, but "Multiple Tables in Page" fails with this error in Chrome (on Ubuntu 14.04):

Invalid json sent back from server. Error: SyntaxError: Unexpected token <
Server sent:
(repeats twice)

Meanwhile the loading icon is spinning in 3 places at the left.

In Firefox, this error:

Invalid json sent back from server. Error: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
Server sent:
(repeats 3 times)

I'm very interested in the multiple tables on a page feature, so would like to get this resolved. Thanks.
Attachments
mate error.png
screenshot of firefox errors
mate error.png (35.54 KiB) Viewed 23127 times
aemandler
 
Posts: 1
Joined: Tue Dec 08, 2015 7:49 pm

Re: Error running Example Script "Multiple Tables in Page"

Postby admin » Tue Jan 19, 2016 3:23 pm

I am looking into this issue.
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am

Re: Error running Example Script "Multiple Tables in Page"

Postby Sibul » Tue Jan 26, 2016 12:48 pm

Got the same error on Debian 8.2

Also in "Multiple Row In-Line Editing / User Action / Join Example" Example:

Something went wrong...

Most likely the ajax url is incorrect.

If the ajax url is correct check your apache error log file for more information.

-> Error Log:

[Tue Jan 26 13:46:09.557850 2016] [:error] [pid 30556] [client <censored>:49996] PHP Fatal error: Uncaught exception 'Exception' with message 'An error occurred in script /var/www/<censored>/php/AjaxTableEditor.php on line 2830: <br /><br />There was an error executing the following query: <br />select `login_info`.`id`, \nconcat(emp.first_name,' ',emp.last_name) as `employee_id`, \n`login_info`.`login`, \n`login_info`.`password`, \n`login_info`.`account_type`\nfrom login_info\n left join `employees` as `employees` on `login_info`.`employee_id` = `employees`.`id`\n order by `employee_id` asc limit 0, 20<br /><br />PDO error:<br /> "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'emp.first_name' in 'field list'" on line: 346' in /var/www/<censored>/Common.php:26\nStack trace:\n#0 [internal function]: Common->logError('<br /><br />Th...', '/var/www/<censored>...', 2830, 'mate1_')\n#1 /var/www/<censored>/php/AjaxTableEditor.php(361): call_user_func(Array, '<br /><br />Th...', '/var/www/<censored>...', 2830, 'mate1_')\n#2 /var/www/<censored>/php/AjaxTableEditor.php(2830): AjaxTableEditor->doQuery('select `login_i...' in /var/www/<censored>/Common.php on line 26, referer: http://<censored>/mate/JoinExample.php
Sibul
 
Posts: 5
Joined: Tue Jan 26, 2016 12:40 pm

Re: Error running Example Script "Multiple Tables in Page"

Postby Ferdinand » Thu Jan 28, 2016 12:41 pm

JFYI - same Error here with MultipleTables.php

Console-Message:
Code: Select all
Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.


tested on winxp, win7, openSuse - with different Browsers!
Ferdinand
 
Posts: 5
Joined: Sun Jan 10, 2016 10:37 pm

Re: Error running Example Script "Multiple Tables in Page"

Postby ibn » Fri Jan 29, 2016 11:06 am

Hola , yo tengo el mismo problema . Tengo Debian 8 , lo he probado en varios navegadores incluido chrome.

Estoy actualmente utilizando la versión demo , pero voy a comprar la versión de pago ...
Es un error de la versión de demo ??? Gracias por responder .
ibn
 
Posts: 13
Joined: Fri Sep 09, 2011 10:16 am


Return to Installation

Who is online

Users browsing this forum: No registered users and 2 guests

cron