UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support EMERGENCY! Help!

JoshPet - I did like you said and nuked everything but left the "DONOTDELETE" user inplace. Then I did the import again and all seemed to go well. However, now when I try to create a new forum - where it asks what permissions for what groups you want to assign, all I get is a grey box with the text in it, but no way to set anything. Is there supposed to be any other tables that should not have been nuked? For example, my Language table is blank now - should it have some data it it? If so, can you etll me what goes in each field (there are only a few fields and I can us PhPMyAdmin to add the info). Any other tables I should not have nuked?

Basil

Well actually I thought you were just going to remove the user's and the posts - there are a few other tables that need data. Like the groups and languages etc... Sorry I didn't clarify which tables not to touch. I was speaking only of the Users table in the other thread. Leaving user#1 there.

This will put the default groups back:

INSERT INTO `w3t_Groups` VALUES ('Administrators', 1, 0);
INSERT INTO `w3t_Groups` VALUES ('Moderators', 2, 0);
INSERT INTO `w3t_Groups` VALUES ('Users', 3, 0);
INSERT INTO `w3t_Groups` VALUES ('Guests', 4, 0);

If your graemlins table is empty - do this:
INSERT INTO `w3t_Graemlins` VALUES (1, '$ubbt_lang[\'ICON_OOO\']', '', 'ooo.gif');
INSERT INTO `w3t_Graemlins` VALUES (2, '$ubbt_lang[\'ICON_MAD\']', '', 'mad.gif');
INSERT INTO `w3t_Graemlins` VALUES (3, '$ubbt_lang[\'ICON_COOL\']', '', 'cool.gif');
INSERT INTO `w3t_Graemlins` VALUES (4, '$ubbt_lang[\'ICON_SMILE\']', ':)', 'smile.gif');
INSERT INTO `w3t_Graemlins` VALUES (5, '$ubbt_lang[\'ICON_FROWN\']', ':(', 'frown.gif');
INSERT INTO `w3t_Graemlins` VALUES (6, '$ubbt_lang[\'ICON_BLUSH\']', ':o', 'blush.gif');
INSERT INTO `w3t_Graemlins` VALUES (7, '$ubbt_lang[\'ICON_CRAZY\']', '', 'crazy.gif');
INSERT INTO `w3t_Graemlins` VALUES (8, '$ubbt_lang[\'ICON_LAUGH\']', ':D', 'laugh.gif');
INSERT INTO `w3t_Graemlins` VALUES (9, '$ubbt_lang[\'ICON_SHOCKED\']', '', 'shocked.gif');
INSERT INTO `w3t_Graemlins` VALUES (10, '$ubbt_lang[\'ICON_SMIRK\']', '', 'smirk.gif');
INSERT INTO `w3t_Graemlins` VALUES (11, '$ubbt_lang[\'ICON_CONFUSED\']', '', 'confused.gif');
INSERT INTO `w3t_Graemlins` VALUES (12, '$ubbt_lang[\'ICON_GRIN\']', '', 'grin.gif');
INSERT INTO `w3t_Graemlins` VALUES (13, '$ubbt_lang[\'ICON_WINK\']', ';)', 'wink.gif');
INSERT INTO `w3t_Graemlins` VALUES (14, '$ubbt_lang[\'ICON_TONGUE\']', ':p', 'tongue.gif');


If the langauges table is empty:
INSERT INTO `w3t_Languages` VALUES (1, 'english', 'English', 1);

You can add more langauges later from the admin panel, but you must have at least 1.

If the w3t_Cache table is empty, run this:

INSERT INTO w3t_Cache (C_Users) VALUES ('0');


If the version table is empty - run this
INSERT INTO `w3t_Version` VALUES ('6.4.2', NULL, NULL, NULL);


I think that should put the main issue (no groups/no languages) back on track. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Well, not a big deal. I just droped the whole table, then reuploaded the install and config files and did the install from scratch, then did the import of Classic. All seems ok now. By the way, again, even though I did NOT create an admin (or any other user), when I imported Classic, my Admin user (#2 in Classic) became #4 in Threads. Wierd. I ran my little script and changed it back to #2 and it seems to be working now. Thanks,
Basil

Very odd - then if there were no users created, the fact that your classic user didn't become user#2 points to a problem with the importer.

I'll ask Charles to look at this thread. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Mmm. It looks like the importer actually doesn't create a user number 2...