Announcement

#1 2008-06-09 13:42:55

acorna
Member
Holland
2008-06-09
4

[solved] pwg_sessions crashed

Hi, I'm running PWG 1.7.0 on www.tifo-dordrecht.nl.

Today I discovered an error within my site:

(top of the page)

SELECT data
  FROM pwg_sessions
  WHERE id = '78639ba61441605454138dffadaae03b'
;
[mysql error 145] Table './md26035db42518/pwg_sessions' is marked as crashed and should be repaired

(bottom of the page)

UPDATE pwg_sessions
  SET expiration = now(),
  data = ''
  WHERE id = '78639ba61441605454138dffadaae03b'
;
[mysql error 145] Table './md26035db42518/pwg_sessions' is marked as crashed and should be repaired

HELP!

It is not possible to login via admin.php.

How can I correct this error?

Last edited by acorna (2008-06-21 16:40:38)

Offline

 

#2 2008-06-09 14:12:32

acorna
Member
Holland
2008-06-09
4

Re: [solved] pwg_sessions crashed

If I empty the table pwg_sessions, will this solve my problem?

Offline

 

#3 2008-06-10 08:33:47

linuxlefty
Member
China
2008-04-13
65

Re: [solved] pwg_sessions crashed

From what I've read, this error indicates that your MySQL table is corrupted. This is a problem with MySQL not one with PWG. You'll need to ask your hosting provider to repair the tables. Or, you could try deleting the tables and reinstalling. However, getting your hosting provider to repair the tables would probably be an easier route.

Offline

 

#4 2008-06-10 10:28:56

acorna
Member
Holland
2008-06-09
4

Re: [solved] pwg_sessions crashed

Thanx for your reply! I checked my database and found the same error.

I've contacted my hosting provider. I hope they can solve the problem (fast).

Offline

 

#5 2008-06-10 13:42:09

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: [solved] pwg_sessions crashed

In phpMyAdmin, on the pwg_sessions table, find the repair function in the operations you will find
"Table maintenance" and "Repair table".
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#6 2008-06-10 17:39:09

acorna
Member
Holland
2008-06-09
4

Re: [solved] pwg_sessions crashed

All I had to do was executing the following SQL statements in MySQL:

repair table pwg_sessions
repair table pwg_images

The problem was solved within seconds!

linuxlefty, VDigital, thanx for your help!

Offline

 

#7 2008-06-10 17:50:03

rio
Piwigo Team
Paris
2006-07-24
1430

Re: [solved] pwg_sessions crashed

Good!
You can put [solved] in the title by editing your first post.
Enjoy your PWG!

:-))


-> /<Ä®¿M <-
http://riohome.free.fr
Il forum è anche in ITALIANO

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact