View Single Post
Old September 24th, 2004, 09:37 AM   #1 (permalink)
bloud
Junior Member
Verified Customer
 
Join Date: Feb 2004
Posts: 12
Question MySQL error after posting review

I am recieving the following error once I complete and post a review to a product.
**Begin Error**
MySQL error reported!

Script: showproduct

Query: SELECT nuke_users.username,nuke_users.user_website,nuke_users.user_posts,nuke_ranks.rank_title,nuke_users.user_regdate FROM nuke_users LEFT JOIN nuke_ranks ON nuke_users.user_rank = nuke_ranks.rank_id WHERE nuke_users.user_id=2 LIMIT 1

Result: Table 'micdi.nuke_ranks' doesn't exist

Database handle: Resource id #7
**End Error*

I have RP added as an iframe in the modules folder of PHPNuke. You can view products that don't have reviews fine. But once I add a review it starts freaking out and gives me that error. I looks like it's trying to use a nuke table instead of a RP table, why would it do this, it's only and iframe.

I am adding the product using my admin logon.

Thanks for any help.

You can view the site here www.micdigest.com
the review post install is here: http://www.micdigest.com/modules.php?name=DigestReviews
bloud is offline   Reply With Quote