tables and categories in upgrades?

[pollesel]

Hi there,
After being hit with someone who was able to use my code to send out massive amounts of spam, I'm finally upgrading from 0.8.4 to 1.0.2. It's all gone well, except for the "categories" part. I keep getting this message:

SELECT c.categoryid,
c.category_name,
c.category_icon,
c.category_description,
c.authorid,
c.category_left,
c.category_right,
c.parentid,

a.username,
a.realname
FROM serendipity_category AS c
LEFT OUTER JOIN serendipity_authors AS a
ON c.authorid = a.authorid
LEFT OUTER JOIN serendipity_authorgroups AS ag
ON ag.authorid = 1
LEFT OUTER JOIN serendipity_access AS acl
ON (ag.groupid = acl.groupid AND acl.artifact_id = c.categoryid)

GROUP BY c.categoryid
ORDER BY category_name ASC

/ Table 'iheartmu_serendipity.serendipity_authorgroups' doesn't exist

The site is http://www.iheartmusic.net/serendipity.

What do I do?

Thanks!

[garvinhicking]

Hi!

Did you perform the upgrade as noted in the FAQ on www.s9y.org?

The 'authorgroups' table should have been created in one of the upgrade .sql files. Did the upgrader run successfully or did you get any error messages?

If you know some basic SQL, you could dig into the sql/*.sql files and search if all of them were executed and created the tables.

HTH,
Garvin

[pollesel]

As far as I can tell, I did everything in the upgrade. I don't know anything about sql, but I changed all the permissions, and I didn't get any error messages.

The only problem I had was with the serendpity/templates_c directory, where the file names are:

carl_contest^%%17^179^179A7579%%content.tpl.php
carl_contest^%%22^222^222D91BD%%index.tpl.php
carl_contest^%%2A^2AF^2AFC0325%%sidebar.tpl.php
carl_contest^%%A6^A64^A64118EE%%entries.tpl.php
carl_contest^%%AB^AB4^AB4245F6%%plugin_calendar.tpl.php
contest^%%02^024^024DE99E%%index.tpl.php
contest^%%1F^1F0^1F0EFDFA%%plugin_calendar.tpl.php
contest^%%2A^2AF^2AFC0325%%sidebar.tpl.php
contest^%%41^410^410B807E%%content.tpl.php
contest^%%A6^A6B^A6BAA6CC%%entries.tpl.php
iheartmusic^%%17^179^179A7579%%content.tpl.php
iheartmusic^%%17^17D^17D6B0EE%%feed_2.0.tpl.php
iheartmusic^%%2A^2AF^2AFC0325%%sidebar.tpl.php
iheartmusic^%%2D^2D3^2D353308%%index.tpl.php
iheartmusic^%%42^42E^42E41E10%%plugin_calendar.tpl.php
iheartmusic^%%66^66E^66E24BC3%%feed_atom1.0.tpl.php
iheartmusic^%%B6^B67^B67A4572%%trackbacks.tpl.php
iheartmusic^%%BC^BC6^BC66E10F%%entries_archives.tpl.php
iheartmusic^%%BE^BE2^BE2345DE%%entries_summary.tpl.php
iheartmusic^%%D1^D1D^D1D1CF07%%comments.tpl.php
iheartmusic^%%D6^D66^D6681396%%commentform.tpl.php
iheartmusic^%%F0^F02^F02B53CB%%entries.tpl.php

When I went to change the permissions on those, I got the error message "550 Could not change perms on iheartmusic^%%D6^D66^D6681396%%commentform.tpl.php: Bad file descriptor"

Could that have anything to do with it? Is there any way to re-run the sql updates, to make sure they get done?

[garvinhicking]

Hi!

Did you get the upgrade screen in the admin panel, and did the upgrade screen tell you that it will run several SQL commands and that you have to click on "Yes, upgrade now"? And you did click that and did get messages?

You can "retry" the upgrade routine by editing serendipity_config_local.inc.php and setting $serendipity['VersionInstalled'] to the version that you were previously running...?

Best regards,
Garvin

[pollesel]

You, sir, are a genius. Retrying it worked perfectly! Thank you, thank you, thank you.

[garvinhicking]

Hi!

Awesome. I was afraid it wouldn't be that easy. All the better.

Have fun!

Best regards,
Garvin