vb.org Archive - Need Help with database issue

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Need Help with database issue (https://vborg.vbsupport.ru/showthread.php?t=302602)

cardjim

09-24-2013 05:10 PM

Need Help with database issue

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

09-24-2013 05:12 PM

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

cardjim

09-24-2013 05:12 PM

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

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

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/showt...seball?p=98101
Referrer :
IP Address : 66.249.75.65
Username :
Classname : vB_Database
MySQL Version :

ForceHSS

09-24-2013 05:14 PM

check the email that is in the config
line 40 of config

Code:

$config['Database']['technicalemail']

cardjim

09-24-2013 05:16 PM

Posted above. thanks

ForceHSS

09-24-2013 05:19 PM

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

cardjim

09-24-2013 05:20 PM

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

09-24-2013 05:21 PM

what did u edit config with

cardjim

09-24-2013 05:25 PM

I used wordpad.

Zachery

09-24-2013 05:33 PM

change MySQL to mysqli instead

cardjim

09-24-2013 05:34 PM

How do I do that?

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

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

ForceHSS

09-24-2013 05:36 PM

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

cardjim

09-24-2013 05:43 PM

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 [DATE]1380051822[/DATE] at [TIME]1380051822[/TIME] ---------------

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

ForceHSS

09-24-2013 06:00 PM

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

Zachery

09-24-2013 07:22 PM

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

ozzy47

09-24-2013 07:30 PM

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

Code:

    //    ****** 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

01-08-2016 11:22 PM

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 [DATE]1452306596[/DATE] at [TIME]1452306596[/TIME] ---------------

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 [DATE]1452308056[/DATE] at [TIME]1452308056[/TIME] ---------------

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

jagtpf

01-10-2016 01:32 PM

Quote:

Originally Posted by blind-eddie (Post 2562321)

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

05-22-2016 03:40 PM

Quote:

Originally Posted by Zachery (Post 2447747)

change MySQL to mysqli instead

This fixed it for me. Thanks Zachery, you rock

All times are GMT. The time now is 01:49 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02706 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (19)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: