Pages: 1
Hi all,
i tried the test option without changing database first and there was no error.
Then i decided to run the sync but i got the following error.
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 'm-Boot','Auf'm-Boot','1',NULL,'299','true','true','public','180','180')
, ('30' at line 301
INSERT INTO piwigo_categories
(id,dir,name,site_id,id_uppercat,uppercats,commentable,visible,status,rank,global_rank)
VALUES('1','Bei-Nadin','Bei-Nadin','1',NULL,'1','true','true','public','1','1')
, ('2','27.12.2011','27.12.2011','1','1','1,2','true','true','public','1','1.1')
, ('3','11.05.2012','11.05.2012','1','1','1,3','true','true','public','2','1.2')
, ('4','Gatow-Kleine-Badewiese','Gatow-Kleine-Badewiese','1',NULL,'4','true','true','public','2','2')
, ('5','schnapsdrossel','schnapsdrossel','1',NULL,'5','true','true','public','3','3')
, ('6','Luca-Finn','Luca-Finn','1',NULL,'6','true','true','public','4','4')
, ('7','02.-03.04.15','02.-03.04.15','1','6','6,7','true','true','public','1','4.1')
, ('8','Chrissi-&-John','Chrissi-&-John','1',NU in /var/www/............/piwigo/include/dblayer/functions_mysqli.inc.php on line 830
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 ')
AND status = 'private'' at line 3
SELECT id
FROM piwigo_categories
WHERE id IN ()
AND status = 'private'
; in /var/www/............./piwigo/include/dblayer/functions_mysqli.inc.php on line 830
Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/clients/......./piwigo/include/dblayer/functions_mysqli.inc.php on line 891
Piwigo version: Piwigo 2.7.4
PHP version: PHP Version 5.4.39-0+deb7u1
MySQL version: client API version 5.5.41
Piwigo URL: http://
thank you for help.
cheers
serversponsor
Last edited by serversponsor (2015-04-09 17:20:53)
Offline
the problem is the single quote (') in your file names, that are strictly unallowed (yes it's a bug in Piwigo)
sorry I induced you in error in your other topic, you will need to rename your files before sync
Offline
Hi mistic100,
thank you for help.
I changed the names and now it works :)
now i try too take a closer look on theming :)
thangs again
cheers
serversponsor
Offline
in your first, at the right bottom there is alink "Set this topic as resolved" close to the Edit one you used
Offline
Pages: 1