problem with upgrade from v151 to v153 - help please

You said you're using Hostgator, right?
Go into cPanel, scroll down to the bottom to the "Advanced" section and click on the option for "PHP Configuration" (or use the search at the top of the page and simply type "PHP" as the search term, then click on "PHP Configuration" when it shows up in the results).
Then on the next screen choose which PHP version you wish to use on your site.

DK_Scully:

And that purpose would be to drive me crazy...and it's such a short drive! :P

That's a common condition around these parts.

DK_Scully:

Okay, so now what?

Dunno yet. I'm still not exactly sure where it is that you are having a problem. (I'm easily confused too) ;-)

DK_Scully:

I'm trying to get hold of HostGator to find out why their cPanel says I'm using one version of php, but ZenCart thinks I'm using another...it's going to be a long wait because they're still trying to dig out from all their servers being down for 4 hours yesterday...which no doubt contributed to the problems I was having. Can anything be done in the meantime?

Too be perfectly honest, if you know that HostGator are having thier own issues, I'd be inclined to do nothing until they've been resolved. You could quite easily be digging yourself into a deeper and deeper hole (or at the very least, going around and around in circles).

What I can do for you though is save the wait for a response. The reason why Cpanel is reporting one version of PHP and ZenCart another can be because the PHP version can be configured/set on a (sub)domain name (host) basis, IOW, there could be dozens of sites hosted on the same server, each with a different version of PHP, and although it isn't obvious to most people
https://www.yourdomain.com and cpanel.yourdomain.com are different hosts and therefore it is easily possible for them to be using different PHP versions.
You only need to concern yourself with what ZenCart is reporting as the version being used.

<a few minutes later> OK, I've just been taking a look at the HostGator help pages

This page:
http://support.hostgator.com/articles/hosting-guide/hardware-software/articles/hosting-guide/hardware-software/what-version-of-php-are-you-using
States that on a shared hosting the current default is (or should be) php 5.4.x
V5.2 (which is what your zencart is reporting is flagged as being available but deprecated and no longer being updated.

This implies that you probably have something set somewhere that is forcing the use of V5.2 .. Most likely in the .htaccess file in the root folder of your store, or possibly the php.ini file (also in the root folder of your store)

To change to use PHP V5.4 the first thing you should do is check these files and delete any lines that read like
AddHandler application/x-httpd-php52 .php

Save the files when done, and if you are lucky the next time you check via ZenCart you'll be using php5.4
If not, then try adding this line
AddHandler application/x-httpd-php54 .php
to your .htaccess file.

OR..... according to this page:
http://support.hostgator.com/articles/cpanel/php-configuration-plugin
You can also use the 'PHP Configuration' option in cPanel. Click on the link I've just given and follow the step by step instructions. I suggest you try this method before the other methods. Not all cPanel's provide this option, but apparently HostGator does.

I suspect that with the newer PHP version activated most, if not all of your problems will simply go away.

Cheers
RodG

Rod:

Yes, I can easily log into ZenCart using my primary login, which is why I never understood why I had to log in from a secondary login. I did create the secondary one, though, and updated the password for the first one.

The problem that started this was, I upgraded the shopping cart, but keep getting the red banner at the top that says "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels." So I tried following the instructions for updating it using the zc_install folder, but (possibly due to HostGator's server problems) I wasn't able to access it several times. When I finally did manage it, I tried to upgrade just the database per instructions...and the username/password didn't work. I researched the problem and found mention of a general.php file which should be installed as a patch...but that didn't work, either.

So I appealed to the forum board for help...was told to follow the "I Lost It" instructions...and got confused with that because it seemed to say that I must have a secondary username in order to affect any changes. Finally got past that, created a secondary username, tried to access phpMyAdmin. No joy...no one had told me to retrieve the password from the configure.php file and I was totally baffled because the cPanel un/pw wasn't working.

Per instructions, I tried to enter code to create a generic Admin/admin username using the Install SQL Patches page, and that errored out, too.

The cPanel says I'm using one version of PHP, Dr. Byte says I'm using an older one. So I'm appealing to HostGator for that...and still waiting for a reply. And waiting. And waiting.

Yes, the new username I created was done through ZenCart, and it's a new Admin user with Superpowers. LOL I didn't do anything through phpMyAdmin because I haven't yet been able to access phpMyAdmin...though I may be able to now using the info you provided re configure.php. But I don't dare do anything else at this point, not until I know specifically what I should try next.

Does that make it all clear-as-mud? LOL

Jo

RodG:

http://support.hostgator.com/articles/cpanel/php-configuration-plugin
You can also use the 'PHP Configuration' option in cPanel. Click on the link I've just given and follow the step by step instructions. I suggest you try this method before the other methods. Not all cPanel's provide this option, but apparently HostGator does.

I suspect that with the newer PHP version activated most, if not all of your problems will simply go away.

Thank you for that...and thank you, too, Dr. Byte...I just saw your post!

I just went in and manually set it to 5.4. Interestingly, I could have chosen 5.5, but I didn't want to push my luck.

My Version information now reads:

Server Information
Server Host: volt.websitewelcome.com (192.185.2.189) Database Host: localhost (127.0.0.1)
Server OS: Linux 3.12.24 Database: MySQL 5.5.40-36.1
Server Date: 10/30/2014 12:13:46 Database Date: 10/30/2014 12:13:46
Server Up Time: 12:13:46 up 1 day, 39 min, 0 users, load average: 0.02, 0.01, 0.00 HTTP Server: Apache
PHP Version: 5.4.32 (Zend: 2.4.0) PHP Memory Limit: 256M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 23,122 kB Database Index Size: 1,685 kB

Zen Cart
Zen Cart 1.5.3
Database Patch Level: 1.5.0
v1.5.0 [2012-04-28 15:32:41] (Fresh Installation)
v1.5.0 [2012-04-28 15:32:41] (Fresh Installation)
PHP Version 5.4.32

So...now what? I'm afraid to try anything at this point, because so many things have errored out...so I'm not doing anything until I know exactly what I should do next. LOL

DK_Scully:

Does that make it all clear-as-mud? LOL

Yup. All quite clear now. A bit of a 'comedy of errors' that seems to have had us all going around in circles rather than getting to the root of the problem, which at this stage points directly to the use of PHP V5.2.x.

I've noted that whilst composing my last response Dr.Byte and Ajeh had both stepped in with similar ideas and suggestions that I had. This is the equivalent to bringing out the 'big guns' to solve the problem, and re-affirms my own suggestions, so you can't go too fat wrong from here.

I'm gunna hit the sack (almost 4am). I suspect you'll be up and running before I get up tomorrow.

Cheers
RodG

Rod:

I saw them both chip in...yeah, talk about big guns! Nothing like getting the program designers involved! wince But isn't it nice that they were backing up your recommendations? Nice to know you're on the right track!

Should I risk renaming my admin folder to just 'admin' again and retrying the zc_install script? I really want this resolved so my ulcer will settle down again, but I'm afraid to touch anything lest it blow up in my face again. :lookaroun

Reading through this thread, it sounds like you may have used a "one click" process to upgrade Zen Cart to 1.5.3. Is this the case? Do you have a backup of the database and files from before the upgrade was performed? After the upgrade was performed?

As for the renaming of the admin folder, I would follow the advice posted by Dr Byte earlier.

lhungil:

Reading through this thread, it sounds like you may have used a "one click" process to upgrade Zen Cart to 1.5.3. Is this the case? Do you have a backup of the database and files from before the upgrade was performed? After the upgrade was performed?

I made a backup before I started...haven't done one since, because I've been wondering whether to abandon the entire nightmare and just go back to the previous version. I used the zen-cart-v1.5.3-(hotfix1)-07192014 zip.

Well, this is fun. I tried the zc_install script again, and specified JUST to update the database. It seemed to accept my un/pw this time...then has gone to a totally blank white screen. It's been that way for several minutes now. It says to be patient, but...is that normal, or did something else go wrong??

DK_Scully:

I made a backup before I started...haven't done one since, because I've been wondering whether to abandon the entire nightmare and just go back to the previous version. I used the zen-cart-v1.5.3-(hotfix1)-07192014 zip.

Now that all is caught up, no need to rename the admin folder (although I stated so earlier). When doing a database only upgrade, the admin folder is not a factor.
The only other thing/question before running the zc_install one last time is when the general.php file was replaced in the zc_install folder, was the content of post #8 of the same thread added to the general.php file? It was two lines to be added just after the first <?php in the file.

If it was, then you should now be able to complete the database upgrade successfully.

This is how it currently looks...I'm not sure if I added those lines in the right place or not. But the upgrade has not finished properly; it's just sitting on a blank white screen.

<?php define('DIR_FS_CATALOG', zen_read_config_value('DIR_FS_CATALOG', FALSE)); define('DIR_WS_CLASSES', 'includes/classes/'); /** * general functions used by the installer * @package Installer * @access private * @copyright Copyright 2003-2014 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version GIT: $Id: Author: Ian Wilson Wed Oct 23 18:28:44 2013 +0100 Modified in v1.5.2 $ */ if (!defined('TABLE_UPGRADE_EXCEPTIONS')) define('TABLE_UPGRADE_EXCEPTIONS','upgrade_exceptions'); require('../includes/classes/class.zcPassword.php'); function zen_not_null($value) { if (is_array($value)) { if (sizeof($value) > 0) { return true; } else { return false;

For general information regarding the background/reason I had suggested running the sql to establish a known username, password, and authority level when the "known" password was provided because of past experience updating several other older sites that for some reason had the access level of 0 instead of 1 and yet the user(s) having a zero under the slightly older version were able to login and perform super user related functions, upon upgrade those credentials no longer worked. But, when either the user level was changed to 1 or in the path I took and was suggesting here where I created the login information from the "I forgot my password" FAQ I was able to complete the upgrade. After the upgrade, all of the users remained as level 0, and when they were able to login, they had no access to any applications/options.

When I then took the backup, restored it, and changed the access level to 1 before going through the same process and was able to perform the upgrade using the then "known" username/passwod without running the sql query.

As to identifying how to gain access to the myphpadmin/mysql area, I didn't see the benefit of being able to get there at that point as the actions requested to be performed could be done without access to that area based on being able to login to the admin area.

As to the duration of troubleshooting, there were definitely assumptions made on my part, at a minimum of validating that the area to serve the site met the minimum requirements. (Yes there is/was conflicting information, though I should have gone to the version info first/outright.) After seeing the answers to the posting guidelines I should have maintained a much more formally documented status of everything.

I certainly appreciate the fresh perspective and ajeh, you can never be ignored. :) hope you got some good sleep rod. Thanks to dr. Byte, and I know one or two others stepped in. (Sorry, for losing track after all of this.)

DK_Scully:

This is how it currently looks...I'm not sure if I added those lines in the right place or not. But the upgrade has not finished properly; it's just sitting on a blank white screen.

<?php define('DIR_FS_CATALOG', zen_read_config_value('DIR_FS_CATALOG', FALSE)); define('DIR_WS_CLASSES', 'includes/classes/'); /** * general functions used by the installer * @package Installer * @access private * @copyright Copyright 2003-2014 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version GIT: $Id: Author: Ian Wilson Wed Oct 23 18:28:44 2013 +0100 Modified in v1.5.2 $ */ if (!defined('TABLE_UPGRADE_EXCEPTIONS')) define('TABLE_UPGRADE_EXCEPTIONS','upgrade_exceptions'); require('../includes/classes/class.zcPassword.php'); function zen_not_null($value) { if (is_array($value)) { if (sizeof($value) > 0) { return true; } else { return false;

White page: error log (generally speaking) I assume that the file should be in the logs folder, but may be in the cache directory based on current status of upgrade, etc... Same place I would expect as the last error log that was found. And another thing I've run across is that sometimes after running zc_install I have to upload the directory again to run it a second time as it seems one or more important files gets deleted and white screens.

Inclusion looks correct. No extra character/space before the first <?php is there?

http://www.carnal-pleasures.com/zencart/zc_install/index.php?main_page=database_upgrade is still sitting on a blank white screen. It's been what, over half an hour now? Definitely failed...any ideas why or what to do next? (I did try it a second time, btw...same problem.)

No space before the first <?php .

Update: I found the cache folder...this is the only recent file: sess_134629234d07e00735e2f3bdf12b2d91 The last myDEBUG file is the one I posted a few hours ago.

DK_Scully:

http://www.carnal-pleasures.com/zencart/zc_install/index.php?main_page=database_upgrade is still sitting on a blank white screen. It's been what, over half an hour now? Definitely failed...any ideas why or what to do next? (I did try it a second time, btw...same problem.)

No space before the first <?php .

Update: I found the cache folder...this is the only recent file: sess_134629234d07e00735e2f3bdf12b2d91 The last myDEBUG file is the one I posted a few hours ago.

Look in the logs folder? And possibly a stretch, cleared your browser's cache?

The install process is supposed to also create an install/upgrade log. Anything there?

Thanks for pointing me toward the /logs/ folder. Are all these errors being caused because I haven't renamed my secret-admin folder just 'admin'? First I was told I needed to, then several people said I didn't need to. This error message definitely seems to be saying I do need to.

---

Oct 30 2014 13:15 -- inspect
/admin/includes/configure.php does not exist

---

Oct 30 2014 13:15 -- inspect
FATAL: store configure.php is not writeable

---

Oct 30 2014 13:15 -- inspect
System Inspection Results:

NA: Webserver => Apache
NA: HTTP Host => https://www.carnal-pleasures.com
NA: Path_Translated => /home/carnal1/public_html/zencart/zc_install/index.php(SCRIPT_FILENAME)
NA: Real Path => /home/carnal1/public_html/zencart
NA: Server Free Disk Space => 763.84 GB
NA: PHP O/S => Linux
NA: PHP API Mode => cgi-fcgi
NA: PHP Max Execution Time per page => 30
NA: Disabled PHP Functions => dl
OK: MySQL Support => ON
OK: PHP Version => 5.4.32
OK: PHP Sessions Support => ON
OK: PHP Session.AutoStart => OFF
OK: PHP session.use_trans_sid => OFF
OK: Current SQL Cache Folder => /home/carnal1/public_html/zencart/cache-->Writeable
OK: Suggested SQL Cache Folder => /home/carnal1/public_html/zencart/cache
OK: PHP GD Support => ON
OK: GD Version => GD bundled (2.1.0 compatible)
OK: PHP ZLIB Compression Support => ON
OK: PHP OpenSSL Support => ON
OK: PHP cURL Support => ON
OK: CURL NON-SSL Capability => Okay
OK: CURL SSL Capability => Okay
OK: PHP Upload Support => ON upload_max_filesize=64M; post_max_size=64M
OK: PHP Upload TMP dir =>
OK: Apache .htaccess Support => ON
NA: PHP include_path => .:/opt/php54/lib/php
NA: PHP SMTP destination => localhost
NA: PHP sendmail path => /usr/sbin/sendmail -t -i
NA: PHP sendmail 'from' =>
OK: PHP open_basedir restrictions =>
WARN: PHP Output Buffering (gzip) => OFF
OK: PHP XML Support => ON
OK: PHP Session.Save_Path => /home/carnal1/public_html/zencart/cache-->Writeable
FAIL: includes/configure.php => <span class='errors'>Unwriteable</span>
FAIL: admin/includes/configure.php => NOT FOUND
OK: cache => OK 777 read/write/execute
OK: images => OK 777 read/write/execute (INCLUDE SUBDIRECTORIES TOO)
OK: includes/languages/english/html_includes => OK 777 read/write (INCLUDE SUBDIRECTORIES TOO)
OK: logs => OK 777 read/write/execute
OK: media => OK 777 read/write/execute
OK: pub => OK 777 read/write/execute
WARN: admin/backups => <span class='errors'>Unwriteable</span> 777 read/write
WARN: admin/images/graphs => <span class='errors'>Unwriteable</span> 777 read/write/execute
PHP Extensions compiled: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, intl, json, mbstring, mcrypt, mssql, mysql, mysqli, odbc, standard, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, Reflection, imap, SimpleXML, soap, sockets, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, imagick, SourceGuardian, mhash, ionCube Loader, Zend Guard Loader

---

Oct 30 2014 13:16 -- inspect
/admin/includes/configure.php does not exist

---

Oct 30 2014 13:16 -- inspect
FATAL: store configure.php is not writeable

---

Oct 30 2014 13:18 -- database_upgrade
FATAL: Admin Password required to proceed with upgrade

---

Oct 30 2014 13:18 -- database_upgrade
FATAL: Admin Password required to proceed with upgrade

From what is provided in that log (which is the result one should see while going through the zc_install "check") basically it's providing information to identify that it is not possible/there is insufficient information to perform a "fresh" database install. You don't want to do that anyways, so all the info in that file actually looks correct and makes it known that the zc_install can only be used to do a database upgrade.

Ie. Secret admin directory can stay secret for a database only upgrade, but must be admin if doing a full install/database wipe of the core tables.

Okay...so why did it fail??

DK_Scully:

Okay...so why did it fail??

Try again, that log seems to imply that the username/password wasn't right. :) as soon as the white screen comes up, go check that folder and logs.

The newest error message says:

[30-Oct-2014 14:32:13 America/Chicago] PHP Warning: require_once(/home/carnal1/public_html/zencart/../includes/classes/vendors/password_compat-master/lib/password.php): failed to open stream: No such file or directory in /home/carnal1/public_html/zencart/includes/classes/class.zcPassword.php on line 52

[30-Oct-2014 14:32:13 America/Chicago] PHP Fatal error: require_once(): Failed opening required '/home/carnal1/public_html/zencart/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.:/opt/php54/lib/php') in /home/carnal1/public_html/zencart/includes/classes/class.zcPassword.php on line 52

I tried using the new login I created this morning, and it refused that one...the only one it would accept was the original one that I've been using all along.