In need of help upgrading to new version

[DrByte]

I'm not getting the upgrade database option upon re-running the install...

https://docs.zen-cart.com/user/upgra...er_no_upgrade/

I am still at a loss on how to bring the database info from my 1.3.9h store to my 1.5.7 store

I currently have the new install under a new directory with it's own new database and all seems to work properly

Brief recap of the step by step instructions in the upgrade docs https://docs.zen-cart.com/user/upgrading/
- In the "new" store's /includes/configure.php file there are some DB_XXXXXX settings.
- The DB_DATABASE must be the NEW database
- The DB_PREFIX must match whatever was in the "old" store's /includes/configure.php file
- Then you make a backup of the "old" store's database
- And import that backup of the "old" database into the "new" database, replacing the tables previously in the "new" database from the temporary new install you did.
- Then running zc_install on the "new" store will give you the Upgrade Database option.

[iknowalttl]

https://docs.zen-cart.com/user/upgra...er_no_upgrade/



Brief recap of the step by step instructions in the upgrade docs https://docs.zen-cart.com/user/upgrading/
- In the "new" store's /includes/configure.php file there are some DB_XXXXXX settings.
- The DB_DATABASE must be the NEW database
- The DB_PREFIX must match whatever was in the "old" store's /includes/configure.php file
- Then you make a backup of the "old" store's database
- And import that backup of the "old" database into the "new" database, replacing the tables previously in the "new" database from the temporary new install you did.
- Then running zc_install on the "new" store will give you the Upgrade Database option.

I am pretty sure these are the steps I had taken in the past... I just now went through these steps again to make sure...
- The DB_DATABASE must be the NEW database... confirmed...
- The DB_PREFIX must match whatever was in the "old" store's /includes/configure.php file... confirmed...
old store... define('DB_PREFIX', '');
new store... define('DB_PREFIX', '');
- Then you make a backup of the "old" store's database... just now exported fresh backup through cpanel phpMyAdmin as a .sql file...
- And import that backup of the "old" database into the "new" database, replacing the tables previously in the "new" database from the temporary new install you did... just now imported .sql file through cpanel phpMyAdmin... received following...

Error
SQL query:


--
-- Database: `apparvuc_printers_zc1`
--

-- --------------------------------------------------------

--
-- Table structure for table `address_book`
--

CREATE TABLE `address_book` (
`address_book_id` int(11) NOT NULL,
`customers_id` int(11) NOT NULL DEFAULT '0',
`entry_gender` char(1) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_company` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
`entry_firstname` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_lastname` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_street_address` varchar(64) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_suburb` varchar(32) COLLATE latin1_general_ci DEFAULT NULL,
`entry_postcode` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_city` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`entry_state` varchar(32) COLLATE latin1_general_ci DEFAULT NULL,
`entry_country_id` int(11) NOT NULL DEFAULT '0',
`ent[...]
MySQL said: Documentation

#1050 - Table 'address_book' already exists

but if I look in the file I do see data info for customers...
here is what I get on running the install...

[DrByte]

#1050 - Table 'address_book' already exists

Redo your export -- in the settings tick the box for "Include DROP TABLES ..." so that it deletes any tables already in the database when later importing it.
Or just delete all the tables from the "new" database before importing the backup into it.

[iknowalttl]

Redo your export -- in the settings tick the box for "Include DROP TABLES ..." so that it deletes any tables already in the database when later importing it.
Or just delete all the tables from the "new" database before importing the backup into it.

thank you very much for your help... I was deleting all the tables that were common as I was waiting on a response... got r done... upgrade option now appears... now issue is password... I did go in and change it in the admin area but somehow it is not working... trying to do the sql query to reset and a little confused... where it says "INSERT INTO admin (admin_name, admin_email, admin_pass, admin_profile)" what is admin_profile...

[DrByte]

now issue is password... I did go in and change it in the admin area but somehow it is not working...

It requires the usual admin password of an administrator in the "old" database (not from the "new" one that you just wiped out by importing the sql)

trying to do the sql query to reset and a little confused... where it says "INSERT INTO admin (admin_name, admin_email, admin_pass, admin_profile)" what is admin_profile...

You don't need to alter the query, since your DB_PREFIX is blank.

[iknowalttl]

It requires the usual admin password of an administrator in the "old" database (not from the "new" one that you just wiped out by importing the sql)


You don't need to alter the query, since your DB_PREFIX is blank.

thank you so much again... old user name and password worked just fine... I think I am go to go now... fingers crossed... just need to modify the template for appearance now...