[horde] MDB2 Error: unknown error - When Attempting to Create Calendar, Address Book, Memo, or Task

[Brian Spraker]

Correct.

I have installed all extensions that I believe are needed with horde.  I setup 
PHP 5.2.14 compiling with the same extensions that PHP 5.3.2 is using.

I even did a 'sudo apt-get install horde3' on the server to look at the other 
suggested/required packages - and the only ones available are the suggested 
horde applications.

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: Sun, January 2, 2011 12:33:04 PM
Subject: Re: [horde] MDB2 Error: unknown error - When Attempting to Create 
Calendar, Address Book, Memo, or Task


On Jan 2, 2011, at 12:19 PM, Brian Spraker <spraker at yahoo.com> wrote:

> OK - so Horde doesn't have issues with PHP 5.3.x.  However, what about the 
>other 
>
> applications - turba, kronolith, nmemo, etc?

Sorry, that is what I meant.  I am running Horde 3 and Horde 4 on the exact same 
version of PHP, on ubuntu, without any problems.

I am assuming that you have installed separate php-mysql extensions for each php 
version you are running and have ensured each version is using the correct 
extensions?


> 
> Horde does work without problems with PHP 5.3.x, but the other applications 
> throw the MDB2 error.
> 
> I've turned off E_DEPRECATED errors and ensured that pear MDB2,  MDB2/mysql, 
> MDB2/mysqli and MDB2_Schema are installed.  The problem  persists.
> 
> But, the moment that I change to using PHP 5.2.14, everything works.
> 
> Brian S.
> 
> 
> ----- Original Message ----
> From: Michael J Rubinsky <mrubinsk at horde.org>
> To: horde at lists.horde.org
> Sent: Sun, January 2, 2011 10:56:17 AM
> Subject: Re: [horde] MDB2 Error: unknown error - When Attempting to Create 
> Calendar, Address Book, Memo, or Task
> 
> 
> 
> On Jan 2, 2011, at 11:30 AM, Brian Spraker <spraker at yahoo.com> wrote:
> 
>> Hello all,
>> 
>> I began to recently receive the error message:
>> 
>> MDB2 Error:  unknown error
>> 
>> When attempting to create a new calendar, address book, memo pad, or task pad 

>> in 
>> 
>> Horde.
>> 
>> I have the very latest versions of all software for Horde.
>> 
>> Here is the catch that I've found.
>> 
>> I recently updated the Ubuntu server from PHP 5.2.x to PHP 5.3.2 with a 
>> distribution upgrade.  I also have installed PHP 4.2.14 in FastCGI mode so I 
>> can 
>> 
>> run both versions of PHP simultaneously depending upon one extra configuration 
>
> 
>> setting in the VirtualHosts in Apache.
>> 
>> Ever since the upgrade to PHP 5.3.2, this error message occurs.  If I add the 

>> configuration line in the Apache config to have the VirtualHost use PHP 5.2.14, 
>>
>> 
>> the error does not happen and the object is created without a problem.
>> 
>> Has anyone heard of potential problems with PHP 5.3.x with Horde applications 

>> and any solutions?  Really would prefer to use PHP 5.3.2 with Horde instead of 
>
> 
>> downgrading to PHP 5.2.14 for the VirtualHost.
> 
> There are no issues with Horde and PHP 5.3.x. 
> 
> 
>> 
>> In the Horde.log:
>> 
>> [pid 8202 on line 1053 of 
>> "/home/bsntech-com/www/webmail/lib/Horde/Share/sql.php"]
>> Jan 02 10:09:51 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, attribute_desc, perm_creator, perm_default, perm_guest, 
>> share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
>> [Native code: 0]
>> [pid 8283 on line 1053 of 
>> "/home/bsntech-com/www/webmail/lib/Horde/Share/sql.php"]
>> 
>> 
>> Thank you for any help you can provide!
>> 
>> Brian Spraker -- BsnTech Networks
>> http://www.bsntech.com
> 
> Check that both instances of PHP have the same database extensions installed, 
> and both have the needed PEAR MDB2 drivers installed...
> 
> --
> Mike
> Sent from my iPad...