[Tickets #4849] MDB2 Error adding bookmark

Mon Jan 8 05:17:19 PST 2007

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4849
-----------------------------------------------------------------------
 Ticket             | 4849
 Created By         | vfigueiro at gocial.pt
 Summary            | MDB2 Error adding bookmark
 Queue              | Trean
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------

vfigueiro at gocial.pt (2007-01-08 05:17) wrote:

Using latest HEAD with pgsql.

Whenever I try to add a new bookmark, I get the following message:
"There was an error adding the bookmark: MDB2 Error: unknown error"

In pgsql's log:
LOG:  statement: SET SESSION DATESTYLE = 'ISO'                            

LOG:  statement: SELECT NEXTVAL('trean_bookmarks_seq')                    

LOG:  statement: PREPARE
mdb2_statement_pgsql_19e382a54dc81783ea1aefc6f57ed6d6 (text, text, text,
text, text, text, text, text,
 text)  AS                                                                

	            INSERT INTO trean_bookmarks                                  

	                (bookmark_id, folder_id, bookmark_url, bookmark_title,
bookmark_description,                               
	                 bookmark_clicks, bookmark_rating, favicon_id,
bookmark_http_status)                                       
	            VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)                  

ERROR:  column "bookmark_id" is of type integer but expression is of type
text                                                 
HINT:  You will need to rewrite or cast the expression.                   