Help Asap!!!!

[ctvtec]

Ok heres what i did.

I own ctvtec.com & nyvtec.com
I copied all the memebrs from ctvtec.com to nyvtec.com and people are able to login.
But now, when people sign up on nyvtec.com, they are not able to login agian.

What did i do wrong does anyone know???

Help me out a.s.ap

[Lynne]

You copied them how? (There is no method to just copy members.) We need more details on what you did in order to figure out what it going on Also, what version are you running? What version was the old site running?

[ctvtec]

what i did was went into the database, copied 'user' table from one site to the other, structure and data, i did the same with userfield, user group

Also ctvtec.com is running on 3.8.1 and nyvtec.com is on 3.8.6? ( the latest version of 3.8)

--------------- Added 1290709814 at 1290709814 ---------------

Also another issue that i have is, its showing that users have 90% inbox left or something, saying they have x amount of messages in the inbox, i think the same amount that is shown on ctvtec.

[Lynne]

The salt field in the user table changed between those two versions (it is used for login in) which is probably why you are having problems. Did you run the upgrade script *after* copying over those tables? You will need to do that.

[ctvtec]

wait? where do i run the upgrade scirpt? how do i do that?
Im not really too familiar with these things please help me out lol

on which site do i run it also

[Lynne]

Honestly, if you aren't familiar with vbulletin and databases and such, you really should not have done what you did.

You took 3.8.1 tables and put them into a 3.8.6 database. That doesn't work. You can't do that without altering those 3.8.1 tables to then be 3.8.6 tables. You would do this by running the install/upgrade.php script (on the 3.8.6 database to make those 3.8.1 tables upgraded). Hopefully that will work. If not, you will have to go in and manually upgrade those tables to be 3.8.6 database tables (take a look in the install/mysql-schema.php file and compare the fields in those tables and make any changes).

[vbenhancer]

actually, Lynne, even with the upgrade, the process is uncomplete. the process to add users is not complete only with the users table, it also have to be with the custom fields, the forum stats and some other details. the users authentication is done between 3 to 4 tables in the database, depending on the version you use.

next time, ask a pro first.

[ctvtec]

I should have lol, i was rushing, and when you rush this is what happens..

So what other tables should i copy over??

--------------- Added 1290715647 at 1290715647 ---------------

I tried the upgrade, that didnt work

what else you think i should try

[Lynne]

I really don't know what to suggest since I really don't fully understand exactly what you did or what you were trying to accomplish by doing what you did. There are several user tables (user, userfield, usertextfield, usertitle) and then many other tables that have little bits of user information in them. There are counters that may need to be rebuilt. There are fields in the table that need to be upgraded to 3.8.6. If you could, I'd revert to a backup database and hire someone to do whatever it is you need done.

[biocyberman]

Lynne, I think what he is trying to do from beginning is:
Take members (usernames, password, names, etc) from ctvtec.com and put them on nyvtec.com so that those members don't need to register on nyvtec.com . One challenge is that ctvtec.com already has its own data, users, etc, so "site cloning" is not a choice.

@ctvtec: The way you did is very error prone. I hope you have your backup for nyvtec.com . My suggestion is that:


You do some experiment on a test forum, which can be put in a folder, for example, nyvtec.com/test and do all testing stuffs there before you do real things to nyvtec.com.

If you do not have a backup for nyvtec.com (please recognize this is a very bad practice), you can also clone current modified nyvtec.com into something say, nyvtec.com/backup and try 'clean up' nyvtec.com/backup by removing users that you added from ctvtec.com

Before doing any 'JOINING' of these two sites that you intend to do, a safe move would be make sure the two sites have the same setup (vbulletin versions, addons, custom fields).


Hope this help.
Biocyberman.

Update:

Well I took a look at your two sites. Looks like you actually want to clone ctvtec.com into nyvtec.com where existing data of nyvtec.com is not important. If that is true, I would like to suggest that:

Backup nyvtec.com files and database.
Remove nyvtec.com live files and database
Copy everything from ctvtec.com to nyvtec.com to make it work as a duplicate.
Remove articles, photos and posts of nyvtec.com from its admincp
Update/Upgrade nyvtec.com to newer version if you want.

[ctvtec]

The last part you said seems like the thing i must really do right now.


Lynne, I think what he is trying to do from beginning is:
Take members (usernames, password, names, etc) from ctvtec.com and put them on nyvtec.com so that those members don't need to register on nyvtec.com . One challenge is that ctvtec.com already has its own data, users, etc, so "site cloning" is not a choice.

@ctvtec: The way you did is very error prone. I hope you have your backup for nyvtec.com . My suggestion is that:


You do some experiment on a test forum, which can be put in a folder, for example, nyvtec.com/test and do all testing stuffs there before you do real things to nyvtec.com.

If you do not have a backup for nyvtec.com (please recognize this is a very bad practice), you can also clone current modified nyvtec.com into something say, nyvtec.com/backup and try 'clean up' nyvtec.com/backup by removing users that you added from ctvtec.com

Before doing any 'JOINING' of these two sites that you intend to do, a safe move would be make sure the two sites have the same setup (vbulletin versions, addons, custom fields).


Hope this help.
Biocyberman.

Update:

Well I took a look at your two sites. Looks like you actually want to clone ctvtec.com into nyvtec.com where existing data of nyvtec.com is not important. If that is true, I would like to suggest that:

Backup nyvtec.com files and database.
Remove nyvtec.com live files and database
Copy everything from ctvtec.com to nyvtec.com to make it work as a duplicate.
Remove articles, photos and posts of nyvtec.com from its admincp
Update/Upgrade nyvtec.com to newer version if you want.

[ctvtec]

Does anyone else think there is any easier way of doing all this?
Another problem i have now is when members register, it brings them to a database error page

--------------- Added 1290938758 at 1290938758 ---------------

What if i upgrade my ctvtec.com to the version 3.8.6

Will i be able to do what i did to the database and have everything work? or will everything just still be the same???

If doing that will make it work, how do i upgrade the site