MySQL error after posting review

[bloud]

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

[Michael P]

Do you not have a nuke_ranks table? Last version we tested with had this table - is your version different?

[bloud]

Actually I just looked and No there is no nuke_ranks table. I am using PHP-Nuke 7.5 Final version. I was hoping that it was just a Query issue.

[bloud]

There is a nuke_bbranks and user_rank field in the nuke_users table.

But I don't see anywhere in the showproduct.php file where it is querying a rank table at all.

[Chuck S]

In the nuke.php file in the forums directory under reviewpost

Line 151-159

if ($cuserid != 0) {
if ( !empty( $Globals['dprefix'] ) ) {
$utable = "{$Globals['dprefix']}users";
$rtable = "{$Globals['dprefix']}ranks";
}
else {
$utable = "users";
$rtable = "ranks";
}


would become this

if ($cuserid != 0) {
if ( !empty( $Globals['dprefix'] ) ) {
$utable = "{$Globals['dprefix']}users";
$rtable = "{$Globals['dprefix']}bbranks";
}
else {
$utable = "users";
$rtable = "bbranks";
}

[bloud]

Bingo! Thanks for the fast help. Works great now.....