upgrading the filestorage error

eralf · Post by **eralf** » Thu 23. Feb 2006, 16:26

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

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 !!

DeXXus · Post by **DeXXus** » Thu 23. Feb 2006, 17:22

http://www.phpwcms.de/forum/viewtopic.p ... ight=every
Keyword: EVERY

eralf · Post by **eralf** » Thu 23. Feb 2006, 17:36

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** » Thu 23. Feb 2006, 17:43

hello

wich php version runs on your server

eralf · Post by **eralf** » Thu 23. Feb 2006, 17:47

Version PHP 4.4.0

eralf · Post by **eralf** » Thu 23. Feb 2006, 19:47

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

Thanks and Greetings

eralf · Post by **eralf** » Fri 24. Feb 2006, 11:35

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 !!