Jump to content
PPNSteve

Upgrading from 3.x to latest 6.x - HTTP 500 PROBLEM!

Recommended Posts

I'm getting a 500 error after the install process checks if the folders are writable (they are) .. when you click continue I get 500 error in Chrome browser and a white page in MS edge browser thing. did the error log thing, nothing generated (cPanel's error log is also blank) so have no clue what / where it is failing.. need some help here to complete the upgrade. 

thanks.

Share this post


Link to post
Share on other sites

When you say cPanel's error log, is this the web server's error log (which should log the 500 Response) or PHP's error log?

Share this post


Link to post
Share on other sites

I mean the error's shown in cPanel's error log page.. I haven't yet dug into the server logs yet.. (also no local error log is generated at the web-user's account level)

 

attached image shows as far as the process gets.

cubecart_update01.png

Share this post


Link to post
Share on other sites

If possible, determine if the user that has access to the CC3 database has permission to drop tables. You will need to examine the user details from within the database server, probably needing to use a database utility such as phpMyAdmin, if finding this info is not available by examining the database section in cPanel.

 

Share this post


Link to post
Share on other sites

Server logs show:

[07-Jan-2020 23:25:08 UTC] PHP Fatal error:  Access denied for user 'gbnet_ccrt1'@'localhost' (using password: YES) in /home/gbnet/public_html/templates/classes/db/mysqli.class.php on line 42
[07-Jan-2020 23:28:05 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 33
[07-Jan-2020 23:28:05 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 41
[07-Jan-2020 23:28:05 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43
[07-Jan-2020 23:28:05 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function chmod_writable() in /home/gbnet/public_html/templates/setup/setup.upgrade.php:43
Stack trace:
#0 {main}
  thrown in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43
[07-Jan-2020 23:28:09 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 33
[07-Jan-2020 23:28:09 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 41
[07-Jan-2020 23:28:09 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43
[07-Jan-2020 23:28:09 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function chmod_writable() in /home/gbnet/public_html/templates/setup/setup.upgrade.php:43
Stack trace:
#0 {main}
  thrown in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43
[07-Jan-2020 23:28:50 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 33
[07-Jan-2020 23:28:50 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 41
[07-Jan-2020 23:28:50 UTC] PHP Warning:  Use of undefined constant CC_ROOT_DIR - assumed 'CC_ROOT_DIR' (this will throw an Error in a future version of PHP) in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43
[07-Jan-2020 23:28:50 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function chmod_writable() in /home/gbnet/public_html/templates/setup/setup.upgrade.php:43
Stack trace:
#0 {main}
  thrown in /home/gbnet/public_html/templates/setup/setup.upgrade.php on line 43

as well as some MYSQLi connect issues:

[07-Jan-2020 23:31:24 UTC] PHP Warning:  mysqli::__construct() [<a href='http://docs.php.net/manual/en/mysqli.construct.php'>mysqli.construct.php</a>]: (HY000/1045): Access denied for user '[redacted]'@'localhost' (using password: YES) in .. /classes/db/mysqli.class.php on line 37
[07-Jan-2020 23:31:24 UTC] PHP Warning:  mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in .. /classes/db/mysqli.class.php on line 39
[07-Jan-2020 23:31:24 UTC] PHP Fatal error:  Access denied for user '[redacted]'@'localhost' (using password: YES) in .. /classes/db/mysqli.class.php on line 42

 

DB user has all privileges on the assigned database.

Share this post


Link to post
Share on other sites
Posted (edited)

Thanks much for the assist..

As we all like to check every possibility, i went back to the db user and reset the password.. for some reason CC setup script was reading it or parsing it incorrectly and once I re-entered it the setup processed on through.. is still processing as I type this.. 

Edited by PPNSteve

Share this post


Link to post
Share on other sites

Please verify that the database user is using the correct password. Note that if you mouse-swiped the password displayed somewhere else to copy-paste it onto a web form, in many cases the mouse-swipe also captures invisible white-space before or after the actual password characters. Thus, the password is now not correct.

The warnings about an undefined constant is strange. In /setup/index.php line 13 will require_once the file ini.inc.php. In ini.inc.php line 68 is where CC_ROOT_DIR is defined. So, something is really weird is going on with this.

Then, undefined function chmod_writable() would suggest that the /setup/index.php line 14 that will require_once the file /includes/functions.inc.php where this function is located, fails to find it.

Something inconceivable is haunting your site.

Share this post


Link to post
Share on other sites

Yeah, it has ghosts from the way-past.. I am updating from ver 3 to 6.. it has been a few years..  lol

 

It seems to be working now tho.. so lets see what happens as we update settings, etc.

  • Like 1

Share this post


Link to post
Share on other sites

I see this often, especially when using either Edge and occasionally Chrome. It can happen if you have a larger store as the installer will timeout (thus 500 error) but is still running in the background. once the installer gets beyond a certain point (later version) it starts to work again. smashing F5 over and over until it starts to behave usually works.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...