The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Can you post the error message? Can you connect to the db with phpadmin or anything else?
|
#3
|
|||
|
|||
![]()
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 |
#4
|
|||
|
|||
![]()
Have a look here http://www.vbulletin.com/forum/project.php?issueid=5627
not the answer but you may be onto something re collation |
#5
|
|||
|
|||
![]()
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 |
#6
|
|||
|
|||
![]()
I have never seen a host where such an edit was needed.
|
#7
|
|||
|
|||
![]()
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. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|