Hi.

I have a Joomla 1.5.3 site running with CB1.1 and 500+ users.

I have made a fresh install of Joomla 1.5.4 running with CB1.2.

I would like to import the users, and if possible all the other fields and things to the new installation..

I tried using JUICE and get the following error:

[code:1]
SQL error in comprofilerDB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usertype FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)' at line 1 SQL=SELECT ,usertype FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)
SQL =

SELECT ,usertype FROM jos_users u LEFT JOIN jos_comprofiler c on (u.id=c.user_id)
[/code:1]

Questions:

1) Can I just export all CB tables and the com_user table to the new installation? (Tried it, works but shows none of the users in the User Manager or in CB User Manager)

2) How else can I do this? Is there a better way?

Any help will be much appreciated.

Chris

Post edited by: chriscapetown, at: 2008/07/10 16:25

anyone ? ;\ still puzzling with none of my tried methods working..

Ok, made some progress, but getting this error after copying all the jos_core_acl_* and the com_comprofiler_* and com_users tables.

What do I have to do exactly?

[code:1]
Warning: 62 entries in the users table without corresponding core_acl_aro table rows.

user id: 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 670, 671, 672, 673, 674, 675 are missing in core_acl_aro table

This one can be fixed in SQL using a tool like phpMyAdmin.

Warning: 1 entries in the core_acl_aro table without corresponding users table rows.

Following entries of core_acl_aro table are missing in users table: user id=540 (aro_id=488).

This one can be fixed in SQL using a tool like phpMyAdmin.
[/code:1]