Announcement

#1 2018-10-16 17:40:59

Mallev
Member
2018-10-16
2

Warning: [mysql error 144] Table './piwigo/512862user_infos'

Hi All,

So I have been running piwigo for several years on my readyNAS. Today I received this error when navigating to the URL.

Warning:  [mysql error 144] Table './piwigo/512862user_infos' is marked as crashed and last (automatic?) repair failed

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM 512862user_infos AS ui
    LEFT JOIN 512862user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN 512862themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 1
; in /apps/piwigo/web/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Call to a member function fetch_assoc() on boolean in /apps/piwigo/web/include/dblayer/functions_mysqli.inc.php on line 226

Anyone have any idea how to fix it?

Piwigo version: 2.5.3
PHP version: 4.0.4.1
MySQL version: 5.5.44-0+deb7u1 - (Debian)
Piwigo URL: No outside URL only for LAN

Offline

 

#2 2018-10-16 17:53:18

Mallev
Member
2018-10-16
2

Re: Warning: [mysql error 144] Table './piwigo/512862user_infos'

Ok, fixed it already. So posting solution in case anyone else has the issue.

Logged into myphpadmin and ran the SQL command REPAIR TABLE512862user_infos;

Offline

 

Board footer

Powered by FluxBB

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