Major Upgrade Error
 

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

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

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.

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

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

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

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.

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

You Have A Reef Forum???

Yes and 5 reef tanks in my house LOL

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

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

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

Yes, he is...

Ok, so how do I fix that???

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

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

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

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

Gimme Gimme!

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.