MySQL error(s)

[CyYanara]

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

[CyYanara]

I have determined the following error:

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

results from the fact that the script is connecting to MySQL 3.22.32 and "order by rand() limit 12" is only supported by MySQL 3.23.xx

Just a guess, without much investigation again, but the other error may be attributed to the version of MySQL running as well.

-Cy

You need to update your mysql version