Announcement

Collapse
No announcement yet.

Upgraded Site - some irritating errors...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Upgraded Site - some irritating errors...

    First up, yes, I've searched, and gained nothing fruitful from the results...

    Have been using Actinic since v3, network settings have never changed thru v4, v5, v6, and now to v8... however, anything that involves a CGI script won't work (all working fine with v6 site pre-update half an hour ago). I just get a 500 error on every scripts.

    Permissions are fine on CGI-BIN and it's contents, and the ACATALOG directory and it's contents. Have tried manually uploading all scripts in ASCII mode... and manually setting permissions. No change. All other apps on the server that use CGI scripts are functioning as they always have.

    Have compacted database and refreshed, no change.

    Have deleted all contents from CGI-BIN and ACATALOG, and completely refreshed, still no change.

    URL in question: http://store.over-clock.com (which equals http://www.over-clock.com/acatalog/ - problem exists regardless of which URL you use... so it isn't that.)

    Network Setup as follows...

    Server Details
    Catalog URL: http://store.over-clock.com/
    CGI-BIN URL: http://www.over-clock.com/cgi-bin/
    Codebase: ./public_html/
    Path from CGI-BIN to acatalog directory: ../acatalog/

    FTP Details
    Path to CGI-BIN: /public_html/cgi-bin/
    Path from CGI-BIN to acatalog: /public_html/acatalog/

    Common Settings
    Ignore Passive Transfer Errors - checked.
    WebSite URL: http://www.over-clock.com
    Path to Perl Shell: /usr/bin/perl

    We've also got the marginally less serious "an error occured while sending the merge request" but that can wait as far as I'm concerned, unless it's directly related to the scripts problems...
    Cheers!
    Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

    #2
    Hi Marci,

    can you export your network settings and then copy and paste them into the forum? It's best to see the whole set.

    At first glance, this:

    FTP Details
    Path to CGI-BIN: /public_html/cgi-bin/
    Path from CGI-BIN to acatalog: /public_html/acatalog/

    Looks wrong as it's implying that the acatalog folder is in

    /public_html/cgi-bin/public_html/acatalog/

    Which can't be right.

    Mike
    -----------------------------------------

    First Tackle - Fly Fishing and Game Angling

    -----------------------------------------

    Comment


      #3
      Voila...

      Code:
      HTTPPROXYMODE	0
      HTTPPROXYADDRESS	
      HTTPPROXYPORT	80
      HTTPPROXYUSER	
      HTTPPROXYPASSWORD	
      FTPPROXYMODE	0
      FTPPROXYADDRESS	
      FTPPROXYPORT	21
      FTPPROXYUSER	
      FTPPROXYPASSWORD	
      SCRIPTID	1
      SCRIPTEXT	.pl
      SMTPHOST	localhost
      WEBSITEURL	http://www.over-clock.com
      IGNOREPASSIVEERRORS	true
      USERELATIVECGIURLS	false
      PATHTOPERL	/usr/bin/perl
      USEENHANCEFTP	false
      FTPCLIENTTIMEOUT	15000
      FTPRETRYDELAY	3000
      FTPSILENT	false
      FTPMAXRETRIES	3
      FTPCONNECTTIMEOUT	25000
      SMTPAUTHREQUIRED	false
      SMTPUSERNAME	
      SMTPPASSWORD	
      CATALOGURL	http://store.over-clock.com/
      CGIBINURL	http://www.over-clock.com/cgi-bin/
      PATHFROMCGITOCATALOG	../acatalog/
      CODEBASE	./public_html/
      FTPHOST	69.93.114.226
      FTPUSERNAME	*******
      FTPPASSWORD	*******
      PATHTOCGIBIN	/public_html/cgi-bin/
      USEPASSIVEFTP	false
      FTPPATHFROMCGITOCATALOG	/public_html/acatalog/
      Cheers!
      Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

      Comment


        #4
        FTP Details
        Path to CGI-BIN: /public_html/cgi-bin/
        Path from CGI-BIN to acatalog: /public_html/acatalog/
        Preceeded by a slash implies from root of the webserver... (or root of that webuser, so root being the equivalent of $home)
        public_html/acatalog would imply /public_html/cgi-bin/public_html/acatalog
        /public_html/acatalog implies back to root... /public_html/acatalog/
        Cheers!
        Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

        Comment


          #5
          Just tried network settings wizard...

          Stalls on Mail Server page (all settings are correct on this page) stating:

          "An error occurred while sending an HTTP request to the webserver. Perhaps your network is down or the webserver is down. Try again or contact blah de blah..."

          If I untick the "yes, send an email after order", it completes fine and presents me with all the settings as quoted above...

          Test from Advanced Network Setup confirms the CGI error...

          "Actinic received a server error from the web server. The CGI scripts are not executing properly on the server...."
          Cheers!
          Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

          Comment


            #6
            I don't know how your hosting is configured but you have both www and non www URLs

            this could cause an issue, but i have to agree with Mike

            PATHTOCGIBIN /public_html/cgi-bin/
            FTPPATHFROMCGITOCATALOG /public_html/acatalog/
            this is very suspect.

            What happens when you run the wizard with just the root and cgi bin as the paths to start with

            Comment


              #7
              Good point about the cgi-bin location. Looking at one of my sites on a cpanel server I see that I also have the same settings so please excuse my slow brain moment.

              Normally the catalog url would be:

              CATALOGURL http://store.over-clock.com/acatalog/

              (i.e. with the acatalog/ bit).


              Whoops. Reading the first post again I see that you have some aliasing or whatever running. Another slow brain moment!

              Mike
              -----------------------------------------

              First Tackle - Fly Fishing and Game Angling

              -----------------------------------------

              Comment


                #8
                Comes back with exactly as above... none of these SHOULD be issues, as these are the exact network settings as we've been running since Actinic v3... for the past 7 or so years... (back when this was all done via the Actinic Majordomo mailing list - predating the existence of this forum), and I completely emptied CGI-BIN and ACATALOG to avoid any issues with older files from previous versions.

                Have also tried
                CATALOGURL - http://www.over-clock.com/acatalog/
                CGIBINURL - http://www.over-clock.com/cgi-bin/

                and

                PATHTOCGIBIN /public_html/cgi-bin/
                FTPPATHFROMCGITOCATALOG ../acatalog/

                Problem remains and is exactly the same.

                http://store.over-clock.com = http://www.over-clock.com/acatalog/ - the two are identical locations. S'just a subdomain... and as I said, we've operated for years with it set like this without problems...

                http://store.over-clock.com/acatalog/ would take you to http://www.over-clock.com/acatalog/acatalog/


                I'm a bit hesitant of phoning support at the mo seeing as last time I was on hold for 30+ minutes, got thru to someone using VoiP of appallingly bad quality, and got bounced round from dept to dept simply to get my auth code emailed out when we purchased v8.5... despite being Actinic Cover subscribers.
                Cheers!
                Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                Comment


                  #9
                  Try:

                  FTPPATHFROMCGITOCATALOG ../public_html/acatalog/

                  Comment


                    #10
                    Right... for simplicity's sake... have just refreshed the site with the following Network Settings... and problem remains...

                    Code:
                    HTTPPROXYMODE	0
                    HTTPPROXYADDRESS	
                    HTTPPROXYPORT	80
                    HTTPPROXYUSER	
                    HTTPPROXYPASSWORD	
                    FTPPROXYMODE	0
                    FTPPROXYADDRESS	
                    FTPPROXYPORT	21
                    FTPPROXYUSER	
                    FTPPROXYPASSWORD	
                    SCRIPTID	1
                    SCRIPTEXT	.pl
                    SMTPHOST	localhost
                    WEBSITEURL	http://www.over-clock.com/
                    IGNOREPASSIVEERRORS	true
                    USERELATIVECGIURLS	false
                    PATHTOPERL	/usr/bin/perl
                    USEENHANCEFTP	false
                    FTPCLIENTTIMEOUT	15000
                    FTPRETRYDELAY	3000
                    FTPSILENT	false
                    FTPMAXRETRIES	3
                    FTPCONNECTTIMEOUT	25000
                    SMTPAUTHREQUIRED	true
                    SMTPUSERNAME	******
                    SMTPPASSWORD	******
                    CATALOGURL	http://www.over-clock.com/acatalog/
                    CGIBINURL	http://www.over-clock.com/cgi-bin/
                    PATHFROMCGITOCATALOG	../acatalog/
                    CODEBASE	./public_html/
                    FTPHOST	69.93.114.226
                    FTPUSERNAME	******
                    FTPPASSWORD	******
                    PATHTOCGIBIN	/public_html/cgi-bin/
                    USEPASSIVEFTP	true
                    FTPPATHFROMCGITOCATALOG	../acatalog/
                    Cheers!
                    Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                    Comment


                      #11
                      Try:

                      FTPPATHFROMCGITOCATALOG ../public_html/acatalog/
                      Can tell you right now that that won't work...

                      If I SSH into the server, and head to $home/public_html/cgi-bin and type in

                      cd ../public_html/acatalog I get "No such file or directory" as this is attempting to navigate to $home/public_html/public_html/acatalog/

                      Whereas if I type in cd ../acatalog I succesfully land in the acatalog folder.

                      If I try uploading with it set as your recommendation, I get the following error:

                      Possible Cause:
                      The path From CGI-BIN to the acatalog directory is incorrect
                      The network timed out
                      The network is disconnected
                      Recommendation:
                      Long n' short, all paths etc are correct and verified by hand via SSH on the server to work fine... along with the methods for negotiating from one path to another... it isn't the paths that's the issue.
                      Cheers!
                      Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                      Comment


                        #12
                        Right. Think I'm getting somewhere...

                        If I open the perlscripts from cgi-bin on the server via SSH using VI, I find at the top of every script the following:

                        Code:
                        #!NETQUOTEVAR:PERLPATH
                        Actinic should have substitued this variable with the correct perl path (usr/bin/perl)... but obviously isn't. Am about to go thru all these scripts manually setting the path to the perl interpreter, will then upload and test and let u know...

                        EDIT: Oh well - t'isn't that either...
                        Cheers!
                        Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                        Comment


                          #13
                          Getting somewhere... the pl and pm scripts from the old v6 site appear to have been copied over into the v8 site when v8 auto-upgraded v6...

                          I'm guessing the NETQUOTEVAR for the perl interpreter has changed from v6 to v8, hence v8 wasn't automatically replacing it with the correct path to perl...

                          Have just overwritten all scripts in Site1 with those from the /Actinic v8/Original folder, and things appear to be showing signs of functioning now... could be worth noting for future queries along the same lines...

                          EDIT: Yep, confirmed - new NETQUOTEVAR for v8 is <Actinic:Variable Name="PerlPath"/> as opposed to NETQUOTEVAR:PERLPATH in v6, confirming that the v8.5 upgrade package had carried over the old scripts rather than replacing them with the new scripts.

                          The above solution could do with possibly being included in the Knowledgebase yonder: http://knowledge.actinic.com/acatalo...400.html#a1168 as a "just in case..."

                          Have only checked adding to cart at the mo, which works fine. All other CGI functions appear to be dependant on fil files yet to be uploaded in the refresh. I'm off fer a brew in the meantime! Will let y'all know if this works out - cheers for everyone's suggestions thus far....!
                          Cheers!
                          Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                          Comment


                            #14
                            K... now appear to be getting errors at Checkout... os000001.pl

                            Code:
                            A General Script Error Occurred
                            Error: Error executing the advanced shipping plug-in script.
                            
                            Global symbol "$DefaultWeight" requires explicit package name at (eval 43)
                            line 1351. Global symbol "$DefaultWeight" requires explicit package name at 
                            (eval 43) line 1908. Global symbol "$sOptimalWeight" requires explicit package 
                            name at (eval 43) line 1915. Global symbol "$sOptimalWeight" requires explicit 
                            package name at (eval 43) line 1916. Global symbol "$sOptimalWeight" 
                            requires explicit package name at (eval 43) line 1955. Global symbol 
                            "$sOptimalWeight" requires explicit package name at (eval 43) line 1956. 
                            Global symbol "$sOptimalWeight" requires explicit package name at (eval 43) 
                            line 1958. Global symbol "$sOptimalWeight" requires explicit package name at 
                            (eval 43) line 2280. Global symbol "$sOptimalWeight" requires explicit package 
                            name at (eval 43) line 2281. Global symbol "$sOptimalWeight" requires explicit 
                            package name at (eval 43) line 2284
                            Mefinx same issue - old shipping script (looking at the date of the script more or less confirms this... *Sigh* Haven't a clue WHAT's gone on during the upgrade!)
                            Cheers!
                            Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                            Comment


                              #15
                              Confirmed. Overwritten ShipControl\ShippingTemplate.pl with correctly dated script and refreshed, all fixed.

                              Every function works, final merge goes thru without error. Finally up n' running on Actinic v8 after yonks of badgering the management to let me do it! (Was sick of v6 and the code it generated). LOVE the "import orders" routine - finally allows stock monitoring to function whilst split across 2 machines (order processing and maintenance)...

                              Shall start a new thread for comments on the site itself...

                              (and that's WITH it set to http://store.over-clock.com & http://www.over-clock.com/cgi-bin)
                              Cheers!
                              Marci - <a href="http://www.Over-Clock.co.uk" target="_blank">www.Over-Clock.co.uk</a>

                              Comment

                              Working...
                              X