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 10-09-2011, 07:58 PM
Shadow Shadow is offline
 
Join Date: Jan 2011
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vBulletin Database Error

Alright, for the past hour or so, my site has been spitting out Database Errors. Now, the problem is, i don't know how to fix this because the email that is used for sending the DB Error logs isn't receiving the emails.

So now, i'm stuck with a non working website and confused members. Any suggestions guys?

Thanks in advance.

EDIT: Just to let you know, the most recent site/server change was to the "php.ini" file to increase the Maximum Memory Limit. No other changes have been made recently.
Reply With Quote
  #2  
Old 10-09-2011, 08:11 PM
Reycer Reycer is offline
 
Join Date: Jul 2008
Location: Lebanon, MO (USA)
Posts: 747
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can't help ya if we don't know the Database Error you are getting.
Reply With Quote
  #3  
Old 10-09-2011, 08:18 PM
Shadow Shadow is offline
 
Join Date: Jan 2011
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I understand that but I'm trying to find out what's wrong with the site myself but i'm not getting the emails and was wondering if there's another way to find out the cause.

Thanks though.
Reply With Quote
  #4  
Old 10-09-2011, 08:18 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Shadow786 View Post
Alright, for the past hour or so, my site has been spitting out Database Errors. Now, the problem is, i don't know how to fix this because the email that is used for sending the DB Error logs isn't receiving the emails.

So now, i'm stuck with a non working website and confused members. Any suggestions guys?

Thanks in advance.

EDIT: Just to let you know, the most recent site/server change was to the "php.ini" file to increase the Maximum Memory Limit. No other changes have been made recently.
How did you edit this file? As in, what program was used?
Reply With Quote
  #5  
Old 10-09-2011, 08:24 PM
Reycer Reycer is offline
 
Join Date: Jul 2008
Location: Lebanon, MO (USA)
Posts: 747
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Shadow786 View Post
I understand that but I'm trying to find out what's wrong with the site myself but i'm not getting the emails and was wondering if there's another way to find out the cause.

Thanks though.
Look in your error logs on your server.
Reply With Quote
  #6  
Old 10-09-2011, 08:25 PM
Shadow Shadow is offline
 
Join Date: Jan 2011
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Notepad++ was used.
Reply With Quote
  #7  
Old 10-09-2011, 08:29 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Shadow786 View Post
Notepad++ was used.
Just as I'd assumed.

Notepad sometimes adds characters at the top or the bottom of these files, that you cannot see but WILL mess things up. If you have this file still in your vB packet, upload it to your server, to overwrite back to default. If not, must edit files with something like TextEdit, which is a free utility. You will see the added characters using TextEdit that you won't see using notepad.

Notepad is NOT for editing executable files or scripts.

Edit to add: I am not assuming the php.ini file is your problem, I am merely trying to eliminate it as a suspect.
Reply With Quote
  #8  
Old 10-09-2011, 08:35 PM
Shadow Shadow is offline
 
Join Date: Jan 2011
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah i get you. Thanks for that.

One thing though, TextEdit doesn't appear to be for Ubuntu or for Windows (My Operating Systems). Can you suggest an alternative please?
Reply With Quote
  #9  
Old 10-09-2011, 08:39 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Shadow786 View Post
Ah i get you. Thanks for that.

One thing though, TextEdit doesn't appear to be for Ubuntu or for Windows (My Operating Systems). Can you suggest an alternative please?
I use TextEdit with windowsXP no problem and it also integrates with my FileZilla FTP..

The first thing I would do though, were I you, is save a copy of your php.ini file as it is, then upload the stock one to overwrite on your server and see if this database error problem goes away. Then you can solve the mystery of file editing at a later time.

Let's see if your edits to this file are indeed causing the errors.
Reply With Quote
  #10  
Old 10-10-2011, 02:31 PM
Shadow Shadow is offline
 
Join Date: Jan 2011
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, I figured it out. I was looking at the TextEdit that comes bundled with OSXM my mistake.

I tried what you suggested and then rebooted my server but still no joy.
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 09:21 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.04394 seconds
  • Memory Usage 2,249KB
  • Queries Executed 13 (?)
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
  • (4)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
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete