Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Oct 2015
    Location
    Amsterdam
    Posts
    12
    Plugin Contributions
    0

    Default server error 500 after upgrade

    Hi all.
    a friend of mine has a zencart webshop. It is running in 1.5.1 and he asked me to help upgrade to 1.5.5a.

    Here is what I did:
    1. Installed a clean version of zencart 1.5.5a in a sub-domain (test.realurl.com). In a new database on the same server as his current 1.5.1 database (I told zencart to use a database prefix "new_")
    2. Installed the needed modules.
    3. Using PHPmyadmin (which his hosting provider provides) selected all the tables in the database from the 1.5.1 site, selected copy table(s) to, and copied the tables to the new 1.5.5a database.
    4. Used FTP to edit /includes/configure.php from define('DB_PREFIX', 'new_'); into define('DB_PREFIX', '');. The site works, it contains all product! SUCCES. (I still need to upload all the images etc. but succes!
    5. I went into the admin area, logged in, and he! no products!? Ah, stupid, I need to edit edit /adminfolder/includes/configure.php from define('DB_PREFIX', 'new_'); into define('DB_PREFIX', ''); also.
      !! but now when i go to test.realurl.com/adminfolder i get a Server Error 500.
    6. when I go back to /adminfolder/includes/configure.php and tell it to use the prefix "new_" again, the admin works again, but ofcourse withou products.


    What am I overlooking? Any ideas?
    many thanks in advance.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,980
    Plugin Contributions
    63

    Default Re: server error 500 after upgrade

    Check your /logs folder. The myDEBUG*.log files there most likely hold details of what the Server-500 is all about.

    If you're going to post the contents of a log, remember that the logs named myDEBUG-adm*.log will contain your admin folder's name.

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    5,620
    Plugin Contributions
    211

    Default Re: server error 500 after upgrade

    Check also that files are not writable - some hosts disallow execution of PHP files with +w permissions.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  4. #4
    Join Date
    Jul 2012
    Posts
    11,632
    Plugin Contributions
    13

    Default Re: server error 500 after upgrade

    Ummm. Zc_install to upgrade the database as an action not yet described. Wouldn't expect that to cause a 500 error, but is an action not described and necessary.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  5. #5
    Join Date
    Oct 2015
    Location
    Amsterdam
    Posts
    12
    Plugin Contributions
    0

    Default Re: server error 500 after upgrade

    Oops!
    Yes, between 3 and 4
    zc_install was executed to upgrade the database. With succes

    Forgot to mention. Will exit the post. Also tomorrow I'll look into the log files als suggested. Thanks zo far!

  6. #6
    Join Date
    Oct 2015
    Location
    Amsterdam
    Posts
    12
    Plugin Contributions
    0

    Default Re: server error 500 after upgrade

    Seems that it has something to do with a template and language?

    I've tried some stuff, but it seems like trail and error which leads to new issues. I'm not familiar enough with zencart to be able to interpret the log file for a single cause.
    For instance, I've tried just uploading the dutch.php to from the old includes/languages folder to the new. But that leads to the site (the front end also giving a system error), removing this dutch.php again, front end works.
    I've tried to replace the "includes" folder in the new site with the "includes" folder with all contents from the old site. This does not make the back end work (it does however make the new site look exactly like the old site (because it now finds things belonging to the old template).

    Could it be that i need to make the new site look for the new default template and english language? If so, how do i do this without being able to log into the back end?

    Here is the first part of the log file

    Code:
     [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  include_once() called at [/var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php:72]
    #2  require(/var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php) called at [/var/www/vhosts/MYWEBSITE/includes/autoload_func.php:48]
    #3  require(/var/www/vhosts/MYWEBSITE/includes/autoload_func.php) called at [/var/www/vhosts/MYWEBSITE/includes/application_top.php:170]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/application_top.php) called at [/var/www/vhosts/MYWEBSITE/index.php:26]
    
    [05-Aug-2016 11:22:34 Europe/Amsterdam] PHP Warning:  include_once(includes/languages/dutch.php): failed to open stream: No such file or directory in /var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php on line 72
    [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  include_once() called at [/var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php:72]
    #2  require(/var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php) called at [/var/www/vhosts/MYWEBSITE/includes/autoload_func.php:48]
    #3  require(/var/www/vhosts/MYWEBSITE/includes/autoload_func.php) called at [/var/www/vhosts/MYWEBSITE/includes/application_top.php:170]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/application_top.php) called at [/var/www/vhosts/MYWEBSITE/index.php:26]
    
    [05-Aug-2016 11:22:34 Europe/Amsterdam] PHP Warning:  include_once(): Failed opening 'includes/languages/dutch.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/vhosts/MYWEBSITE/includes/init_includes/init_templates.php on line 72
    [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  htmlspecialchars() called at [/var/www/vhosts/MYWEBSITE/includes/functions/functions_general.php:73]
    #2  zen_output_string() called at [/var/www/vhosts/MYWEBSITE/includes/functions/functions_general.php:93]
    #3  zen_output_string_protected() called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/sideboxes/tpl_reviews_random.php:16]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/sideboxes/tpl_reviews_random.php) called at [/var/www/vhosts/MYWEBSITE/includes/modules/sideboxes/reviews.php:33]
    #5  require(/var/www/vhosts/MYWEBSITE/includes/modules/sideboxes/reviews.php) called at [/var/www/vhosts/MYWEBSITE/includes/modules/column_left.php:31]
    #6  require(/var/www/vhosts/MYWEBSITE/includes/modules/column_left.php) called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php:103]
    #7  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php) called at [/var/www/vhosts/MYWEBSITE/index.php:97]
    
    [05-Aug-2016 11:22:34 Europe/Amsterdam] PHP Warning:  htmlspecialchars(): charset `CHARSET' not supported, assuming utf-8 in /var/www/vhosts/MYWEBSITE/includes/functions/functions_general.php on line 73
    [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  include() called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php:39]
    #2  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php) called at [/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php:236]
    #3  require(/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php) called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php:133]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php) called at [/var/www/vhosts/MYWEBSITE/index.php:97]
    
    [05-Aug-2016 11:22:34 Europe/Amsterdam] PHP Warning:  include(includes/languages/dutch/html_includes/define_main_page.php): failed to open stream: No such file or directory in /var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php on line 39
    [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  include() called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php:39]
    #2  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php) called at [/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php:236]
    #3  require(/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php) called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php:133]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php) called at [/var/www/vhosts/MYWEBSITE/index.php:97]
    
    [05-Aug-2016 11:22:34 Europe/Amsterdam] PHP Warning:  include(includes/languages/dutch/html_includes/define_main_page.php): failed to open stream: No such file or directory in /var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php on line 39
    [05-Aug-2016 11:22:34 Europe/Amsterdam] Request URI: /, IP address: ---IPADDRESS---
    #1  include() called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php:39]
    #2  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/templates/tpl_index_categories.php) called at [/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php:236]
    #3  require(/var/www/vhosts/MYWEBSITE/includes/modules/pages/index/main_template_vars.php) called at [/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php:133]
    #4  require(/var/www/vhosts/MYWEBSITE/includes/templates/template_default/common/tpl_main_page.php) called at [/var/www/vhosts/MYWEBSITE/index.php:97]

  7. #7
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: server error 500 after upgrade

    You've got your site configured to use a Dutch language pack. But you haven't put the files for that into the new site.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Oct 2015
    Location
    Amsterdam
    Posts
    12
    Plugin Contributions
    0

    Default Re: server error 500 after upgrade

    @DrByte (and all others): thanks! that did the trick. It's up and running!!!

  9. #9
    Join Date
    Jun 2007
    Location
    Eustis, Florida, USA, EARTH
    Posts
    548
    Plugin Contributions
    0

    Default Re: server error 500 after upgrade

    I have a constant error that also appears above.

    [03-Dec-2017 15:01:34 Etc/UTC] Request URI: /, IP address: 66.249.64.221
    #1 htmlspecialchars() called at [/home/my/public/website.com/includes/functions/functions_general.php:73]
    #2 zen_output_string() called at [/home/my/public/website.com/includes/functions/functions_general.php:93]
    #3 zen_output_string_protected() called at [/home/my/public/website.com/includes/templates/template_default/sideboxes/tpl_reviews_random.php:16]
    #4 require(/home/my/public/website.com/includes/templates/template_default/sideboxes/tpl_reviews_random.php) called at [/home/my/public/website.com/includes/modules/sideboxes/reviews.php:33]
    #5 require(/home/my/public/website.com/includes/modules/sideboxes/reviews.php) called at [/home/my/public/website.com/includes/modules/column_right.php:32]
    #6 require(/home/my/public/website.com/includes/modules/column_right.php) called at [/home/my/public/website.com/includes/templates/template_default/common/tpl_main_page.php:160]
    #7 require(/home/my/public/website.com/includes/templates/template_default/common/tpl_main_page.php) called at [/home/my/public/website.com/index.php:97]

    [03-Dec-2017 15:01:34 Etc/UTC] PHP Warning: htmlspecialchars(): charset `utf8' not supported, assuming utf-8 in /home/my/public/website.com/includes/functions/functions_general.php on line 73

    Can anyone make anything out from the logs. Here is php config info.

    ; PHP's default character set is set to UTF-8.
    ; http://php.net/default-charset
    default_charset = "UTF-8"
    Last edited by pixelpadre; 3 Dec 2017 at 04:41 PM.
    ZC v1.5.4 "I was so much older then...I'm younger than that now" Cut the umbilical cord with webhosts after 20 years. FREEDOM!

  10. #10
    Join Date
    Jul 2012
    Posts
    11,632
    Plugin Contributions
    13

    Default Re: server error 500 after upgrade

    Quote Originally Posted by pixelpadre View Post
    I have a constant error that also appears above.

    [03-Dec-2017 15:01:34 Etc/UTC] Request URI: /, IP address: 66.249.64.221
    #1 htmlspecialchars() called at [/home/my/public/website.com/includes/functions/functions_general.php:73]
    #2 zen_output_string() called at [/home/my/public/website.com/includes/functions/functions_general.php:93]
    #3 zen_output_string_protected() called at [/home/my/public/website.com/includes/templates/template_default/sideboxes/tpl_reviews_random.php:16]
    #4 require(/home/my/public/website.com/includes/templates/template_default/sideboxes/tpl_reviews_random.php) called at [/home/my/public/website.com/includes/modules/sideboxes/reviews.php:33]
    #5 require(/home/my/public/website.com/includes/modules/sideboxes/reviews.php) called at [/home/my/public/website.com/includes/modules/column_right.php:32]
    #6 require(/home/my/public/website.com/includes/modules/column_right.php) called at [/home/my/public/website.com/includes/templates/template_default/common/tpl_main_page.php:160]
    #7 require(/home/my/public/website.com/includes/templates/template_default/common/tpl_main_page.php) called at [/home/my/public/website.com/index.php:97]

    [03-Dec-2017 15:01:34 Etc/UTC] PHP Warning: htmlspecialchars(): charset `utf8' not supported, assuming utf-8 in /home/my/public/website.com/includes/functions/functions_general.php on line 73

    Can anyone make anything out from the logs. Here is php config info.

    ; PHP's default character set is set to UTF-8.
    ; http://php.net/default-charset
    default_charset = "UTF-8"
    While perhaps the easiest way to identify where the location of the problem is would be to use the developers tool kit to search for utf8, my guess is that the language file that is loaded: includes/languages/YOUR_LANGUAGE.php or includes/languages/YOUR_TEMPLATE/YOUR_LANGUAGE.php has an incorrect setting for CHARSET and that it identifies it as utf8 which is incorrect for the format expected by htmlspecialchars.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. 500 Internal Server Error after installing Ultimate SEO
    By rlexyd in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 15 Sep 2011, 12:32 PM
  2. 500 - Internal server error after install?
    By AlanH in forum Installing on a Windows Server
    Replies: 1
    Last Post: 14 Aug 2011, 06:43 PM
  3. Replies: 1
    Last Post: 23 Sep 2010, 09:55 PM
  4. Error 500: Internal Server Error after submit
    By bigbrit9 in forum General Questions
    Replies: 4
    Last Post: 27 Mar 2010, 07:02 PM
  5. 500 Internal Server Error - Problem after upgrade
    By Rangertrek in forum General Questions
    Replies: 1
    Last Post: 3 Oct 2009, 11:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR