[Tickets #5006] Re: postgresql 8.2.1: Errormessage "IN types character varying and integer cannot be matched"

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=5006
-----------------------------------------------------------------------
 Ticket             | 5006
 Updated By         | mussi at snoop.alphanet.ch
 Summary            | postgresql 8.2.1: Errormessage "IN types character varying and integer
                    | cannot be matched"
 Queue              | Horde Base
 Version            | HEAD
 Type               | Bug
 State              | Feedback
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


mussi at snoop.alphanet.ch (2007-02-25 12:43) wrote:

> Are you sure you are using latest HEAD code? The line that you patch 
> is responsible for a completely different SQL statement, and the code 
> that produces the statement that causes your error is already putting 
> quotes around the values.

I have just tried it again.

Update horde and framework. Type 'php -q install-packages.php' on my box,
wait, and test Bookmarks and mnemo.

Lo' and behold, the same bug with the (421, 425, 423) without quotes
appear again, and I don't see a single bookmark. Apply the patch in the
horde directory against DataTree/sql.php and then rerun the install, and
click 'reload' in the browser button. Bookmarks visible again.

I suspect the bug is only visible if one runs postgresql 8.2.1, so there
might be some version dependency.