Upgrade 0.9a5 to 1.0b1

[randulo]

I know this question comes up but now I can't find any answers so I'm posting.

I untarred the new over the old. The file system has changed but I changed the paths in the database config table.

I have a bad URL when going to the index, it thinks it's the site root.

Code: Select all

Serendipity has detected that your currently installed Serendipity version is 0.9-alpha5. It seems you are attempting to upgrade to version 1.0-beta1, so you need to click here to continue the upgrade process.

The link is to "http://domainname.com/serendipity_admin.php"

If I enter the admin link manually I get this:

Code: Select all

I am here to help you upgrade your Serendipity 0.9-alpha5 installation.
You are seeing this message because you have just installed Serendipity 1.0-beta1, but have not yet upgraded your database installation to fit this version.
First we will take a look at your current setup and attempt to diagnose any 
compatibility problems.

with all the file perms OK.

No version specific tasks found

config.inc and config_local are what you'd expect, the new and the old version numpbers.

What now?

[garvinhicking]

Can you post a screenshot of that site? You should see two buttons you can click on to perform the upgrade...

Regards,
Garvin

[randulo]

only one button, "assume it was upgraded" and I clicked on that. I'm also trying to just install a new one now because the content was testing stuff not worth saving anyway. Wasn't there a script that updates the db ?

[randulo]

the new install seems to be going better since I forced the user to sysadmin account. I don't know why it was failing before, it should have worked.

[randulo]

Garvin (or anyone), is there a list of db columns to add from 9a5 to 1.0b? I'm getting a static pages error

Code: Select all

/ Unknown column 'articletype' in 'field list'

I need to update the db and was not able to do it using the install over method.

[garvinhicking]

Staticpages is an external plugin that is not covered by any Serendipity core upgrades, since it is unrelated.

It seems that you installed the staticpage plugin on top of an existing database? Then the staticpage plugin cannot perform its own upgrade routines; it must be already installed with the version that you previously used, and then you need to update the plugin with a new version so that it will upgrade. Else, the staticpage plugin will try to create the database tables from scratch, which fails because they already exist.

In your case you'll need to uninstall the staticpage plugin, rename the existing staticpage tables, install the new plugin, migrate the contents of the old staticpage tables into the new ones.

Or if you have a backup, restore that, so that the old staticpage plugin is still installed and then you can just copy the staticpage plugin files over the existing directory instead of installing it new.

Or if you know some PHP/MYSQL, look at the source of the plugin and see what SQL codes need to be executed to create the missing DB fields.

Regards,
Garvin

[randulo]

Good point Garvin,

a quick "grep ALTER serendipity_event_plugin/*php" revealed what was needed.