Pages: 1
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.
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:
$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_.\[\]\';@,&ß\(\)´\sÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ!\(\)\&\°]+$/';
Does somebody have a suggestion for me?
Thank you
Michael
Offline
Hello
Are you sure you didn't download the beta 2.6?
Offline
Hello, i used the Downloadbutton on top of the www.piwigo.org Frontpage which guides me to the Downloadlink of the NetInstall script.
http://piwigo.org/download/dlcounter.php?code=netinstall
And the Admin Panel Shows me this Information:
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
^^ 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
Offline
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
Pages: 1