[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