Vox Populi(x) forum

Alexandria Book Library => Errori (Bugs) => Topic started by: yzzabel on 15 September 2017, 11:25:39

Title: Error 1064
Post by: yzzabel on 15 September 2017, 11:25:39
Hi!

Got a 1064 error
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 ') GROUP BY a.id LIMIT 5' at line 7

This happens when Abook All in one is enabled in the modules section. It happened after software update.

I'm using PHP version 7.0.22-0ubuntu0.16.04.1 and Mysql version 5.7.19-0ubuntu0.16.04.1
Title: Re: Error 1064
Post by: federica on 15 September 2017, 14:52:51
Hi yzzabel,
which abook version are you using now?
Could you give me the website link?
Title: Re: Error 1064
Post by: yzzabel on 18 September 2017, 10:35:14

Dear Federica,

I'm using ABook version 3.1.1 and Joomla 3.7.5.

I can not give you access right now because I'm out of the office. I'll do it tomorrow when I report for work.

I setup a new development server to test if ABook will work with the latest Linux and PHP versions. I don't want to upgrade our production server until I am sure that ABook will work with the latest Ubuntu, Joomla and PHP. anks,

Thank you.

Title: Re: Error 1064
Post by: yzzabel on 22 September 2017, 11:43:20
Hi Federica,

The problem is solved.

It was my mistake. I created a new module of type Abook All in one instead of using the module that was created when I installed the Abook All in one module and just rename it.

Thanks.
Title: Re: Error 1064
Post by: federica on 11 October 2017, 09:45:11
Many thanks for your feedback.