Major Upgrade Error

Wildcatt88 · July 4th, 2005, 12:07 PM

I upgraded from 5.02 to the new 5.11, however I am getting this error, not allowing me to fix, correct or do anything with the software...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/photopost/forums/vb3.php on line 25

Can someone PLEASE help me!??!?!?!?!?!

Wildcatt88 · July 6th, 2005, 11:09 AM

Nothing? The upgrade has my whole site screwed up, and it was done professionally...

Michael P · July 6th, 2005, 12:37 PM

It would appear that your config-inc.php settings are not pointing to the vb3 user database; the query that is failing is a simple user lookup query. Check your database settings and ensure that your user database is pointing to your vb3 database.

Wildcatt88 · July 6th, 2005, 12:46 PM

One of the developers of vbPortal, probably someone you know well, was helping me install/fix this issue. Apparently it is still a problem. We have fixed some of it, but the thumbnailer everone uses doesn't appear to work with the new upgrade. Therefore we had to create a new one just to use until someone makes one that works.

On the admin menu, I keep changing the usergroups file sizes, but they don't stay, and stuff I haven't entered appears. Also, I now receive these errors when I go into the admin:

Warning: is_dir(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//526/mini/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 695

Warning: is_file(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//526/mini/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 697

Warning: is_dir(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/medium/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 695

Warning: is_file(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/medium/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 697

Warning: is_dir(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/medium/1194000_0648.jpg (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 695

Warning: is_file(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/medium/1194000_0648.jpg (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 697

Warning: is_dir(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/mini/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 695

Warning: is_file(): Stat failed for /usr/local/etc/httpd/htdocs/photopost/data//545/mini/index.htm (errno=5 - Input/output error) in /usr/local/etc/httpd/htdocs/photopost/adm-inc.php on line 697

Chuck S · July 7th, 2005, 08:42 AM

Double check your path statements in storage options and revert if needed.

Wildcatt88 · July 7th, 2005, 09:50 AM

Hey Chuck. Will Reece has been helping me, and it seems that the upgrade to 5.12 caused the problem. There is something within the upgrade that the vbportal hacks you made no longer can function properly.

I do not know more than that, but would be willing to let you take a look if you were interested...

Chuck S · July 7th, 2005, 10:21 AM

http://www.reeftalk.com/

there are no changes that interfere with any block I made for vbportal. I have ran them on my site for along time.

Wildcatt88 · July 7th, 2005, 10:23 AM

Ok, thanks Chuck. I am at a loss...

Wildcatt88 · July 7th, 2005, 10:24 AM

You Have A Reef Forum???

Chuck S · July 7th, 2005, 10:42 AM

Yes and 5 reef tanks in my house LOL

Wildcatt88 · July 7th, 2005, 11:24 AM

Weird, cus I have a reef site too. We need to get together...

Wildcatt88 · July 8th, 2005, 12:20 PM

Here is the error I am getting now:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM mailqueue
ORDER BY mailqueueid DESC
LIMIT 250
mysql error: Table 'photopost.mailqueue' doesn't exist

mysql error number: 1146

Date: Friday 08th of July 2005 12:46:48 PM
Script: http://www.~~~~~~~~~~.com/
Referer: http://my.myway.com/
Username: ~~~~~
IP Address: ~~~~~~~~~

The 'photopost.mailqueue' is throwing us off...

Chuck S · July 8th, 2005, 12:24 PM

well this is not a photopost error.

Most likely if your talking the vbportal hack I did you have not uncommented the mysql select database statements before and after the hack to select the proper database and then after select back to vbulletin

You need to use those if your using separate databases. Your telling me Bill is getting thrown by that one

This is right on the instructions. Hope it helps

Quote:

Make sure you set the proper paths and urls and if your database is in a separate one from vbportal to uncomment the mysql lines and fill in the proper info at the top of the file and the bottom of the file

Wildcatt88 · July 8th, 2005, 12:25 PM

Yes, he is...

Ok, so how do I fix that???

Wildcatt88 · July 8th, 2005, 12:26 PM

Oh, and yes, I set it up ages ago as seperate DBs, not knowing any better...

Chuck S · July 8th, 2005, 12:28 PM

well uncommenting the mysql select database thing will fix it. Take note if the user and password to access the databases are different you need to also fill in and uncomment the link statement up top as well

Wildcatt88 · July 8th, 2005, 12:30 PM

I have the correct paths in, userids and passwords. But I haven't commented anything out, unless Will did...

Wildcatt88 · July 8th, 2005, 12:36 PM

Where are these instructions? I am going nuts trying to find what to comment out...

Wildcatt88 · July 8th, 2005, 12:36 PM

Gimme Gimme!

Chuck S · July 8th, 2005, 01:09 PM

where you got the hack from on phpportals. They are roughtly as I have stated. Look at the hack. Look at the link line does it have the right info. Look at both mysql_select statements do they have the right databases. Now make sure // is removed from the front of those 3 lines.

If you need any other assistance please post in that hack's thread.