Problem with SQL import

[stevesh]

You can't delete a post, but a description of how you solved the problem might help someone else.

[tragosina]

Right! Sorry :)

It was so easy as delete the second language product description line.

I had for example:

product id 319, lang id 2, xxxxxxxxx
product id 319, lang id 1, xxxxxxxx

I deleted the second line f every product ( as I´m using lang id 2) and then imported and now I can see my products perfectly :)


Also as a tip, yesterday I just copy pasted without doing/changing nothing on the language id number. So I was able to see on my home page and in admin that in the category x I had x number of products, but then if I clicked on the category I didn´t see nothing.
The problem was that on my old zen cart database I had only one language with id number 1. So now when I copy pasted I had to change that number 1 for each product line to number 2. And now I´m able to see them.