Announcement

#1 2015-10-10 19:56:28

heviifoto
Member
Switzerland
2015-09-18
20

Piwigo "Maintenance" not repairing database :-(

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

 

#2 2015-10-10 20:01:58

heviifoto
Member
Switzerland
2015-09-18
20

Re: Piwigo "Maintenance" not repairing database :-(

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

 

#3 2015-10-10 20:09:33

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Piwigo "Maintenance" not repairing database :-(

Hi

Open a MySQL client (like phpMyAdmin if available on your host) and manually repair the tables (select them and choose "Repair" action)

Offline

 

#4 2015-10-11 17:11:12

heviifoto
Member
Switzerland
2015-09-18
20

Re: Piwigo "Maintenance" not repairing database :-(

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

 

#5 2015-10-11 18:14:50

jnashpiwigo
Piwigo Team
2014-10-21
236

Re: Piwigo "Maintenance" not repairing database :-(

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

 

Board footer

Powered by FluxBB

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