mariadb 10.2 syntax error

[panayotb]

Roundcube 1.2.5
MariaDB 10.2

MariaDB does not like when 'rows' is used as column name. The query is in rcube_contacts.php
in "private function _count()"

Error log:

26-May-2017 19:59:33 +0300]: DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM contacts AS c WHERE c.del <> 1 AND c.user_id = '2' AND ((((emai' at line 1 (SQL Query: SELECT COUNT(c.contact_id) AS rows FROM contacts AS c WHERE c.del <> 1 AND c.user_id = '2' AND ((((emailLIKE '[email protected]' ORemailLIKE '[email protected],%' ORemailLIKE '%,[email protected],%' ORemail` LIKE '%,[email protected]'))))) in /var/www/roundcube/program/lib/Roundcube/rcube_db.php

[alecpl]

It is indeed reserved word in MySQL. I suppose we can just rename that alias to cnt.

[alecpl]

Fixed.

[andipfaff]

The correct syntax if using reserved words should be:
... AS rows FROM contacts ...

use backticks to enclose reserved word