[horde] MDB2 Error: Revisited
Brian Spraker
spraker at yahoo.com
Thu Jan 6 18:26:05 UTC 2011
----- Original Message ----
From: Michael J Rubinsky <mrubinsk at horde.org>
To: Brian Spraker <spraker at yahoo.com>
Cc: Michael J Rubinsky <mrubinsk at horde.org>; "horde at lists.horde.org"
<horde at lists.horde.org>
Sent: Thu, January 6, 2011 11:42:04 AM
Subject: Re: [horde] MDB2 Error: Revisited
On Jan 6, 2011, at 11:33 AM, Brian Spraker <spraker at yahoo.com> wrote:
> OK -
>
> I have just installed a clean copy of Ubuntu 10.04 64-bit with Horde Groupware
> Webmail Edition 1.2.9 along with apache2, dovecot, and exim.
>
> I left the horde database exactly the same and created a new user.
>
> Logged in with the new user and tried to make an address book. Same MDB2
>error.
>
> So to me, there is clearly a problem with turba/kronolith/mnemo/nag and the
> other applications with MDB2 and PHP 5.3.2.
>
> I ran the test.php page to check to ensure all dependencies were met, and they
> are. However, there is a notice about the PHP version:
>
> This version of PHP has not been fully tested with this version of Horde.
I am using the same distro, with the same packaged version of php. I see NO
issues with either Horde 4 or Horde 3 code. I can create and otherwise
manipulate shares with no issues.
Have you tried with a fresh DB? You, or someone else experiencing this issue, is
going to have to trace the problem. A better error message dumped from the
code, or a backtrace might be helpful here.
--
mike
Are you using the version that is installed by Ubuntu by doing the 'sudo apt-get
install horde3' or are you downloading the Horde Groupware WebMail Edition tar
file from the site and using it this way?
I have used a completely new install - even on a different computer. I then
installed Horde from the tar file and ran the scripts/setup.php file to setup
the database and everything brand new.
What kind of logging information would be beneficial? I set logging as
PEAR_NOTICE in Horde. Here is the result from the moment I turned that on - to
navigating to the address book and attempting to create the address book:
Jan 06 12:03:23 HORDE [error] [turba] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO turba_shares (share_name, share_owner,
attribute_name, attribute_params, perm_creator, perm_default, perm_guest,
share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5118 on line 452 of "/var/www/horde/turba/lib/Turba.php"]
Jan 06 12:03:23 HORDE [error] [kronolith] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO kronolith_shares (share_name, share_owner,
attribute_name, perm_creator, perm_default, perm_guest, share_flags, share_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5118 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:03:23 HORDE [error] [nag] MDB2 Error: unknown error: _execute: [Error
message: Unable to execute statement]
[Last executed query: INSERT INTO nag_shares (share_name, share_owner,
attribute_name, perm_creator, perm_default, perm_guest, share_flags, share_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5118 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:03:23 HORDE [error] [mnemo] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO mnemo_shares (share_name, share_owner,
attribute_name, perm_creator, perm_default, perm_guest, share_flags, share_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5118 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:03:49 HORDE [error] [kronolith] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO kronolith_shares (share_name, share_owner,
attribute_name, perm_creator, perm_default, perm_guest, share_flags, share_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5120 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:03:49 HORDE [error] [nag] MDB2 Error: unknown error: _execute: [Error
message: Unable to execute statement]
[Last executed query: INSERT INTO nag_shares (share_name, share_owner,
attribute_name, perm_creator, perm_default, perm_guest, share_flags, share_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5120 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting sam inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting forwards inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting genie inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting trean inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting chora inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting whups inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting luxor inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting klutz inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting mottle inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting jonah inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting goops inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting juno inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting midas inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting sesha inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting hermes inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting gollem inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting jeta inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting agora inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting ulaform inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting volos inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting ansel inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting scry inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting merk inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting wicked inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting vilma inactive because the
fileroot does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Setting nic inactive because the fileroot
does not exist. [pid 5120 on line 241 of
"/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:03:57 HORDE [debug] [horde] SQL query by Horde_Alarm_sql::_list():
SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods, alarm_params,
alarm_title, alarm_text, alarm_snooze, alarm_internal FROM horde_alarms WHERE
alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR
alarm_snooze <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS
NULL OR alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid
5120 on line 151 of "/var/www/horde/lib/Horde/Alarm/sql.php"]
Jan 06 12:03:57 HORDE [debug] [horde] Max memory usage: 10747904 bytes [pid 5120
on line 340 of "/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:04:00 HORDE [debug] [turba] Hook _horde_hook_share_init in application
horde not called. [pid 5119 on line 1736 of "/var/www/horde/lib/Horde.php"]
Jan 06 12:04:00 HORDE [debug] [turba] SQL query by Horde_Share_sql::listShares:
SELECT DISTINCT s.* FROM turba_shares s LEFT JOIN turba_shares_users u ON
u.share_id = s.share_id WHERE s.share_owner = brian' OR (s.perm_creator & 4) OR
(s.perm_default & 4) OR ( u.user_uid = 'brian' AND (u.perm & 4)) ORDER BY
s.share_name ASC [pid 5119 on line 469 of
"/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:04:00 HORDE [error] [turba] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO turba_shares (share_name, share_owner,
attribute_name, attribute_params, perm_creator, perm_default, perm_guest,
share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5119 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:04:00 HORDE [error] [turba] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO turba_shares (share_name, share_owner,
attribute_name, attribute_params, perm_creator, perm_default, perm_guest,
share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5119 on line 452 of "/var/www/horde/turba/lib/Turba.php"]
Jan 06 12:04:00 HORDE [debug] [turba] SQL query by Horde_Alarm_sql::_list():
SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods, alarm_params,
alarm_title, alarm_text, alarm_snooze, alarm_internal FROM horde_alarms WHERE
alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR
alarm_snooze <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS
NULL OR alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid
5119 on line 151 of "/var/www/horde/lib/Horde/Alarm/sql.php"]
Jan 06 12:04:00 HORDE [debug] [turba] Max memory usage: 16252928 bytes [pid 5119
on line 340 of "/var/www/horde/lib/Horde/Registry.php"]
Jan 06 12:04:02 HORDE [debug] [turba] Hook _horde_hook_share_init in application
horde not called. [pid 5120 on line 1736 of "/var/www/horde/lib/Horde.php"]
Jan 06 12:04:02 HORDE [debug] [turba] SQL query by Horde_Share_sql::listShares:
SELECT DISTINCT s.* FROM turba_shares s LEFT JOIN turba_shares_users u ON
u.share_id = s.share_id WHERE s.share_owner = 'brian' OR (s.perm_creator & 4) OR
(s.perm_default & 4) OR ( u.user_uid = 'brian' AND (u.perm & 4)) ORDER BY
s.share_name ASC [pid 5120 on line 469 of
"/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:04:02 HORDE [error] [turba] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO turba_shares (share_name, share_owner,
attribute_name, attribute_params, perm_creator, perm_default, perm_guest,
share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5120 on line 1053 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jan 06 12:04:02 HORDE [error] [turba] MDB2 Error: unknown error: _execute:
[Error message: Unable to execute statement]
[Last executed query: INSERT INTO turba_shares (share_name, share_owner,
attribute_name, attribute_params, perm_creator, perm_default, perm_guest,
share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[Native code: 0]
[pid 5120 on line 452 of "/var/www/horde/turba/lib/Turba.php"]
Jan 06 12:04:02 HORDE [debug] [imp] IMP_Sentmail_sql::favouriteRecipients():
SELECT sentmail_recipient, count(*) AS sentmail_count FROM imp_sentmail WHERE
sentmail_who = 'brian' AND sentmail_success = 1 AND sentmail_action in ('new',
'forward', 'reply', 'redirect') GROUP BY sentmail_recipient ORDER BY
sentmail_count DESC [pid 5120 on line 114 of
"/var/www/horde/imp/lib/Sentmail/sql.php"]
Jan 06 12:04:02 HORDE [debug] [turba] SQL query by Horde_Alarm_sql::_list():
SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods, alarm_params,
alarm_title, alarm_text, alarm_snooze, alarm_internal FROM horde_alarms WHERE
alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR
alarm_snooze <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS
NULL OR alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid
5120 on line 151 of "/var/www/horde/lib/Horde/Alarm/sql.php"]
Brian S.
More information about the horde
mailing list