Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 06-20-2011, 07:51 AM
dlewisr dlewisr is offline
 
Join Date: Mar 2011
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MYSQL error

Database error in vBulletin :

I am getting the error below on my forum, there were no problems last night but
when I got up this morning this is the message I got. Members are taken to 500
internal server error when they click the what's new and also on the
unreadposts or New Posts.


Database error in vBulletin :

mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxxxxx/public_html/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Monday, June 20th 2011 @ 05:14:11 AM
Error Date : Monday, June 20th 2011 @ 05:14:11 AM
Script : http://www.xxxxxxxx.co.uk/misc.php?show=ccbmessages
Referrer :
http://www.xxxxxxx.co.uk/showthread.php/419-xxxxxxxxxx
IP Address : 194.66.200.1
Username :
Classname : vB_Database
MySQL Version :


Any ideas or suggestions anyone? I've contacted the server who said it maybe because they have updated to php version 5.3.6 which is my version anyway, so sounds lame. I've asked them to locate and analyse the error logs as there is no error showing in the logs when I looked.

Open to suggestions?
Cheers in advance
Reply With Quote
  #2  
Old 06-20-2011, 02:00 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MySQL can't connect (through socket):

See this page for the causes of this error: https://www.vbulletin.com/docs/html/cantconnect You will most likely need to talk to your host in order to fix the issue.
Reply With Quote
Благодарность от:
borbole
  #3  
Old 06-20-2011, 08:52 PM
dlewisr dlewisr is offline
 
Join Date: Mar 2011
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I emailed them before I went to work and they are now saying that it maybe because I upgraded to 5.3.6 and there is now incompatibility issues with scripts, but I have not upgraded. I'm now emailing to say this. Thank you Lynne and I'll check the link that you mention.

The strange thing is that posts are adding on the 'new posts' and going down when read but not linking when clicked, I've just been informed the search is also directing to the 500 page too.

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

I've read the link that you sent me........... and I'm baffled by that. I'm no tech savvy, unfortunately.
Reply With Quote
  #4  
Old 06-20-2011, 10:13 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dlewisr View Post
I emailed them before I went to work and they are now saying that it maybe because I upgraded to 5.3.6 and there is now incompatibility issues with scripts, but I have not upgraded. I'm now emailing to say this. Thank you Lynne and I'll check the link that you mention.

The strange thing is that posts are adding on the 'new posts' and going down when read but not linking when clicked, I've just been informed the search is also directing to the 500 page too.

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

I've read the link that you sent me........... and I'm baffled by that. I'm no tech savvy, unfortunately.
Did you contact your host as suggested above? It is something that is caused on their end.
Reply With Quote
Благодарность от:
dlewisr
  #5  
Old 06-20-2011, 10:19 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe they meant that they upgraded you to 5.3 and that is causing the issue? You should be able to see what version of php your are running in your admincp.
Reply With Quote
  #6  
Old 06-21-2011, 06:40 PM
dlewisr dlewisr is offline
 
Join Date: Mar 2011
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you both for sticking with me! I have contacted them and you're right it is the webserver that upgraded to 5.3.6 I am running that on my site but previously it was 5.2. I don't know how that changes? Can they change that from the web host side? My apologies for sounding such a noobie......... but basically that is what I am.

I asked them when the upgrade occured and the time and date they give me corresponds exactly with that of the first email of the data base error and so it must be incompatibility issues.

There last email was this:

Hello David,

We do not provide support fro custom coding. You will need to code your site appropriately to work with php 5.3. The only alternative to this would be to put you on one of our older servers with the older version of php but be aware this would only be a temporary fix and all servers will eventually migrate to the newest version of php and similar issues will continue. The best solution is to look for a solution on getting your code working on php 5.3.
--
Thank you for choosing HostPapa!

Regards,

I thought Vbullettin was already 5.3.6 compatible. Is it? Although I am still on the 4.1.2 version and haven't upgraded to 4.1.4 yet.
Reply With Quote
  #7  
Old 06-21-2011, 07:14 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vB4 is compatible with php5.3 There is a bug in php5.3 that can cause issues on the search page, and somebody entered it into Jira and there is a fix posted in the bug report (which isn't a vb bug, but a php bug, but it's still in Jira). I do not think that would cause the error you are seeing though since it isn't from the search page. The script you are running is misc.php?show=ccbmessages which happens to be from one of your modifications. You may need to see if it is php5.3 compatible.
Reply With Quote
  #8  
Old 06-21-2011, 07:23 PM
dlewisr dlewisr is offline
 
Join Date: Mar 2011
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

there is a problem with the search too and so may be related. The search takes me to the same 500 page too.

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

what is Jira? I do have a few mods on but they have all been fine, no problems till they upgraded?

Thanks for your help Lynne, which isn't the first time as it happens lol

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

Just re-read your post, duh, you mean that although they were fine before they may not be now that the upgrade has happened. I'll disable them all tomorrow to see what happens. Too late now as I'm at work in 5 hours and haven't been to bed yet!!!!

I'll let you know tomorrow. Fingers crossed.

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

I've disabled every mod and there is no change. Was the fix this, that you were referring to Lynne


vb/search/criteria.php

if (method_exists($this->search_type, 'get_display_name'))
{
$hashstrings[] = 'type:' . $this->search_type->get_display_name();
}
else
{
$hashstrings[] = 'type:' . strval($this->search_type);
}

and replace it with

$hashstrings[] = 'type:' . strval($this->search_type);
Reply With Quote
  #9  
Old 06-22-2011, 07:45 PM
dlewisr dlewisr is offline
 
Join Date: Mar 2011
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just to close this thread as editing the file mentioned above has solved the problem. I'm really grateful for the help Lynne as your post reminded me of the search error I had read some days ago, although I hadn't linked the two.

Thanks for the help too Borbole

Now to reinstall all those mods again lol

cheers again.
Reply With Quote
  #10  
Old 06-20-2012, 06:27 AM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dlewisr View Post
vb/search/criteria.php

if (method_exists($this->search_type, 'get_display_name'))
{
$hashstrings[] = 'type:' . $this->search_type->get_display_name();
}
else
{
$hashstrings[] = 'type:' . strval($this->search_type);
}

and replace it with

$hashstrings[] = 'type:' . strval($this->search_type);
Is this the fix.?
I am having a similar issue.


Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/mysite.com/forum/includes/class_core.php on line 314
Reply With Quote
Reply

Thread Tools
Display Modes

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 03:09 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04390 seconds
  • Memory Usage 2,257KB
  • 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
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (2)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete