[horde] Recreate horde_histories table

[Vilius Sumskas/LNK]

>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"]

Drop horde_histories and horde_histories_schema tables. Then execute initiate the schema trough administration GUI or horde-db-migrate.

-- 
   Vilius