0.7.1 to 0.8.4 Upgrade

[DortoH]

I am not really sure what I need to do here in order to upgrade to the latest and greatest. When I tired to upgrade to 0.8.0 a while back I received this error:

http://thelazyadmin.com/images/08error.jpg

I restored everything from backup and never looked back, but now I am ready for another attempt. I don't know much about MySql or PHP so any guidance is appreciated.

The last time i tried to upgrade I copied over all the files and loaded up the admin page, just like the upgrade doc said

[garvinhicking]

The error you got previosuly could only happen if after you called the Admin panel and upgraded the database, the SQL files were not applied.

Do you remember if you saw the "Upgrade" panel when goign to your admin panel? That should list you several database .sql files that are about to get executed.

Now, your SQL user needs ALTER TABLE privileges so that Serendipity can properly upgrade. Please check back with your provider that your MySQL user is allowed to do that, and if he has all needed privileges.

As a fallback, I could tell you how to run the .sql files manually. But this should not be required.

Regards,
Garvin

[DortoH]

Yes I did laucnh get the Upgrade panel and that was the result of the upgrade. I will contact my host about this permission.

Is the permission something I can set via PHPMyadmin? My hosts technical support is not the greatest and if I can do it, and someone can tell me how I'd rather not call!

[garvinhicking]

You can only set it via phpMyAdmin if you have superuser privileges (some kind of "root account" for mySQL).

Is the serendipity username+password for the SQL database the same you use to login via phpMyAdmin? If yes, you can try to alter a table via phpMyAdmin and see if you get an error message (like adding a column to a table)

Regards,
Garvin

[DortoH]

I can add a table manually from phpmyadmin and it looks like i can run sql scripts from there as well.

[garvinhicking]

Did you add a TABLE or did you add a COLUMN to an existing table? The first one must work, because else you couldn't have installed Serendipity. The second one may not work and is only required when s9y upgrades; since that fails for you, it seems likely that your mysql user does not have the ALTER TABLE privileges...

Regards,
Garvin

[DortoH]

I did add a table not a column. I am not too familiar with this but I will see if I can add a column to my test table.

I will also call the host and see if they can help. If this can't be done, is there any way to upgrade manually by running the scripts? Any volunteers, I'd rather pay a few $$ than destroy everything

[DortoH]

Well the host says that it is all doable in phpmyadmin. From phpmyadmin I was able to insert a row into the test table.

Inserted rows: 1
SQL-query:
INSERT INTO `test` ( `entryid` , `points` , `ip` , `user_agent` )
VALUES (ASCII( '1' ) , ASCII( '2' ) , ASCII( '3' ) , ASCII( '4' ) );

[garvinhicking]

Try to execute this query:

Code: Select all

ALTER TABLE test ADD column info varchar(255)

If that works, your s9y upgrade should work as well. And you can run the DB update manually if it fails. But try the simple route first, is this works for nearly everybody

Regards,
Garvin

[DortoH]

Your SQL-query has been executed successfully (Query took 0.0572 sec)
SQL-query:
ALTER TABLE test ADD COLUMN info varchar( 255 )

I take it that is good news?

[garvinhicking]

Yes, that means all should be well when you upgrade. If all things fail, just send me a mail and we'll work it out

Regards,
Garvin

[DortoH]

Its on the books for Thursday night

[DortoH]

PERFECT, this upgrade went much smoother than the last. Now I just need to get my template up to snuff for 0.8.4

Thanks for the help!

[DortoH]

One final question. I noticed that not ALL the files were overwritten. Are there any 0.7.1 files/folders that should be removed?

[garvinhicking]

Yes, read here for removed files info: http://www.s9y.org/index.php?node=63#A16

Regards,
Garvin