[ic] Error creating database with foundation demo on devel interchange

[Stefan Hornburg Racke]

Casey West <casey@geeknest.com> writes:

> On Thu, Apr 18, 2002 at 12:32:15PM -0400, Casey West wrote:
> :
> :On Thu, Apr 18, 2002 at 10:09:36AM +0200, Stefan Hornburg (Racke) wrote:
> ::
> ::Casey West <casey@geeknest.com> writes:
> ::
> ::> After I finish running bin/makecat and I run bin/interchange -r, I get
> ::> the following error after every table creation.  I'm using the
> ::> postgres database and everything in the sql db is being created and
> ::> inserted.
> ::> 
> ::>   (SQL insert statements yak yak...)
> ::> 
> ::>   table 'products' failed: DBD::Pg::db table_info failed: ERROR:
> ::>   parser: parse error at or near "left" at
> ::>   /home/sites/site10/interchange/lib/Vend/Table/DBI.pm line 539.
> ::> 
> ::>   kvs config error: products not a database, cannot use as products
> ::>   file
> ::> 
> ::>   kvs: error in configuration. Skipping.
> ::>   kvs: config error. Skipping.
> ::>   Interchange server started in INET and UNIX mode(s) (process id 24965)
> ::> 
> ::> As stated, this happens for every table, not just products.  I'm a
> ::> little perplexed because I've had no problems using devel on a vanilla
> ::> redhat 7.2, but the exact same source is killing me on a cobalt raq3
> ::> (i386) that carries a linux built by cobalt (of course, this shouldn't
> ::> matter).
> ::
> ::Probably you should mention the versions of Interchange, DBI and DBD::Pg
> ::to get help.
> :
> :I should also mention it's a raq4 and not raq3.  DBI is 1.21 and
> :DBD::Pg is 1.12.  I am using Perl 5.6.1 in /usr/local
> 
> I tried just going with the latest stable release from cvs and I have
> verified that this happens with -stable too.
> 
> Any thoughts on the problem?  I don't think I have any other option
> but to believe it's something outside interchange causing this but,
> what?

Can you please list the SQL insert statements Interchange tries ?

Ciao
        Racke

-- 
Think of it !

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)