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

[Brian Spraker]

No more ideas on what to check or look for?

I've set Horde to use PHP 5.2.14 in FastCGI mode (since PHP 5.3.2 is the module 
install for Apache).  Everything is working normally - but as you can imagine, 
PHP running in FastCGI mode is much more processor-intensive and it has to open 
the configuration file and all extensions everytime a PHP page is parsed.

While a completely different subject -

When you need to fully delete a user account, how can you be sure you delete the 
user account and all settings that are stored in the horde database - address 
books, preferences, history, calendars, etc?  I've noticed that whenever I 
"delete" users - which is just deleting their mailbox and the row in the 
horde_users table, all of their preferences and such still remain.

Brian S.
http://www.bsntech.com



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