G'day all,
There appear to be errors in the db which I don't know how to repair. Initially, I couldn't access the Albums>Manage module. Now I can't access History either. Can somebody please provide some insight into this problem? Here are the errors:
/piwigo_history_summary' is marked as crashed and last (automatic?) repair failed
/piwigo_category_filters' is marked as crashed and last (automatic?) repair failed
SELECT DISTINCT id, name
FROM piwigo_categories AS c
INNER JOIN piwigo_category_filters AS cf
ON c.id = cf.category_id
; in /var/www/html/heviifoto/include/dblayer/functions_mysqli.inc.php on line 830
Is there any way that I can re-install piwigo while maintaining the existing database content?
Piwigo version:
PHP version:
MySQL version:
Piwigo URL: http://
Offline
Oops. Sorry for missing the important content:
Piwigo version
Piwigo 2.7.4
Environment
Operating system: Linux
PHP: 5.6.13 (Show info)
MySQL: 5.5.5-10.0.21-MariaDB
Offline
Hi
Open a MySQL client (like phpMyAdmin if available on your host) and manually repair the tables (select them and choose "Repair" action)
Offline
Thank-you, Mistic. Your comment pointed me in the right direction.
For the benefit of those who may face a similar problem yet need additional guidance, here is how I repaired the damaged tables:
* the subsequent instructions assume that:
your piwigo site is self-hosted
your mysql (or mariadb) user name is ' username '
the name of your database is ' fotodb '
the name of the damaged table is ' piwigo_damagedtable '
Login to the shell
Enter ‘mysql -u username -p fotodb
Enter ‘show databases;’ to view all databases
Enter ‘use fotodb;‘ to engage the database
Enter ‘show tables;‘ to show all tables within the database
Enter ‘check table piwigo_damagedtable;' to verify that this is the damaged table
Correct it with ‘repair table piwigo_damagedtable;‘
The above solved the problem for me. Hopefully, it helps you as well.
Offline
heviifoto wrote:
Thank-you, Mistic. Your comment pointed me in the right direction.
For the benefit of those who may face a similar problem yet need additional guidance, here is how I repaired the damaged tables:
* the subsequent instructions assume that:
your piwigo site is self-hosted
your mysql (or mariadb) user name is ' username '
the name of your database is ' fotodb '
the name of the damaged table is ' piwigo_damagedtable '
Login to the shell
Enter ‘mysql -u username -p fotodb
Enter ‘show databases;’ to view all databases
Enter ‘use fotodb;‘ to engage the database
Enter ‘show tables;‘ to show all tables within the database
Enter ‘check table piwigo_damagedtable;' to verify that this is the damaged table
Correct it with ‘repair table piwigo_damagedtable;‘
The above solved the problem for me. Hopefully, it helps you as well.
Thanks for the write-up - hopefully this will help someone in the future.
Offline