[horde] SQL errors with Kronolith

[Daniel Bareiro]

Hi, Jan.

On 10/01/17 14:29, Jan Schneider wrote:

>>>> During the day I was observing in the syslog some SQL errors with
>>>> Kronolith:
>>>>
>>>> -----------------------------------------------------------------------
>>>> Jan  8 23:02:40 mail HORDE: [kronolith] SQL QUERY FAILED:
>>>> SQLSTATE[42000] Syntax error or access violation: 1064 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 'ON t.tag_id =
>>>> tagged.tag_id AND tagged.object_id = 310' at line 1  #012#011SELECT
>>>> DISTINCT t.tag_id AS tag_id, tag_name FROM#012#011
>>>> `rampage_tags``rampage_tagged` tagged ON t.tag_id = tagged.tag_id
>>>> AND#012#011  tagged.object_id = 310 [pid 13824 on line 234 of
>>>> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
>>>> -----------------------------------------------------------------------

>>> Is this the complete error message? The SQL query is not complete.

>> Yes, it's the same line that was repeated over and over again.

>>>> I'm using Horde Groupware Webmail Edition 5.2.14 and kronolith
>>>> 4.2.16 on
>>>> Debian GNU/Linux Jessie.

>>> Make sure your "content" application is up-to-date too.
>>>
>>>> If I can provide more information, please let me know.
>>>
>>> If updating "content" doesn't help, enable debug logging and send the
>>> backtrace being logged.

>> It's strange. Reviewing the last seven syslog rotations, I only see this
>> error in syslog.2.gz, with 130 occurrences. It seems that this error has
>> faded. The last time I saw it was in Jan 9 01:10:28 GMT-3.
>>
>> I have not made any changes in Horde. What did you mean by "content"
>> application?

> "content" is one of the modules (applications) of Horde, like IMP,
> Turba, or Kronolith.

Ah! Thank you for clarification. As far as I can see, the version of
"content" is updated: 2.0.5. I have not seen again the SQL error I
mentioned.


Thanks for your reply.

Kind regards,
Daniel

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL: <https://lists.horde.org/archives/horde/attachments/20170113/402d2afd/attachment.bin>