Error while viewing product.

Ginslinger · February 4th, 2013, 01:40 PM

Using Review Post 6.03 and invision power board newest version 3.42 I did a new RP install which seems to be working fine but I get the following error above the header when viewing product

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/diecast/public_html/data/forums/ib3.php on line 197

Line 197 in this file is showing: WHERE $utable.member_id=$cuserid LIMIT 1";

Did maybe something change in IBP newest version?

Chuck S · February 4th, 2013, 01:59 PM

It is possible but line 197 of ib3.php is this

Code:

Content visible to verified customers only.

What actually it means is that query can not be ran successfully.

Maybe try running this in phpmyadmin and see what the real error is now I used a table prefix of ib3_ you will need to correct it to what yours is.

Code:

Content visible to verified customers only.

Ginslinger · February 4th, 2013, 02:42 PM

Here is the code I run:

Code:

Content visible to verified customers only.

I get the error #1146 - Table 'diecast_data.ipbmembers' doesn't exist

Not sure I did this right as I am not very good at DB stuff.

Chuck S · February 4th, 2013, 02:59 PM

I do not beleive you did it right because your not throwing errors anywhere else in the program and the members table is valid in Invisionboard. If that table did not exist you would get errors everywhere and not be logged in.

I would think your forum database table prefix you did is wrong. I would think maybe the table prefix is ipb_ not ipb

I can not obviously know without more info. What is under your reviewpost admin for forum settings table prefix of your forum?

Ginslinger · February 4th, 2013, 03:07 PM

No underscore on the forum database. I was surprised to see that myself. Forum database prefix is set to ipb

Chuck S · February 4th, 2013, 03:10 PM

Like I said I can not comment without seeing your setup database tables etc.

Why would you be throwing an error looking for ibpmembers since obviously your already querying that table when you login.

Ginslinger · February 4th, 2013, 03:23 PM

If I knew that I wouldn't be asking. LOL. Might just try to re-install and see what happens. Strange that I am logged in and can access everything. As I said I only get the error while viewing a product.

Chuck S · February 4th, 2013, 03:43 PM

That is why I said I would need more information like definately seeing your database and how its installed.

I do not own invisionboard so my access is limited to what you all let me see.

Ginslinger · February 4th, 2013, 03:54 PM

Be glad to send you login information if you want to take a look at it.

Chuck S · February 4th, 2013, 04:31 PM

Yes you can do that though the contact us form.

If your logged in authorized in reviewpost admin the error is with that specific query. I just have a feeling your not giving me the correct answer on the issue with the query. My guess is a field name has changed.

Chuck S · February 4th, 2013, 05:55 PM

Yep just needed to update the profile query

Ginslinger · February 4th, 2013, 06:05 PM

Thanks Chuck. Now what do you mean by updating the Profile query? Is that something you did in the file itself?

Chuck S · February 4th, 2013, 07:27 PM

Yes I updated it your good to go

Chuck S · February 5th, 2013, 11:02 AM

I will of course address this universally in the upcoming ReviewPost 6.1 release.

Chuck S · February 7th, 2013, 08:07 AM

ReviewPost 6.1 Beta 2 Released 2-6-2013

If you have some ideas on some new features let me know have added a few new things that people have wanted always need some fresh thoughts.

Figured you might want to see some of the new features so far.