Jump to content

Copy produc info from one language id to another with SQL statement.


Smiles

Recommended Posts

In an earlier forum post (archive) I found this SQL:

INSERT INTO `ps_product_lang` SELECT `id_product`, 2015, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later` FROM `ps_product_lang` WHERE `id_lang` = 6;

 

I wanted to run this in my 1.6 installation but did get some errors.


/* SQL Error (1136): Column count doesn't match value count at row 1 */
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 0 of 1 query: 0.000 sec. */

 

Anyway, I would like to change it a bit and get it running on 1.6. I would like to add:

Products ID form to .... For example 2015 to 2020 (and 5 products will be updated)

Language to copy from  For example from Language ID 5 to Language ID 6

 

I am also running multistore in case this affects the query.  Someone any Idea how to achieve this?

 

 

Link to comment
Share on other sites

You can see that your sql editor is responding with an understandable error message which says that the columns of the insert statement does not match with the selection.

Is the 2015 an id lang or an id_shop value for ? This 2 columns are the ones missing on your statement based on the table standards... 

Try to write so all the columns which match the select statement .  

 

INSERT INTO `ps_product_lang`  

(id_product, id_lang, description, description_short, link_rewrite, meta_description, meta_keywords, meta_title, name, available_now 

, available_later)

SELECT `id_product`, 2015, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later` FROM `ps_product_lang` WHERE `id_lang` = 6;

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...