Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2010, 08:31 AM
ctvtec ctvtec is offline
 
Join Date: Feb 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help Asap!!!!

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
Reply With Quote
  #2  
Old 11-25-2010, 01:59 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #3  
Old 11-25-2010, 04:28 PM
ctvtec ctvtec is offline
 
Join Date: Feb 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 [DATE]1290709814[/DATE] at [TIME]1290709814[/TIME] ---------------

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.
Reply With Quote
  #4  
Old 11-25-2010, 04:58 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 11-25-2010, 05:00 PM
ctvtec ctvtec is offline
 
Join Date: Feb 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 11-25-2010, 05:10 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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).
Reply With Quote
  #7  
Old 11-25-2010, 05:18 PM
vbenhancer's Avatar
vbenhancer vbenhancer is offline
 
Join Date: Dec 2009
Location: Qu?bec city, Canada
Posts: 740
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 11-25-2010, 06:04 PM
ctvtec ctvtec is offline
 
Join Date: Feb 2008
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

So what other tables should i copy over??

--------------- Added [DATE]1290715647[/DATE] at [TIME]1290715647[/TIME] ---------------

I tried the upgrade, that didnt work

what else you think i should try
Reply With Quote
  #9  
Old 11-26-2010, 03:06 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #10  
Old 11-26-2010, 08:49 AM
biocyberman biocyberman is offline
 
Join Date: May 2007
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
  1. 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.
  2. 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
  3. 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:
  1. Backup nyvtec.com files and database.
  2. Remove nyvtec.com live files and database
  3. Copy everything from ctvtec.com to nyvtec.com to make it work as a duplicate.
  4. Remove articles, photos and posts of nyvtec.com from its admincp
  5. Update/Upgrade nyvtec.com to newer version if you want.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:01 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05122 seconds
  • Memory Usage 2,250KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete