Copy Jshopping db tables

06.10.2013 20:33
#1
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Copy Jshopping db tables

Hello,

I am redesiging my site. I upgraded to the latest version on the old site, installed the latest version on the new site and did an export and that worked.

Now I need to import users and reviews using phpmyadmin but I constantly get these errors:
#1136 column count doesn't match value count at row 1 or 1062 - Duplicate entry '1' for key 'PRIMARY'.

Is there a way to fix this?

 
06.10.2013 20:36
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16509
Quote
Aw: Copy Jshopping db tables

delete old data or ...

 
06.10.2013 22:44
#3
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Aw: Copy Jshopping db tables

I deleted the data and the reviews were copied but the problem with users is still there:
#1136 column count doesn't match value count at row 1


Letzte Ă„nderung: 07.10.2013 00:02
 
12.10.2013 10:07
#4
mmleoni
Joomshopping forum user no avatar
Name: marco
02.10.2013
Posts: 7
Quote
Aw: Copy Jshopping db tables

are you talking about joomla or jshopping users?
you can't import joomla user with phpmyadmin, because #__users is used as foreign key in many joomla tables, (groups, contents, ...). jshopping user must match joomla users.

anyway "count doesn't match": database versions are NOT compatible!!
see http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/1/6355.html?lang=en

I hope it solves.

bye,
marco


Letzte Ă„nderung: 12.10.2013 10:08
 
Copyrights MAXXmarketing GmbH. All Rights Reserved