Need Help with database issue

[cardjim]

My site has went down as of five days ago... currently getting a database error and I'm needing someone to take a look and help me fix this issue. I'm willing to pay or do what ever it takes to get this up within the next 12-24 hours.

If you can help please email codycolbyj@gmail.com and I will exchange my phone number there.

Website is sportscardarena.com

[ForceHSS]

You need to post the error you are getting in the email

[cardjim]

I don't get an error message. That is the issue. Not sure why...

--------------- Added 1380050053 at 1380050053 ---------------

Found it... Database error in vBulletin :

mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
/home/sportsca/public_html/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Thursday, September 19th 2013 @ 07:38:30 AM
Error Date : Thursday, September 19th 2013 @ 07:38:30 AM
Script : http://www.sportscardarena.com/showthread.php/25333-Trading-this-big-2013-Bowman-lot-for-Baseball?p=98101
Referrer :
IP Address : 66.249.75.65
Username :
Classname : vB_Database
MySQL Version :

[ForceHSS]

check the email that is in the config
line 40 of config
$config['Database']['technicalemail']

[cardjim]

Posted above. thanks

[ForceHSS]

check db name username and password in your config make sure they are right

[cardjim]

I confirmed that and changed the user and added a new user and replaced the database with a back up db and still nothing showing up.... randomly happened overnight with no known changes by me (the only one with ftp and cpanel)

[ForceHSS]

what did u edit config with

[cardjim]

I used wordpad.

[Zachery]

change MySQL to mysqli instead

[cardjim]

How do I do that?

--------------- Added 1380051279 at 1380051279 ---------------

Sorry. I'm not very familiar with VB. Thanks.

[ForceHSS]

your host must of changed something for some reason talk to them

[cardjim]

I've tried and they said they haven't changed anything. Are there any other troubleshooting methods or options to get my site of 5 years back up?

--------------- Added 1380051822 at 1380051822 ---------------

I'm willing to do what ever it takes to get this back up.

[ForceHSS]

This wait to see if others can help you with this problem

[Zachery]

It should be the first setting in your config.php for dbtype

[ozzy47]

Just for reference, includes/config.php should look like the following, for the first setting, according to Zachary.

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysqli';

[blind-eddie]

I received a few database error emails regarding this very subject. I went to my site to find it unreachable, meaning database errors show for every page I go to.
I have done nothing to this site in a very long time & my host say they made no changes to my server.
What would case this to happen out of the blue?
I did edit my config with edit to fix.

BTW: I have 4 vb sites and only one received this issue and config.php in others is still set to MYSQL and have no issues.

--------------- Added 1452306596 at 1452306596 ---------------

Looks like my host updated my php to 5.6 beta via cpanel but my sites show I am using 5.4.
I am running only vb3.8, will I have any issues using php5.6?

--------------- Added 1452308056 at 1452308056 ---------------

I had to switch back to 5.4, many addon site functions would not function properly.

[jagtpf]

I received a few database error emails regarding this very subject. I went to my site to find it unreachable, meaning database errors show for every page I go to.
I have done nothing to this site in a very long time & my host say they made no changes to my server.
What would case this to happen out of the blue?
I did edit my config with edit to fix.

BTW: I have 4 vb sites and only one received this issue and config.php in others is still set to MYSQL and have no issues.

--------------- Added 1452306596 at 1452306596 ---------------

Looks like my host updated my php to 5.6 beta via cpanel but my sites show I am using 5.4.
I am running only vb3.8, will I have any issues using php5.6?

--------------- Added 1452308056 at 1452308056 ---------------

I had to switch back to 5.4, many addon site functions would not function properly.

A mulled server change to php5.6 was one of the drivers towards us having to upgrade to vB 4, from 3.8. Our server owner tested the change to 5.6 thus crashing the Forum - thankfully he allowed us 3 months to sort out the upgrade.
Whilst the basic upgrade was seamless, we're still 'fighting' to get some of the tried and tested vB3 hacks to work.

[plubius]

change MySQL to mysqli instead

This fixed it for me. Thanks Zachery, you rock