package: interchange
Dear All,
I am running catalogs on IC 5.5. dated Feb 14th 2007 using
mysql databases.
The following SQL query works for DBI class tables
but not for SHADOW class tables.
select count(sku) from products
Actually all similar functions (max(), sum(), etc.) won't work
for SHADOW class databases and cause an internal server error:
The error generated:
Runtime error: Bad column name (from count(sku)):
'count(sku)' at /usr/local/interchange/lib/Vend/SQL_Parser.pm line 838.
Interchange will switch from DBI to SHADOW class database as soon
as one table uses mapping as below:
Database products MAP description de_DE products::description_de
Database products MAP description nl_NL products::description_nl
Database products MAP comment de_DE products::comment_de
Database products MAP comment nl_NL products::comment_nl
Database products MAP description fallback 1
Any ideas what is going on and/or how to solve this issue?
Many thanks guys !
Best regards,
Ton
--
Alamerce Nederland --- Cornerstone of eBusiness
Phone +31-40-2374381 [EMAIL PROTECTED] http://www.alamerce.nl
eCommerce Solutions -- Consulting -- Website & Interchange Hosting
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
