[ic] Novice Help: error - Table Not Found in database - Can Interchange work with Interbase?

Stefan Hornburg interchange-users@icdevgroup.org
Wed Apr 23 03:56:01 2003


On Wed, 23 Apr 2003 00:33:31 +0200
"Marco Carcano" <info@draksoft.com> wrote:

> Quoting Racke (<racke@linuxia.de>)
> Quoting Marco (info@draksoft.com)
> >>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?
> 
> Quoting Racke (<racke@linuxia.de>)
> >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]
> Thanks Racke,
> I tried this, but it doesn't work. Seems like interchange could
> connect with the database, but does not "link" the table articoli:
> .
> Don't know if this can tell you more:
> 1) when I restart interchange a file named articoli.autonumber is
> created 2) the code below put into index.html produces the word
> ="products" and not"articoli". Is this right?
> [perl]$Config->{ProductFiles}[0][/perl]

Ah, OK. [perl]$Config->{ProductFiles}[1][/perl] should output articoli
now.

Next suggestion is to put into catalog.cfg:

Replace ProductFiles
ProductFiles articoli

Bye
	Racke