[horde] SQL errors with Kronolith

[Daniel Bareiro]

Hi, Jan.

On 09/01/17 08:34, 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?


Thanks for your reply and your time.


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/20170110/76693b47/attachment.bin>