[horde] MDB2 Error: Revisited

Thu Jan 6 21:10:37 UTC 2011

What happens when PHP 6 droops the mysql driver and moves to mysqli?  Hopefully 
this won't be an issue at that point.

----- 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:53:55 PM
Subject: Re: [horde] MDB2 Error:  Revisited

On Jan 6, 2011, at 3:42 PM, Brian Spraker <spraker at yahoo.com> wrote:

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

This was suggested earlier in the thread :)

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

They are separate php extensions. You probably either don't have the mysqli 
extension installed, have a version of mysql that is  too old  for mysqli, or 
maybe MDB2 has issues with it for some reason.  for more information, see 
http://php.net/mysqli

Mike

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