Page 1 of 1

help with database crash (static pages)

Posted: Tue Oct 02, 2007 1:57 am
by izzlik
Hello, 1 month ago i installed static pages on serendipity and havent touched the blogg until a few minutes ago, 1 month ago i could add and edit static pages fine. today when i try to add del or edit them i get the error bellow, how can i solve it?

ERROR:
UPDATE serendipity_staticpages SET id='3', parent_id='0', articleformattitle='My little blog on the web... ::', articleformat='1', markup='1', pagetitle='Projects', permalink='/index.php?/pages/pagetitle.html', is_startpage='0', show_childpages='0', content='\r\n\r\TEST', pre_content='', headline='Projects', filename='none.html', pass='', timestamp='1184954939', authorid='1', pageorder='2', articletype='1', shownavi='0', showonnavi='1', publishstatus='0', language='en' WHERE id='3'
/ Table 'serendipity_staticpages' is marked as crashed and should be repaired

Re: help with database crash (static pages)

Posted: Fri Oct 05, 2007 9:05 am
by garvinhicking
Hi!

You must try to use a tool like phpMyAmdin to access your database and repair the table 'Serendipity_staticpages'. Seems your DB server once crashed and now the table is in a corrupted state.

Regards,
Garvin

Posted: Thu Oct 11, 2007 11:01 am
by izzlik
Sorry for the delay in answering.

but how do i repair it? im not so good with mysql :( when im in phpmyadmin, what do i do?

Posted: Thu Oct 11, 2007 11:04 am
by garvinhicking
Hi!

phpMyAdmin has a "repair" table option. For details please look up the phpMyAdmin documentation or ask on their forums, as I can only focus on serendipity here...

Best regards,
Garvin

Posted: Thu Oct 11, 2007 6:15 pm
by chickens
izzlik,

This link should explain how to repair tables in a database using phpmyadmin.
http://paulstamatiou.com/2006/05/31/how ... hpmyadmin/