[ic] Odd DBI error.

Mike Heins mike at perusion.com
Mon Jul 5 12:14:58 EDT 2004


Quoting Sandy Thomson (sandy at scotwebshops.com):
> Hi,
> I am having odd DBI errors when trying to use a table:
> 
> The weird thing is, i can insert into this table fine from a webpage 
> which makes me think it is a bug with interchange, rather than something 
> wrong with my config.
> Using the postgres command line i can select and insert fine.
> 
> Postgres version is 7.4.3, Interchange version is 5.0.
> 
> Error i get:
> ----
> 217.43.239.244 4kB5gCRh:nobody - [05/July/2004:11:33:42 +0100] clubdev 
> www.scotwebshops.com/clubdev/sr_swhdr_standard_pc_outfit.html Query on 
> table prodlink; failed: Can't call method "config" on an undefined value 
> at /home/shops/interchange-5.0/lib/Vend/Table/DBI.pm line 1980.
> >
> > Query was: SELECT * FROM prodlink;
> ----
> 
> catalog.cfg:
> ----
> Variable SQLDSN dbi:Pg:dbname=<database_name>
> Variable SQLUSER <the db user>
> 
> Database prodlink prodlink.txt __SQLDSN__
> Database prodlink USER __SQLUSER__
> Database prodlink DEFAULT_TYPE TEXT
> Database prodlink COLUMN_DEF "product=text"
> Database prodlink COLUMN_DEF "link=integer"
> ----
> 
> products/prodlink.txt
> ----
> product<tab>link
> ----
> 

You don't show what ITL code generates this, but I am guessing that
if you added a "table=prodlink" parameter to your [query ...] it
would work.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer


More information about the interchange-users mailing list