[ic] 4.8x to 5.0.1 upgrade sql_parser issue

New Media E.M.S. ic_users at newmediaems.com
Wed Apr 28 18:53:42 EDT 2004


At 02:55 PM 4/28/2004 -0700, you wrote:

>Hello,
>
>I'm upgrading my IC to the latest coming from a 4.8x configuration.  I've
>had to remove the NoCache and Static* directives from the catalog.cfg files.
>Is there something else to replace them?
>
>Also, I'm getting this error:
>
>(table products): Query on table failed: Can't locate object method "name"
>via package "Vend::SQL_Parser: No tables found in: SELECT sub_category FROM
>subpage_category WHERE main_category = '[sql_escape]King's High
>Way[/sql_escape]' ORDER BY sortby" (perhaps you forgot to load
>"Vend::SQL_Parser: No tables found in: SELECT sub_category FROM
>subpage_category WHERE main_category = '[sql_escape]King's High
>Way[/sql_escape]' ORDER BY sortby"?) at
>/home/interch/interchange/lib/Vend/Scan.pm line 623. Query was: SELECT
>sub_category FROM subpage_category WHERE main_category = '[sql_escape]King's
>High Way[/sql_escape]' ORDER BY sortby
>
>It looks like it's not processing the sql_escape subroutine for some reason.
>Or am I misinterpreting this info?

I would agree. Is [sql_escape] a custom UserTag? If so, you'll need to copy 
it into VENROOT-5.0.1/code/UserTag and restart interchange.

- Ed


===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
=============================================================== 



More information about the interchange-users mailing list