[horde] Recreate horde_histories table

Louis-Philippe Allard lp.allard.1 at gmail.com
Sun Oct 26 21:07:17 UTC 2014


Hello,

I am still having extreme troubles with my horde setup and I have not
received any replies from my last email to the mailiing list in regards to
recreating the "horde_histories" table.

For an unknown reason (I assume database corruption of some sort) the
horde_histories table is currently corrupted and as a result horde is
having troubles writing to it (understandably) and therefore it stopped
working..

I tried running "horde-db-migrate" but the script just executes and doesnt
report any modifications to the table and doesnt recreate it.

Under the adminbistration panel of horde, it says "Schema OK" besides
horde-histories which is confusing for me since the table is empty with the
exception of a single field with numbers in it but nothing else.

The errors I see in /var/log/messages are typically:

Oct 26 11:01:03 centos HORDE: [imp] SQL QUERY FAILED: Table
'horde.horde_histories' doesn't exist  #012#011SELECT * FROM
horde_histories WHERE object_uid =#012#011
'imp:lp*allard*1 at gmail*com:<1954764206.4377263.1414281838672.JavaMail.#012#011
root at worker001.ix5>' [pid 20419 on line 315 of
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Oct 26 11:01:03 centos HORDE: [imp] SQL QUERY FAILED: Table
'horde.horde_histories' doesn't exist  #012#011SELECT * FROM
horde_histories WHERE object_uid =#012#011  'imp:lp*allard*1 at gmail
*com:<issues/1961/60515761 at gi#012#011  thub.com>' [pid 20419 on line 315 of
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Oct 26 11:02:59 centos HORDE: [imp] SQL QUERY FAILED: Table
'horde.horde_histories' doesn't exist  #012#011SELECT * FROM
horde_histories WHERE object_uid =#012#011
'imp:lp*allard*1 at gmail*com:<1189491432.3362962.1414281838485.JavaMail.#012#011
root at worker002.ix5>' [pid 20413 on line 315 of
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Oct 26 11:02:59 centos HORDE: [imp] SQL QUERY FAILED: Table
'horde.horde_histories' doesn't exist  #012#011SELECT * FROM
horde_histories WHERE object_uid =#012#011  'imp:lp*allard*1 at gmail
*com:<201410261217.s9QCHmGN007097 at centos#012#011>' [pid 20413 on line 315
of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]

If someone can help with this ongoing issue I'd appreciate....

Thanks


More information about the horde mailing list