The following MySQL error occurs at the home page post-installation after adding two products to the "test" shop:

You have an error in your SQL syntax near 'rand() limit 12' at line 5

The syntax appears to be correct and similar to other result sets, which may error as well, but i haven't gotten past this one yet. I understand that I am able to remove the "randomization" and the problem may be alleviated, but I thought I would post, since it appears as a new version is in "the works".

In addition, the following error occurs when two products are entered into the "test" shop and, using the "quick search" feature, you select one of the products:

You have an error in your SQL syntax near ') and p.active = 'yes'' at line 1 {CATEGORY_NAME}
You have an error in your SQL syntax near ') and p.active = 'yes' ' at line 1 {PAGES}

I have not investigated the second MySQL error at all, but I will post if I find a resolution.

-Cy