ecart
Advanced Member
123 Posts |
 Posted - 02/21/2021 : 15:54:40
Hello,
I'm changing an ECT Dreamweaver site to a Wordpress site.
I've setup Wordpress with the ECT integration. I'm using the Astra Child Theme and imported an Astra main theme. The imported theme was an ecommerce theme that installed WooCommerce. Once I realized that happened, I deleted the WooCommerce plugin.
I then looked at the MySQL database and there are still tables from WooCommerce installation in it. Should I drop the WooCommerce tables before importing the database from the old site? Also, will the import only involve matching tables and their records?
Thanks
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 02/22/2021 : 03:10:06
Hi, The latest ECT WP installations use one database, so the WP tables and the ECT tables are all in the same database. This is what I would do 1. Take a copy/backup of the current database the store is currently connected to first. 2. Make sure the sql file you're importing has the drop table statement and import that 3. Then fully apply the latest updater 4. If all runs well take another copy of the database and then remove any unwanted WP tables 
* Database Migrations and Conversions*
* ASP to PHP Cart Conversions**Contact Us**Buy The PHP Capture Card Plugin**Rate Our Services/View Our Feedback* |
ecart
Advanced Member
123 Posts |
Posted - 02/24/2021 : 16:41:15
Hi Phil,
Thanks for the input. What is the drop table statement?
Also, there seems to be a user/permissions issue. I get an error saying that: MySQL said, #1044 - Access denied for user 'newdatabase'@'localhost' to database 'olddatabase' .
Any thoughts on this?
Thanks
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 02/25/2021 : 03:09:44
quote:
What is the drop table statement?
When you export the database choose the custom option, scroll down and under the heading Object creation options you'll see an add drop table checkbox - you need to check that. For the user permissions error you need to check that the user you created has ALL privileges. If you still struggle to import it click on my name and send me login details and email me the SQL file
* Database Migrations and Conversions*
* ASP to PHP Cart Conversions**Contact Us**Buy The PHP Capture Card Plugin**Rate Our Services/View Our Feedback*
|
ecart
Advanced Member
123 Posts |
Posted - 02/28/2021 : 12:05:41
Hi Phil,
I was able to import the database successfully. However, when I went to the website's homepage it showed this error:
"ECT Database Error
It seems that the ECT createdb.php script has not been executed to create the database tables.
Please click here to run the script.
Error Message for Support
Unknown column 'storelang' in 'field list' "
Before the import, the site was functioning properly. If I run the createdb.php script again, will it overwrite the import data?
Thanks
|
ecart
Advanced Member
123 Posts |
Posted - 02/28/2021 : 12:24:22
I ran the updater 7.3. Now the error message says:
"There has been a critical error on this website.
Learn more about debugging in WordPress."
How can I resolve this?
Thanks
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/01/2021 : 00:02:43
quote:
I've setup Wordpress with the ECT integration. I'm using the Astra Child Theme and imported an Astra main theme
I'm assuming you imported the database into the Wordpress database that already exists? If you edit the line in your wp-config.php file define( 'WP_DEBUG', false ); to define( 'WP_DEBUG', true ); That should give you a detailed error message so you should have a better idea of what's wrong. Can you also check that your vsadmin/db_con_open.php file begins like this from line 9 // !!! THIS FILE NEEDS NO EDITING !!! // Your WordPress database configuration details will be used. if(! defined('DB_USER')){
* Database Migrations and Conversions*
* ASP to PHP Cart Conversions**Contact Us**Buy The PHP Capture Card Plugin**Rate Our Services/View Our Feedback*
|
ecart
Advanced Member
123 Posts |
Posted - 03/01/2021 : 18:11:27
Hi Phil,
Yes, the Wordpress database was already installed.
define( 'WP_DEBUG', false );
This line does not exist in the wp-config.php file. Should I add it?
The vsadmin/db_con_open.php file does not exist in the vsadmin folder. Something happened during the import or the update because the site worked before those two operations.
What next?
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/01/2021 : 18:15:43
Edited by - Phil on 03/01/2021 18:18:54
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/02/2021 : 12:31:15
|
ecart
Advanced Member
123 Posts |
Posted - 03/02/2021 : 14:08:39
Thanks Phil.
I can access the site again, but the product images don't show on the product listings or on the product detail pages. The prodimages folder has all of the images and the database's product records show prodimages/"imagename.jpg" in the pImage field and the pLargeImage field. The prodimages folder is in the root directory.
Any thoughts?
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/03/2021 : 03:52:11
Hi Stan, I took a look at the database and the product image data was entered in the products table which was a few years ago when that was the case. It should now be in the productimages table, and all that had was the default example image data. I ran the 7.3 updatestore.php script hoping that they would be moved over, but it didn't happen because it's that long since image data was in the products table there's no check for that in the script so I've moved them over manually. So your images should now be displaying.
* Database Migrations and Conversions*
* ASP to PHP Cart Conversions**Contact Us**Buy The PHP Capture Card Plugin**Rate Our Services/View Our Feedback* |
ecart
Advanced Member
123 Posts |
Posted - 03/03/2021 : 11:19:34
Thanks Phil,
What is the manual process? Is there a way to export the products table and import just the image data into the productimages table?
I have several more ECT to Wordpress conversions to do. One of them has more than 4K product records and was setup in 2008. Version 6.07 was the last update because the client uses Macs and wanted to continue using capture card.
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/03/2021 : 13:21:19
Hi Stan, I think you've had this problem because you possibly ran a later version of createdb.php script and created the database which added the table productimages, then imported your sql file So when you updated and ran the updatestore.php script, the script checks for the presence of the table productimages and if it doesn't exist it'll create the table and move over the image data from the products table. If it does exist it will not move any image data over from the products table So really you shouldn't have any problems as long as you don't use the createdb.php script, just import the sql file into the existing wp database.
* Database Migrations and Conversions*
* ASP to PHP Cart Conversions**Contact Us**Buy The PHP Capture Card Plugin**Rate Our Services/View Our Feedback* |
ecart
Advanced Member
123 Posts |
Posted - 03/04/2021 : 10:56:52
Hi Phil,
I want to make sure I run the proper sequence of steps.
I’m setting up an alternate/staging server, the .net, instead of using the live server, the .com.
Steps:
1. Setup staging server with Wordpress
2. Import MySQL database from the live ECT installation with Drop table statement checked.
3. Install ECT Wordpress template. This requires running createdb.php. Should I skip this step since I’ve imported the MySQL database from the live site? Or run the script and then drop the productimages table so the 7.3 update will create the productimages table and move the image data over?
4. Migrate the .net to the .com server.
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/04/2021 : 11:19:11
|
ecart
Advanced Member
123 Posts |
Posted - 03/21/2021 : 16:18:58
Hi Phil,
I've follow the steps and did not use the createdb.php file. Do I need to manually create the shopping cart pages?
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/22/2021 : 00:43:32
Edited by - Phil on 03/22/2021 02:01:36
|
ecart
Advanced Member
123 Posts |
Posted - 03/22/2021 : 11:41:50
OK.
Most of the products are missing their images. The database seemed to import fine.
Any thoughts on this?
Thanks,
Stan
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/22/2021 : 11:50:53
|
Phil
ECT Moderator
United Kingdom
7715 Posts |
Posted - 03/22/2021 : 12:38:15
|
| |
|
Database Import