Review error

[Farnee]

Hi

I just finished uploading review post and all went well, except when I add a product review I the the following error

MySQL error reported!

Script: showproduct

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

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

Database handle: Resource id #6

I can upload the product and write a review for it but when I post it I get that error!

What have I done?

[Chuck S]

what are you integrating with?

If its reviewpost or photopost try this in the forum integration files for eith one of those

change this

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

to

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

[Farnee]

Do I have to integrate ReviewPost with a forum? or anything at all?

[Chuck S]

You integrate with whatever you integrate with itself is fine. I was just asking so I provide the proper response

You gave no response so I am assuming you are using a standalone install and the fix above should work

[Farnee]

I am using as standalone.

So what files(s) do I need to change?

[Chuck S]

the change posted above in your /forum/reviewpost.php file

[Farnee]

I have done that but I still get the same error....

[Chuck S]

I don't see how if you made the change I posted you would get the same error and the rest of the program is working. If the program can not find {$Globals['pp_db_prefix']}users it certainly would not find everything else either {$Globals['pp_db_prefix']}photos etc

Try making sure that file actually did UPDATE!!

[Farnee]

Everything works fine for the first time. I can upload a new product, view that product and then write a review. But as soon as I go to view that product for a 2nd time I get the error.

I have uploaded the file 3 times now and its still the same error

[Farnee]

Hello?

Can anyone help me?

[Farnee]

Forget it

I think I have fixed it. It was looking for the database.

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

It wasnt looking for realcr2_test.rp_users, so I removed in rp_ prefix and seems to be working now....