Firefox PHP

upgrade errors

Posted by Steve H 
upgrade errors
November 29, 2007 06:51PM
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?

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
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
Re: upgrade errors
November 29, 2007 08:05PM
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!
Re: upgrade errors
November 30, 2007 01:24AM
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
Re: upgrade errors
November 30, 2007 04:58AM
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
Re: upgrade errors
November 30, 2007 02:26PM
That did the trick.

Thanks again
Sorry, only registered users may post in this forum.

Click here to login