Announcement

#1 2015-04-09 11:22:38

serversponsor
Member
2015-04-08
13

[resolved] Sync gallery3 folders & pics mysql error / (solved)

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

 

#2 2015-04-09 11:30:15

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: [resolved] Sync gallery3 folders & pics mysql error / (solved)

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

 

#3 2015-04-09 16:50:44

serversponsor
Member
2015-04-08
13

Re: [resolved] Sync gallery3 folders & pics mysql error / (solved)

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

 

#4 2015-04-10 10:10:56

flop25
Piwigo Team
2006-07-06
7037

Re: [resolved] Sync gallery3 folders & pics mysql error / (solved)

in your first, at the right bottom there is alink "Set this topic as resolved" close to the Edit one you used


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact