search

bgarrels / textpattern

Automatically exported from code.google.com/p/textpattern
0 stars 0 forks source link

Documentation: MySQL system requirements too low #381

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

1. Use a MySQL server instance below version 4.1
2. Navigate to the "Sections" tab
3. Experience a MySQL error stating something like "You have an error in your 
SQL syntax.  Check the manual that corresponds to your MySQL server version for 
the right syntax to use near 'SELECT count(  *  )"

We introduced a subquery to get the article count per section in r3832.

Apparently MySQL started to support this particular subquery syntax with 
version 4.1 (see http://dev.mysql.com/doc/refman/4.1/en/subqueries.html).

Original issue reported on code.google.com by r.wetzlmayr on 11 Jun 2013 at 7:51

GoogleCodeExporter commented 9 years ago 
Upped required MySQL version to 4.1 in 
http://textpattern.com/about/119/system-requirements

Original comment by r.wetzlmayr on 11 Jun 2013 at 7:54