Problems with upgrade.

marcjd · August 21st, 2006, 08:28 PM

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/forums/vb3.php on line 426

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3820

I just tried upgrading to 5.31 from 4.82. There were some problems with the install with similar results as above. The above is from when I enter photopost index.php. Not able to get logged into it either, including the admin control panel. Running vB 3.6 after a successful upgrade from 3.5. Any ideas? Is there a way of doing a clean install without losing all of the pics and data with those pics? Or can a clean install be averted? Thanks!

marcjd · August 21st, 2006, 08:35 PM

Here is a link.

marcjd · August 21st, 2006, 08:50 PM

In addition to Photopost upgrade script not being able to remove files it no longer uses, I received the following errors:

Quote:

Warning: unlink(/home/politics/public_html/photopost/adm-userg.php) [function.unlink]: Permission denied in /home/politics/public_html/photopost/upgrade.php on line 2100

Warning: unlink(/home/politics/public_html/photopost/adm-approve.php) [function.unlink]: Permission denied in /home/politics/public_html/photopost/upgrade.php on line 2101

Warning: unlink(/home/politics/public_html/photopost/adm-db.php) [function.unlink]: Permission denied in /home/politics/public_html/photopost/upgrade.php on line 2102

Warning: unlink(/home/politics/public_html/photopost/adm-menu.php) [function.unlink]: Permission denied in /home/politics/public_html/photopost/upgrade.php on line 2103

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 2691

And later...

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3793

marcjd · August 22nd, 2006, 11:40 PM

Btw, Apache on a dedicated server w/ current install of MySQL. 1 GB of RAM.

Chuck S · August 23rd, 2006, 09:56 AM

You have several issues that I see.

One is you did not run all the required upgrades I think you missed upgrade 482

You ran upgrade 485 more than once which resulted in your thumbnails now not showing since you prepended userids in the photos table more than once now.

You need to restore a backup of the photos table and then rerun the required upgrades only once

marcjd · August 28th, 2006, 12:01 AM

How would I go about doing this? I have the photopost tables within my vb db. Obviously I am not a db expert, but can learn pretty quick with a few helpful tips. I do have backups of the entire db. Does this have to be done through SSH or can it be done through PHPMyAdmin? Thanks!

marcjd · August 28th, 2006, 12:04 AM

I did accidentally run the 485 before the 482. Went back and ran the 482 and then the rest of the sequence, including the 485 again. Thanks for any help you can give me.

Chuck S · August 29th, 2006, 04:21 PM

You can not run the 485 upgrade more than once or your photos table will get messed up

RESTORE A BACKUP of your mysql database tables and run through the required upgrades ONCE.

marcjd · August 29th, 2006, 10:06 PM

I guess my question was whether or not this can be done w/o screwing up the vb db since the tables are in the vb db. Can just certain tables be restored? Thanks!

Chuck S · August 30th, 2006, 09:18 AM

Yes restore a backup of your photos table for photopost and run through the upgrades once.

NSXTC · September 10th, 2006, 07:37 PM

Chuck, I am getting the exact same errors as in post #1 except I did a fresh install of PP. What did I miss?

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sportsni/public_html/gallery/forums/vb3.php on line 426

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sportsni/public_html/gallery/pp-inc.php on line 3820

Chuck S · September 10th, 2006, 07:48 PM

Your missing your usergroups table. You can rerun install and make sure your mysql database info and table prefixes are correct.

marcjd · October 21st, 2006, 08:05 PM

I have deleted the tables from my vb db and restored the tables from a good copy before the attempted upgrade. I received several errors still, including unlink errors as it said permission denied. I assume this was just the attempted removal of files no longer needed, but may be wrong on that.

I also received the following error: "Table 'politics_discussion.settings' doesn't exist" Should there be this table? There is a table 'politics_discussion.setting'.

And then got this on the last step: "Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3793"

Does the files themselves need to be reverted to what they were prior to the first attempted upgrade? I don't know if I have current backups of those.

Thanks!

Of note is that nothing happened when I clicked on the first couple of upgrades...4.2, 4.85, etc. I had to use the back button to get to the list again. Not sure where to go from here.

Chuck S · October 21st, 2006, 08:15 PM

there should be a settings table with photopost with whatever table prefix you have. You need to restore that table or in your photopost config-inc.php file make sure you have entered the correct photopost table prefix in there. You need to ensure to have all the new files and run your upgrades there is no query at line 3793 of pp-inc.php

marcjd · October 21st, 2006, 08:54 PM

The table is there: discussion_ppsettings, but it appears it is looking for a file w/o the prefix. I checked the other two files and the prefix is set to pp and it is reading it correctly everywhere else.

I have this on the top of my index.php file:

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/forums/vb3.php on line 426

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3820

marcjd · October 22nd, 2006, 01:25 AM

This is one of the errors during the upgrade process:

Quote:

Error performing MySQL command: UPDATE settings SET setting = 'Powered by: PhotoPost --replaceme--
Copyright 2006 All Enthusiast, Inc.' WHERE id=37
Error: Table 'politics_discussion.settings' doesn't exist

I noticed looking through the script several of the instances referring to the table "settings" does not have the prefix code before it. I imagine this could be causing part of the problem I am having. Thanks.

Chuck S · October 22nd, 2006, 09:10 AM

what version of the software you using its not current cause there is no query at 3820 line of pp-inc.php

I would ensure if your restoring a backup your running all your proper upgrades cause that means the queries noted can not be performed you might want to use phpmyadmin to run those specific queries to see what is missing and you can run the right upgrades your missing.

marcjd · October 22nd, 2006, 12:48 PM

Just to make sure I deleted all photopost files on the server except the two config files that have already been updated. I cleared the vb db of the pp files and then put them back in to what they were prior to the first upgrade attempt.

I ran the upgrade again and got these errors in addition to some of the uplink errors again.

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3934
[looked it up and is this: while ( $row = mysql_fetch_row($resultb) ) ]

Error performing MySQL command: UPDATE settings SET setting = 'Powered by: PhotoPost --replaceme--
Copyright 2006 All Enthusiast, Inc.' WHERE id=37
Error: Table 'politics_discussion.settings' doesn't exist

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/pp-inc.php on line 3934

And now on the photopost index.php page these two errors are on top and the backgrounds/formatting still don’t work right as before.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/politics/public_html/photopost/forums/vb3.php on line 426

[looked it up and is this: list( $usergroup,$cpaccess_a,$modaccess_a,$diskspace_a,$uploadsize_a,$uplimit_a,$uploads_a,$comments_a,$ueditpho_a,$ueditposts_a,$useralb_a,$reqmod_a,$assign_a ) = mysql_fetch_row($result); ]

Warning: Invalid argument supplied for foreach() in /home/politics/public_html/photopost/pp-inc.php on line 3975

[looked it up and is this: foreach( $Globals['cats'] as $key => $value ) ]

I shouldn't be getting that settings error. I can try and add the prefix and run this again, but don't how much this will help.

Thanks.

Chuck S · October 22nd, 2006, 12:49 PM

Yes this tells me your possibly not running one of the upgrades you need to run. Your usergroups table query is failing what version where you running?

marcjd · October 22nd, 2006, 02:12 PM

My version was 4.8 and I don't see that listed in the upgrade script, only 4.7 and 4.82. I have tried 4.7 and 4.82 and nothing happens with either of those scripts. No action is performed. So I have to go back and try them until something happens. Don't know what to do here.

Thanks.