[horde] MDB2 Error: Revisited

[Michael J Rubinsky]

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

> 
> 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: Tue, January 4, 2011 7:46:10 PM
> Subject: Re: [horde] MDB2 Error:  Revisited
> 
> 
> 
> On Jan 4, 2011, at 8:29 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: "horde at lists.horde.org" <horde at lists.horde.org>
>> Sent: Tue, January 4, 2011 7:23:22 PM
>> Subject: Re: [horde] MDB2 Error:  Revisited
>> 
>> 
>> 
>> 
>> On Jan 4, 2011, at 7:24 PM, Brian Spraker <spraker at yahoo.com> wrote:
>> 
>>> OK - I'm bringing the subject up again because there is something that I am not 
>>> 
>>> 
>>> quite understanding.  Apparently this doesn't cause a problem since it works 
>>> with PHP 5.2.14 but not PHP 5.3.2.
>>> 
>>> Looking at the horde.log, I see this error:
>>> 
>>> Jan 04 18:18:06 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, attribute_desc, perm_creator, perm_default, 
> 
>>> perm_guest, share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
>>> [Native code: 0]
>>> [pid 31754 on line 1053 of 
>>> "/home/bsntech-com/www/webmail/lib/Horde/Share/sql.php"]
>>> 
>>> OK - so my question is this - how can horde be inserting question marks (?) 
>>> into 
>>> 
>>> the turba_shares table when there are several fields that only accept integers 
>> 
>> 
>> 
>> These are placeholders for prepared SQL statements, the correct values are 
>> inserted by the MDB2 driver.
>> 
>> --
>> Mike
>> Sent from my iPad..
>> 
>> Thank you Mike.  Why wouldn't the actual values show up in the horde log then?  
>> 
>> Certainly would think that horde would fill in those values instead of 
>> questions 
>> 
>> marks to help.  Completely at a loss on this one and have went through all of 
>> my 
>> 
>> troubleshooting knowledge.
>> 
> 
> 
> Horde does log the array of values in the debug output. This is an error string 
> coming directly from the MDB2 pear package, which Horde outputs to the error 
> log.
> 
> 
> --
> Mike
> Sent from my iPad...
> 
> 
>