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

[Jan Schneider]

Zitat von Brian Spraker <spraker at yahoo.com>:

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

The opposite is actually true, using FastCGI for PHP usually scales  
much better, and beside *not* having to load the configuration and the  
extensions on every request, you *additionally* save the PHP startup.

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

Use Horde to delete (or at least reset) users.

> 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...
>
>
>
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/