Announcement

#1 2016-10-13 08:03:42

atk69
Member
2016-10-13
2

[resolved] ¨SQL error / piwigo.caddie

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

 

#2 2016-10-13 17:25:31

flop25
Piwigo Team
2006-07-06
7037

Re: [resolved] ¨SQL error / piwigo.caddie

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?


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2016-10-14 08:34:31

atk69
Member
2016-10-13
2

Re: [resolved] ¨SQL error / piwigo.caddie

Hi,

It was a fresh installation with netinstall. No update.
Newly installed DebianServer.

greets
atk69

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact