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

Barry Treahy, Jr. Treahy at MMaz.com
Tue Sep 6 22:05:18 EDT 2005


-------- 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. <Treahy at mmaz.com>
Reply-To: 	interchange-users at icdevgroup.org
To: 	interchange-users at icdevgroup.org
References: 	<s31dc94f.014 at mail.ics-va.com>



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: Treahy at MMaz.com
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President/CIO                        FAX:  480/661-7028

                      ... but it's a DRY HEAT!                          


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




-- 

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

                       ... but it's a DRY HEAT!                          




More information about the interchange-users mailing list