desperate cart/ perl problem/ nightmare yuk!

[Barry]

Hi folks

We have a big problem with the ca00002.pl file on our site, a few weeks ago we were suspended by the hosts for overusing resources on a shared hosting platform, no support at all, just suspension (nice one Fasthosts) so we scrambled over to mosso.com who have been great, but, the shopping cart page is hogging all their resources too

as a result the site is crawling and after 2 weeks, our business is tanking!

does anyone have any clue on how we can fix this file? I have an error log from mosso which is massive, here is a small portion of it;

[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $Status masks earlier declaration in same scope at ca000002.pl line 307., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $Message masks earlier declaration in same scope at ca000002.pl line 307., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $sCartHTML masks earlier declaration in same scope at ca000002.pl line 615., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $sMessage masks earlier declaration in same scope at ca000002.pl line 989., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $Status masks earlier declaration in same scope at ca000002.pl line 1306., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $Message masks earlier declaration in same scope at ca000002.pl line 1306., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] "my" variable $sHTML masks earlier declaration in same scope at ca000002.pl line 1535., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::ATCM_PDONCART" used only once: possible typo at ca000002.pl line 180., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_pSectionList" used only once: possible typo at ca000002.pl line 167., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_sEditButtonLabel" used only once: possible typo at ca000002.pl line 1254., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::bCookieCheckRequired" used only once: possible typo at ca000002.pl line 37., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "ACTINIC::FORM_URL_ENCODED" used only once: possible typo at ca000002.pl line 1588., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_sAccountScript" used only once: possible typo at ca000002.pl line 1624., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::gMonthList" used only once: possible typo at ca000002.pl line 1059., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::ATCM_SINGLE" used only once: possible typo at ca000002.pl line 176., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_pDiscountBlob" used only once: possible typo at ca000002.pl line 130., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "ActinicOrder::s_nContext" used only once: possible typo at ca000002.pl line 1208., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "ActinicOrder::FROM_CART" used only once: possible typo at ca000002.pl line 1208., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "ActinicOrder::PRICING_MODEL_STANDARD" used only once: possible typo at ca000002.pl line 542., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::ATCM_SIMPLE" used only once: possible typo at ca000002.pl line 168., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_MonthMap" used only once: possible typo at ca000002.pl line 529., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_sRequiredColor" used only once: possible typo at ca000002.pl line 135., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_sRemoveButtonLabel" used only once: possible typo at ca000002.pl line 1258., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::ATCM_ADVANCED" used only once: possible typo at ca000002.pl line 172., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::MAX_ORD_QTY" used only once: possible typo at ca000002.pl line 1020., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::PRELIMINARYINFOPHASE" used only once: possible typo at ca000002.pl line 902., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Name "main::g_sConfirmButtonLabel" used only once: possible typo at ca000002.pl line 1233., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Use of uninitialized value in concatenation (.) or string at ac000002.pm line 21., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Using a hash as a reference is deprecated at px000002.pm line 388., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Using a hash as a reference is deprecated at px000002.pm line 414., referer: http://www.tshirtsville.com/acatalog..._T_Shirts.html
[Sat Sep 27 06:29:26 2008] [error] [client 172.16.10.1] Using a hash as a reference is deprecated at px000002.pm line 435., referer:

all of that is in 1 second

anyone have any ideas? perhaps we can overwrite corrupt perl files with originals? or will we lose the edits we have made? im just guessing

Yours desperately

Barry

[RuralWeb]

Looks like you have been playing with the checkout pages - I would revert them to standard - purge and refresh then see what happens

[NormanRouxel]

Have you made any changes to ShoppingCart.pl?

If not, it may well be that you host is using a very strict Perl system. Most of those messages aren't really errors but are warnings aboult messy (but functional) Perl.

The only real way to check this would be to upload to another known Actinic friendly host (e.g. contact Actinic and they should give you trial space).

[Barry]

Thanks for the tip Mal

yes we've made quite a lot of changes to the cart and checkout pages over the years, but this seemed to come from nowhere, no changes have beenmade for quite a while

but what you suggest sounds good, whats the best/ safest way to revert those pages and will we lose all the edits we've made over the years?

[NormanRouxel]

Or simply install Apache / Perl / WarFTPd on a spare internal system (see the Advanced Guide for details) and test there.

[Barry]

Thanks Norman

No not made any changes to ShoppingCart.pl is that the file we should revert?

The current host, Mosso.com is a Rackspace company, we picked them for their very good reputation after a few tricky years with Fasthosts, both companies said that the ca00002.pl and os00002.pl files were using massive amounts of resources, mosso have said that those file were "using 100% of our perl/ cgi server"

so we have had both a very average and a very good host company report the same thing. could it be that ShoppingCart.pl is corrupt?

BTW when it comes to support, this board and you guys beat hands down the combined support of actinic, fasthosts and rackspace, cant be beaten!! THANK YOU!!!!

[Barry]

love the way you use the word "simply" Norman

that looks a bit beyond me im afraid, theres a slim chance i could get that set up and running some time this year but then i wouldnt have any knowledge on how to test the perl set up or much else come to think of it.

still liking the sound of reverting files back to standard ones as the best way out, but still pretty much clueless at this stage

[RuralWeb]

Webfusion (link on my website) offer 30 days free trial so get a package and test it as actinic works fine with them. If it works ok then its a host problem if it also fails then its your checkout.

I would try a purge and refresh first though

[RuralWeb]

still liking the sound of reverting files back to standard ones

Take a snapshot - revert the checkout to standard and refresh. Let it run for a few days and see what happens.

If you need your original checkout back just import the snapshot

[Barry]

Thanks again Mal
Im just signing up with webfusion via your link, but im going to try that as a last resort, i want to revert the checkout to standard first

can you advise please how best to do that? and what files need replacing?

snaphot export is running now...

phew, thanks guys

[RuralWeb]

go into the libaray and select the modified layout check box then look in the checkout section and revert anything on there that has an asterix. Check what the pages look like and if workable upload.

[Mike Hughes]

both companies said that the ca00002.pl and os00002.pl files were using massive amounts of resources, mosso have said that those file were "using 100% of our perl/ cgi server"

It looks to me as if you're scripts aren't working properly and you really do have to fix these. I would revert back to the original ones and see what impact that has. If the resource problems still occur then it's the host, if not then it's your script mods.

one way of finding out which bit is the problem is to start with clean scripts and then make your changes one by one. At some point you'll probably find a single change that causes the problem and then you know where the problem lies.

You will need your hosts help with this as they'll need to monitor how much of the available resources the scripts are taking.

Mike

[Barry]

Thanks Mike, that sounds like good advice

I have been trying to revert the scripts all night, its going from bad to worse. heres whats been happening in the hope someone can shed some light

In Help > Troubleshooting. Firstly the Web Site Analysis doesnt work, no response.
The Compare Perl Scripts feature reports that no changes have been made to the originals.

I ran the Purge and Refresh feature, deselected the 'Delete Cat Files' feature as there are loads of these and selected the other 2 options (cant remember the names of those) ran it and it deleted all the cat files! what a nightmare. Ive spent the rest of the night waiting for the upload and clicking on continue whenever the uploader says it cant continue

How ive been dreaming since Actinic 3 for an uploader that just keeps on going, no matter what, until it has uploaded everything. That, together with a working cancel button has been a sadly unfufilled dream of ours from the off, is that too much to ask Actinic guys?

Sorry, im very tired and a bit crabby now, the site is down, again and our business is tanking further

if this upload finisheses in the next 48 hours ill be delighted

meanwhile i might just take up alcoholism to ease the pain

[Mike Hughes]

Hi Barry. It's hard to tell what's happening as there are too many things going on at once.

The move to a new host can also cause problems so if you ever get a quiet moment with actinic here's what I do:

1. Check the permissions on your server. The /acatalog/ and cgi-bin folders should be set to 755. There are some signs of permission problems in your error log.

2. Run the network test and make sure everything passes correctly with no error message.

3. Once this is all done, then I would start looking into the script problems.

Mike

[RuralWeb]

send me a snapshot and I will put it on my test server