Urgent Please - Site down after MYSQL upgrade.

[SaN-DeeP]

Hello,
We have scheduled a vbulletin upgrade next week.
We were just trying to upgrade the mysql version to latest.

After successfully upgrading mysql, we are getting following errors.
We also have bought dbseo.

Please provide some help urgently, so atleast we get the site live again.
This are errors:


Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 45

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 93

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 97

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 105

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 116

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 120

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 128

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 197

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/init.php on line 404

Strict Standards: Declaration of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = NULL) in /home/tarena/public_html/forums/includes/class_core.php on line 1115

Deprecated: Assigning the return value of new by reference is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 2345

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Strict Standards: Non-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/tarena/public_html/forums/includes/class_core.php on line 2348

Fatal error: Memcache is not installed in /includes/class_datastore.php on line 270

[kh99]

What version of vbulletin and php are you running? Those messages look like maybe you've upgraded your php version.

[SaN-DeeP]

Hello kh99,
Thank You for immediate answer, it was our bad to not close the forums..
Vbulletin 3.6.x
Apache Version 2.2.29
PHP Version 5.4.39
MySQL Version 5.6.23

I got rid of many errors after following this :
http://www.vbulletin.com/forum/forum/vbulletin-3-8/vbulletin-3-8-questions-problems-and-troubleshooting/3949475-trying-to-move-and-upgrade-forums-and-i-am-unable-to-see-content-in-development-site?p=3949907#post3949907

[kh99]

Like that thread says, your version of vbulletin doesn't support php 5.4, so you should really either upgrade vbulletin or go back to an older php. But in any case, what errors do you have left?

[SaN-DeeP]

Strict Standards: Declaration of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = NULL) in /home/tarena/public_html/forums/includes/class_core.php on line 1115

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Strict Standards: Non-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/tarena/public_html/forums/includes/class_core.php on line 2348

Fatal error: Memcache is not installed in /includes/class_datastore.php on line 270

This errors when trying to open admincp.
Site is scheduled to be uprgaded next week to vb 4.x latest.


And following errors on front-end.

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 279

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 86

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 129

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 130

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 131

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php on line 132

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 18

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 19

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 20

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 21

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 22

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 23

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 24

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 25

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 26

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo.php on line 27

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo.php on line 17

Strict Standards: Non-static method vBSEO_Storage::path() should not be called statically in /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_url.php on line 359

Strict Standards: Declaration of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = NULL) in /home/tarena/public_html/forums/includes/class_core.php on line 1115

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Strict Standards: Non-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/tarena/public_html/forums/includes/class_core.php on line 2348

Fatal error: Memcache is not installed in /includes/class_datastore.php on line 270

[kh99]

Yeah, the last error is the one really causing a problem. I don't know about memcached, but I suppose the problem is that you don't actually have it installed, so maybe you either need to install it or edit your config.php file and comment out the lines where it's configured.

[SaN-DeeP]

Commented out memcache configuration from config.php
Fatal error: Memcache is not installed in /includes/class_datastore.php on line 270 this error is gone.

But getting a new error instead of memcache and all other still there:
Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php
Line: 279

--------------- Added 1428670660 at 1428670660 ---------------

This is response from our hosting provider.

Hello,
MySQL upgrades are, unfortunately, very tricky, and it's most recommended to increase them incrementally (5.0 to 5.1, 5.1 to 5.5, 5.5 to 5.6 in this case). I'm very sorry this upgrade didn't go smoothly for you.

It looks like you're running PHP 5.4.39 at the moment:

root@new [~]# php -v
PHP Deprecated: Comments starting with '#' are deprecated in /usr/local/lib/php.ini on line 234 in Unknown on line 0
PHP 5.4.39 (cli) (built: Apr 10 2015 17:18:37)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.6.1, Copyright (c) 2002-2014, by ionCube Ltd.

Sometimes with MySQL upgrades, PHP needs to be rebuilt. Would you me to try that? I can rebuild the same version, or a different version if you need.
Thanks!

Hello,

I see you've upgraded to MySQL 5.6. MySQL looks to be functioning correctly, and the errors shown on http://forums.techarena.in/ appear to be site-code related, and unfortunately not something we'd be able to assist with. You'll have to wait for the vBulletin support to respond . If they do mention something that needs to be adjusted on the server itself, please let us know and we'd be more than happy to assist you.


--------------- Added 1428671267 at 1428671267 ---------------

Still this errors on admincp exists.. which wont allow us to upgrade vbulletin.
Strict Standards: Declaration of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = NULL) in /home/tarena/public_html/forums/includes/class_core.php on line 1115

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Strict Standards: Non-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/tarena/public_html/forums/includes/class_core.php on line 2348



Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/includes/class_core.php
Line: 1115

[kh99]

But getting a new error instead of memcache and all other still there:
Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php
Line: 279

Yes, that's caused by the fact that the error messages are unexpected "output", and as the message says, headers can't be set after output is sent. So you do have to fix the remaining messages to get rid of that error, but a lot of times it's minor enough that the forum can still be used. Obviously you don't want your users seeing that, but what I mean is that you might be able to get to the admincp even with those messages being displayed.

I don't have the source code for vb3.6 handy so I can't tell you how to fix those errors. You might be able to change the error_reporting() call to stop those errors from being displayed, but I think that has to be done in many places.

[SaN-DeeP]

Atleast if we are able to fix the issue on admincp part.
We can continue ahead with the upgrade.

This are problems appearing on admincp
Strict Standards: Declaration of vB_Database_MySQLi::select_db_wrapper() should be compatible with vB_Database::select_db_wrapper($database = '', $link = NULL) in /home/tarena/public_html/forums/includes/class_core.php on line 1115

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Strict Standards: Non-static method vB_Shutdown::init() should not be called statically, assuming $this from incompatible context in /home/tarena/public_html/forums/includes/class_core.php on line 2348



Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/includes/class_core.php
Line: 1115

--------------- Added 1428672038 at 1428672038 ---------------

Can you allow me to send the source code of few specific files to you or post here ?
Please let me know which files to get access to admincp.

Will reverting back to old version of php help ? as per our hosting provider ?
Thanks.

--------------- Added 1428672207 at 1428672207 ---------------

Will reverting back to old version of php help ? as per our hosting provider ?

[kh99]

OK, for the first error, if you edit includes/class_core.php, somewhere around like 1090 (actually, I guess it's line 1115 like in the error message) should be this:
/**
* Simple wrapper for select_db(), to allow argument order changes
*
* @param string Database name
* @param integer Link identifier
*
* @return boolean
*/
function select_db_wrapper($database, $link)
{
return $this->functions['select_db']($link, $database);
}


and you would want to change it to be like this (the part in red has changed):
/**
* Simple wrapper for select_db(), to allow argument order changes
*
* @param string Database name
* @param integer Link identifier
*
* @return boolean
*/
function select_db_wrapper($database = '', $link = null)
{
return $this->functions['select_db']($link, $database);
}



Yes, I think what vbulletin support would recommend is to use a php version that is compatible with the vbulletin you're running. I don't know what version that would be - I think your host has upgraded and not told you, or they didn't realize they did it.

If you want to try to get rid of those errors and see what happens, I can try to help with that. But I think what might happen is that you might get rid of the errors but there could be other problems that aren't so obvious. But if you're planning to upgrade vbulletin next week, it might be good enough until then.

[kh99]

OK, also in class_core.php, around line 2900-3000, you should find this:

/**
* Singleton emulation - use this function to instantiate the class
*
* @return vB_Shutdown
*/
static function &init()
{
static $instance;

if (!$instance)


add the word 'static' (in red above).

[kh99]

And for that last one, I think you just need to find set_magic_quotes_runtime() on line 1514 and comment it out (put // at the beginning of the line).

Hopefully that would fix those 3 messages, but you might find others. Or maybe you've decided to go back to a different php version instead of making these changes.

[SaN-DeeP]

Respected Sir,
Can you allow me to pm you for once.
I have a sensitive question related to our site.
If no,
no issues I respect site and admin rules.
Please do not reply to this message I will debug further and post problems.

Regards,

[kh99]

You can pm me.

[kh99]

BTW, I just saw the link in your signature and clicked on it, and saw the many vbSEO errors - I can't help you with vbSEO. It might be a good idea after all to go back to an older version of php.

[SaN-DeeP]

our hosting provider tried best to switch php version from 5.4 to 5.3 and surprised how core works but.

this are errors now on frontend and admincp.
Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/tarena/public_html/forums/includes/class_core.php on line 1514

Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/includes/class_core.php
Line: 1514

Rest nothing url being = forums.techarena.in

[kh99]

Try editing class_core.php and comment out line 1514.

[Lynne]

vB3.6 doesn't work with PHP5.3 either. You really need to upgrade you vB version.