[ic] usps_query.tag RateV4 errors

Glenn McCalley glenn at bnetmd.net
Sat Jun 2 13:26:56 UTC 2012


> 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.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
> 





More information about the interchange-users mailing list