Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2010, 01:27 PM
cynthetiq's Avatar
cynthetiq cynthetiq is offline
 
Join Date: Jul 2005
Location: NYC
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Transferring 3.8.x users only to 4.1

I'd like to upgrade to 4.1 but because the forum software harkens back from vb2 days there are a lot of extras that are in the mix of database and file structure.

I want to start with a fresh 4.1 install, but I want to keep the users. How can I do this as easy as possible? Or can someone suggest a way to upgrade and clean up the database and the files?
Reply With Quote
  #2  
Old 12-09-2010, 01:48 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would set up a test site, try installing 4.1 and then, since you only want the users, try using Impex to only import the users. See if that works.

Optionally, use Calorie's database compare utility (do a search - it's in the 3.8 area) and see what extra tables/fields are in your database and do whatever with that info - delete them, keep them, you decide. Then do an upgrade.
Reply With Quote
  #3  
Old 12-12-2010, 03:36 PM
cynthetiq's Avatar
cynthetiq cynthetiq is offline
 
Join Date: Jul 2005
Location: NYC
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks. I'm using impex right now and it is importing the users just fine. The next question I have is how can I reset everyone that got imported to a new join date. I want to use a tool like vbexperience but if I keep the old join date, I have one of the same issues I have now.
Reply With Quote
  #4  
Old 12-12-2010, 06:57 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You could probably do a query to set them to all be some date. It's UNIX time, so google some conversion tool to set the date correctly.
Reply With Quote
  #5  
Old 12-12-2010, 11:52 PM
cynthetiq's Avatar
cynthetiq cynthetiq is offline
 
Join Date: Jul 2005
Location: NYC
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
You could probably do a query to set them to all be some date. It's UNIX time, so google some conversion tool to set the date correctly.
Thanks Lynne.

I got the conversion for UNIX time. I am not very good with SQL nor queries. I have never been good with them for some reason. Hopefully someone else out there can give me a hand with the exact statement to use, save the UNIX time part.
Reply With Quote
  #6  
Old 12-13-2010, 12:59 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Probably just something like (please backup your database first!!!!!):
Code:
UPDATE user SET joindate=xxxxxxx;
That would reset it for everyone to one specific date. If you have a table prefix, then you would have to put that before the table name, ie. prefixuser.
Reply With Quote
  #7  
Old 12-13-2010, 03:31 PM
cynthetiq's Avatar
cynthetiq cynthetiq is offline
 
Join Date: Jul 2005
Location: NYC
Posts: 190
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks. I had the process die in the middle of import. I'm not sure if this is the correct place to post such a support issue, but I'll start it here and move it at your request.

When I got this the first time, I started over. It keeps failing at the user import script.
Quote:
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@cynthetiq.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Quote:
[Mon Dec 13 08:40:27 2010] [error] [client 108.27.16.60] Premature end of script headers: index.php, referer: http://cynthetiq.com/thetfp/impex/index.php
[Mon Dec 13 08:40:27 2010] [error] [client 108.27.16.60] File does not exist: /home/cynthetiq/cynthetiq.com/internal_error.html, referer: http://cynthetiq.com/thetfp/impex/index.php
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 01:42 AM.


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.06524 seconds
  • Memory Usage 2,219KB
  • 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)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete