Error - Posting a Review

[InterFX]

I have a clean install of RP2.8.2, and am getting this error when posting a review on the first product I have uploaded... I am using the standalone RP user system - what do I need to do to fix this?

Thanks in advance...

InterFX



MySQL error reported!

Script: showproduct

Query: SELECT username,homepage,posts,joindate,location FROM users WHERE userid=1 LIMIT 1

Result: Table 'worthy_db.users' doesn't exist

Database handle: Resource id #7

[InterFX]

Found the solution in another thread... Please update the *.zip download file from the members area... Will help others with same issue...

Thanks -
InterFX

In forums/reviewpost.php find this at line 120

$query = "SELECT username,homepage,posts,joindate,location FROM {$Globals['dprefix']}users WHERE userid=$cuserid LIMIT 1";

change to

$query = "SELECT username,homepage,posts,joindate,location FROM {$Globals['rp_db_prefix']}users WHERE userid=$cuserid LIMIT 1";

[Chuck S]

Yep thats it.