Page 2 of 2
Posted: Tue Sep 20, 2005 7:45 pm
by Piata
Hiya,
I'm having the same problem, except I switched servers and I'm migrating my db to a new host and figured I'd start fresh with the latest version.
Where can I find the SQL to update my DB? I'd rather not attempt another re-install and changing things with SQL should take a whole 5 seconds.
I can read/write/alter/del tables and databases so its not a permission issue.
thanks in advance.
Posted: Tue Sep 20, 2005 8:14 pm
by garvinhicking
Usually the s9y DB upgrader does all you want/need to your DB. It is strongly suggested that you use this facility, because DB updates alone don't work, you sometimes need to execute certain functions.
From which version are you upgrading from and to?
The needed files are include/admin/upgrader.inc.php, include/functions_upgrader.inc.php and sql/db_update*.sql.
Regards,
Garvin
Posted: Wed Sep 21, 2005 3:24 am
by Piata
I was using v0.7.3, upgrading to v0.8.4.
Only the database was carried over to the new host. I put all the files for v0.8.4 in the appropriate directory, ran it, said it didn't need to create the DB because it was already there and then index.php brings up the same error as the thread starter had.
Posted: Wed Sep 21, 2005 1:22 pm
by garvinhicking
Yes, sadly you did it wrong. Serendipity needs for upgrading also the files of your old installation. Actually, it only needs the "serendipity_config_local.inc.php" file. This one contains the version number of your old Serendipity version and then performs an upgrade.
Do this:
1. Copy over the DB again
2. Copy over your "serendipity_config_local.inc.php" file
3. Now open your new blog URL, and you'll see the automatic upgrader.
(You may leave step 1. out, if you have not changed anything yet in your configuration on the new URL)
Regards,
Garvin