[Fwd: Re: [ic] [perl tables=tiers] producing error: Table TIERS not found in databases]

["Barry Treahy, Jr." <suppressed>]

-------- Original Message --------
Subject: 	Re: [ic] [perl tables=tiers] producing error: Table TIERS not 
found in databases
Date: 	Tue, 06 Sep 2005 14:27:09 -0700
From: 	Barry Treahy, Jr. <suppressed>
Reply-To: 	suppressed
To: 	suppressed
References: 	<suppressed>



Daniel Davenport wrote:

> > 68.142.249.64 XqDN4Atc:68.142.249.64 - [05/September/2005:20:49:15 
> > -0700] mmb2c /cgi-bin/mmb2c/ATT-217M-13-NNN-02 Table TIERS not found in 
> > databases
> > 68.142.249.64 XqDN4Atc:68.142.249.64 - [05/September/2005:20:49:15 
> > -0700] mmb2c /cgi-bin/mmb2c/ATT-217M-13-NNN-02 Runtime error: Can't use 
> > an undefined value as an ARRAY reference at (eval 138) line 50.
> >
> > It seems to happen everytime on the flypage which is where I have:
> >
> > [tmp page_title]__COMPANY__ -- [item-code][/tmp]
> > [tmp members_only][/tmp]
> >
> > [perl tables=products][/perl]
> > [perl tables=tiers][/perl]
> >
> > [control reset=1]
> >
> > Barry
> >    
>
> just to verify....the table "tiers" exists (in that exact case, if you're using mysql), 
> and IC has been set up to use it, right?  as in, is it specified in a .mysql file somewhere
> or in catalog.cfg?
>
>
>  
yes, lower case even though the error message is displaying it up 
uppercase...

Please note that this is not a SQL table, but rather GDBM.  
Additionally, this table, and all others, by they SQL or GDBM are 
accessible from within the admin UI.


I believe I've isolated the problem.  Withn commonadjust, I reference a usertag which does a:

$sql = "select quantity,discount from tiers where tier='" . $tier ."' order by code desc"; $results = $Tag->query({ wantarray => 1,sql => $sql } );

And it is here that IC is blowing...  Now I'm beginning to remember that I had to load a module that would allow emulation of SQL for GDBM databases.  Anyone remember what that module is so that I can get this loaded?

Barry


--

Barry Treahy, Jr                     E-mail: suppressed
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President/CIO                        FAX:  480/661-7028

                     ... but it's a DRY HEAT!                          


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users




--

Barry Treahy, Jr                     E-mail: suppressed
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President/CIO                        FAX:  480/661-7028

                      ... but it's a DRY HEAT!                          


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users