Page 1 of 1

Got trouble with upgrading

Posted: Tue Apr 22, 2008 3:16 pm
by rappy
Hi,

I tried to upgrade my blog from 1.1.2 to the newest version, but when executing the update it always gives me the following error messages:

Code: Select all

ALTER TABLE serendipity2_category ADD COLUMN sort_order int(11);

/ Duplicate column name 'sort_order'

ALTER TABLE serendipity2_category ADD COLUMN hide_sub int(1);

/ Duplicate column name 'hide_sub'

CREATE INDEX categoryso_idx ON serendipity2_category (sort_order);

/ Access denied for user 'web338'@'localhost' to database 'usr_web338_1'
If I visit my blog after that, several plugins can't be loaded, the statics pages don't turn up and when going to the admin panel, it says:

Code: Select all

Warning: Smarty error: unable to read resource: "admin/index.tpl" in /home/www/web338/html/blog/bundled-libs/Smarty/libs/Smarty.class.php on line 1092
Can anybody help me?

Thanks a lot

Re: Got trouble with upgrading

Posted: Tue Apr 22, 2008 3:25 pm
by garvinhicking
Hi!

The error messages only occur because you seem to already have executed the upgrade at some point. You shouldn't care about those.

The only important one is the "Access Denied", you should ask your hoster to give your mysql user the "INDEX" privilege.

The other errors seems to happen because you forgot to upload all files, especially the files in /templates/default/ from the new s9y version.

Regards,
Garvin