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)
Offline
Hello
atk69 wrote:
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 ,-(.
weird! Is it from a Softaculous-like installer or really from the Piwigo native one?
Offline
Hi,
It was a fresh installation with netinstall. No update.
Newly installed DebianServer.
greets
atk69
Offline