[horde] MDB2 Error: Revisited
Michael J Rubinsky
mrubinsk at horde.org
Thu Jan 6 20:03:43 UTC 2011
On Jan 6, 2011, at 1:26 PM, Brian Spraker <spraker at yahoo.com> wrote:
>
>
>
>
> ----- 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?
Neither. I'm using up to date CVS and Git code.
> 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.
I would use debug, but it looks like it's already logging debug output anyway.
> 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"]
I would start by looking at this line, and var_dump the full error object.
--
Mike
> 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