Users running a non-download version of Vanilla (pulled from github), on branch release/2019.016 or master from the last 2 weeks should upgrade to release/2019.017 or latest master for security reasons. Downloaded official open sources releases are not affected.
Please upgrade here. These earlier versions are no longer being updated and have security issues.

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

  • Vanilla v2.6.4

  • 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 TABLEGDN_zUser(UserIDint(11) DEFAULT NULL,Namevarchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,Emailvarchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,Passwordvarbinary(100) DEFAULT NULL,HashMethodvarchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,Photovarchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,DateInserteddatetime DEFAULT NULL,DateLastActivedatetime DEFAULT NULL,Confirmedtinyint(4) DEFAULT NULL,Admintinyint(4) DEFAULT NULL,Bannedtinyint(4) DEFAULT NULL,_NewIDint(11) DEFAULT NULL,_Actionenum('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.