[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