1
madcapjv
Migrate users from 2.0.13 to 2.2??
  • 2005/7/29 11:57

  • madcapjv

  • Just popping in

  • Posts: 33

  • Since: 2004/11/28


I'd like to migrate my users list from 2.0.13, can i do a direct dump of my old users tables into my new install with success?

2
Gambero[removed]
Re: Migrate users from 2.0.13 to 2.2??

Why to make fresh install ? You can easily upgrade from 2.0.13 to 2.2.

But, if you really want I think you can make it like this:

- export your 2.0.13 database
- make a fresh install of 2.2
- import 2.0.13 database
- run xoopsupdate.php
- reinstall system module

I think this should work but I am not sure ... Off course make a backup!

3
madcapjv
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/29 14:01

  • madcapjv

  • Just popping in

  • Posts: 33

  • Since: 2004/11/28


when re-installing system module, I get the following errors...

Adding user profile fields...
  
ERRORCould not insert field umode into the databaseDuplicate column name 'umode'
  
ERRORCould not insert field uorder into the databaseDuplicate column name 'uorder'
  
ERRORCould not insert field notify_method into the databaseDuplicate column name 'notify_method'
  
ERRORCould not insert field notify_mode into the databaseDuplicate column name 'notify_mode'
  
ERRORCould not insert field user_regdate into the databaseDuplicate column name 'user_regdate'
  
ERRORCould not insert field posts into the databaseDuplicate column name 'posts'
  
ERRORCould not insert field attachsig into the databaseDuplicate column name 'attachsig'
  
ERRORCould not insert field timezone_offset into the databaseDuplicate column name 'timezone_offset'
  
ERRORCould not insert field user_mailok into the databaseDuplicate column name 'user_mailok'
  
ERRORCould not insert field theme into the databaseDuplicate column name 'theme'
  
ERRORCould not insert field actkey into the databaseDuplicate column name 'actkey'
  
ERRORCould not insert field last_login into the databaseDuplicate column name 'last_login'

4
madcapjv
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/29 23:52

  • madcapjv

  • Just popping in

  • Posts: 33

  • Since: 2004/11/28


well, got the users imported, and logins now work, although, users aren't showing up under the admin user search tool...and after updating the system module, I still notice this

Adding user profile fields...
  
NOTICEumode exists skipped
  NOTICE
uorder exists skipped
  NOTICE
notify_method exists skipped
  NOTICE
notify_mode exists skipped
  NOTICE
user_regdate exists skipped
  NOTICE
posts exists skipped
  NOTICE
attachsig exists skipped
  NOTICE
timezone_offset exists skipped
  NOTICE
user_mailok exists skipped
  NOTICE
theme exists skipped
  NOTICE
actkey exists skipped
  NOTICE
last_login exists skipped


Any useful input is appreciated.

tia

5
Kapeket
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/30 2:42

  • Kapeket

  • Just popping in

  • Posts: 3

  • Since: 2005/5/3 3


Import database.

In phpMyadmin, I do not see this function. I was going to manually do this but hey, its time to use the tools we are blessed with.

So, how exactly do I "import" the original database into the present one?

Thanks guys. =)

6
isignal
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/30 3:19

  • isignal

  • Just popping in

  • Posts: 1

  • Since: 2004/3/22


how to solute this problem?

i just update all file from 2.2
and then run xoopsupdate.php

but fail at ..

xoops_module_pre_update_system executed successfully.
Module data inserted successfully. Module ID: 1
Updating templates...
ERROR: Could not insert template system_imagemanager.html to the database.
ERROR: Could not insert template system_imagemanager2.html to the database.
ERROR: Could not insert template system_userinfo.html to the database.
ERROR: Could not insert template system_userform.html to the database.
ERROR: Could not insert template system_rss.html to the database.
ERROR: Could not insert template system_redirect.html to the database.
ERROR: Could not insert template system_comment.html to the database.
ERROR: Could not insert template system_comments_flat.html to the database.
ERROR: Could not insert template system_comments_thread.html to the database.
ERROR: Could not insert template system_comments_nest.html to the database.
ERROR: Could not insert template system_siteclosed.html to the database.
ERROR: Could not insert template system_dummy.html to the database.
ERROR: Could not insert template system_notification_list.html to the database.
ERROR: Could not insert template system_notification_select.html to the database.
ERROR: Could not insert template system_error.html to the database.
ERROR: Could not insert template system_plain.html to the database.
ERROR: Could not insert template system_admin_block.html to the database.
Building blocks...
Updating existing block
Block User Menu inserted. Block ID: 1
ERROR: Could not insert template system_block_user.html.
Updating existing block
Block Login inserted. Block ID: 2
ERROR: Could not insert template system_block_login.html.
Updating existing block
Block Search inserted. Block ID: 3
ERROR: Could not insert template system_block_search.html.
Updating existing block
Block Waiting Contents inserted. Block ID: 4
ERROR: Could not insert template system_block_waiting.html.
Updating existing block
Block Main Menu inserted. Block ID: 5
ERROR: Could not insert template system_block_mainmenu.html.
Updating existing block
Block Who's Online inserted. Block ID: 7
ERROR: Could not insert template system_block_online.html.
Updating existing block
Block Top Posters inserted. Block ID: 8
ERROR: Could not insert template system_block_topusers.html.
Updating existing block
Block New Members inserted. Block ID: 9
ERROR: Could not insert template system_block_newusers.html.
Updating existing block
Block Recent Comments inserted. Block ID: 10
ERROR: Could not insert template system_block_comments.html.
Updating existing block
Block Notification Options inserted. Block ID: 11
ERROR: Could not insert template system_block_notification.html.
Updating existing block
Block Themes inserted. Block ID: 12
ERROR: Could not insert template system_block_themes.html.
Updating existing block
Block Custom Block inserted. Block ID: 49
ERROR: Could not insert template system_block_dummy.html.

7
Dave_L
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/30 3:22

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


To import a database with phpMyAdmin, select the SQL tab at the top, and then select the Browse... button.

You may need to drop all the tables first, depending on whether the .sql file you're importing contains DROP TABLE queries.

But as noted above, you're going to run into problems importing users from 2.0.x to 2.2, since there are various tables that have to be modified.

8
Kapeket
Re: Migrate users from 2.0.13 to 2.2??
  • 2005/7/30 4:09

  • Kapeket

  • Just popping in

  • Posts: 3

  • Since: 2005/5/3 3


Perhaps I should elaborate on what I did.

When I moved the site and database, I got some errors regarding newbb.

The reason was for whatever reason, the modules directory did not completely download. I lost newbb and all modules for the site from n to a.

Very odd but true.

In any case, what would you suggest is the best option for such a newb activity as not backing stuff up right? I am still shrugging about that.

Version we were using was 2.0xx

And thanks for such a quick reply from you guys.

Login

Who's Online

195 user(s) are online (119 user(s) are browsing Support Forums)


Members: 0


Guests: 195


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits