Author Topic: Error 1064  (Read 1334 times)

Offline yzzabel

  • Coccinella
  • *
  • Posts: 9
  • Karma: +0/-0
Error 1064
« 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

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.006
  • Karma: +1/-0
Re: Error 1064
« Reply #1 on: 15 September 2017, 14:52:51 »
Hi yzzabel,
which abook version are you using now?
Could you give me the website link?
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!

Offline yzzabel

  • Coccinella
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Error 1064
« Reply #2 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.


Offline yzzabel

  • Coccinella
  • *
  • Posts: 9
  • Karma: +0/-0
Re: Error 1064
« Reply #3 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.

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.006
  • Karma: +1/-0
Re: Error 1064
« Reply #4 on: 11 October 2017, 09:45:11 »
Many thanks for your feedback.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!