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

Marco Carcano interchange-users@icdevgroup.org
Tue Apr 22 06:41:01 2003


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 sales@vascabella.it

#########################################

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]


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

@_BOTTOM_@
##########################################
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?

Thanks to all, an excuse me for my poor English