The Database Has Encountered a Problem

Timo

Hi, I inherited my vbulletin forum/site from my predecessor four or five years ago, I believe it's vBulletin version 3.6.four or thereabouts. Unfortunately as of yesterday (tenth May) it has encountered a database fault "The database has encountered a trouble" and fails to load at all:

http://Infekted.org

I accept done nothing server-side to cause such a trouble.

I would be very grateful if anyone could advise how to troubleshoot the mistake, please. Unfortunately my predecessor has moved on and is no longer able to advise. I did buy the vBulletin license off him at the fourth dimension, but it has since expired.

I did take a database backup last week (5th May), but I wish to troubleshoot the problem in case information technology happens again and/or to retain any data on the forum that was added since that date, earlier having to resort to restoring the database to that engagement.

View Page Source gives the following:

                            Database mistake in vBulletin : mysql_connect(): The mysql extension is deprecated and will be removed in the time to come: use mysqli or PDO instead /home/drammy/public_html/virus/includes/class_core.php on line 273  MySQL Fault  :  Mistake Number :  Date         : Thursday, May 12th 2016 @ 11:36:15 AM Script       : http://infekted.org/virus/ Referrer     :  IP Address   : 81.135.241.178 Username     :  Classname    : vB_Database -->

If I'm non barking up the wrong tree, line #273 on class_core.php is:

$link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);

I fully understand HTML and CSS, only am less experienced with PHP and MySQL databases. I'thousand non certain what has changed for it to warrant such an error (no passwords take been changed). Sorry for the greenness.

Thanks for any help yous could offer,
Timo

Timo

I'g not sure if this is connected to the database error, withal I've noticed in the logs I keep getting these errors repeated over and over:

[fault] [client 68.180.231.30] PHP Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/drammy/public_html/virus/includes/class_core.php on line 1514
[error] [client 68.180.231.30] PHP Strict Standards: Annunciation of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = Naught) in /home/drammy/public_html/virus/includes/class_core.php on line 1115
[error] [client 192.243.55.135] PHP Deprecated: Assigning the return value of new by reference is deprecated in /dwelling/drammy/public_html/virus/includes/functions.php on line 794
[error] [client 192.243.55.135] PHP Deprecated: Assigning the return value of new by reference is deprecated in /abode/drammy/public_html/virus/includes/functions.php on line 790
[fault] [client 192.243.55.135] PHP Strict Standards: Not-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/drammy/public_html/virus/includes/class_core.php on line 2348

I've uploaded a re-create of class_core.php below, if anyone could please offer any help:-

http://world wide web.infekted.org/files/class_core.php

mysiteguy

What is up with "virus" in the url?

BirdOPrey5

Your host (or someone) has upgraded your PHP version to PHP 5.5 or beyond.

VB 3.six.4 is not compatible with this new version of PHP but you can likely set up this specific error by editing the /includes/config.php file and irresolute the line

                            $config['Database']['dbtype'] = 'mysql';

to

                            $config['Database']['dbtype'] = 'mysqli';

Just calculation an i to the end my mysql.

DO Non edit the file with WIndows Notepad. Download Notepad2 or Notepad++ if you are on Windows, both are free.

That should get most of the site running at that point.

Long term you volition need to upgrade to VB 3.viii.9 / 3.8.10 at some point.

zappaDPJ

What is upward with "virus" in the url?

If the OPs site is the site I think it is then it could be a reference to the Admission Virus TI Synth or something similar.

Empire

How did this error happen?

zappaDPJ

How did this error happen?

Your host (or someone) has upgraded your PHP version to PHP 5.5 or beyond.

Timo

Your host (or someone) has upgraded your PHP version to PHP 5.5 or beyond.
VB iii.6.four is not compatible with this new version of PHP but you lot tin likely fix this specific error by editing the /includes/config.php file and irresolute the line
                                $config['Database']['dbtype'] = 'mysql';                              
to
                                $config['Database']['dbtype'] = 'mysqli';                              
Simply adding an i to the end my mysql.
DO NOT edit the file with WIndows Notepad. Download Notepad2 or Notepad++ if you are on Windows, both are free.

That should become most of the site running at that point.

Long term you lot will need to upgrade to VB 3.8.9 / 3.viii.10 at some indicate.

Super, that worked! Give thanks you and so, so much!

I've tried accessing the vBulletin site in the past to obtain the latest software for vBulletin serial 3.x but I seemingly found you had to have an ongoing subscription to access the downloads and my license had elapsed in that period, effectively leaving me locked out.

What is up with "virus" in the url?

My apologies, completely forgot 'virus' was a dodgy give-and-take out of context, simply Zappa was correct, 'Virus' is a serial of music keyboards that accept been made the last 15 years or so. Our site is an enthusiast/fan forum for those synths. Nothing to do with computer viruses, I can assure!

ac1.staticflickr.com_3_2218_2365695100_541f39c6f5.jpg

I believe at the time the prior possessor of the site was testing new forum software during a forum migration and had created the Virus/ redirection folder (pointing to Infekted.org/virus) and after everything worked it's never been removed.

Huge thanks to you all!

Timo

BirdOPrey5

I've tried accessing the vBulletin site in the past to obtain the latest software for vBulletin serial 3.x but I seemingly establish yous had to accept an ongoing subscription to access the downloads and my license had elapsed in that menses, effectively leaving me locked out.

Well the annual updates concluded years ago. At this point to upgrade to 3.eight.10 yous'd need to upgrade to either a VB4 or VB5 license. VB5 license upgrade is $209. VB4 license upgrade is $149. Either will give you access to any future versions of VB3 and VB4. The VB5 license will of course also give you access to all future versions of VB5.

A cheaper, merely somewhat riskier option is to purchase a 2nd hand or "used" license only you lot demand to be very careful if doing that.

doubt

DO Non edit the file with WIndows Notepad. Download Notepad2 or Notepad++ if you are on Windows, both are gratis.

What's wrong with Windows Notepad?

zappaDPJ

What'southward wrong with Windows Notepad?

Some editors salve spurious characters to files. I approximate Notepad must be one of them although I must admit I wasn't aware of that.

Tracy Perry

Maybe the inapplicable 0D hex code (a carriage return) being inserted by notepad in addition to the 0A hex lawmaking that is causing issues with some input requirements.

NotePad++ does not accept that issue

doubt

Some editors save spurious characters to files. I estimate Notepad must be one of them although I must admit I wasn't aware of that.

I wasn't equally well.
I have Notepad++, using it for simple edits-searches for C, C++.
Any simple edits for the Web I use Notepad. (Such as a config file)

BirdOPrey5

Windows Notepad volition often add together a BOM (Byte Order Marker) - an invisible character that causes major bug with PHP. If you edited your config.php and the site goes down, or you go white pages, information technology may be a BOM.

mysiteguy

Notepad itself does create the BOM characters. The issue is that if you paste annihilation into it with BOM, it won't give any indication it's there in the text, and will happily save it to the file.

The railroad vehicle return vs line feed thing, not an issue. PHP will just as happily utilize one every bit the other, or both.

BirdOPrey5

The carriage return vs line feed matter, not an event. PHP will just every bit happily use one every bit the other, or both.

PHP might exist happy, y'all won't reading the file without proper line breaks.

Tracy Perry

Notepad itself does create the BOM characters. The result is that if you lot paste annihilation into information technology with BOM, it won't give any indication it'due south in that location in the text, and volition happily save it to the file.
The railroad vehicle return vs line feed thing, not an outcome. PHP will just as happily use one as the other, or both.

Aye, I couldn't really remember - it was awhile agone that I learned not to use Notepad for whatever config files...
now that I'm on a Mac TextWrangler works merely fine for me. For Windows I e'er install Notepad ++.

doubt

If you edited your config.php and the site goes down, or you get white pages, it may be a BOM.

And then far I'thou lucky, it'due south non happened with VB and XF ever.
Especially With VB had to edit the config file often.

The Database Has Encountered a Problem

vBulletin Database Error

0 Response to "The Database Has Encountered a Problem"

إرسال تعليق

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel