Crashed Table

Found a bug? Tell us!!
Post Reply
Josh
Regular
Posts: 110
Joined: Mon Jul 18, 2005 3:02 pm
Location: Berlin
Contact:

Crashed Table

Post by Josh »

I have made two new posts on my blog and they showed up fine, but then soon after I got the following error message on my startpage: http://atlanticreview.org saying that some "table e" is crashed, but I can't find a table e in MySQL.

Code: Select all

Query failed:

SELECT 
                    ep_sticky.value AS orderkey,

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.email
                     , e.body, e.extended
                     
                FROM
                    s9y_entries AS e
                    LEFT JOIN s9y_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN s9y_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN s9y_category c
                        ON ec.categoryid = c.categoryid
                     LEFT OUTER JOIN s9y_entryproperties ep_no_frontpage
                                                  ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
 LEFT OUTER JOIN s9y_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
 LEFT JOIN s9y_entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
                    WHERE isdraft = 'false' AND e.timestamp <= 1186476582 AND  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))  AND  (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')  
                     GROUP BY e.id
            ORDER BY orderkey DESC, timestamp DESC
                      LIMIT 10

/ Table 'e' is marked as crashed and should be repaired
This same error message shows up in "Edit Entries." Thus I can't delete the last two posts.

When I try to open a permalink to a post, for instance http://atlanticreview.org/archives/779- ... rmany.html

Then I get this error message:

Code: Select all

Fatal error: Cannot create references to/from string offsets nor overloaded objects in /kunden/xx/xx/serendipity/include/plugin_api.inc.php on line 1496
I am using Serendipity 1.0 and PHP 4.4.1
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Crashed Table

Post by garvinhicking »

Hi!

The table 'e' is the alias for table 's9y_entries'. Try to repair that one. :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Josh
Regular
Posts: 110
Joined: Mon Jul 18, 2005 3:02 pm
Location: Berlin
Contact:

Post by Josh »

Thanks. T

Now there is one post twice. I can't delete it.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Did you try to delete it in your database table directly? Maybe because of the crash that entry is corrupt.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Josh
Regular
Posts: 110
Joined: Mon Jul 18, 2005 3:02 pm
Location: Berlin
Contact:

Post by Josh »

Direct Deleting does not work:

#1034 - Incorrect key file for table 's9y_entries'; try to repair it


I don't get it. That table is repaired.
I don't know what to do about that incorrect key file.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

You will need to recover that table with the 'myisamchk' console tool, so you might need to contact your provider about it.

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply