[ic] Interchange in cPanel - upgrade issue.

[dzhang-msi]

----- Original Message -----
From: "Jonathan Clark" <jonc@webmaint.com>
To: <interchange-users@icdevgroup.org>
Sent: Sunday, February 23, 2003 3:32 PM
Subject: [ic] Interchange in cPanel - upgrade issue.


>
> It has come to our attention that a recent cPanel version upgrades the
Perl
> module SQL::Statement to 1.006. ICDEVGROUP made it clear in December 2002
> that the latest version of SQL::Statement was incompatible with
Interchange
> and that there were no plans to provide compatibility at this time.
> Accordingly, the Perl module bundle for Interchange (Bundle::Interchange)
> continues to use version 0.1021.
>
> A correctly functioning SQL::Statement is required for the administration
> interface. The use of any version of SQL::Statement newer than 0.1021 will
> cause undesirable effects. To check which version you are running, go to
> the Interchange administration page Administration, Perl Information and
> look for SQL::Statement. The correct version is 0.1021.
>
> If you find you are running an incorrect version within your cPanel
> installation, please contact your host immediately. DO NOT post support
> requests, or the errors you are experiencing, to the interchange-users
list.
>
> Please note also that ICDEVGROUP does not support the use of Interchange
> within a cPanel installation. For more information, please see:
> http://www.icdevgroup.org/i/dev/cpanel.html
>
>
> Jonathan Clark
> On behalf of ICDEVGROUP.
>

The above is very instructive.

For those using cpanel installed interchange, to demonstrate to your host
the error, do the following:

1    rename your catalogs dir, cart.cgi in your cgi-bin dir, and cart/images
(back up your old work)
2    install a new cart from cpanel
3    click on "enter as customer"
4    open the error.log in the cart directory (usually
/home/username/catelogs/username/error.log )

You shoudl see the error record:

SQL query failed: Can't locate object method "where" via package
"SQL::Statement" (perhaps you forgot to load "SQL::Statement"?) at
/usr/local/cpanel/3rdparty/interchange/lib/Vend/Scan.pm line 665.


Hope your host will help you out.

David
dzhang@msihosting.com
http://www.msihosting.com
Expert -- ecommerce solutions, interchange hosting.