Strange behaviour after 1.01 --> 1.02 upgrade

[hgoor]

Hi,

I didn't know where to post this, so I did it here

I have upgraded from 1.01 to 1.02 and now I have some strange plugin-behaviour.

The biggest problem is with the updated spam-plugin (1.33)

For some reason the captchas did not work anymore, even if I turned them on.

I got this error:
Warning: Invalid argument supplied for foreach() in F:\apache2triad\htdocs\serendipity\plugins\serendipity_event_spamblock\serendipity_event_spamblock.php on line 134

So I deleted the plugin (from the admin page) and tried to reinstalled it.

Now I got this error:

Fatal error: Cannot redeclare class serendipity_event_linktoolbar in F:\apache2triad\htdocs\serendipity\plugins\serendipity_event_linktoolbar\serendipity_event_linktoolbar_OLD.php on line 12

How do I correct this?

ps: as you might have noticed I host on Windows

[hgoor]

Woops, I better downgrade real fast again. I have all kinds of weird problems suddenly: categories not showing etc. errors on my page tc. etc.

Seems like I have a lot plugin troubles..

[garvinhicking]

You must delete the file

F:\apache2triad\htdocs\serendipity\plugins\serendipity_event_linktoolbar\serendipity_event_linktoolbar_OLD.php

You may not have backup files with .php extension and plugin name convention in subdirectories as s9y tries to recognize those files.

The spamblock error can happen if your s9y installation does not have usergroups?

Regards
Garvin

[hgoor]

You must delete the file

F:\apache2triad\htdocs\serendipity\plugins\serendipity_event_linktoolbar\serendipity_event_linktoolbar_OLD.php

You may not have backup files with .php extension and plugin name convention in subdirectories as s9y tries to recognize those files.

The spamblock error can happen if your s9y installation does not have usergroups?

Regards
Garvin

Is this something that I could have got from some documentation?

Is there a S9y Wiki somewhere?

[hgoor]

Help!

I downgraded my files, imported a DB backup from before the upgrade and now I still have weird errors: categories are gone but when I make a catgorie it starts saying it already exists...
Query failed:

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 'serendipity.serendipity_authorgroups' doesn't exist

[garvinhicking]

You are missing the "authorgroups" table. That one was introduced for 0.9 already! Did you drop that table?

It seems you should reinstall serendipity to get all DB tables that are needed. The table above should not be missing. Maybe you fetched a backup from pre 0.9, which does not fit with the files from 0.9.

So you need to use the s9y version that you used with your DB installation, and then make an upgrade to 1.0.

I'm sorry to tell you, but you did something wrong in between migration from a previous version...

Regards,
Garvin

[hgoor]

You are missing the "authorgroups" table. That one was introduced for 0.9 already! Did you drop that table?

It seems you should reinstall serendipity to get all DB tables that are needed. The table above should not be missing. Maybe you fetched a backup from pre 0.9, which does not fit with the files from 0.9.

So you need to use the s9y version that you used with your DB installation, and then make an upgrade to 1.0.

I'm sorry to tell you, but you did something wrong in between migration from a previous version...

Regards,
Garvin

Weird. Very weird.

What did I do before the upgrade:

- rar'red the whole serendipity directory
- made a backup of the whole serendipity database with MySQl Administrator

What is the exact table name? I do have serendipity_authors

Btw: worst case scenario: is there a way to recover my posts etc?

[garvinhicking]

Please read again through the message: serendipity_authorGROUPS is missing!

Posts can be recovered if you still have the serendipity_entries table. Other tables related to entries are serendipity_entrycat and serendipity_entryproperties. serendipity_authors holds your current authors that are also associated to entries. serendipity_categories hold categories associated via serendipity_entrycat. serendipity_groupconfig and serendipity_roups hold the configuration if usergroups. serendipity_authorgroups holds the associations of users to groups. serendipity_config holds plugin and central configuration items, serendipity_plugins holds the list of installed plugins, serendipity_pluginlist and serendipity_plugincategories holds a cache of available plugins. serendipity_access holds access lists on which usergroups can access categories. serendipity_images holds an index of your media database. serendipity_comments stores comments and trackbacks. serendipity_references holds links to offsite URLs. serendipity_exits, serendipity_referrers and serendipity_suppress hold referrers/exit links of your entries. serendipity_permalinks holds the permalinsk of all your entries.

As you can see, you basically need each and every table for specific features. Having a missing table should not happen - only if you manually delete those tables somehow.

You might then need to play with importing the tables into a fresh install; only import the data to existing tables, and empty the existing tables before you add your imported data to avoid duplicates.

Regards,
Garvin

[hgoor]

Please read again through the message: serendipity_authorGROUPS is missing!

Posts can be recovered if you still have the serendipity_entries table. Other tables related to entries are serendipity_entrycat and serendipity_entryproperties. serendipity_authors holds your current authors that are also associated to entries. serendipity_categories hold categories associated via serendipity_entrycat. serendipity_groupconfig and serendipity_roups hold the configuration if usergroups. serendipity_authorgroups holds the associations of users to groups. serendipity_config holds plugin and central configuration items, serendipity_plugins holds the list of installed plugins, serendipity_pluginlist and serendipity_plugincategories holds a cache of available plugins. serendipity_access holds access lists on which usergroups can access categories. serendipity_images holds an index of your media database. serendipity_comments stores comments and trackbacks. serendipity_references holds links to offsite URLs. serendipity_exits, serendipity_referrers and serendipity_suppress hold referrers/exit links of your entries. serendipity_permalinks holds the permalinsk of all your entries.

As you can see, you basically need each and every table for specific features. Having a missing table should not happen - only if you manually delete those tables somehow.

You might then need to play with importing the tables into a fresh install; only import the data to existing tables, and empty the existing tables before you add your imported data to avoid duplicates.

Regards,
Garvin

Oops... It seems that my backups of the database were incomplete. Some tables that - I assume - were added in later versions (?) were not included.

Hence: when I downgraded I actually did an incomplete restore.

Arghhhh... 245 entries....

[garvinhicking]

Hi!

each s9y version has the required updates inside the sql/ folder, so don'T abandon your hope. If you still have the main serendipity_entries table, your entries are not lost. Just try to reconstruct the missing tables!

Regard,s
Garvin

[hgoor]

Hi!

each s9y version has the required updates inside the sql/ folder, so don'T abandon your hope. If you still have the main serendipity_entries table, your entries are not lost. Just try to reconstruct the missing tables!

Regard,s
Garvin

Pfff, I think I was able to do it....

Scary.

My mistake:

- my automatic SQL backups were out of date: new tables (created by either plugins or updates) were missing!

So when I downgraded I actually completely f* up

Lesson learned!

[hgoor]

OMFG...

I am a retard.

I just found out what caused al this sh* (besides my bad backup).

It was just the fact that there are new options to the damn spam plugin...

Man, you guys REALLY need to make sure that the release notes are included!

In fact: can't you make it were if you update/upgrade a plugin or install a new one you get MORE info on what has changed??

[judebert]

You're normal. I think the upgrade notes idea is a good one; I'd like to see it included on the admin front page, and maybe even include a link to view the latest release notes any time.

I'll look into it after the 1.0 release.

[garvinhicking]

I don't understand what options of the spamblock plugin caused trouble? Usually we have a place in the admin panel where we tell about important things. However there were no important things worth metnioning, IMHO. If you tell me which these were, I can add them easily.

Regards,
Garvin