Wiki . Forums . Bugs . Translation . Privacy Policy | Search . Simple . Advanced | Reports . Help | Matrix . 10.x . 11.x . 12.x . 13.x . Future . Recent . Contribs

Bug 8528 - HORDE5.2.1: SQL QUERY FAILED: Table 'horde.horde_dav_collections' doesn't exist
Summary: HORDE5.2.1: SQL QUERY FAILED: Table 'horde.horde_dav_collections' doesn't exist
Status: CLOSED NOTABUG
Alias: None
Product: SME Contribs
Classification: Contribs
Component: Unknown (show other bugs)
Version: 9beta
Hardware: --- ---
: P3 normal (vote)
Target Milestone: ---
Assignee: SME Server bug team
QA Contact:
URL:
Depends on:
Blocks: 6653
  Show dependency tree / graph
 
Reported: 2014-08-15 01:20 CEST by Stephane de Labrusse
Modified: 2014-08-30 07:11 CEST (History)
1 user (show)

See Also:
Package: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stephane de Labrusse 2014-08-15 01:20:51 CEST
Hi john

I found that bug in horde5.2

Aug 15 09:17:05 sme9dev5 HORDE: [kronolith] SQL QUERY FAILED: Table 'horde.horde_dav_collections' doesn't exist   #011SELECT id_external FROM horde_dav_collections WHERE id_internal = #011  'DA6ilQ3WxCPw_BT-Y5KuFg7' AND id_interface = 'calendar' [pid 2239 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]

Aug 15 09:17:06 sme9dev5 HORDE: [kronolith] SQL QUERY FAILED: Table 'horde.horde_dav_collections' doesn't exist   #011SELECT id_external FROM horde_dav_collections WHERE id_internal = #011  'QJzPwryX0svDUPnW7gaUjA1' AND id_interface = 'tasks' [pid 2239 on line 315 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
(END) 

In order to reproduce it I simply use the calendar and see that warning in /var/log/messages
Comment 5 Stephane de Labrusse 2014-08-30 07:11:33 CEST
closed notabug reopen if needed
Comment 4 Stephane de Labrusse 2014-08-17 12:23:11 CEST
sorry john for my lack of precision but I use the version of horde 5.2.1 that you provided on the your contrib web space.
See http://bugs.contribs.org/show_bug.cgi?id=6653#c61 on how I installed horde52.

I will look after on your last comment.
Comment 3 John H. Bennett III 2014-08-15 09:38:32 CEST
(In reply to Stephane de Labrusse from comment #0)
> Hi john
> 
> I found that bug in horde5.2
> 
> Aug 15 09:17:05 sme9dev5 HORDE: [kronolith] SQL QUERY FAILED: Table
> 'horde.horde_dav_collections' doesn't exist   #011SELECT id_external FROM
> horde_dav_collections WHERE id_internal = #011  'DA6ilQ3WxCPw_BT-Y5KuFg7'
> AND id_interface = 'calendar' [pid 2239 on line 315 of
> "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> 
> Aug 15 09:17:06 sme9dev5 HORDE: [kronolith] SQL QUERY FAILED: Table
> 'horde.horde_dav_collections' doesn't exist   #011SELECT id_external FROM
> horde_dav_collections WHERE id_internal = #011  'QJzPwryX0svDUPnW7gaUjA1'
> AND id_interface = 'tasks' [pid 2239 on line 315 of
> "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
> (END) 
> 
> In order to reproduce it I simply use the calendar and see that warning in
> /var/log/messages

Please update to the most current version of horde, which will be horde 5.2.1.  Your issue is for some reason the Horde_Dav RPM seems to not have been installed, or didn't install correctly.

type - rpm -qa | grep Dav

If you don't see Horde_Dav..., then you can manually install it.

If you see it, then remove it, rpm -e Horde_Dav, and reinstall it.

I never saw this in my testing, but others had reported it on the horde lists, and re-install was always the solution.
Comment 2 Stephane de Labrusse 2014-08-15 02:42:35 CEST
I cannot reproduce this error message with a new server, indeed i have had updated php(php55) and mysql(mysql5.5) on the former server of tests.

with a server without php/mysql updated i have no more warnings in /var/log/messages.

funny ?

probably we ought to close notabug
Comment 1 Stephane de Labrusse 2014-08-15 01:22:05 CEST
Sorry for the noise, john I added you in cc of this bug