Hi Nitha,

This is a bug with Store 01.00.01! You have probably created a test user account and add a review with this user, then you have deleted this account. Because the review module try to link this account with the coresponding review records, you receive this error!

For correcting this problem, login to the web site as Host. Go to Host > SQL menu. Copy and paste the full line below in the text box:

delete from {databaseOwner}{objectQualifier}Store_Reviews where UserID not in (select UserID from {databaseOwner}{objectQualifier}Users)

Check the option "Run as Script" then click on Execute. That's all!

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

Hi vitkoz,

I do not have only one response. It's depends if you have a short dead line for your project. In this case my advice is: try WWStore 02.00.08. If you have time, wait for Store 02.01.00. I repeat from month that WWStore is the code base of Store. In other words, for 99.90% it's the same module. It's your choice!

I do my best for unify both projects and offer a working module for the community. From months too, I give ~1h/day for support in US and French forums. But I do not have any "offical" responsability in the US community. Here, I'm like all other people in the community, I do not control anything!

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.