Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
After February 6, this site will no longer have Facebook, Twitter, or OpenID sign-in options. Read our announcement about social media SSO support in 2.8 for more info.

Make sure you have a current, valid email address set in your profile and set a password so you can login without it. If you get locked out after that time, you can choose "Forgot Password" to fix it as long as a valid email is on your account.

Users missing after import

Hi,

I have managed to finish import, after restarting import process once. It finishes, but all my users are in GDN_zUser table, and not in GDN_User. Same with GDN_zUserRole table.

So I need to transfer users and their roles from 'z' prefixed tables. Is this something I can do manually?

Comments

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    Since importing a new user table would overwrite the existing one, you should be able to delete GDN_User and GDN_UserMeta and rename GDN_zUser and GDN_zUserMeta

    Always do a backup before changing your database.

    From which forum script were you exporting?

    dbradvic
  • I am importing file exported from fuse forum.
    I don't think zUser table has all fields User table has, but I will confirm that.
    However, if I copy data, it shold be good. That is all I needed, thank you very much! :)

  • Yep, fields like title, location, about, preferences, permssions, atributes and many more are missing. Would it be ok to leave fields lik preferences, permssions, atributes empty?

    CREATE TABLE GDN_zUser ( UserID int(11) DEFAULT NULL, Name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, Email varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, Password varbinary(100) DEFAULT NULL, HashMethod varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, Photo varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, DateInserted datetime DEFAULT NULL, DateLastActive datetime DEFAULT NULL, Confirmed tinyint(4) DEFAULT NULL, Admin tinyint(4) DEFAULT NULL, Banned tinyint(4) DEFAULT NULL, _NewID int(11) DEFAULT NULL, _Action enum('Insert','Update') COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE TABLE `GDN_User` ( `UserID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `Password` varbinary(100) NOT NULL, `HashMethod` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `About` text COLLATE utf8mb4_unicode_ci, `Email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `ShowEmail` tinyint(4) NOT NULL DEFAULT '0', `Gender` enum('u','m','f') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'u', `CountVisits` int(11) NOT NULL DEFAULT '0', `CountInvitations` int(11) NOT NULL DEFAULT '0', `CountNotifications` int(11) DEFAULT NULL, `InviteUserID` int(11) DEFAULT NULL, `DiscoveryText` text COLLATE utf8mb4_unicode_ci, `Preferences` text COLLATE utf8mb4_unicode_ci, `Permissions` text COLLATE utf8mb4_unicode_ci, `Attributes` text COLLATE utf8mb4_unicode_ci, `DateSetInvitations` datetime DEFAULT NULL, `DateOfBirth` datetime DEFAULT NULL, `DateFirstVisit` datetime DEFAULT NULL, `DateLastActive` datetime DEFAULT NULL, `LastIPAddress` varbinary(16) DEFAULT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varbinary(16) DEFAULT NULL, `DateUpdated` datetime DEFAULT NULL, `UpdateIPAddress` varbinary(16) DEFAULT NULL, `HourOffset` int(11) NOT NULL DEFAULT '0', `Score` float DEFAULT NULL, `Admin` tinyint(4) NOT NULL DEFAULT '0', `Confirmed` tinyint(4) NOT NULL DEFAULT '1', `Verified` tinyint(4) NOT NULL DEFAULT '0', `Banned` tinyint(4) NOT NULL DEFAULT '0', `Deleted` tinyint(4) NOT NULL DEFAULT '0', `Points` int(11) NOT NULL DEFAULT '0', `CountUnreadConversations` int(11) DEFAULT NULL, `CountDiscussions` int(11) DEFAULT NULL, `CountUnreadDiscussions` int(11) DEFAULT NULL, `CountComments` int(11) DEFAULT NULL, `CountDrafts` int(11) DEFAULT NULL, `CountBookmarks` int(11) DEFAULT NULL, PRIMARY KEY (`UserID`), KEY `FK_User_Name` (`Name`), KEY `IX_User_Email` (`Email`), KEY `IX_User_DateLastActive` (`DateLastActive`), KEY `IX_User_DateInserted` (`DateInserted`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    Visit yourforum.com/utility/structure
    That should repair the incomplete table

  • Hmmm I don't have "utility" folder.

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    You don't have a /categories or /discussions folder either :wink:

    Try yourforum.com/index.php?p=/utility/structure in your browser

    dbradvic
Sign In or Register to comment.