Can someone give me some info

[lasto]

on how i might go about this ....

i want to redo me board so want to take all the members over to a new install but i have hacks that have added themselfs to the database such as the store hack etc.

I want to know how i can just take the users (login and password only) and not take any more fields along with it which are un-nessecary as new install wont have the hacks installed.

now if i was to take the table called User and add that to new install would that work or do i need to take more

Now ive just checked me User table and i see fields such as Karma/new/karma new etc all part of karma hack which i dont need.

Someone tell me exactly what i need to do and what to get rid off.

Tried a few times today but it messed up on me.

Thanks in advance

[lasto]

ok ive suzzed out how to drop the extra tables in the table USER

me new board now shows xx amount of members but going to member list only shows one which is me.

So doing search for all members in admin cp only shows 1 as well

Yet when im looking though the user table in phpmyadmin i see all the members info there in the table USER so what am i missing and why has`nt their info been written to the board.

Really need help on this ........

[lasto]

lot harder than i thought - beginning to think cant swap bits from one database to another

never got errors on the board but when i checked me email this morning i got these :

Invalid SQL: UPDATE user SET lastactivity=1061523189,inforum='0' WHERE userid='1'
mysql error: Unknown column 'inforum' in 'field list'
mysql error number: 1054

Another email

Invalid SQL: SELECT vote, threadrateid FROM threadrate
WHERE userid = AND threadid = '47'
mysql error: You have an error in your SQL syntax near 'AND threadid = '47'' at line 2
mysql error number: 1064

Another email

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064

Taking the user table aint enough on its own is it ?

Obviously ive gotta take soemthing else that im missing or should i just give up on this.

[lasto]

ok i got all members over and its working fine

just cant change anyone in admin cause of this error

so how do i fix it and thats it PLZ

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE userfield SET userid=30,field1='',field2='',field3='none' WHERE userid=30
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

[NTLDR]

You need to re-create the profile fields I suspect. When copying users you need to copy the user and userfield tables.

[lasto]

cheers NTLDR appreciate help all done and working

the fields where different though so i renamed 2 fields and errors in admin cp have gone

members are there now so im happy

[high]* lasto thinks this can be closed now[/high]

[lasto]

am having problems with my database at moment as its what u call corrupt

so for me to take members is this all the tables i need to take :

User and userfields only as ive just done this but am getting a sql error when editing members because the usertable must have excess fields that a fresh install would`nt need.

Would i have to drop these first inside the user table ?

[lasto]

am redoing this thread as need help

am after exactly the same thing but as im on 3.0.7 will it still work by moving the members to a fresh board and is this correct :

the tables i need to grab are : user/userfield and Users.

Another thing with existing hack already isntalled what happens to the tables say USER which has other tables added in it for the bank etc will i need to drop these or will it be ok to grab them inside the usertable.

I done this local and the users where there in the admincp but total members for the board was set at 1 - unsure why this is.