Remove Old Domain From New Db: LOCK TABLES `upgrade_exceptions`

[Webskipper]

Recently noticed that imported database from old site to new ZC 2.0 site also included connecting the two sites. No log errors.

How do we disconnect the new site from the old domain?

While I removed links to the old site in the banners, the real issue is mostly likely here in the Sql:


--
-- Dumping data for table `upgrade_exceptions`
--


LOCK TABLES `upgrade_exceptions` WRITE;
/*!40000 ALTER TABLE `upgrade_exceptions` DISABLE KEYS */;
INSERT INTO `upgrade_exceptions` (`upgrade_exception_id`, `sql_file`, `reason`, `errordate`, `sqlstatement`) VALUES (1,'/home1/USER/public_html/OLDDOMAIN/store/zc_install/sql/install/mysql_zencart.sql','Cannot create table customer_groups because it already exists','2022-12-20 12:35:57','CREATE TABLE customer_groups ('),(2,'/home1/USER/public_html/OLDDOMAIN/store/zc_install/sql/install/mysql_zencart.sql','Cannot create table customers_to_groups because it already exists','2022-12-20 12:35:57','CREATE TABLE customers_to_groups ('),(3,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column products_length because it does not exist.','2024-03-23 19:44:22',NULL),(4,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column products_width because it does not exist.','2024-03-23 19:44:22',NULL),(5,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column products_height because it does not exist.','2024-03-23 19:44:22',NULL),(6,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column products_ready_to_ship because it does not exist.','2024-03-23 19:44:22',NULL),(7,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column product_ships_in_own_box because it does not exist.','2024-03-23 19:44:22',NULL),(8,'/home1/USER/public_html/NEW_DOMAIN/zc_install/sql/updates/mysql_upgrade_zencart_200.sql','Cannot CHANGE column customers_whole because it does not exist.','2024-03-23 19:44:22',NULL);
/*!40000 ALTER TABLE `upgrade_exceptions` ENABLE KEYS */;
UNLOCK TABLES;

[dbltoe]

The two locations should have different database names in their respective configure.php files (two in each site).

[Webskipper]

I see what you are saying. Both site’s configs are correct and only reference their respective db’s and domains. Admin configs, too.

[dbltoe]

Where is that dump from? Old or new? Did you do the update of the 2.0 database with the old info?

https://docs.zen-cart.com/user/upgra...orary-database

[Webskipper]

New fresh clean site installed with 2.0 then imported the db from old site. Where else could they be connected?

[dbltoe]

If the database names are different in the configure.php files, they are not "connected".

Have you run the zc_install for the 2.0 siite and selected Update as https://docs.zen-cart.com/user/upgra...orary-database says?

[Webskipper]

Yes. It upgraded it to the new Php version.

Downloading today's version of 2.0 and Uploading its zc_install today calls for a clean install on a clean install.

I dont have time to re-install 500 products. Surely there’s something else to fix.

[dbltoe]

A bit of clarification.

There are two configure.php files for each site one in in YOUR_ADMIN/includes and the other is in includes/.

Both those files need tgo reflect the settings for THAT site and database. PHP is NOT set in those two files.

Specifically, the database settings in each should be:

/** * The following settings define your database connection.
 * These must be the SAME as you're using in your admin copy of configure.php
 */
define('DB_TYPE', 'mysql'); // always 'mysql'
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8'); // 'utf8' or 'latin1' are most common
define('DB_SERVER', 'localhost');  // address of your db server
define('DB_SERVER_USERNAME', 'Can be the same for both sites');
define('DB_SERVER_PASSWORD', 'Can be the same for both sites');
define('DB_DATABASE', 'MUST be the database name for the specific site');

There are other settings in each configure.php file that need to be "site specific" but the database settings are what make sure your site is using the correct database.

[Webskipper]

Hi

As above, "I see what you are saying. Both site’s configs are correct and only reference their respective db’s and domains. Admin configs, too.”
The old domain only exists where I stated above.

[dbltoe]

Yet you keep saying the two databases are connected.

Perhaps you need to start over and let us know the steps you went through to discover this problem.