I've finally decided to upgrade my S9 installation (busy, but getting sick of the insane amount of comment spam I've been getting and deleting).
Anyhow, I dropped the new version over the old one, wen't to the blog, and get this.
I take it that somehow S9 didn't notice that I'd upgraded and run the upgrade scripts.
NOTE : I'm running on my ISP's webserver, so only have FTP access (and PHP of course). Also, I'm not POSITIVE I'm running 5.1, could be 5.0?? Don't know how to check.
I have a (local) backup of both the S9 directory and the database (thank heavens for phpMyAdmin!)
Thanks,
Craig
Code: Select all
Query failed:
SELECT
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.author,
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' AND e.timestamp <= '1110609466'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'db0293650406.serendipity_entrycat' doesn't exist
