vb3.php on line 32

[StuartDH]

I'm running PP6 and I've been using PP for a couple of years. I've recently run the scan database feature > "Check here to resync photo/comments usernames/update comments counts."

and about 5% of my images show the following in the following report page

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/*******/forum/photopost/forums/vb3.php on line 32

Looking at the PP6 db, the user id column is OK, but lots of the user fields are empty. This means that lots of the gallery images show the correct avatar for the member who uploaded the image, but it doesn't show their name.

Been trying for ages to sort it, but can't seem to fix it.

[Chuck S]

That issue is usually connected to an incorrect/old forum database information in the config or your table prefix is incorrect. I would suspect if it works for most the database your connecting to is an old forum database and not the correct new one if you updated things.

[StuartDH]

I've got PP6 running on a different database to vb3 and I've checked the config-inc to make sure that database name, username, passwords are right.

The pp6 db has a table prefix of pp_ and this matches up with config-inc's $pp_db_prefix = "pp_";

The vb database has a prefix of vb3_ and this matches the gallery's admin > forum settings > forumdatabase table prefix > vb3_

Is the anywhere I can check to see if the settings are right/wrong?

[Chuck S]

How about the actual vb database in your vb config file does Photopost users database info match that file?

[StuartDH]

the vb database looks ok

In phpmyadmin, the pp6_user has all the user ids, but lots of usernames are missing

More seem to disappear every time I run the ""Check here to resync photo/comments usernames/update comments counts." with all categories selected.

Looks like if I run it with just one category selected then some usernames return

[Chuck S]

Well this issue has nothing to do with your photopost tables. I guess the issue is why does the user not exist in your vbulletin

Content visible to verified customers only.

What has happened to your site. Is this some switched integration I mean is there something I do not know about here that I might be able to assist you.

[StuartDH]

Sorry, typo on my last post.

I meant to say that it's the pp_photos table that's missing info in the user column. All the userid info appears to be there, but the user column has lots of blank fields. It even has blanks where it has the right info in other rows, like the attached phpmyadmin screenshot where the user 'Tinkerbell' has userid 3 and they're all there in the userid column, but only one entry in the user column

[Chuck S]

well they are blank because of your line 32 error but like I previously stated that is usually because that user can not be found in vb or some more likely an issue with the table prefix or database info is usually the case. Try setting your debug setting to display errors in global options and see if it gives you a more precise error message.

[StuartDH]

I've switched on debug, but it's not showing any error info at the moment. On this page the user has posted an image and their name is missing from the photo avatar, but showing in the comments avatar. Some of their other photos are showing their name correctly.

Greater Horntail Sawfly - Urocerus Gigas - Wildlife Photography

the users photopage is showing with names for some pics, but not others, and the ones that disappeared only went after we ran the check database script

Kayleigh Gallery - Wildlife Photography

The vb database looks ok, with all problem names in pp6 appearing normally in vb

The gallery used to be vbagallery until we did an import to pp6, and we've got vbdrupal installed, as well as pp reviews and vbseo

I've checked over the config settings for db names etc and they all seem ok.

[Chuck S]

list( $tid, $tmpname, $tmail ) = get_userinfo("", $tuserid);

This is where your getting your issue. Well your probally not going to get any more errors but running scan database again does it fix things? IT SHOULD. Based on the fact you have userid's in the Photos table you should get a name written into the photos table.

Tinkerbell Gallery - Wildlife Photography

Here is the user based on your database photos table pic userid 3 should be Tinkerbell?

Wildlife and Environment Forums - View Profile: Tinkerbell

You should be able to run the scan database to rebuild the names its what it is made for.

[StuartDH]

Originally Posted by Chuck S

list( $tid, $tmpname, $tmail ) = get_userinfo("", $tuserid);

This is where your getting your issue. Well your probally not going to get any more errors but running scan database again does it fix things? IT SHOULD. Based on the fact you have userid's in the Photos table you should get a name written into the photos table.

Still getting problems

Originally Posted by Chuck S

Tinkerbell Gallery - Wildlife Photography

Here is the user based on your database photos table pic userid 3 should be Tinkerbell?

yep, and userid 3 shows in the vb database, and the PP6 database pp_users table (see attachment), but only occasionally in the pp_photos table, as above

Originally Posted by Chuck S

You should be able to run the scan database to rebuild the names its what it is made for.

I've tried it twice in the past hour and it's still stripping out usernames, more each time

Scan about an hour ago:

Checking photo #2369: done.
Checking photo #2793: done.
Checking photo #2900: done.
Checking photo #2901: done.
Checking photo #2917: done.
Checking photo #2918: done.
Checking photo #2924: done.
Checking photo #2997: done.
Checking photo #3174: done.
Checking photo #3175: done.
Checking photo #3271: done.
Checking photo #3276: done.
Checking photo #3279: done.
Checking photo #3368: done.
Checking photo #3397: done.
Checking photo #3398: done.
Checking photo #3399: done.
Checking photo #3423: done.
Checking photo #3424: done.



scan just minutes ago: (the only thing I've done since last scan was run "Check here to update your user table last photo field."

Checking photo #2369:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done.
Checking photo #2793: done.
Checking photo #2900: done.
Checking photo #2901: done.
Checking photo #2917:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done.
Checking photo #2918: done.
Checking photo #2924: done.
Checking photo #2997: done.
Checking photo #3174: done.
Checking photo #3175: done.
Checking photo #3271: done.
Checking photo #3276: done.
Checking photo #3279: done.
Checking photo #3368:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done.
Checking photo #3397:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done.
Checking photo #3398: done.
Checking photo #3399:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done.
Checking photo #3423: done.
Checking photo #3424: done.

[Chuck S]

well you need to check those individual photos. What is wrong with that specific userid

Only do the update username thing.

[StuartDH]

I haven't found anything obviously wrong with the photos or users, it all looks normal, but just seen mydebug emails from earlier on and they read like:

SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,s.lastactivity,u.membergroupids FROM vb3_user u LEFT JOIN vb3_session s ON s.userid=u.userid WHERE u.userid=2079

The query returned with an errorcode of:

MySQL server has gone away

with dozens more userid= variations in repeat emails...each one of which has lost the username under their images

The server isn't down and the sites are still running OK, but I'll contact the host and ask them to investigate anything at their end.

Any ideas?

[Chuck S]

MySQL server has gone away

Your mysql server is going down thats what that error means.

[StuartDH]

I've contacted liquidweb who host our dedicated server and got:

"I do not see any errors anywhere. I clicked around on the pictures page and
did not see any errors in the apache error log. I also checked the server logs
to make sure that mysql is not being restarted."

can the server go down 100+ times and come back every few lines like the second scan on post 11, during a quick database check of about 15 minutes?

anyway, I loaded a new config-inc.php and only thing that's different is the vb license, which was pointing to our licence on another domain in the old config-inc.

just tried another scan. it's repaired some of the earlier names disappearing, but not others.

[Chuck S]

yes well if the true error you get is mysql has gone away thats your mysql server going down intermittently and it can happen and you might let your host know what is going on and give them the error you see. That error comes right from your mysql server.

[StuartDH]

Here's the host's comments:

*****

"This error indicates a query took longer than the setting for wait_timeout to
complete. It is very odd you are seeing that with a session lookup, as those
are usually only stored in memory.

I have raised that setting and restarted mysql to apply the change.
The optimize pass has completed without any problems.
If you get any more error notices, please let us know."

*****

Ran "Check here to resync photo/comments usernames/update comments counts.". Got blank screen for 2minutes with just "Processing may take a while... please be patient and wait the for FINISHED message..."

then the first 300 photos seem to go OK, with "Checking photo #168: done." etc

Then it starts to fail again with about 5% of photos getting "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wildabou/public_html/pictures/forums/vb3.php on line 32
done."


So to sum up the situation so far:

* The server isn't showing any problems
* Settings and db connections look OK, and 95% of photos are checking OK
* The userid and username are showing for every user in vb3_user
* About 1% of usernames are missing in pp_users, but all the ids are there
* About 5% usernames are missing in pp_photos

But usernames are still being stripped when I run "Check here to resync photo/comments usernames/update comments counts."

With each run, some more are stripped out, some are fixed, and it's usually the same 5% of photos (several hundred users, several thousand photos)

What next?

[Chuck S]

Are you still getting the error

MySQL server has gone away

I need the exact error to post any suggestions as this does not happen on the many setups I have tested this on and it does appear to be centered around your server setup and mysql based on what you have posted.

[StuartDH]

yep, when I run the db check I still get the debug email errors like:

*****

SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,s.lastactivity,u.membergroupids FROM vb3_user u LEFT JOIN vb3_session s ON s.userid=u.userid WHERE u.userid=748

The query returned with an errorcode of:

MySQL server has gone away

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

*****

Hundreds of them and each the same with only the userid= bit changing each time

[Chuck S]

Stuart has to be your server sorry to say. That error from mysql is pretty darn specific. You can see our query is properly formatted with the userid so we are trying to grab the users info to update the post and your mysql server is temporarily dieing resulting in no username being pulled so then it moves on.

Your host needs to address why MYSQL HAS GONE AWAY. This is nothing we can fix on our end as we can only address issues in the software not your actual server.