[horde] MDB2 Error: Revisited
Michael J Rubinsky
mrubinsk at horde.org
Thu Jan 6 21:30:53 UTC 2011
On Jan 6, 2011, at 4:10 PM, Brian Spraker <spraker at yahoo.com> wrote:
> What happens when PHP 6 droops the mysql driver and moves to mysqli? Hopefully
> this won't be an issue at that point.
>
Well, that's an issue for the MDB2 developers. Regardless, Horde 4 is already moving away from using the DB and MDB2 packages in favor of Horde_DB.
Mike
>
>
> ----- 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.
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
More information about the horde
mailing list