Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2015, 10:19 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Urgent Please - Site down after MYSQL upgrade.

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:

HTML Code:
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
Reply With Quote
  #2  
Old 04-10-2015, 10:25 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What version of vbulletin and php are you running? Those messages look like maybe you've upgraded your php version.
Reply With Quote
Благодарность от:
SaN-DeeP
  #3  
Old 04-10-2015, 10:38 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...07#post3949907
Reply With Quote
  #4  
Old 04-10-2015, 10:41 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #5  
Old 04-10-2015, 10:43 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
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.
Code:
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
Reply With Quote
  #6  
Old 04-10-2015, 10:49 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 04-10-2015, 10:55 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Commented out memcache configuration from config.php
Code:
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:
Code:
Unable to add cookies, header already sent.
File: /home/tarena/public_html/forums/vbseo/includes/functions_vbseo_pre.php
Line: 279
--------------- Added [DATE]1428670660[/DATE] at [TIME]1428670660[/TIME] ---------------

This is response from our hosting provider.

Quote:
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!
Quote:
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 [DATE]1428671267[/DATE] at [TIME]1428671267[/TIME] ---------------

Still this errors on admincp exists.. which wont allow us to upgrade vbulletin.
Code:
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
Reply With Quote
  #8  
Old 04-10-2015, 11:15 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SaN-DeeP View Post
But getting a new error instead of memcache and all other still there:
Code:
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.
Reply With Quote
  #9  
Old 04-10-2015, 11:18 AM
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 1,195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Code:
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 [DATE]1428672038[/DATE] at [TIME]1428672038[/TIME] ---------------

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

Will reverting back to old version of php help ? as per our hosting provider ?
Reply With Quote
  #10  
Old 04-10-2015, 11:32 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
PHP Code:
    /**
    * 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):
Code:
	/**
	* 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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07831 seconds
  • Memory Usage 2,288KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (8)bbcode_code
  • (1)bbcode_html
  • (1)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (1)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete