[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