Page 1 of 1

1.1 Upgrade error

Posted: Wed Feb 21, 2007 11:46 pm
by siringo
I've just completed upgrading from 1.01 to 1.1 and at the end of the upgrade, received this error ...

CREATE INDEX pluginretr_idx ON serendipity_plugins (placement, sort_order);

/ Duplicate key name 'pluginretr_idx'

create table serendipity_mediaproperties (
mediaid int(11) not null,
property varchar(128) not null,
property_group varchar(50) not null default '',
property_subgroup varchar(50) not null default '',
value text
) /*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

/ Table 'serendipity_mediaproperties' already exists

CREATE INDEX mediapropid_idx ON serendipity_mediaproperties (mediaid);

/ Duplicate key name 'mediapropid_idx'

CREATE UNIQUE INDEX media_idx ON serendipity_mediaproperties (mediaid, property, property_group, property_subgroup);

/ Duplicate key name 'media_idx'

create table serendipity_options (
name varchar(255) not null,
value text not null,
okey varchar(64) not null default ''
) /*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

/ Table 'serendipity_options' already exists

CREATE INDEX options_idx ON serendipity_options (okey);

/ Duplicate key name 'options_idx'

ALTER TABLE serendipity_images ADD COLUMN realname varchar(255) not null default '';

/ Duplicate column name 'realname'

ALTER TABLE serendipity_references ADD COLUMN type varchar(128) not null default '';

/ Duplicate column name 'type'

CREATE INDEX reftype_idx ON serendipity_references (type);

/ Duplicate key name 'reftype_idx'


Warning: fopen(/home/mydomain/public_html/radio/blog/serendipity_config_local.inc.php) [function.fopen]: failed to open stream: Permission denied in /home/mydomain/public_html/radio/blog/include/functions_installer.inc.php on line 72
Your Serendipity installation is now upgraded to version 1.1

You can return to your blog by clicking here

=========

Is that a successful installation or do I need to do something else?

Also, what permissions should I apply to the s9y folders as I had to set all of them to 777 before the upgrade would allow me to complete it.

Thanks.

Posted: Wed Feb 21, 2007 11:59 pm
by siringo
Further to the above, when I click on the link at the bottom of all that to return to my blog, I receive this message ...

Serendipity has detected that your currently installed Serendipity version is 1.0.1. It seems you are attempting to upgrade to version 1.1, so you need to click here to continue the upgrade process.

=====

Seems to be stuck in an upgrade loop!

Thanks,
Matt.

Posted: Thu Feb 22, 2007 10:31 am
by garvinhicking
Hi!

Look at the last PHP error: s9y cannot write to serendipity_config_local.inc.php! Fix that, and the upgrade can be finalized.

Regards,
Garvin

Posted: Thu Feb 22, 2007 10:37 am
by siringo
Hi and thanks Garvin. Is it safe to remove the writepermissions now that the upgrade has completed?
Thanks again.

Posted: Thu Feb 22, 2007 10:38 am
by garvinhicking
Hi!

S9y should always have write permissions to that file. Unless you don'T want to configure or upgrade your blog any longer. ;)

Best regards,
Garvin

Posted: Thu Feb 22, 2007 10:40 am
by siringo
LOL a blog you can't write to LOL. Sorry, maybe I should have put it this way, the file was CHMOD'd to 744 I CHMOD'd it to 766 so the upgrade would complete. Can I t put it back to 744?

Thanks.

Posted: Thu Feb 22, 2007 10:45 am
by garvinhicking
Hi!

If you put it back to 744, you will need to put it to 766 again if you a.) upgrade your blog again or b.) make any configuration changes to the global serendipity configuration.

HTH,
Garvin

Posted: Thu Feb 22, 2007 11:55 am
by siringo
Thanks for your help Garvin, greatly appreciated.