Error 1064

Started by yzzabel, 15 September 2017, 11:25:39

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

yzzabel

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

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

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.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

yzzabel


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.


yzzabel

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.

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

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.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]