Page 1 of 1

MySQL error

Posted: Fri Sep 09, 2005 11:09 am
by alexi
Ok, I have my site installed, and it worked perfectly for 3 Months, and then I appointed someone as chief administrator. Now my site does not work dues to a SQL error.

My PHP knowledge is good, but my SQL knowledge is limited.

The error I get is this:

Code: Select all

Query failed: 
SELECT 
                    

                    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
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                    
                    WHERE isdraft = 'false'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 5
/ Can't open file: 'serendipity_entries.MYI'. (errno: 145)
Anyone have the slightest idea on what I can do to restore everything back to normal?

Also.. the webhost sent me a stupid email, which Im not sure what they trying to say, and their forums/support stinks: Basically they did this to all their accounts:
In order to solve the above problems, Hetzner will be implementing a change on all our hosting accounts, which will allow for the following: on a nightly basis all files under the user’s home directory on our server that are described as owned by the user ‘nobody’ will be changed in ownership to reflect ownership by the username in question. Users are to note that files created by a CMS will only change to their ownership on the following night’s run.
Read the full thing at: http://hetzner.co.za/index.php?id=71

Im presuming this is a file permission error, but I cant seem to find what im doing wrong. Please someone assist!

And the website is at http://www.finishingstrong.co.za

Thank you! :( :( :(

Re: MySQL error

Posted: Fri Sep 09, 2005 3:58 pm
by garvinhicking
You must contact your server Admin. The serendipity_entries MySQL database file no longer exists, so someone deleted or changed files in the /var/lib directory of MySQL.

This is basically unrelated to Serendipity, so your Admin needs to tell what happened with your MySQL datadir...

Regards,
Garvin

Issue Resolved.

Posted: Fri Sep 09, 2005 7:03 pm
by alexi
Yes, i eventually figured it out. I recreated the table via phpMyAdmin.

Thanks for your help! :D :D :D