[horde] MDB2 Error: Revisited

[Brian Spraker]

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

Ran the debug output; still didn't provide the actual data that was to be 
inserted into the table - but sure did give a lot of other debug info about 
other add-ins not being available.

So this seems to be narrowed down to either a pear problem or a PHP 5.3.2 
problem then - I'm assuming - since it has been said that Horde GroupWare works 
fine with PHP 5.3.x.  I plan on setting up a temp server and installing Horde as 
a fresh install to see if the problem occurs on a system with the same software.

Could someone look over my installed pear list below and compare it to yours if 
you are running PHP 5.3.x and you are able to create calendars/address books?

Installed packages, channel __uri:
==================================
(no packages installed)

Installed packages, channel doc.php.net:
========================================
(no packages installed)

Installed packages, channel pear.php.net:
=========================================
Package            Version State
Archive_Tar        1.3.7   stable
Cache              1.5.6   stable
Console_Getopt     1.3.0   stable
DB                 1.7.13  stable
Date               1.4.7   stable
File               1.3.0   stable
Fileinfo           1.0.4   stable
HTTP_Request       1.4.4   stable
Log                1.12.5  stable
MDB2               2.5.0b3 beta
MDB2_Driver_mysql  1.5.0b3 beta
MDB2_Driver_mysqli 1.5.0b3 beta
MDB2_Schema        0.8.5   beta
Mail               1.2.0   stable
Mail_Mime          1.8.1   stable
Mail_mimeDecode    1.5.5   stable
Net_DIME           1.0.2   stable
Net_FTP            1.3.7   stable
Net_SMTP           1.4.4   stable
Net_Socket         1.0.10  stable
Net_URL            1.0.15  stable
PEAR               1.9.1   stable
SOAP               0.12.0  beta
Services_Weather   1.4.5   stable
Structures_Graph   1.0.4   stable
XML_Parser         1.3.4   stable
XML_Serializer     0.20.0  beta
XML_Util           1.2.1   stable

Installed packages, channel pecl.php.net:
=========================================
(no packages installed)


Brian S.

--
Mike
Sent from my iPad...