Plugins - Serendipity 0.8-alpha9

[Blake_Ivey]

I cannot install plugins. It says it has been added and saved, but they never appear on the plugin list. I tried Categories, and ShoutBox. Also, on the event list I have 3 of the same plugin: Announce entries Send notification of new entries to online services. The last 2 say error! for the description. I'm not sure if this is the code itself or my server itself. I just recovered from a crash but managed to save my old database to upgrade from 0.7.1.

[garvinhicking]

You may be missing some database structural upgrades. Please go through the various sql/db_update* files since 0.7.1 and see if those changes have been made to your database (I suspect you'Re an advanced user and know how to do that - if not, please report back).

Regards,
Garvin

[Guest]

I'm not to familiar with MySQL right now. In fact, I'm in the process of learning it and PHP5. I'm advanced in the other parts of linux (for the most part) though. If you wouldn't mind getting me started, I would really appreciate it. I see all the *.sql files in the sql directory, but I'm not sure what I'm looking for, and where to import (I assume I'm to import the correct one) it.

Thanks,

[Blake_Ivey]

Sorry, didnt realize I wasn't logged in.

[garvinhicking]

Okay, no problem. First off, I'd suggest you to go and get phpMyAdmin to browse your MySQL table/database.

Then, for instance, you take the file sql/db_update_0.8-alpha4_0.8-alpha5_mysql.sql and look at it. It reads:

Code: Select all

ALTER TABLE {PREFIX}comments ADD referer varchar(200) default null;

Most SQL should be obvious by reading it, so this one says, that the column "referer" was added to the serendipity_comment table. Then you go to your phpMyAdmin and browse your actual table and see if that column really exists.

The specific column which may cause the trouble for is is the one of file sql/db_update_0.8-alpha5_0.8-alpha6_mysql.sql

Code: Select all

ALTER TABLE {PREFIX}plugins ADD path varchar(255) default null;

Which means that the 'path' column should exist on your plugins table. If not, that could create a SQL statement error when you add plugins. If the column doesn't exist, just execute the query above and replace {PREFIX} with your table prefix ("serendipity_").

HTH,
Garvin.

[Blake_Ivey]

Got it, thanks. I have another problem now...the staticpage is creating a new div or table under the blog. Any ideas? Take a look if you like, about me only works right now, but contact did the same thing. www.blakeivey.com
Thanks,

[garvinhicking]

Your staticpage plugins seems to be because of an old staticpage plugin. Fetch the latest one from our Plugins CVS additional_modules list (see www.s9y.org), that should work

Regards,
Garvin

[Guest]

Awesome, thanks again for all the help! I don't mean to be such a bother

Bif