version not sure as I can not get to admin

[pageblair]

Hello and thank you, I have lost the ability to log in to the admin, I ran the query:

DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_profile)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

This is successful but still can not get in,
Admin
admin

please help,John

[pageblair]

marsauto.net is the site

[Design75]

marsauto.net is the site

With ftp go to YOUR_SITE/includes/version.php, and view the contents of the file.

[pageblair]

@license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version GIT: $Id: Author: DrByte Tue Aug 28 14:21:34 2012 -0400 Modified in v1.5.1 $
* @private
*/

define('PROJECT_VERSION_NAME', 'Zen Cart');
define('PROJECT_VERSION_MAJOR', '1');
define('PROJECT_VERSION_MINOR', '5.1');
define('PROJECT_VERSION_PATCH1', '');
define('PROJECT_VERSION_PATCH2', '');
define('PROJECT_VERSION_PATCH1_SOURCE', '');
define('PROJECT_VERSION_PATCH2_SOURCE', '');
define('NEW_VERSION_CHECKUP_URL','http://ping.zen-cart.com/version_id.txt');
define('EXPECTED_DATABASE_VERSION_MAJOR', '1');
define('EXPECTED_DATABASE_VERSION_MINOR', '5.0');

[carlwhat]

have u tried the forgot password link for the admin? does sending mail work on the server?

you would either need to have another admin user in your database or change the email you entered above to an address to which you have access.

[lat9]

Is it possible that your webhost has upgraded the version of PHP on which the site runs? zc1.5.1 is very, very long-in-the-tooth and will not operate under now-current versions of PHP.

[mc12345678]

@license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version GIT: $Id: Author: DrByte Tue Aug 28 14:21:34 2012 -0400 Modified in v1.5.1 $
* @private
*/

define('PROJECT_VERSION_NAME', 'Zen Cart');
define('PROJECT_VERSION_MAJOR', '1');
define('PROJECT_VERSION_MINOR', '5.1');
define('PROJECT_VERSION_PATCH1', '');
define('PROJECT_VERSION_PATCH2', '');
define('PROJECT_VERSION_PATCH1_SOURCE', '');
define('PROJECT_VERSION_PATCH2_SOURCE', '');
define('NEW_VERSION_CHECKUP_URL','http://ping.zen-cart.com/version_id.txt');
define('EXPECTED_DATABASE_VERSION_MAJOR', '1');
define('EXPECTED_DATABASE_VERSION_MINOR', '5.0');

The next question would be what version of php is running for the site, and specifically what version of php is the site seeing when run. The first part of the question would likely be found in cPanel if you have one when logging into your host account.

The second part of that question could be identified by putting a file at the root of your store with a filename of your choosing, preferably not phpinfo or anything easily guessed, but with the extension .php and having the following contents:

<?php
echo phpinfo();

More than likely the version is greater than 5.3 which was the highest version for which ZC 1.5.1 was designed. As such, there are two general recommendations: 1. See if your php version can be decreased to 5.3 for at least a short period of time or 2. Perform an upgrade of the site by rebuild: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

This can be done without taking down your site any longer than necessary to place the files after verifying operation of the new site.

If it is necessary to get to something specific in the existing site to support operations, then it may be necessary to use phpmyadmin or equivalent to review the situation and take action with notes maintained about what needs to be done once the store has been made fully operational again and/or modifying the database to reflect those operations. Ideally though everything would be done through a functional admin area...

A third option is to "debug" or incorporate files from newer versions to support the current php version and allow access while also doing the above upgrade in parallel.

[pageblair]

5.6.4 is the lowest they allow, I have to contact the hosting co.

[pageblair]

can i make changes to the site via FTP. categories and ez pages?

[mc12345678]

can i make changes to the site via FTP. categories and ez pages?

FTP can be used to write code that could then possibly be used to make changes, so yes in a really hard way of doing things...

Otherwise, like said before, can go for the upgrade of the software that would then allow updating the database with backups made of data and software alike and frequently.