Can't access admin section after changing DB password

mc12345678:

What php version is installed?

1.5.1 - i think

mc12345678:

Umm,unfortunately may need to change the DB password again... All the DB stuff got posted... It's not quite formatted as expected, but it's there...

gets even stranger.. i changed the DB password.. in both places.. the front end works.. admin does NOT.. used the exact same procedure to change only the password in both files and uploaded the same way.

mc12345678:

I was wrong, it was SID which represents the SessionID.

Find this at or around line 62:

  if (defined('SID') && zen_not_null(SID)) {
    $sid = SID;

> 
> And change to:
> ```
      if (defined('SID') && zen_not_null(constant('SID'))) {
        $sid = constant('SID');

didn't work..

lidlchris:

1.5.1 - i think

This is the ZC version.

Php would be 5.2.x, 5.3.x, (both of those are basically retired), 5.4.x (retired or soon to be), 5.5.x (approaching same), or 5.6.x.

See http://phpinfofile.com for a way to tell what version is currently running.

mc12345678:

This is the ZC version.

Php would be 5.2.x, 5.3.x, (both of those are basically retired), 5.4.x (retired or soon to be), 5.5.x (approaching same), or 5.6.x.

See http://phpinfofile.com for a way to tell what version is currently running.

Sorry about that.. in cpanel it shows to be 5.5.22

lidlchris:

gets even stranger.. i changed the DB password.. in both places.. the front end works.. admin does NOT.. used the exact same procedure to change only the password in both files and uploaded the same way.

What I meant is that in one of the recent posts where the admin/includes/configure.php file was posted, two things: one the DB_ info was posted. (Pretty much all of it) and 2) the contents between the code tags appear to be all one line rather than multiple lines, this may be because of the source from which copied, or could also be an issue with the file.

What again (or for the first time) are the symptoms on the admin side access? Please be more specific than doesn't work...

mc12345678:

What I meant is that in one of the recent posts where the admin/includes/configure.php file was posted, two things: one the DB_ info was posted. (Pretty much all of it) and 2) the contents between the code tags appear to be all one line rather than multiple lines, this may be because of the source from which copied, or could also be an issue with the file.

What again (or for the first time) are the symptoms on the admin side access? Please be more specific than doesn't work...

yes i know but i didn't post the right password in those posts.. :) when i say it doesn't work i mean a blank white page comes up.. no errors - just nothing.

lidlchris:

Sorry about that.. in cpanel it shows to be 5.5.22

Another example of where it helps most to provide the information of the posting tips up front... Generally speaking without making specfic changes, ZC 1.5.1 is not supported beyond pHP 5.3... Ie, time to upgrade... However, I did see a post recently about how it might be able to hobble along until the upgrade is complete (fyi upgrade by rebuild: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading)

Recent thread about how to hobble. :P https://www.zen-cart.com/showthread.php?218424-v1-5-1-and-PHP5-5-or-5-6

Server reqs: http://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart

mc12345678:

Another example of where it helps most to provide the information of the posting tips up front... Generally speaking without making specfic changes, ZC 1.5.1 is not supported beyond pHP 5.3... Ie, time to upgrade... However, I did see a post recently about how it might be able to hobble along until the upgrade is complete (fyi upgrade by rebuild: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading)

Recent thread about how to hobble. :P https://www.zen-cart.com/showthread.php?218424-v1-5-1-and-PHP5-5-or-5-6

Server reqs: http://www.zen-cart.com/content.php?48-what-are-the-server-requirements-to-run-zen-cart

but it was working fine until i changed the DB password - that's all i changed.. I need access asap as we have orders to process.. an upgrade will take weeks.

GOT IT... did NOT have to upgrade.. the admin configure file was formatted wrong?? i edited it in notepad to make it identical to the dist-configure.php file and moved it and it works.. :smile:

lidlchris:

but it was working fine until i changed the DB password - that's all i changed.. I need access asap as we have orders to process.. an upgrade will take weeks.

lidlchris:

GOT IT... did NOT have to upgrade.. the admin configure file was formatted wrong?? i edited it in notepad to make it identical to the dist-configure.php file and moved it and it works.. :smile:

It seems that for now things are working then. Be advised though: 1) yes it stopped working after "operator error" the incorrect upload of the admin/includes/configure.php, but the php version could be changed without your doing and therefore could cause a larger problem. 2) an upgrade/rebuild should not take weeks to perform if talking about simply updating just the operating system portion especiially from 1.5.1... 3) the particular "upgrade" identified in the second link merely required uploading (possibly with some merging) files from a slightly more recent version that would make/keep the store operational under the more recent versions of PHP. Not doing something to upgrade the files even a little is taking a significant risk... Consider the impact of the site going down and no sales even able to be taken on the customer side... At least in the above situation the store front worked and you could have limped along using just phpmyadmin as a work-around...

Glad the store is working again, but hopefully it can continue operating based on your future decisions.

mc12345678:

It seems that for now things are working then. Be advised though: 1) yes it stopped working after "operator error" the incorrect upload of the admin/includes/configure.php, but the php version could be changed without your doing and therefore could cause a larger problem. 2) an upgrade/rebuild should not take weeks to perform if talking about simply updating just the operating system portion especiially from 1.5.1... 3) the particular "upgrade" identified in the second link merely required uploading (possibly with some merging) files from a slightly more recent version that would make/keep the store operational under the more recent versions of PHP. Not doing something to upgrade the files even a little is taking a significant risk... Consider the impact of the site going down and no sales even able to be taken on the customer side... At least in the above situation the store front worked and you could have limped along using just phpmyadmin as a work-around...

Glad the store is working again, but hopefully it can continue operating based on your future decisions.

yes i fully intend to upgrade.. it's always like going to the dentist for me with zen cart though.. i've been using them for about 7 years and every upgrade has been a nightmare.. mostly because of all of the custom coding that has been used.

thanks for all of your help..

mc12345678:

ZC 1.5.1, correct?

Have you modified the includes/functions/html_output.php file to change or address the need to assign/cast the SESSIONS constant I think it was? It's a change that is incorporated in more recent ZC versions and causes if I remember correctly memory to be exhasted similar to what is reported here... Though I am a little surprised to see adm error logs that don't include the admin directory path, generally speaking...

hey do you know how i edit previous posts?? i'd like to take out the coding i posted in one post but there is no edit button for that post.

lidlchris:

hey do you know how i edit previous posts?? i'd like to take out the coding i posted in one post but there is no edit button for that post.

There's a time limit on when you can directly edit the post, otherwise have to write to the "staff" and ask that information be removed... Sometimes they will somehow catch it quickly and immediately (only going out to those subscribed) but if not mistaken that was the same post to which I was referring above. I chose not to reply with quote so as not to exacerbate the issue in particular because I would have to navigate through the previous post to try to identify each item of concern...

As for the upgrade/rebuild process if the changes could be applied outside of the default ZC files (template overrides) then the upgrade process should not be so bad... Upgrade through 1.5.x is far simpler than from previous to the current and really should be no more than a weekend task for full restoration, a few hours for standard operation most of that time being upload time...