thousand moderators in 1 form??? UBB Import

[evoir]

Just migrated from UBB 5.47 to VB 1.15 HELP!

Ok, it seemed to go soothly, but I have a mess on my hands.

One of my forums now has a HUGE amount of moderators listed. I can't imaging deleting them individually. literally, thousands.
http://www.curvemag.com/forum/

and no posts are listed :(

any help is greatly appreciated. Would be happy to just empty tables in VB and try again, on an empty DB.

[Martin]

all I see is one forum (moderators corner) with Evie listed as mod.

[evoir]

Well, I tried re-importing (supposedly clearing data) and this is what happened.

But allt he forums ARE there, in the control panel.

Is it possible someone could help me directly? (ie fix it in CP?) Would ask for a VB moderator or admin.

It also somehow corrupted my UBB. In a very strange way. am trying to fix that now too :)

still excited about the upgrade, though ;)

[evoir]

Ok, I guess it was stressful on my UBB but after going through all those old admin steps, we are back in UBB business.

Now, we want to be in VB business!

[Martin]

as it only reads tyhe files from UBB I don't see how it could have corrupted them...

did you have forums set up as private forums in UBB? You might need to go into the CP and open them to the public.

[evoir]

the only one that was private was the moderators corner! lol

[evoir]

try looking here (http://www.curvemag.com/forum/forumdisplay.php?forumid=12)

[Martin]

holy crap!

that's a new one on me!

the best way to get rid of it is to run a mysql line command deleted all your mods and reassigning them properly in the vB CP.

[evoir]

how would one do that?

I am confused.

[evoir]

oh, and I am importing from a clean version of UBB 5.47 btw. Just a few html changes here and there.

[evoir]

sorry, one more thought.

Can someone tell me how to empty the DB completely? (members and topics and posts.)

I have double posts and topics of everything. <pulling hair>

[chrispadfield]

the first thing to do is install phpmyadmin, can't remember url do a search here for it or in google.com to find it. That will help you empty the database and control stuff by hand much easier.

[Martin]

http://www.phpwizard.net

that's where to get phpMyAdmin.

it's an extremely useful tool, just make sure to .htaccess the folder you install it in. :)

telent or ssh into your server, go to root, open mysql into the forum db, and run a query something like:

DELETE * FROM usergroup WHERE usertitle = Moderator


now, i'm very tired from working on my database all night, so please let someone else confirm this query before you try it:)

[evoir]

ok. I installed phpmyadmin (and password protected the directory)

I go to the DB in question, and I see these tables. I don't see one ofr moderators.


announcement
bbcode
category 2
forum
forumpermission 67
icon 14
post 41280
replacement 17
session 1
smilie 11
template 162
thread 3604
user 2799
usergroup 33
usertitle 3

do I simply delete all of those to empty all of the db?

[Martin]

if you want to start over, doing a clean import, select the database name on the left and do a "drop database".

it will clear ALL the info out of the database, leaving it empty. Then you can reimport the data from your UBB.

1 question, though. You *are* shutting down your UBB while doing the import, right?

[evoir]

right. I am shutting down.

Ok, I emptied all the tables while I was imaptient :) and now I cannot log in, even after using getadmin.php :(

If I drop table, do I have to re-install?

[Martin]

yes, you have to reinstall...

sorry, long night last night, I should have told you that

[evoir]

Ok. I deleted db and re-installed. lost all the template work though :(

Is there a way tp save them as a batch once I get them right?