View Full Version : Error while viewing product.
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?
February 4th, 2013, 01:59 PM
It is possible but line 197 of ib3.php is this
list( $cuser, $chomepage, $cposts, $ctitle, $regdate, $avatar_location, $avatar_type, $clocation, $csig ) = mysql_fetch_row($results);
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.
SELECT ib3_members.name,ib3_pfields_content.field_3,ib3_members.posts,ib3_members.title,ib3_members.joined,ib3_profile_portal.avatar_location,ib3_profile_portal.avatar_type,ib3_pfields_content.field_6,ib3_profile_portal.signature FROM ib3_members
LEFT JOIN ib3_profile_portal ON ib3_members.member_id = ib3_profile_portal.rp_member_id
LEFT JOIN ib3_pfields_content ON ib3_members.member_id = ib3_pfields_content.member_id
WHERE ib3_members.member_id=1 LIMIT 1
February 4th, 2013, 02:42 PM
Here is the code I run:
SELECT ipbmembers.name,ipbpfields_content.field_3,ipbmembers.posts,ipbmembers.title,ipbmembers.joined,ipbprofile_portal.avatar_location,ipbprofile_portal.avatar_type,ipbpfields_content.field_6,ipbprofile_portal.signature FROM ipbmembers
LEFT JOIN ipbprofile_portal ON ipbmembers.member_id = ipbprofile_portal.rp_member_id
LEFT JOIN ipbpfields_content ON ipbmembers.member_id = ipbpfields_content.member_id
WHERE ipbmembers.member_id=1 LIMIT 1
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.
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?
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
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.
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.
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. ;)
February 4th, 2013, 03:54 PM
Be glad to send you login information if you want to take a look at it.
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.
February 4th, 2013, 05:55 PM
Yep just needed to update the profile query
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?
February 4th, 2013, 07:27 PM
Yes I updated it your good to go
February 5th, 2013, 11:02 AM
I will of course address this universally in the upcoming ReviewPost 6.1 release.
February 7th, 2013, 08:07 AM
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.