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

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2008, 11:40 AM
Promoking Promoking is offline
 
Join Date: Feb 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL4 - MySQL5 migration woes

I searched the forums and did not find relevant info so if this is a repeat I apologize.

Just created a new db using MySQL5 and migrated my previous db MySQL4 data into it. I've edited includes/config.php to refelect the new db however, vb never connects.

Are there other files that need to be modified or any other steps I need to take to access the new MySQL5 db?

Thanks!

-Brian
Reply With Quote
  #2  
Old 10-22-2008, 11:44 AM
punchbowl punchbowl is offline
 
Join Date: Nov 2006
Posts: 505
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you post the error message? Can you connect to the db with phpadmin or anything else?
Reply With Quote
  #3  
Old 10-22-2008, 01:03 PM
Promoking Promoking is offline
 
Join Date: Feb 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

phpMyAdmin connects fine. The error is thus:

Database error
The database has encountered a problem.

And then tells me to refresh or try again. Not much help. My collation on the new db is:

latin1_general_ci

Could that have anything to do with it?

the only changes I made to includes/config.php are:

dbname
servername
port

username and password remain the same

Ideas?

Thank you
Reply With Quote
  #4  
Old 10-22-2008, 01:13 PM
punchbowl punchbowl is offline
 
Join Date: Nov 2006
Posts: 505
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have a look here http://www.vbulletin.com/forum/project.php?issueid=5627

not the answer but you may be onto something re collation
Reply With Quote
  #5  
Old 10-22-2008, 01:26 PM
Promoking Promoking is offline
 
Join Date: Feb 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm... lots of good info in there - thank you.

is: latin1_bin = latin1

Thanks

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

Naw that didnt work

Should be a simple thing right? BTW im using vb3.6.8 right now but plan to upgrade as soon as this db thing is fixed

System:

vb 3.6.8
MySQL client version: 5.0.45
php 4.2.1 (I think )

Steps:

1) Created a new db using mysql5 (tried various char sets "latin1_general_ci" default)
2) Migrated the existing db4 to the new one (checked with phpMyAdmin)
3) created a new user and password just to eliminate any potential conflicts
4) Updated my includes/config.php file
- dbname
- servername
- port

but I get a simple "The database has encountered a problem" error when try to access the forum.

Help?

Thank you

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

Solved....

I got this back from my hosts tech support:

" It seems that Vbulletin does not understand the "localhost:/tmp/mysql5.sock" syntax used to connect to a MySQL 5 database.

To circumvent this restriction, please edit the vBulletin configuration file (includes/config.php), and add the following line to the beginning:

ini_set('mysql.default_socket', '/tmp/mysql5.sock');

You will need to use

localhost

for the database host. "

Thanks for all your help... maybe this can benefit others in the future if they upgrade older mysql4 db's to mysql5

Cheers

-Brian
Reply With Quote
  #6  
Old 10-23-2008, 09:29 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have never seen a host where such an edit was needed.
Reply With Quote
  #7  
Old 11-10-2008, 09:24 PM
Allnick Allnick is offline
 
Join Date: Feb 2006
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've had exactly the same problem at the weekend.
Unfortunately, I only found this thread after hours of frustration.

I was given the exact same code from my hosts tech support.
Just added it to the beginning of config.php, and problem solved.
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 02:25 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.03648 seconds
  • Memory Usage 2,215KB
  • 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
  • (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_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