pp-inc issue

CaddisNJF · January 9th, 2009, 06:55 PM

I'm getting the following:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/xxx/njflyfishing.com/photopost/pp-inc.php on line 3270

Where as the following line: list( $msgs ) = mysql_fetch_row($q);

in the following section is line #3270. Any ideas?

if ( $User['userid'] > 0 && $Globals['usemsg'] == "yes" )
{
$q = ppmysql_query("SELECT count(*) FROM {$Globals['pp_db_prefix']}messages WHERE userid={$User['userid']} AND status=0", $link);
list( $msgs ) = mysql_fetch_row($q);

if ( $msgs )
{
if ( $msgs == 1 )
{
$menu2 .= "<br /> [ <a href=\"{$Globals['maindir']}/member.php?protype=6\">$msgs {$Globals['pp_lang']['lcmessage']}</a> ]";
}
else
{
$menu2 .= "<br /> [ <a href=\"{$Globals['maindir']}/member.php?protype=6\">$msgs {$Globals['pp_lang']['lcmessages']}</a> ]";
}
}
else
{
$menu2 .= "<br /> [ {$Globals['pp_lang']['lcnomessages']} ]";
}
}

Chuck S · January 9th, 2009, 07:07 PM

Have you upgraded recently?

Does that table exist or have you checked to make sure its not crashed?

CaddisNJF · January 9th, 2009, 07:57 PM

Quote:

Originally Posted by Chuck S

Have you upgraded recently?

Does that table exist or have you checked to make sure its not crashed?

I'm not sure which table {$Globals['pp_db_prefix']} is?

I did upgrade today, but only thinking that maybe it would get rid of this error. No luck

Chuck S · January 9th, 2009, 08:08 PM

the table would most likely be pp_messages. That error would suggest your table is crashed and you need to repair it in like phpmyamin or that table is missing. If its missing its because you upgraded and did not run the upgrade script. That table was added in version 5.61 so I would more suspect mysql corruption.

REPAIR TABLE pp_messages;

CaddisNJF · January 9th, 2009, 08:22 PM

The table is there and I ran a repair on it. No good though. I'm sure this is something simple that i'm just overlooking.

Chuck S · January 10th, 2009, 09:04 AM

while logged in as admin in global options turn the debug option to display errors and then tell me the error

CaddisNJF · January 10th, 2009, 10:51 AM

Quote:

Originally Posted by Chuck S

while logged in as admin in global options turn the debug option to display errors and then tell me the error

I either get a white screen (but vbulletin header and navbar is still there) or If I go directly to photopost/ (with 0r without the /), i get the page not found thing "IE Cannot display the webpage".

Chuck S · January 10th, 2009, 04:43 PM

You get a white screen with debug set to display errors that sounds odd to me.

Main Index - North Eastern Fly Fishing's Online Photo Gallery

Is this the site your talking about?

do you have a test user login?

CaddisNJF · January 10th, 2009, 05:58 PM

here is a plain user test login. If you need admin, Ill PM it to you.

ChuckS
ChuckS111

Chuck S · January 10th, 2009, 06:31 PM

I see your site fine except that myql error.

If you turn off the vb3 boxes in edit integration in admin do you get this error on a plain loaded photopost page?

CaddisNJF · January 10th, 2009, 06:43 PM

I disabled the debug mode, that's why you're seeing it fine now (with the 1 exception).

I set all 3 boxes to "NO" and don't receive the error anymore.

CaddisNJF · January 10th, 2009, 06:48 PM

Leaving the top box Off and keeping the others ON, kinda of eliminates this problem too but then of course Photopost looks like crapola.

Chuck S · January 10th, 2009, 08:14 PM

Okay so this looks like an issue when your vb is on. I wonder what types of hacks do you have in your vbulletin? The evidence the error is not present when you turn off that vb header narrows it down to really an issue with vbulletin and thats why I am pointing to maybe a hack interference.

CaddisNJF · January 10th, 2009, 08:19 PM

Here's the thing... I've disabled all hacks and reverted all templates. Ok, that's only partly true. VBSEO and VBAdvanced are still running.

If you look on my site, you can see that it's really as basic as it comes, with those two exceptions in mind.

CaddisNJF · January 10th, 2009, 08:22 PM

I'll also add that before yesterday, I was running VB 3.67 and was having the same issue. Yesterday I took the leap and upgraded to 3.80 and still having the issue.

CaddisNJF · January 10th, 2009, 08:23 PM

What exactly is this looking for? Maybe I can dig deeper into the actual table? Maybe a field is missing or something? Maybe I skipped a photopost version during an upgrade?

Chuck S · January 10th, 2009, 08:24 PM

Well yes I would say disable all hacks. Something in vbulletin is interefering with this query

Code:

Content visible to verified customers only.

You can email us server logins and admin login to look at your site if you wish

CaddisNJF · January 10th, 2009, 08:32 PM

Quote:

Originally Posted by Chuck S

Well yes I would say disable all hacks. Something in vbulletin is interefering with this query

Code:

Content visible to verified customers only.

You can email us server logins and admin login to look at your site if you wish

I don't understand why it's vBulletin though. Not doubting you but vBulletin appears to be working just fine.

Who should I email with the login details?

Chuck S · January 11th, 2009, 10:21 AM

email the contact us link in the header.

Yeah it appears to be something in vb if the error disappears when you turn off your vb enhanced integration and photopost alone displays fine. It could be the vbadvanced or vbseo who knows at this point.