Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 11-08-2013, 03:14 PM
kamran_dotnet kamran_dotnet is offline
 
Join Date: Apr 2012
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default how can i fix my database?

hi friends
i just import users to new forum without using impex,
just by using PHPmyadmin and copy user table to new database
i just copy from id number "2"
but now none of users can be search with vbulletin
only user 1 (administrator) that created with vbulletin installation can be found by search
there is no other problem in forum.all users can register and work with forum but other imported users cant search
so some plugins hacks wont work in my forum.
like GxboxLive
its only find user id "1"
whats should i do?
how can i fix my database?

its already late for fresh install.my forum running long time ago and i cant loos my data
Reply With Quote
  #2  
Old 11-08-2013, 06:18 PM
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Location: USA
Posts: 10,929
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is alot more than just the user table to deal with members. Why would you import them anyway?
Reply With Quote
  #3  
Old 11-08-2013, 06:20 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The reason to use Impex is to get all the prefixes right, and so on. It's a step by step automated process which you SHOULD use when importing a SQL to vBulletin.

Try it again with Impex and experience success.
Reply With Quote
  #4  
Old 11-11-2013, 04:04 AM
kamran_dotnet kamran_dotnet is offline
 
Join Date: Apr 2012
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ozzy47 View Post
There is alot more than just the user table to deal with members. Why would you import them anyway?
becouse i want to use members of my another website to use my new website.but i want only users.i forgot to use implex and now i stuck

Quote:
Originally Posted by Max Taxable View Post
The reason to use Impex is to get all the prefixes right, and so on. It's a step by step automated process which you SHOULD use when importing a SQL to vBulletin.

Try it again with Impex and experience success.
but my new forum has many new topics and threads.there is no problem to import new users?
Reply With Quote
  #5  
Old 11-11-2013, 10:29 AM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kamran_dotnet View Post
becouse i want to use members of my another website to use my new website.but i want only users.i forgot to use implex and now i stuck


but my new forum has many new topics and threads.there is no problem to import new users?
Why would there be?
Reply With Quote
  #6  
Old 11-11-2013, 04:17 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You cannot just take a user table from one database and add it to another. User data is in about three or four different tables and so you would need to make sure to take all that data. (Not to mention that all post counts would be totally incorrect since those users won't have any posts.)
Reply With Quote
  #7  
Old 11-11-2013, 06:11 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^^^ Which is why you must run Impex for imports.
Reply With Quote
  #8  
Old 11-14-2013, 10:57 AM
kamran_dotnet kamran_dotnet is offline
 
Join Date: Apr 2012
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well i think its too late
can anyone tell those four tables?
Reply With Quote
Reply

Thread Tools
Display Modes

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 01:47 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04157 seconds
  • Memory Usage 2,224KB
  • Queries Executed 13 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete