Tickets :: [#4849] MDB2 Error adding bookmark

6.0.0-beta1

7/21/25

Summary	MDB2 Error adding bookmark
Queue	Trean
Type	Bug
State	Resolved
Priority	2. Medium
Owners	chuck (at) horde (dot) org
Requester	vfigueiro (at) gocial (dot) pt
Created	01/08/2007 (6769 days ago)
Due
Updated	01/15/2007 (6762 days ago)
Assigned	01/08/2007 (6769 days ago)
Resolved	01/15/2007 (6762 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

01/15/2007 07:55:55 PM	Chuck Hagenbuch	Assigned to Chuck Hagenbuch

01/15/2007 07:55:41 PM	Chuck Hagenbuch	Comment #6 State ⇒ Resolved	Reply to this comment
Great, thanks.

01/15/2007 06:36:20 PM	vfigueiro (at) gocial (dot) pt	Comment #5	Reply to this comment
Please try this update and see if that also works for you: http://lists.horde.org/archives/cvs/Week-of-Mon-20070108/064513.html It works perfectly. Problem solved.

01/10/2007 06:10:57 PM	Chuck Hagenbuch	Comment #4	Reply to this comment
Please try this update and see if that also works for you: http://lists.horde.org/archives/cvs/Week-of-Mon-20070108/064513.html

01/09/2007 09:59:54 AM	vfigueiro (at) gocial (dot) pt	Comment #3	Reply to this comment
What is the value of $bookmark_id then (lib/Bookmarks.php line 1035). We check for errors, so not sure why/how this would be failing. inserting «echo $bookmark_id, gettype($bookmark_id);» on line 1036 prints "27integer". Meanline, I got it working changing line 1044 to: «VALUES (?::integer, ?::integer, ?, ?, ?, ?::integer, ?::integer, ?::integer, ?)');» and doing similar change to the update.

01/08/2007 09:21:45 PM	Chuck Hagenbuch	Comment #2 State ⇒ Feedback	Reply to this comment
What is the value of $bookmark_id then (lib/Bookmarks.php line 1035). We check for errors, so not sure why/how this would be failing.

01/08/2007 01:17:18 PM	vfigueiro (at) gocial (dot) pt	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ MDB2 Error adding bookmark Queue ⇒ Trean State ⇒ Unconfirmed	Reply to this comment
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.