Plesk 11.5.30 + Horde + Error

[DamirH]

Hi ,
i have after Update (11.5.30) , now= 11.5.30 Update #10
Problems with Horde (5.0.4-ubuntu12.04.build115130710.19).

Fatal Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'share_parents' in 'field list'

I try this:
http://forum.parallels.com/showthread.php?288233-BUG-Plesk-11-5-30-and-Horde-Webmailer-A-fatal-error-has-occurred
but nothing helps
Please help !
Thx a lot
DH

 

[Nikolay.]

First try bootstrapper repair.

If it doesn't help, well, then at least following should help:

1) Remove horde component via Parallels Installer.
2) Remove all leftovers from /etc/psa-webmail/horde.
3) Drop horde database.
4) Install horde component via Parallels Installer.

You'll obviously loose any customizations within Horde.

Alternatively, use Roundcube webmail.

 

[DamirH]

First try bootstrapper repair.

If it doesn't help, well, then at least following should help:

1) Remove horde component via Parallels Installer.
2) Remove all leftovers from /etc/psa-webmail/horde.
3) Drop horde database.
4) Install horde component via Parallels Installer.

You'll obviously loose any customizations within Horde.

Alternatively, use Roundcube webmail.

Success !!!

THX a Lot

Greetz
DH

 

[hgmichna]

Success !!!

THX a Lot

Greetz
DH

So what did you do?

 

[DamirH]

So what did you do?

Success with this solution:

1) Remove horde component via Parallels Installer.
2) Remove all leftovers from /etc/psa-webmail/horde.
3) Drop horde database.
4) Install horde component via Parallels Installer.

 

[Roberto Nunez]

Hi,
It is not a solution for CENTOS 6.4 64bits.

DROP TABLE `ingo_shares_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:32:26+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist
SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN
('calendar','event') [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:32:30+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'turba_shares_seq'
DROP TABLE `turba_shares_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:32:48+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'mnemo_shares_seq'
DROP TABLE `mnemo_shares_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:13+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_groups_seq'
DROP TABLE `horde_groups_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:14+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_histories_seq'
DROP TABLE `horde_histories_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:16+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_perms_seq'
DROP TABLE `horde_perms_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:23+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_vfs_seq'
DROP TABLE `horde_vfs_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:23+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'horde_muvfs_seq'
DROP TABLE `horde_muvfs_seq` [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:35+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'kronolith_shares_seq'
DROP TABLE `kronolith_shares_seq` [pid 54762 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]
2013-08-12T18:33:39+00:00 ERR: HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'kronolith_resources_seq'
DROP TABLE `kronolith_resources_seq` [pid 54762 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"]

It 's a Plesk Bug, can someone give any solution? The webmail is broken...

 

[MatrixCrawler]

Hi,
It is not a solution for CENTOS 6.4 64bits.


It 's a Plesk Bug, can someone give any solution? The webmail is broken...

Any news on that issue?
I have the exact same problem.

 

[Nikolay.]

Log bits posted by Roberto Nunez look like they are from installation/upgrade process. Not being able to drop a given table because it doesn't exist is not an error that would prevent Horde from functioning. If anybody has "similar" problems, they should first check whether they have any real problems and report them instead (maybe in another thread depending on similarity to the original problem of this thread).

 

[SauliusZ]

The solution did not help. The attachments are not send, saved in draft or any other way. The email can be received with attachment with no problem, but can not attach any file to new email using Horde. There is nothing in Horde logs, and in postfix logs message sent succesfully.