Mailing List Archive: Interchange: users

usps_query.tag RateV4 errors

Index | Next | Previous | View Threaded

glenn at bnetmd

May 30, 2012, 11:37 AM

Post #1 of 5 (168 views)
Permalink

usps_query.tag RateV4 errors

KNEW it wouldn't be that easy.
I replaced the (apparently) deprecated usps_query.tag.
Restart IC (v5.2.0 - Perl v5.8.8, default DB database).
Got the following start-up errors:

...
Sending debug messages to debug.log.
High traffic settings.
Subroutine Vend::Interpolate::S_ISBLK redefined at
/usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
Subroutine Vend::Interpolate::S_ISCHR redefined at
/usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
Subroutine Vend::Interpolate::S_ISDIR redefined at
/usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
Subroutine Vend::Interpolate::S_ISFIFO redefined at
/usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
Subroutine Vend::Interpolate::S_ISREG redefined at
/usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
Calling UI......UI is loaded...
...

Store seems to work OK until checkout when the ever-popular 500 error
appears.
IC error.log shows:
Runtime error: Can't locate object method "dbh" via package
"Vend::Table::DB_file" at
/usr/local/lib/perl5/site_perl/5.8.8/i386-freebsd/Safe/Hole.pm line 117.

Finding "$dbh" in the new usps_query.tag it appears to be creating an SQL
lookup for country.
If that is the case, can this routine be used with the standard DB_file
databases?

Replace the old usps_query.tag and all is fine.
Thanks!
Glenn.

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

josh at perusion

May 30, 2012, 12:01 PM

Post #2 of 5 (156 views)
Permalink

Re: usps_query.tag RateV4 errors [In reply to]

Quoting Glenn McCalley (glenn [at] bnetmd):
> KNEW it wouldn't be that easy.
> I replaced the (apparently) deprecated usps_query.tag.
> Restart IC (v5.2.0 - Perl v5.8.8, default DB database).
> Got the following start-up errors:

You didn't tell us what you replaced the usps_query.tag with... Did you
try this one? --> ftp://ftp.zolotek.net/ic/usps_query.tag

Otherwise, send a nice diff so we can see what changes you made.

Josh

> ...
> Sending debug messages to debug.log.
> High traffic settings.
> Subroutine Vend::Interpolate::S_ISBLK redefined at
> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
> Subroutine Vend::Interpolate::S_ISCHR redefined at
> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
> Subroutine Vend::Interpolate::S_ISDIR redefined at
> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
> Subroutine Vend::Interpolate::S_ISFIFO redefined at
> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
> Subroutine Vend::Interpolate::S_ISREG redefined at
> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
> Calling UI......UI is loaded...
> ...
>
> Store seems to work OK until checkout when the ever-popular 500
> error appears.
> IC error.log shows:
> Runtime error: Can't locate object method "dbh" via package
> "Vend::Table::DB_file" at
> /usr/local/lib/perl5/site_perl/5.8.8/i386-freebsd/Safe/Hole.pm line
> 117.
>
> Finding "$dbh" in the new usps_query.tag it appears to be creating
> an SQL lookup for country.
> If that is the case, can this routine be used with the standard
> DB_file databases?
>
> Replace the old usps_query.tag and all is fine.
> Thanks!
> Glenn.
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users [at] icdevgroup
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>

--
Josh Lavin
Perusion -- Expert Interchange Consulting http://www.perusion.com/

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

glenn at bnetmd

May 30, 2012, 12:12 PM

Post #3 of 5 (156 views)
Permalink

Re: usps_query.tag RateV4 errors [In reply to]

----- Original Message -----
From: "Josh Lavin" <josh [at] perusion>
To: <interchange-users [at] icdevgroup>
Sent: Wednesday, May 30, 2012 3:01 PM
Subject: Re: [ic] usps_query.tag RateV4 errors

> Quoting Glenn McCalley (glenn [at] bnetmd):
>> KNEW it wouldn't be that easy.
>> I replaced the (apparently) deprecated usps_query.tag.
>> Restart IC (v5.2.0 - Perl v5.8.8, default DB database).
>> Got the following start-up errors:
>
> You didn't tell us what you replaced the usps_query.tag with... Did you
> try this one? --> ftp://ftp.zolotek.net/ic/usps_query.tag
>
> Otherwise, send a nice diff so we can see what changes you made.
>
> Josh
>
>
Thanks Josh, my oversight. Yes that is the one. By Lyn StGeorge I believe?
The one on the icdevgroup site looked to be the old one.

Glenn.

>> ...
>> Sending debug messages to debug.log.
>> High traffic settings.
>> Subroutine Vend::Interpolate::S_ISBLK redefined at
>> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
>> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
>> Subroutine Vend::Interpolate::S_ISCHR redefined at
>> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
>> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
>> Subroutine Vend::Interpolate::S_ISDIR redefined at
>> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
>> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
>> Subroutine Vend::Interpolate::S_ISFIFO redefined at
>> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
>> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
>> Subroutine Vend::Interpolate::S_ISREG redefined at
>> /usr/local/lib/perl5/5.8.8/Exporter.pm line 65, <SYSTAG> line 417.
>> at /usr/local/lib/perl5/5.8.8/i386-freebsd/POSIX.pm line 19
>> Calling UI......UI is loaded...
>> ...
>>
>> Store seems to work OK until checkout when the ever-popular 500
>> error appears.
>> IC error.log shows:
>> Runtime error: Can't locate object method "dbh" via package
>> "Vend::Table::DB_file" at
>> /usr/local/lib/perl5/site_perl/5.8.8/i386-freebsd/Safe/Hole.pm line
>> 117.
>>
>> Finding "$dbh" in the new usps_query.tag it appears to be creating
>> an SQL lookup for country.
>> If that is the case, can this routine be used with the standard
>> DB_file databases?
>>
>> Replace the old usps_query.tag and all is fine.
>> Thanks!
>> Glenn.
>>
>>
>>
>> _______________________________________________
>> interchange-users mailing list
>> interchange-users [at] icdevgroup
>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>
>
> --
> Josh Lavin
> Perusion -- Expert Interchange Consulting http://www.perusion.com/
>
> _______________________________________________
> interchange-users mailing list
> interchange-users [at] icdevgroup
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>

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

peter at pajamian

May 30, 2012, 2:15 PM

Post #4 of 5 (156 views)
Permalink

Re: usps_query.tag RateV4 errors [In reply to]

On 31/05/12 06:37, Glenn McCalley wrote:
> Store seems to work OK until checkout when the ever-popular 500 error
> appears.
> IC error.log shows:
> Runtime error: Can't locate object method "dbh" via package
> "Vend::Table::DB_file" at
> /usr/local/lib/perl5/site_perl/5.8.8/i386-freebsd/Safe/Hole.pm line 117.

That's a Safe error, they are a PITA. Best thing to do is to try to not
use the tag inside a [calc] (or similar) block. Alternatively it may
help to open up the table it's trying to access first with something like:
[perl tablename][/perl]

> Finding "$dbh" in the new usps_query.tag it appears to be creating an
> SQL lookup for country.
> If that is the case, can this routine be used with the standard DB_file
> databases?

db files won't have a dbh handle, this tag would be designed to be used
with an SQL database. If the code is changed to use the $db handle
instead then it will likely work with any type of database.

Peter

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

glenn at bnetmd

Jun 2, 2012, 6:26 AM

Post #5 of 5 (148 views)
Permalink

Re: usps_query.tag RateV4 errors [In reply to]

> On 31/05/12 06:37, Glenn McCalley wrote:
>> Store seems to work OK until checkout when the ever-popular 500 error
>> appears.
>> IC error.log shows:
>> Runtime error: Can't locate object method "dbh" via package
>> "Vend::Table::DB_file" at
>> /usr/local/lib/perl5/site_perl/5.8.8/i386-freebsd/Safe/Hole.pm line 117.
>
> That's a Safe error, they are a PITA. Best thing to do is to try to not
> use the tag inside a [calc] (or similar) block. Alternatively it may
> help to open up the table it's trying to access first with something like:
> [perl tablename][/perl]
>
>> Finding "$dbh" in the new usps_query.tag it appears to be creating an
>> SQL lookup for country.
>> If that is the case, can this routine be used with the standard DB_file
>> databases?
>
> db files won't have a dbh handle, this tag would be designed to be used
> with an SQL database. If the code is changed to use the $db handle
> instead then it will likely work with any type of database.
> Peter
>
The dbh lookup was for country code/name. We only ship domestically so
so I just set those values and commented the lookup. Seems to be OK.

Then I got a half dozen POSIX / Exporter errors about redefining modules.
Changed the "use POSIX;" statement in RateV4 tag to "use POSIX ();" and
these went away. Is that safe to do?

So! The new tag code is in place, but still no USPS shipping being
calculated.
Working on it...
Glenn.

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

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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads