[turba] MDB2 Error: unknown error

[Klemen Humerca]

Hello!

This is from mysql log:


100407  9:00:55    11 Connect   horde at localhost on horde
                   11 Query     SET NAMES cp1250
100407  9:00:56    11 Init DB   horde
                   11 Query     SELECT DISTINCT s.*  FROM turba_shares 
s  LEFT JOIN turba_shares_users AS u ON u.share_id = s.share_id WHERE 
s.share_owner = 'klemen' OR (s.perm_creator & 4) OR (s.perm_default & 4) 
OR ( u.user_uid = 'klemen' AND (u.perm & 4)) ORDER BY s.share_name ASC
                   12 Connect   horde at localhost on horde
                   12 Query     SET NAMES cp1250
                   13 Connect   horde at localhost on horde
                   13 Query     SET NAMES cp1250
                   14 Connect   horde at localhost on horde
                   14 Query     SET NAMES cp1250
                   11 Init DB   horde
                   11 Query     INSERT INTO turba_shares_seq (id) VALUES 
(NULL)
                   11 Init DB   horde
                   11 Query     SELECT LAST_INSERT_ID()
                   11 Init DB   horde
                   11 Query     DELETE FROM turba_shares_seq WHERE id < 2824
                   11 Prepare   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 
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                   11 Quit
                   12 Quit
                   13 Quit
                   14 Quit
                   15 Connect   horde at localhost on horde
                   15 Query     SET NAMES cp1250
                   15 Init DB   horde
                   15 Query     SELECT DISTINCT s.*  FROM turba_shares 
s  LEFT JOIN turba_shares_users AS u ON u.share_id = s.share_id WHERE 
s.share_owner = 'klemen' OR (s.perm_creator & 4) OR (s.perm_default & 4) 
OR ( u.user_uid = 'klemen' AND (u.perm & 4)) ORDER BY s.share_name ASC
                   16 Connect   horde at localhost on horde
                   16 Query     SET NAMES cp1250
                   17 Connect   horde at localhost on horde
                   17 Query     SET NAMES cp1250
                   15 Init DB   horde
                   15 Query     SELECT DISTINCT s.*  FROM turba_shares 
s  LEFT JOIN turba_shares_users AS u ON u.share_id = s.share_id WHERE  
(s.share_owner = 'klemen' OR (s.perm_creator & 4) OR (s.perm_default & 
4) OR ( u.user_uid = 'klemen' AND (u.perm & 4))) AND s.share_owner = 
'klemen' ORDER BY s.share_name ASC
                   18 Connect   horde at localhost on horde
                   18 Query     SET NAMES cp1250
                   15 Quit
                   16 Quit
                   17 Quit
                   18 Quit


There is something wrong with sending variables to database > VALUES (?, 
?, ?, ?, ?, ?, ?, ?, ?, ?)

Klemen Humerca
( klemen at humerca.com | www.humerca.com)



Dne 6.4.2010 9:30, Jan Schneider pravi:
> Zitat von Klemen Humerca <klemen at humerca.com>:
>
>> Hello!
>>
>> I'm having problems creating new Address book and setting address 
>> book permissions. I always get this error: MDB2 Error: unknown error. 
>> I created a new table turba_shares, but error still occurs. I also 
>> reinstalled pear module MDB2 and made a clean install (from cvs) of 
>> horde module turba.
>>
>> This is what I see in horde.log:
>>
>> [pid 16002 on line 1040 of "/usr/share/pear/Horde/Share/sql.php"]
>> Apr 02 09:58:12 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 16112 on line 1040 of "/usr/share/pear/Horde/Share/sql.php"]
>
> Check your database logs. Obviously the database doesn't give a proper 
> error message back, but it's worth a look.
>
> Jan.
>