[ic] Novice Help: error - Table Not Found in database

Stefan Hornburg [email protected]
Tue Apr 22 07:05:00 2003


On Tue, 22 Apr 2003 12:41:05 +0200
"Marco Carcano" <[email protected]> wrote:

> I'm trying to develop a site using interchange and an italian desktop
> program. This program uses borland interbase 6.0 as DB.
> I'd like to have interchange accessing this DB. After having installed and
> tested Perl DBD:Interbase I started writing a catalog.cfg from scratch: here
> is what I wrote:
> 
> ######### START OF CATALOG.CFG ###########
> 
> Database articoli articoli.sql
> dbi:InterBase:/opt/interbase/databases/vascabella
> .gdb
> Database articoli USER myusername
> Database articoli PASS mypassword
> Database articoli TAB
> 
> NoImport articoli
> ProductFiles articoli
> VendURL http://www.vascabella.it/cgi-bin/prova
> SecureURL http://www.vascabella.it/cgi-bin/prova
> MailOrderTo [email protected]
> 
> #########################################
> 
> Then I wrote an index.html page;
> 
> ######## START OF INDEX.HTML ###########
> 
> [comment]
> ui_template: Yes
> ui_template_name: top
> [/comment]
> 
> [tmp page_title]__COMPANY__ -- Benvenuto[/tmp]
> 
> 
> @[email protected]
> @[email protected]
> [query sql="select descrizione from articoli" list=1]
> column_A: [sql-param descrizione]<br>
> [/query]
> 
> @[email protected]
> ##########################################
> Note *** table articoli has not a field called sku: the primary key here is
> called articolo and is varchar(7).
> 
> I restart interchange and all seems right, but if I try to access the
> index,html page, the page is displayed without giving results.
> I found this error in error.log:
> "151.29.252.65 FB7Yx4Kx:151.29.252.65 - [22/aprile/2003:06:17:09 -0400]
> prova /cgi-bin/prova/index.html Table articoli not found in databases"
> I'm sure DBD:Interbase is working and that I have all the rigts to access
> the DB (I use interbase 6.0 since it has been released).
> Again, if I follow the instruction in the tutorial, but substituting the
> original DB with an interbase DB I got everything working.
> Am I missing somthing in catalog.cfg?

No, but you probably need to help the query tag a bit. Try:

[query table="articoli" sql="select descrizione from articoli" list=1]
[list]
column_A: [sql-param descrizione]<br>
[/list]
[/query]

Bye
	Racke