Piwigo.org

dennissweden · 2011-07-16 11:50:50

Hello,

I get the following error when trying to synchronize in admin->tool.

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 /share/MD0_DATA/Qweb/album/include/dblayer/functions_mysql.inc.php on line 654

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /share/MD0_DATA/Qweb/album/include/dblayer/functions_mysql.inc.php on line 200

Warning: Cannot modify header information - headers already sent by (output started at /share/MD0_DATA/Qweb/album/include/dblayer/functions_mysql.inc.php:653) in /share/MD0_DATA/Qweb/album/include/page_header.php on line 98

plg · 2011-07-16 23:29:40

Hi dennissweden,

This SQL query was added in Piwigo 2.2.4, but I wonder how to reproduce.

Can you describe precisely what you are synchronizing? (a specific folder, the whole "galleries"directory, only directories or files + directories)

dennissweden · 2011-07-17 18:22:50

I unchecked "Only simulate" and it worked.

My other problem is now that I got the phsyical directories created I want the users to upload pictures themseleves to it, and what iv'e read I should find somewhere in the adminpanel called "allow user upload", but I've spent the last hour trying to find that setting and I can't find it.

Something removed in 2.2.4?

ddtddt · 2011-07-17 18:51:25

[extension by plg] Community

plg · 2011-07-17 19:23:51

dennissweden wrote:
I unchecked "Only simulate" and it worked.

I still don't reproduce and when I look at the code, I don't understand how this can happen :-/

dennissweden wrote:
My other problem is now that I got the phsyical directories created I want the users to upload pictures themseleves to it, and what iv'e read I should find somewhere in the adminpanel called "allow user upload", but I've spent the last hour trying to find that setting and I can't find it.

Something removed in 2.2.4?

Please, read Section "New design for user upload" on Piwigo 2.2.0 Release Notes

plg · 2011-07-17 19:53:20

OK, now I reproduce :-/

If the simulation finds new albums, then you get this non blocking error.

Thank you very much for reporting it, I have created an entry in the bugtracker : [Bugtracker] ticket 2378

Considering this is just a warning and that it's not blocking, I don't plan to deliver a version 2.2.5 right now to fix it (but the fix is very easy)

Billr · 2011-07-18 05:52:37

I have the same error under the same conditions of simulating when there are files and directories to synchronize.

Bill

plg · 2011-07-18 09:04:43

Everybody should reproduce the warning with a synchronization with new albums and under simulation, this is not related to the user environment.

dennissweden · 2011-07-18 09:42:39

Thank you for fast replies and great support.

Keep up the good work!

Billr · 2011-07-18 17:07:20

I don't know if this is related, but when on the Tools/Synchronize page, when clicking on the Help icon, I got this error:

Warning: filemtime(): stat failed for ../../themes/default/js/jquery.js in /var/www/piwigo/include/template.class.php on line 1278 Warning: filemtime(): stat failed for ../../plugins/cl_conflit/js/conflit.js in /var/www/piwigo/include/template.class.php on line 1278 Warning: filemtime(): stat failed for ../../plugins/cl_conflit/js/jquery.dimensions.js in /var/www/piwigo/include/template.class.php on line 1278 Warning: filemtime(): stat failed for ../../themes/default/js/plugins/jquery.cluetip.js in /var/www/piwigo/include/template.class.php on line 1278

Bill

flop25 · 2011-07-18 17:45:40

it's totally unrelated : disable cl_conflit just to see ...

Billr · 2011-07-19 18:04:56

that solved it. Thanks Flop25. I'm going to assume I don't need cl_conflit for anything. o.O

Bill

Piwigo.org

Announcement

#1 2011-07-16 11:50:50

error when synchronizing folders

#2 2011-07-16 23:29:40

Re: error when synchronizing folders

#3 2011-07-17 18:22:50

Re: error when synchronizing folders

#4 2011-07-17 18:51:25

Re: error when synchronizing folders

#5 2011-07-17 19:23:51

Re: error when synchronizing folders

dennissweden wrote:

dennissweden wrote:

#6 2011-07-17 19:53:20

Re: error when synchronizing folders

#7 2011-07-18 05:52:37

Re: error when synchronizing folders

#8 2011-07-18 09:04:43

Re: error when synchronizing folders

#9 2011-07-18 09:42:39

Re: error when synchronizing folders

#10 2011-07-18 17:07:20

Re: error when synchronizing folders

#11 2011-07-18 17:45:40

Re: error when synchronizing folders

#12 2011-07-19 18:04:56

Re: error when synchronizing folders

Board footer