ugh!

[JavaBlog]

i attempted to upgrade my blog to the latest version of serendipity and everything went fine until at the end when i tried to visit my blog i got this error

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
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= '1130714260' AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 1

/ Table 'javablog.serendipity_authorgroups' doesn't exist

I can still visit my admin control panel so I'm not sure what's up? any idea on how to fix this?

[Guest]

...

[wesley]

I think it's said right there...
"/ Table 'javablog.serendipity_authorgroups' doesn't exist"

Did you encounter any errors during the upgrade? It may be that the new
tables did not get created. Check your MySQL tables (via phpMyAdmin, etc.)
to see if your s9y database has 24 tables inside... it might be that this is
not the case, perhaps.

[JavaBlog]

it appears to only have 16, now that i have found the problem how do i fix it?

[garvinhicking]

How did you exactly perform the update? I assume you're using MySQL?

If you improperly upgraded (like installed 0.9 into a new directory with the same DB data like your old installation), this is the usual error that happens. An upgrade is performed like this:

1. Unpack your files over the EXISTING directory
2. Make sure serendipity_config_local.inc.php and .htaccess are writable
3. Open your s9y blog
4. Say Hi to the upgrader and click on "Perform updates".

You are not lost yet, though. Please edit your serendipity_config_local.inc.php file, set the versionInstalled variable to the version of your serendipity you upgraded from, save that file and re-enter your s9y admin panel - then you will be able to perform the upgrade again. If your serendipity_config_local.inc.php file is not writable, save this file as "change.php" in your s9y directory:

Code: Select all

<?php
chmod('serendipity_config_local.inc.php', 0777);
?>

and call the file via http://yourblog/change.php to reset the file permissions os that you can now save that file.

HTH,
Garvin