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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19424
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


Last change: 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


Last change: 12.10.2013 10:08
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.