Users missing after import

dbradvic

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?

dbradvic

Vanilla v2.6.4

R_J

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!

dbradvic

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_J

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

dbradvic

Hmmm I don't have "utility" folder.

R_J

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

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