My Piwigo stopped allowing me to make albums. It will not allow me to choose a parent album or delete old albums. When i try to delete an old album I get this message:
PHP 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 ')' at line 4
SELECT id
FROM piwizp_images
WHERE storage_category_id IN (
)
; in /home/imagekno/public_html/include/dblayer/functions_mysqli.inc.php on line 832
[11-Sep-2016 05:32:35 UTC] PHP Fatal error: Call to a member function fetch_assoc() on boolean in /home/imagekno/public_html/include/dblayer/functions_mysqli.inc.php on line 893
[11-Sep-2016 05:32:38 UTC] PHP Warning: imagecreatefromjpeg(): gd-jpeg, libjpeg: recoverable error: Corrupt JPEG data: premature end of data segment
in /home/imagekno/public_html/admin/include/image.class.php on line 682
I have absolutely no idea what any of this mean except YOUR PIWIGO IS BROKEN! .
*** If I just reinstall Piwigo will it cure this problem without destroying all my image links? ***
Ok.. Looks like my main problem is when I try to create a new album my list of current albums does not show and I have to re-create my parent album every upload.
Problem Solved ! I went into Toos - Site Maintenance where I repaired and optimized the database. Fixed my problem.