I made some success by opening the .sql file in a text editor and resaving it specifying UTF-8 encoding. This didn't quite work, but I modified the file to be just the product info and it did import, albeit with some issues. I'm trying to trim out bits I don't care about as my basic .sql is just under 20 megs. I would really like to maintain customer names/addresses, products, and reviews and reviews, but I'm not as concerned with past orders, categories, or similar.
Any thoughts?
I believe Editing your sql file is the way to go.
Be careful not to remove too much though (As some tables are required / depend on each other)
You can edit, then test and see if the script fails, edit again, test...
It's been a while, and I can't really remember specifics of the script.
I can't remember if reviews are converted by default.
Another way to go (If you have access to the old database), is export only the required tables...
Be careful not to remove too much though (As some tables are required / depend on each other)
You can edit, then test and see if the script fails, edit again, test...
It's been a while, and I can't really remember specifics of the script.
I can't remember if reviews are converted by default.
Another way to go (If you have access to the old database), is export only the required tables...
Hi,
Can't get the login to work. I made an export in osCommerce v2.3.3.4 and import this in OpenCart v1.5.4.1 (also tried 1.5.2.1). The import is working fine without errors. But afterwards I can't login into OpenCart with the mail and password from the osCommerce customer. There are no vqmod errors and I tried also the manual customer.php files.
Further a question: should this extension also work with OpenCart v1.5.5.1?
Can't get the login to work. I made an export in osCommerce v2.3.3.4 and import this in OpenCart v1.5.4.1 (also tried 1.5.2.1). The import is working fine without errors. But afterwards I can't login into OpenCart with the mail and password from the osCommerce customer. There are no vqmod errors and I tried also the manual customer.php files.
Further a question: should this extension also work with OpenCart v1.5.5.1?
Hi,
I tried to upload my backup from my OsC 2.2 RC2 store to my new Opencart 1.5.5.1 as a whole but ended up with several error messages like:
Now if I see these errors and go back I see the "osCommerce Backup Converted and Saved to Downloads Directory:db_ | Check Conversion Log | Import Converted Data"- message
But of course something is still wrong, because when I try to import converted data I get the following error:
When I look at mysql backup after this process I see that the addresses table(oc_address) is imported, but the customers table (oc_customer) is not. Can someone please tell me what the next logical step is from here? Thank you 
I tried to upload my backup from my OsC 2.2 RC2 store to my new Opencart 1.5.5.1 as a whole but ended up with several error messages like:
Code: Select all
Notice: Undefined index: val in /home/vhosting/c//htdocs/www/store/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 124
Notice: Undefined offset: 4 in /home/vhosting/c//htdocs/www/store/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 109
Notice: Undefined offset: 5 in /home/vhosting/c//htdocs/www/store/vqmod/vqcache/vq2-admin_model_tool_backup.php on line 109But of course something is still wrong, because when I try to import converted data I get the following error:
Code: Select all
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `key` = 'config_owner' AND `store_id` = '0'' at line 1
Error No: 1064
UPDATE `oc_setting` SET `value` = WHERE `key` = 'config_owner' AND `store_id` = '0' in /home/vhosting/c/htdocs/www/store/system/database/mysql.php on line 50I have similar error oc version 1.5.4.1
php5.5
php5.5
Code: Select all
PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE order_id = '183'' at line 1<br />Error No: 1064<br />UPDATE `oc_order` SET `total` = WHERE order_id = '183' in /srv/users/serverpilot/apps/tokokristiktk/public/system/database/mysqliz.php on line 53
Selling Kristik - Jasa Foto Aura - Kapas Vapor - supplier baju anak -
Hi,
This script is very sensitive for errors. I got these errors too. You have to check carefully the OS export file. The order total error you get sometimes when you have some records with this in your export file:
Changing into this will help:
Also try to import by parts. So first take one table, for instance products and import. If no errors take another one. Sometimes a table is not working. Then edit your database file in for instance Notepad++ and start with only a few records. If no error put in more. Like this you can find the record which cause the error and check.
Further when you installed extensions in OS this puts new records in the database. This cause also some troubles. In that case check the table headers.
This script is very sensitive for errors. I got these errors too. You have to check carefully the OS export file. The order total error you get sometimes when you have some records with this in your export file:
Code: Select all
'0.0000', '0.0000',Code: Select all
'0.0001', '0.0000',Further when you installed extensions in OS this puts new records in the database. This cause also some troubles. In that case check the table headers.
Who is online
Users browsing this forum: No registered users and 7 guests
