[ic] IC 5.6.1 + Pg 8.4 = Problem
peter at pajamian.dhs.org
Tue Aug 25 03:13:10 UTC 2009
On 08/24/2009 10:46 AM, Toni Mueller wrote:
> I've just tried to set up the 'standard' shop included with IC 5.6.1 to
> test drive, and found that it does not work:
> 127.0.1.1 mojjh362:127.0.1.1 - [24/August/2009:18:07:35 +0200] standard /cgi/standard Runtime error: DBD::Pg::st execute failed: ERROR: operator does not exist: character varying <> integer
>> LINE 1: select * from products WHERE inactive <> 1
>> HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. at /home/imke/interchange/lib/Vend/Table/DBI.pm line 1910.
> The test box is Debian-Lenny with a backported PostgreSQL (ie, 8.4).
This line should fix it (untested on debian), provided you have sudo:
| sudo -u postgres psql
More information about the interchange-users