I have a store on OpenCart and I need to transfer only products (with price) categories images and Manufacturer. I'm doing that because I'm moving my opencart to a new clear and updated installation, i have to do that because my new template don't support my old set up.
Now im on Version 1.5.1
i need to go on 1.5.6.4
Now im on Version 1.5.1
i need to go on 1.5.6.4
You can export related DB tables from old store and import it into new DB
Note: remember to backup before you do your jobs
Hope this help
Contact me at support@goleo.vn if you willing to pay
Thanks
Note: remember to backup before you do your jobs
Hope this help
Contact me at support@goleo.vn if you willing to pay
Thanks
GOLDEN LEOPARD SYSTEM SOLUTION
An ICT System Solution Company in Vietnam
Website: Store: http://opencart.goleo.vn or http://www.opencart.com/index.php?route ... rname=alin
coant wrote:i was try that but i have an Error: Could not make a database connection using "mydatabse"grserver.gr:3307
any ideas?
Please post the complete error.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Ok i fix that is a problem with the localhost address happened because i use the old one and for that reason they can't find my new localhost of database...i2Paq wrote:coant wrote:i was try that but i have an Error: Could not make a database connection using "mydatabse"grserver.gr:3307
any ideas?
Please post the complete error.
Now im use clean and new opencart as you said but i keep only the config files from admin and catalog im not install the new opencart i just upload the new version to the root folder downloaded from opencart.com and i put only my old config files with new imported database details, now i have 2 errors one on admin when i try to log in
Code: Select all
Notice: Error: Unknown column 'salt' in 'where clause'
Error No: 1054
SELECT * FROM user WHERE username = 'administrator' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('password'))))) OR password = '5f4dcc3b5aa765d61d8327') AND status = '1' in /var/www/vhosts/myside.gr/httpdocs/myside/main/system/database/mysql.php on line 50
Code: Select all
Notice: Undefined index: tag in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /var/www/vhosts/myside.gr/httpdocs/myside/main/catalog/model/catalog/product.php on line 30
Last edited by coant on Tue Oct 14, 2014 6:23 pm, edited 2 times in total.
So you use an old database?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
You Fisrt update now Store to version 1.5.6.4coant wrote:I have a store on OpenCart and I need to transfer only products (with price) categories images and Manufacturer. I'm doing that because I'm moving my opencart to a new clear and updated installation, i have to do that because my new template don't support my old set up.
Now im on Version 1.5.1
i need to go on 1.5.6.4

i import the rest of my old database to the new one with export and import method.i2Paq wrote:So you use an old database?
We have do something wrong? We need to understand if i have to import the rest of my old database or only some tables and if yes what tables is necessary to export from old one DB?
You can open in PhpMyadmin e.g. table "product" and click "Export". Same can be other tables, the need to transfer.coant wrote:i import the rest of my old database to the new one with export and import method.i2Paq wrote:So you use an old database?
We have do something wrong? We need to understand if i have to import the rest of my old database or only some tables and if yes what tables is necessary to export from old one DB?
Load those sql-files to new version.
ok i have to export only the product to do my job? I need to transfer products (with prices) categories, images and Manufacturer. i have all of that with products table? if not what tables i have to select?pm-netti wrote:You can open in PhpMyadmin e.g. table "product" and click "Export". Same can be other tables, the need to transfer.coant wrote:i import the rest of my old database to the new one with export and import method.i2Paq wrote:So you use an old database?
We have do something wrong? We need to understand if i have to import the rest of my old database or only some tables and if yes what tables is necessary to export from old one DB?
Load those sql-files to new version.
i have that error now
Code: Select all
Notice: Error: Table 'DB2015sE.category_path' doesn't exist
Error No: 1146
SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR ' > ') AS name, c.parent_id, c.sort_order FROM category_path cp LEFT JOIN category c ON (cp.path_id = c.category_id) LEFT JOIN category_description cd1 ON (c.category_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) WHERE cd1.language_id = '1' AND cd2.language_id = '1' GROUP BY cp.category_id ORDER BY name LIMIT 0,20 in /var/www/vhosts/myside.gr/httpdocs/myside/main/system/database/mysql.php on line 50
So are you moving products to that old store? It does not category_path board. If you move the products new version to the old store, you must first upgrade the old trade to a newer version.coant wrote: ok i have to export only the product to do my job? I need to transfer products (with prices) categories, images and Manufacturer. i have all of that with products table? if not what tables i have to select?
i have that error nowCode: Select all
Notice: Error: Table 'DB2015sE.category_path' doesn't exist Error No: 1146 SELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR ' > ') AS name, c.parent_id, c.sort_order FROM category_path cp LEFT JOIN category c ON (cp.path_id = c.category_id) LEFT JOIN category_description cd1 ON (c.category_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) WHERE cd1.language_id = '1' AND cd2.language_id = '1' GROUP BY cp.category_id ORDER BY name LIMIT 0,20 in /var/www/vhosts/myside.gr/httpdocs/myside/main/system/database/mysql.php on line 50
Who is online
Users browsing this forum: No registered users and 11 guests