Bonjour/Bonsoir,
Je viens d'installer piwigo et je l'erreur suivante :
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND i.level <= 8
AND c.id NOT IN (0) ORDER BY RAND() LIMIT 25' at line 15
SELECT
i.id as image_id,
i.file as image_file,
i.comment,
i.path,
c.id as catid,
c.name,
c.permalink,
i.name as imgname
FROM piwigo_categories c
JOIN piwigo_image_category ic ON ic.category_id = c.id
JOIN piwigo_images i ON i.id = ic.image_id
WHERE i.id IN ()
AND i.level <= 8
AND c.id NOT IN (0) ORDER BY RAND() LIMIT 25; in /customers/a/e/8/michaelspage.net/httpd.www/piwigo/include/dblayer/functions_mysqli.inc.php on line 830
</pre>
Warning: Cannot modify header information - headers already sent by (output started at /customers/a/e/8/michaelspage.net/httpd.www/piwigo/include/dblayer/functions_mysqli.inc.php:829) in /customers/a/e/8/michaelspage.net/httpd.www/piwigo/include/page_header.php on line 101
-------
Que dois-je faire pour corriger le problème ?
Hebergeur: www.one.com
Operating system: Linux
PHP: 5.6.3
MySQL: 5.5.40-MariaDB-1~wheezy
URL Piwigo: http://michaelspage.net/
Dernière modification par mich74160 (2014-12-15 11:04:13)
Hors ligne
ça m'étonnerai, parce que cette requête viens de Menu Random Photo
http://piwigo.org/dev/browser/extension … c.php#L147
Hors ligne