Piwigo.org

UnConundrum · 2018-09-05 14:27:24

Hello/Hi/Greetings,

New user, new install on Ubuntu 18.04. When I go to create a new/first album, after clicking on "Create" I get the following error:

SyntaxError: JSON Parse error: Unrecognized token '<'

Piwigo version: latest version
PHP version: 7.2
MySQL version: 8.01
Piwigo URL: http://. Not exposed to web as of now.

UnConundrum · 2018-09-09 14:46:05

Doesn't anyone have a suggestion for me?

flop25 · 2018-09-09 21:47:37

you have a silent error, use the Dev console F12 to display the content of the JSOn call, in Network tab

UnConundrum · 2018-09-09 23:47:35

I don't see a JSON call, but could it be related to the sql error where "rank", "status", and "name" needing to be put into back-tics? (reported at [Github] Piwigo issue #919)

The only error I do see is the sql error:

<pre> 
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank,global_rank,commentable,visible,status)
VALUES('Family','0','0','true','t' at line 2

INSERT INTO piwigo_categories
(name,rank,global_rank,commentable,visible,status)
VALUES('Family','0','0','true','true','public') in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 845 
</pre><pre> 
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', global_rank
FROM piwigo_categories
ORDER BY id_uppercat,rank,name' at line 1

SELECT id, id_uppercat, uppercats, rank, global_rank
FROM piwigo_categories
ORDER BY id_uppercat,rank,name in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 845 
</pre> 
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php:226
Stack trace:
#0 /var/www/html/piwigo/admin/include/functions.php(658): pwg_db_fetch_assoc(false)
#1 /var/www/html/piwigo/admin/include/functions.php(1516): update_global_rank()
#2 /var/www/html/piwigo/include/ws_functions/pwg.categories.php(574): create_virtual_category('Family', 0, Array)
#3 /var/www/html/piwigo/include/ws_core.inc.php(608): ws_categories_add(Array, Object(PwgServer))
#4 /var/www/html/piwigo/include/ws_protocols/rest_handler.php(56): PwgServer->invoke('pwg.categories....', Array)
#5 /var/www/html/piwigo/include/ws_core.inc.php(296): PwgRestRequestHandler->handleRequest(Object(PwgServer))
#6 /var/www/html/piwigo/ws.php(94): PwgServer->run()
#7 {main}
thrown in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 226

flop25 · 2018-09-10 19:19:37

it sounds like it's the "reserved word" issue indeed

Piwigo.org

Announcement

#1 2018-09-05 14:27:24

SyntaxError: JSON Parse error: Unrecognized token '<'

#2 2018-09-09 14:46:05

Re: SyntaxError: JSON Parse error: Unrecognized token '<'

#3 2018-09-09 21:47:37

Re: SyntaxError: JSON Parse error: Unrecognized token '<'

#4 2018-09-09 23:47:35

Re: SyntaxError: JSON Parse error: Unrecognized token '<'

#5 2018-09-10 19:19:37

Re: SyntaxError: JSON Parse error: Unrecognized token '<'

Board footer