Hello,

I am now not really the SQL professional. So my question.
For "Administration -  Maintenance - Database repair and optimize" I get the following error message:

"
Warning:  [mysql error 1146] Table 'piwigo.caddie' doesn't exist
DESC piwigo.caddie; in /var/www/html/Fotoarchiv/include/dblayer/functions_mysqli.inc.php on line 832

Fatal error: Call to a member function fetch_assoc() on boolean in /var/www/html/Fotoarchiv/include/dblayer/functions_mysqli.inc.php on line 213
"

Table 'piwigo.caddie' is listed (SHOW TABLES), but is not "reachable" (ERROR 1146 (42S02): Table 'piwigo.caddie' does not exist)
Interestingly, there is also "piwigo_caddie", which is readable and filled.

Error or bug ?

Piwigo version: 2.8.2
PHP version: 5.6.24-0+deb8u1
MySQL version: 5.5.50-0+deb8u1
Piwigo URL: http://local


Meanwhile the solution found:

PIWIGO creates both table formats during installation (piwigo. * And piwigo_ *)
During the installation you are asked, which one you want to use (with me piwigo_ *).
Both versions are created ,-(.

The script for maintenance, however, does not differ and tries to check the unused tables.
This fails with the above error.

Solution:
Just delete all piwigo. * Tables.
The maintenance now works perfectly :-)

Last edited by atk69 (2016-10-13 14:26:53)