[turba] MDB2 Error: unknown error

[Jan Schneider]

Zitat von Klemen Humerca <klemen at humerca.com>:

> 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  
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

No, that's fine, it's a prepare statement. For some reason there is no  
execute statement though, or the execute is failing (see horde log),  
without any further notice in the db log.
No idea where to go from there. Make sure your database is not corrupt, etc.

>
> 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.
>>
> -- 
> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>



Jan.

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