Announcement

#1 2013-08-17 02:18:03

codemanat
Member
2013-08-17
3

Fresh 2.5.2 PiWigo Installation [mysql error 1064] while Syncronizing

Hello, i have a complete fresh Installation of Piwigo 2.5.2. If i try to syncronize my Photos, i get the following Error Message.

Code:

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 's','03 Our Life's','1','1811','1811,1850','true','true','public','2','298.2')
  ' at line 42

INSERT  INTO piwigo_categories
  (id,dir,name,site_id,id_uppercat,uppercats,commentable,visible,status,rank,global_rank)
  VALUES('1811','Bilder & Videos','Bilder & Videos','1',NULL,'1811','true','true','public','298','298')
  , ('1812','miniVHS','miniVHS','1','1811','1811,1812','true','true','public','1','298.1')
  , ('1813','Beschriften Disc 1 von X','Beschriften Disc 1 von X','1','1812','1811,1812,1813','true','true','public','1','298.1.1')
  , ('1814','VIDEO_TS','VIDEO TS','1','1813','1811,1812,1813,1814','true','true','public','1','298.1.1.1')
  , ('1815','1989','1989','1','1812','1811,1812,1815','true','true','public','2','298.1.2')
  , ('1816','Ausflug nach Schönbrunn & Dürnstein','Ausflug nach Schönbrunn & Dürnstein','1','1815','1811,1812,1815,1816','tru in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 834
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 4

SELECT
    id
  FROM piwigo_categories
  WHERE id IN ()
    AND status = 'private'
; in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 834
Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 181

Becouse the File System of my mounted Photo Volume uses Whitespaces and other not appreciated Chars, my $conf['sync_chars_regex'] line looks like this:

Code:

$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_.\[\]\';@,&ß\(\)´\sÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ!\(\)\&\°]+$/';

Does somebody have a suggestion for me?

Thank you
Michael

Offline

 

#2 2013-08-17 08:33:41

flop25
Piwigo Team
2006-07-06
7037

Re: Fresh 2.5.2 PiWigo Installation [mysql error 1064] while Syncronizing

Hello

Are you sure you didn't download the beta 2.6?


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

 

#3 2013-08-17 09:19:53

codemanat
Member
2013-08-17
3

Re: Fresh 2.5.2 PiWigo Installation [mysql error 1064] while Syncronizing

Hello, i used the Downloadbutton on top of the www.piwigo.org Frontpage which guides me to the Downloadlink of the NetInstall script.

Code:

http://piwigo.org/download/dlcounter.php?code=netinstall

And the Admin Panel Shows me this Information:

Code:

Version from Piwigo
Piwigo 2.5.2

Server-Data
Operating System: Linux
PHP: 5.3.3 (Show Info) [2013-08-17 09:14:23]
MySQL: 5.1.69 [2013-08-17 09:14:23]
Graphics Library: External ImageMagick 6.5.4-7

I use german as default laguage, so i translated the Information analogously.

So, as far as the Netinstall Script works fine, i'am sure i installed Version 2.5.2 ;-)

Offline

 

#4 2013-08-17 19:29:49

flop25
Piwigo Team
2006-07-06
7037

Re: Fresh 2.5.2 PiWigo Installation [mysql error 1064] while Syncronizing

^^ ok
I was thinking to something I did in the beta but here, it's about the ' in "03 Our Life's" : I recommend you to change your filenames using a batch renamer, waiting for a future hypothetical patch


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

 

#5 2013-08-19 21:06:56

codemanat
Member
2013-08-17
3

Re: Fresh 2.5.2 PiWigo Installation [mysql error 1064] while Syncronizing

Thank you for your reply, and sorry for my late one. I was busy yesterday.

I looking forward to and hope for an update. Changeing the file structure is currently no option.

Michael

Offline

 

Board footer

Powered by FluxBB

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