Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 09-16-2004, 11:08 AM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default can't connect to local mysql

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/rapdome/public_html/frontlinez/forum/admin/db_mysql.php on line 40

thats the error im getting when im tryna log onto my forum. Earlier i had a different error message but our host said there was a problem and they have fixed it and everything worked, but ive just come back on and i get that, and when i go onto the cpanel and click mySQL..... I can't see any databases at all :-s so im totally baffled
Reply With Quote
  #2  
Old 09-16-2004, 11:13 AM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

heres an image of the mysql on my cpanel so you see what i see
Attached Images
File Type: jpg cpanel.JPG (85.2 KB, 0 views)
Reply With Quote
  #3  
Old 09-16-2004, 11:24 AM
Colin F's Avatar
Colin F Colin F is offline
 
Join Date: Jul 2004
Location: Switzerland
Posts: 1,551
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well your mysql database plainly isn't around, so of course nothing can connect to it

Talk with your host, he probably changed something, or should at least have a backup.
Reply With Quote
  #4  
Old 09-16-2004, 11:28 AM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yeah i sent an email before posting this, im just waiting on a reply.

But, for some weird reason it has worked for me just now, and loaded the main forum page. But the instant i went to read my PM's, it does the same thing again :-\
Reply With Quote
  #5  
Old 09-16-2004, 11:52 AM
nexialys
Guest
 
Posts: n/a
Default

in your includes/config.php file, see for this:

$usepconnect = 0;

if it's set to 0, try with 1 ... if it's 1, set it to 0 .... this may be the cause... some mysql installations are alergic to pconnect...
Reply With Quote
  #6  
Old 09-16-2004, 12:06 PM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well its working now, except when trying to post i get this error message which i emailed my host about


Database error in vBulletin 2.2.6:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1476,27755,0),(220,27755,0),(677,27755,0),(39970, 27755,0),(248,27755,0)
mysql error: Can't open file: 'searchindex.MYI'. (errno: 145)

mysql error number: 1016

Date: Thursday 16th of September 2004 08:56:16 AM
Script: http://www.rapdome.com/front-linez/forum/newreply.php
Referer: http://www.front-linez.com/forum/sho...&threadid=2486
Reply With Quote
  #7  
Old 09-16-2004, 12:21 PM
nexialys
Guest
 
Posts: n/a
Default

hum... your database is corrupted... your MYI (one of the database file related to your structure) is missing, so there system can't archive the db... ask your host to reinstall the last backup ... or you will have to reinstall your site over...
Reply With Quote
  #8  
Old 09-16-2004, 12:23 PM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

now i dont get that message :-s when i hit submit reply it just freezes and doesnt load anything

so i dont know if they are fixing it or what, i dont know.
Reply With Quote
  #9  
Old 09-16-2004, 12:31 PM
wreck wreck is offline
 
Join Date: Jun 2004
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok this just takes the total utter pi$$ im now back to square one with the very very first error i got before all this started

http://www.front-linez.com/forum/index.php?s=
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 06:06 AM.


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.07665 seconds
  • Memory Usage 2,244KB
  • Queries Executed 14 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (1)postbit_attachment
  • (7)postbit_onlinestatus
  • (9)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_postinfo_query
  • fetch_postinfo
  • 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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete