Upgrade Filestorage

Lazyl · Post by **Lazyl** » Wed 28. Dec 2005, 21:22

Hi upgrading the installation to release 1.2.5-DEV works fine except for 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 noticed that a lot of people are having the same issue, but haven't seen any solution. Is it possible to do a SQL query and upgrade the filestorage? Need a solution ASAP, willing to pay for installation help.

DeXXus · Post by **DeXXus** » Wed 28. Dec 2005, 22:06

Probably hasn't been much feedback because it's hard to tell about this part of upgrade, depending on
FROM--> and -->TO versions.
Did you make sure to run each and every .SQL file? If so, were there errors... other than "already exists" ??

Lazyl · Post by **Lazyl** » Thu 29. Dec 2005, 09:29

Well, I thoght I did which I obviously didn't since it's working now

. The upgrade instructions are, to say the least, a bit confusing. Oh well it's OK now

.

DeXXus wrote:Probably hasn't been much feedback because it's hard to tell about this part of upgrade, depending on
FROM--> and -->TO versions.
Did you make sure to run each and every .SQL file? If so, were there errors... other than "already exists" ??

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 13:53

hmm, I have the same problem:

Code: Select all



Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in daten:/usr/vhosts/4AL04/www.feuerwehr-wallern.at/htdocs/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 daten:/usr/vhosts/4AL04/www.feuerwehr-wallern.at/htdocs/setup/upgrade_filestorage.php on line 45

can you help me, I don't understand your solution???

Post by **flip-flop** » Sat 12. Aug 2006, 14:19

Hi,

please tell us the name of your last version (From) and the new version (To).

Upgrade from Version 1.xxx To Version 1.2.xxx

We haven´t no crystal ball.

regards Knut

DeXXus · Post by **DeXXus** » Sat 12. Aug 2006, 14:25

The upgrade procedure ends with a select box for running various .SQL files to update the database (*this* version to *that* version). You can (should) select *each* -and- *every* filename in the dropdown (one at a time) and let the script run the upgrades to the phpWCMS database (for each .SQL file). Ignore any errors (just for running these .SQL files) and go on to the next! When done... the database *should* have all required elements for correct operation of phpWCMS.

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 14:38

oh, sorry, ok my old version was 1.1-RC4 27-08-2004, now I have the files from 20060427_phpwcms_1.2.6 on my server.

At first I had made a backup of all files and database, then I start with overwrite the old files with the new one. (before I have modified the conf.inc.php). The next step was to start upgrade.php, here I choose the SQL File 27-08-2004 to 1.2.6-DEV but I get so much errors and I tried with the other files (same result).

Afterthen I did UPGRADE ARTICLE CONTENT IMAGE and UPGRADE ARTICLE CONTENT IMAGELIST in phpmyadmin. In the case UPGRADE FILESTORAGE I get this error message:

Code: Select all

TOTAL: 291 ENTRIES
=================================================================

If last line number is  < 291  click here

  1ERROR(2): daten:/usr/vhosts/4AL04/www.meinedomain.at/htdocs/phpwcms_filestorage/1/1_2.jpg -> daten:/usr/vhosts/4AL04/www.meinedomain.at/htdocs/phpwcms_filestorage/9b03c8d60e3a69a1202778ba98dd441a.jpg

Post by **flip-flop** » Sat 12. Aug 2006, 14:44

Have you create all folders and set the right permissions for files and folders? http://www.phpwcms-docu.de/inst_de.phtml
Second: http://www.phpwcms-docu.de/update_auf_dev.phtml

Verzeichnis phpwcms_ftp 777
Verzeichnis phpwcms_filestorage 777
Verzeichnis phpwcms_filestorage/can_be_deleted 777
Verzeichnis phpwcms_template 777
Verzeichnis content 777
Verzeichnis content/images 777
Verzeichnis content/gt 777
Verzeichnis content/form 777
Verzeichnis content/rss 777
Verzeichnis content/tmp 777
Verzeichnis content/pages 777

Datei setup/setup.conf.inc.php 666
Datei phpwcms_template/inc_css/frontend.css 666
Datei config/phpwcms/conf.indexpage.inc.php 666
Datei phpwcms_template/inc_default/startup.php 666

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 15:01

yes

(I work with SmartFTP or Filezilla...)

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 15:07

If I start http://www.meinedomain.at/login.php I can't login and get this message:

Code: Select all

Fatal error: Call to undefined function: getremoteip() in daten:/usr/vhosts/4AL04/www.meinedomain..at/htdocs/login.php on line 165

Post by **flip-flop** » Sat 12. Aug 2006, 15:13

Did you upload all files via binary-FTP?? Important for this version.

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 16:24

yes, I did it again, same result....btw, how can I check it?

Post by **flip-flop** » Sat 12. Aug 2006, 16:41

Please upload again "include/inc_lib/default.inc.php" via binary mode. (File-zilla)

http://www.phpwcms.de/forum/viewtopic.php?p=64516#64516

nukia2 · Post by **nukia2** » Sat 12. Aug 2006, 16:49

now:

Code: Select all

Parse error: parse error in daten:/usr/vhosts/4AL04/www.meinedomain.at/htdocs/include/inc_lib/default.inc.php on line 94

Post by **flip-flop** » Sat 12. Aug 2006, 16:57

I think your FTP-transfer doesn´t work right.

Try Total Commander at http://www.ghisler.com. It is a file manager with an integrated ftp client...

That works for me.