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

[Brian Spraker]

As an additional note - here is other troubleshooting I've done:

Copied the php.ini from the PHP 5.2.14 install to the PHP 5.3.2 install location 
and restarted Apache - to see if there was a php.ini issue - Did not resolve the 
problem.

Disabled all PHP extensions (curl, imagick, suhosin, gd, mcrypt, snmp) to 
restarted Apache - still did not resolve the issue.

So - the begging question is - why does the creation of the objects (address 
book, contact list, etc) works just fine with PHP 5.2.14 - but gives the MDB2 
Error with PHP 5.3.x?  Specifically using PHP 5.3.2 on the servers currently.

Brian S.
BsnTech Networks



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


> 
> 
> 
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
-- 
Horde mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org