4.8.5 - vb3 Integration - Occasional MYSQL Errors

[kall]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/gallery/inc_features.php on line 49

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/gallery/inc_features.php on line 63

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/gallery/inc_features.php on line 116

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/gallery/inc_photopost.php on line 97

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/gallery/inc_photopost.php on line 108

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home3/nzboards/public_html/forums/index.php on line 870

This occurs occasionally on my forumhome, and the result (other than a whole heap of error text pushing the page down) is that the featured photos box doesn't display.

Is this due to maybe the database connection not being made *first* of all things on the page or something?

Regardless, does anyone know why this happens sometimes?

[Michael P]

Do you store your PhotoPost tables in a seperate database from your vB tables?

[kall]

Nope. Same db, with a prefix of pp485_

[Chuck S]

related to your prior problem change the table prefix to the proper one you noted in another thread pp23_

[kall]

But that is the old install's tables....the new one is called pp482_ ..

Why is it picking up some of the old data and some of the new?

[Chuck S]

I am just going by what you stated in another thread. you said now that your config picked the one tables everything is working right thus my post here. I still fail to understand why you have two databases.

[kall]

I don't have 2 databases...I have 2 prefixes.

I was leaving the old one there until I was sure the new one was working.

Now, I cleared out all of the photopost tables and re-uploaded the 4.8.5 install files to a new directory.

I then renamed the gallery directory to oldgallery and renamed the photopost directory to gallery.

I then ran the install. Upon going into the admin panel, it looked like a 4.8.2 admin panel, and the config had auto-filled itself with pp23_ as the table prefix.

Hard refreshing, clearing all caches, restarting the PC...nothing changes the fact that it is picking up the old config data from *somewhere*.

Why on earth might this happen? I am going to try again, but not change the directory name to gallery.

[Chuck S]

Are you following the upgrade instructions? Have you ran the upgrade482.php upgrade file from your main photopost directory?

[kall]

I did...now I have written the idea of an upgrade off completely (and dropped all the tables, so such a thing is no longer possible anyway).

On the fresh install, it's looking okay..except I seem to have had to change the admin email twice after the initial install, in a couple of config places.

[kall]

So, it's still occuring.

To avoid the errors showing, the call to inc_photopost etc is being made in my php_include_start template...but I am still occasionally getting the mysql_fetch_row(): supplied argument is not a valid MySQL result resource about 20% of the time, which causes me to have an empty 'Featured Photos' box.

[Chuck S]

You need to follow the instructions Michael has posted

PhotoPost Enhanced vB3 Index Integration

You do not enter anything in your template you meantion. You edit the forumhome template as Michael suggests.

[kall]

A question: Do you use vBulletin?

If so, you would realise that putting the call to the .php files in phpinclude_start with a condition to take effect if the script is called index, is exactly the same as putting the call in index.php...and is entirely unrelated to what happens in forumhome template.

As this 'not picking up the prefix' problem is occuring whether I do it in index.php or phpinclude_start...the method itself is irrelevant.

To answer *your* question - No, I did not do it exactly as Michael suggests, as my 'photopost' directory is called Gallery, and is not located underneath the forum directory (which is actually called 'forums' in my case) so I am using the full server path to the files.

ie: rather than using

Content visible to verified customers only.

, I am using

Content visible to verified customers only.

Aside from that, I have done it as per the instructions. It works sometimes, it fails sometimes. THAT is the problem here.

[Chuck S]

obviously ./photopost is an example and yes you are correct in putting the full path to it. You need to edit the index.php as those are the instructions provided.

Your example above is incorrect as you have forgotten the beginning / in front of home3

[kall]

Fine. It's back in index.php, and it's still happening.

Of course now it is showing all the errors in the top of the page when it happens, rather than it being just not there.

What next?

[Michael P]

What happens if you manually enter the prefix into the queries in the inc_photopost.php file or simply add:

$pp_db_prefix = "<whatever>";

into the inc_photopost.php file at the top?

What I'm trying to figure out is why is the file not always picking up that value - is something overwriting it or clearing it.

[kall]

The same thing happens.

It's really quite odd and more than a little frustrating.

*edit* That's from hardcoding it into each query.

I can try defining it at the top of the file instead...

Maybe what's happening is that it isn't picking up the remainder of the variables from config-int.php?

[Michael P]

Well, I would say that the only thing left is for some reason the script isn't connected to the database to perform the query. I'm not really sure what else it could be since you say that PP/vB are in the same database and vB continues to run except for these couple of queries.

I'll have to give this some thought, because I'm not sure what to test for.

[kall]

Want an admin login/pass? omegatron has one.

I'll have a word with my host just in case it's something off with the db/php/matrix.

[Michael P]

I'm going to move this to the install area because I think its server related and not a bug since you are the only one with this problem. Chuck says you have some kind of mmcache running which was intefering with your scripts before - can you disable this and see if it clears up the problem?

[Chuck S]

I dont keep passwords

You would have to send that to Michael as as I work through one issue which you have had a few on here I delete those PM's or my PM box would be huge