Announcement

Collapse
No announcement yet.

Moving user table to new forum

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    The tables are from 2.2.9 and need to be updated to 2.3.2. The easiest way to do this would be to update the 2.2.9 database first.

    Leave a comment:


  • Nam
    replied
    But all I wanted to do was to transfer user table and nothing else. But the 2.3.2 is a fresh install, there is nothing to upgrade from.

    You mean I have to update the old 2.2.9 to 2.3.2 first, and then move all those user table to the new 2.3.2 board?

    Leave a comment:


  • Steve Machol
    replied
    You can't use a 2.2.9 db with 2.3.2 files. You need to update the database to the latest version by running the appropriate upgrade scripts.

    Leave a comment:


  • Nam
    replied
    I got another problem, I can't register at the newboard. This is the error I got:

    Database error in vBulletin 2.3.2:

    Invalid SQL:
    INSERT INTO useractivation
    (useractivationid, userid, dateline, activationid, type, usergroupid)
    VALUES
    (NULL, 2944, 1066500309, '91405271', 0, 2)

    mysql error: Unknown column 'usergroupid' in 'field list'

    mysql error number: 1054

    Date: Saturday 18th of October 2003 12:05:09 PM
    Script:
    http://www.mysite.com/forum/forum/register.php
    Referer: http://www.mysite.com/forum/register.php

    It seems that there is wrong path in the script, which suppose to be only one forum/register.php.

    What I did was moving user.sql, usergroup.sql, useractivation.sql and userfield from old 2.2.9 to the new 2.3.2, everything is working for current members except that the new member get the error above. Please help?

    Leave a comment:


  • Nam
    replied
    Darn, worked like a charm, thanks Steve.

    I didn't forget though, I didn't want to transfer them because there are fields that I don't want to use anymore. But I should have move it exactly the way it was before remove any unwanted field.

    [Edit]One more questin Steve, what would happen if I move only User table and not any other table? Being not able to list users like I had before, would it lead to not be able to change the permission of the users too?[/edit]

    Thanks again,
    Last edited by Nam; Fri 17 Oct '03, 9:33am.

    Leave a comment:


  • Steve Machol
    replied
    You forgot the userfield table.

    Leave a comment:


  • Nam
    started a topic Moving user table to new forum

    Moving user table to new forum

    Okay, here is the simple problem but I can't find an answer:

    1. I download user.sql, usergroup.sql and useractivation.sql from old forum
    2. I install the new fresh forums, then dropped the table user, usergroup and useractivation.
    3. I run the files *.sql in phpmyAdmin, those files are from 1.

    Result: The new board has all the users the same as old board. Which is good.
    Problem: In new board, I can't move the user from one group to another. I clicked [list all users] on the right side of the Registered group, which has 1914 users, but it says No users found matching those criteria.

    I did the same thing on the old board, it list all the users.

    What did I do wrong? I double check everything, the usergroup ids are the same, all the sub-table under users are the same. Why I can't list the users in the new forum?

    Please help, I'm really appreciate it.
Loading...
Working...
X