[horde] MDB2 Error: Revisited

Thu Jan 6 20:42:56 UTC 2011

Resolved.

Just came across it purely by luck - nothing else.  Trying to do a backtrace 
yielded way too much information to decipher.

I went into the Database setting of Horde and changed the driver from mysqli to 
mysql.

What is the difference between mysqli and mysql that would cause this?

Brian S.

----- Original Message ----
From: Michael J Rubinsky <mrubinsk at horde.org>
To: Brian Spraker <spraker at yahoo.com>
Cc: "horde at lists.horde.org" <horde at lists.horde.org>
Sent: Thu, January 6, 2011 2:03:43 PM
Subject: Re: [horde] MDB2 Error:  Revisited

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.
> 
> 
> 