upgrading the filestorage error

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
eralf
Posts: 67
Joined: Tue 11. Oct 2005, 19:12

upgrading the filestorage error

Post by eralf »

Hi I am upgrading the installation from RC4 01-05-04 to release 1.2.5-DEV. So i start in upgrade/php with 02__phpwcms_1.1-RC4-31-05-2004.sql. end so on to number 12. I did it for several installations on diverend servers and it works fine!! except for one :cry: When i am upgrading the filestorage, i get the following error message:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/b1425/public_html/setup/upgrade_filestorage.php on line 36
TOTAL: ENTRIES
=================================================================

If last line number is < click here


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/b1425/public_html/setup/upgrade_filestorage.php on line 45

I need ASAP a solution!
Please help !!
User avatar
DeXXus
Posts: 2168
Joined: Fri 28. Nov 2003, 06:20
Location: USA - Florida

Post by DeXXus »

eralf
Posts: 67
Joined: Tue 11. Oct 2005, 19:12

Post by eralf »

Yes... I have read the artikel, but i did everything right, i think!
I place back the complete back-up and started all over again.
The same result. :?

What else can be the problem?
Pappnase

Post by Pappnase »

hello

wich php version runs on your server
eralf
Posts: 67
Joined: Tue 11. Oct 2005, 19:12

Post by eralf »

Version PHP 4.4.0
eralf
Posts: 67
Joined: Tue 11. Oct 2005, 19:12

Post by eralf »

I solved the problem.
The MySQL base was corrupt.
I'll wil write down the solution later.

Thanks and Greetings
eralf
Posts: 67
Joined: Tue 11. Oct 2005, 19:12

Post by eralf »

Solution:

I made a dump (only structure) from an working installation 1.2.5
And an dump (only data) from the corrupt installation.

Then i drop the complete DB from the corrupt installation and place back the structure form the working 1.2.5 in the MySQL base. Then i place back te data. At last i start again the upgrade.php en executed only the "UPGRADE FILESTORAGE" and "UPGRADE ARTICLE CONTENT" and "UPGRADE ARTICLE CONTENT IMAGELIST".

It works again !! :lol:
Post Reply