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 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.