upgrade errors
Posted by Steve H
upgrade errors November 29, 2007 06:51PM |
Registered: 19 years ago Posts: 237 |
I am running a test upgrade on my Phorum which is still running version 5.0.8-RC
Out of 69 upgrades, only 3 errored, so it could be worse. ;) However, all my private messages are gone.
Other than that things look ok, I'm not sure what the other errors were. Any suggestions?
Out of 69 upgrades, only 3 errored, so it could be worse. ;) However, all my private messages are gone.
Other than that things look ok, I'm not sure what the other errors were. Any suggestions?
Quote
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/eforum/include/db/upgrade/mysql/2004112603.php on line 7
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/eforum/include/db/upgrade/mysql/2004112603.php on line 9
Upgrading tables (multiple steps possible) ...
upgrade 6 of 69
Upgrading from database version 2004112602 to 2004112603 ...
The upgrade was successful.
Warning: mysql_query() [function.mysql-query]: Access denied for user 'jrdb'@'localhost' (using password: NO) in /var/www/html/eforum/include/db/upgrade/mysql/2005091400.php on line 40
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/html/eforum/include/db/upgrade/mysql/2005091400.php on line 40
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/eforum/include/db/upgrade/mysql/2005091400.php on line 41
Upgrading tables (multiple steps possible) ...
upgrade 18 of 69
Upgrading from database version 2005082800 to 2005091400 ...
The upgrade was successful.
Warning: mysql_query() [function.mysql-query]: Access denied for user 'jrdb'@'localhost' (using password: NO) in /var/www/html/eforum/include/db/upgrade/mysql/2005092200.php on line 17
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/html/eforum/include/db/upgrade/mysql/2005092200.php on line 17
Warning: database upgrade 2005091400 does not seem to have completed successfully. The old style private messages table phorum_private_messages will be kept for backup.
Upgrading tables (multiple steps possible) ...
upgrade 19 of 69
Upgrading from database version 2005091400 to 2005092200 ...
The upgrade was successful.
Re: upgrade errors November 29, 2007 07:53PM |
Admin Registered: 19 years ago Posts: 8,532 |
Thanks for testing and for your report.
I'm on my way to bed, so I have no time to fully get into this now, but that last error is about code that required some low level database function calls. You might be using the "mysqli" PHP extension, while the code from the upgrade uses "mysql" calls instead. In 5.1, we had separate upgrade scripts for those two, but the new 5.2 db layer took away that need. Looks like this script needs an update to use the new db layer code.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
I'm on my way to bed, so I have no time to fully get into this now, but that last error is about code that required some low level database function calls. You might be using the "mysqli" PHP extension, while the code from the upgrade uses "mysql" calls instead. In 5.1, we had separate upgrade scripts for those two, but the new 5.2 db layer took away that need. Looks like this script needs an update to use the new db layer code.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Re: upgrade errors November 29, 2007 08:05PM |
Registered: 19 years ago Posts: 237 |
Thanks Maurice,
I happened to have a test version of 5.1 as well, so I tried upgrading to 5.1.20, and then making another dump and upgrading that from 5.1.20 to 5.2.2-beta. As expected, that worked fine. But it would be better if you didn't have to do the upgrade in 2 steps.
thanks again for the quick response!
I happened to have a test version of 5.1 as well, so I tried upgrading to 5.1.20, and then making another dump and upgrading that from 5.1.20 to 5.2.2-beta. As expected, that worked fine. But it would be better if you didn't have to do the upgrade in 2 steps.
thanks again for the quick response!
Re: upgrade errors November 30, 2007 01:24AM |
Admin Registered: 19 years ago Posts: 8,532 |
Thanks for doing this test. This confirms my guess about the problem that occurred. I will cook up some fixes for the upgrade files in the 5.2 tree, so they will work for a 5.0 -> 5.2 upgrade as well.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Re: upgrade errors November 30, 2007 04:58AM |
Admin Registered: 19 years ago Posts: 8,532 |
Changesets [2738] and [2739] probably fix these upgrading issues for you. If you want to try this out, then grab a fresh phorum52-dev-svn-* snapshot from our snapshot page.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Re: upgrade errors November 30, 2007 02:26PM |
Registered: 19 years ago Posts: 237 |
Sorry, only registered users may post in this forum.