Upgrade 2.5 to 2.6 issues

shelbyforums · April 9th, 2007, 04:57 PM

My upgrade did not go as well as planned. I have a few issues that I will mention below.

1) I have the following error at the top of the index page:

Quote:

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

on category pages, I have the following two errors:

Quote:

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

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/shelbyforums/public_html/classifieds/showcat.php on line 96

2) The thumbnails of each product seem to have disappeared and are replaced by "no image."

3) When clicking on each product, I receive the following message:

Quote:

Product ID is no longer in our database. If you were trying to renew an ad, you will need to resubmit.

4) I cannot log into the admin control panel. It says,

Quote:

You are not a valid administrator or moderator!

The upgrade said it was successful so I'm wondering where to start correcting these issues?

Chuck S · April 10th, 2007, 11:18 AM

Are you sure you have ran all applicable upgrades as the errors your noting state you have not done so and are missing vital fields?

shelbyforums · April 10th, 2007, 11:47 AM

I was running version 2.5 and upgraded to 2.6. It appeared as though only one upgrade was necessary. 2.5>2.6

Code:

Content visible to verified customers only.

Here are the results...

Code:

Content visible to verified customers only.

shelbyforums · April 12th, 2007, 10:19 AM

Help please.

Chuck S · April 12th, 2007, 10:22 AM

You have not ran a required upgrade it would appear to me. There are fields missing in important tables

Try changing the 1 in this line for adminedit to 0 and your true error should be shown in the pp-inc.php file

Code:

Content visible to verified customers only.

shelbyforums · April 13th, 2007, 03:16 PM

I get the same error on the index page.

Quote:

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

And when I try to log into the admin control panel it shows the following errors and says login sussessful but it is not and it kicks me back to the index page without being logged in.

Code:

Content visible to verified customers only.

Chuck S · April 13th, 2007, 03:28 PM

Make sure your vb3.php file does not have stray characters after the closing ?> tag which is usually the culprit of not being able to set a cookie

shelbyforums · April 13th, 2007, 03:43 PM

No stray characters after the closing tag.

Chuck S · April 13th, 2007, 04:57 PM

You are also missing an upgrade cause your missing a usergroup field thats abundently clear with the error here

http://www.shelbyforums.com/classifieds/

shelbyforums · April 13th, 2007, 05:38 PM

It should be abundantly clear to you since you are a Photopost Developer. That is why I am asking for your help. It is not abundantly clear to me.

As my pictures above indicate, I was running version 2.5. Therefore, I ran the upgrade from 2.5 to 2.6. There were no other options to choose from between 2.5 and 2.6 so I have no idea what upgrade I am missing or how to solve the problem.

Could you please tell me how I can rectify this situation?

Thank you.

Chuck S · April 13th, 2007, 06:25 PM

You did not run all of the 2.4 upgrade I would think but dont specifically run that again

Use phpmyadmin and tell me if your missing uplimit or payment fields in that table

shelbyforums · April 15th, 2007, 10:07 PM

Here is the list of my tables:

Code:

Content visible to verified customers only.

I think that the payments table is empty. There is no option to browse that table.

Chuck S · April 16th, 2007, 07:18 AM

That has nothing to do with the payments table. Your issue is your usergroups table. Post the field contents of that table here so I can determine your exact error

shelbyforums · April 16th, 2007, 10:49 AM

I don't see uplimit.

Code:

Content visible to verified customers only.

Chuck S · April 16th, 2007, 11:29 AM

Your definately missing a field from 2.4

I can not say whether you have ran the upgrade before or not so I do not suggest you run through it again

Do this though

Run the upgrade select 2.4 upgrade and ONLY RUN STEP 1

Do not run step 2 and 3 and then see where your at

shelbyforums · April 16th, 2007, 12:15 PM

That fixed the error messages and now I can log into the admin cp. Everything else seems to be working normally except for my images. They are still not showing up. When I look at the data folders, I noticed that some files are separated and located in the thumbs and large folders while other data folders have all the photos in the main folder and they are named with -large and -thumb.

Should I move them and rename the ones that are not yet in the thumbs and large folders? How do I make the system know where to find the images for each ad?

Chuck S · April 16th, 2007, 01:28 PM

You need to open your site so I can see it

It is hard to say anything when it comes to images not showing without seeing the actual site

shelbyforums · April 16th, 2007, 02:51 PM

Ok, I opened the classifieds. Thanks.

Chuck S · April 16th, 2007, 03:53 PM

You have any code modifications to this site? You did upload all the right files right?

You can send us to support@photopost.com the admin login to the program and ftp info

shelbyforums · April 16th, 2007, 06:19 PM

No code modifications, only a couple vBulletin plugins.

All files appear to have uploaded properly.

I'll send login info.