Database error in vBulletin 4.1.2

[sweetguy2004]

from when i have upgraded my vb to 4.0 i get this mail continuosly but never faced any problem or error while browsing site & when i click on search single content type page never load.

Database error in vBulletin 4.1.2:

Invalid SQL:

UPDATE searchlog

please someone help

[Lynne]

We would need to see the full error in order to help. When you get the error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:

The actual mysql query/code/problem....

MySQL Error : some sort of something here
Error Number : another something here
Date : Sunday, April 13th 2008 @ 11:16:43 AM
Script : http://address.path.path/page.php
Referrer :
IP Address : **.***.**.***
Username : username
Classname : database

[sweetguy2004]

no i get 4k-5k mails everyday even if i have Disable Database Error Email Sending to yes so i removed email id from config file now it is stopped but whenever i add the email starts again i get only this stuff in mail

Database error in vBulletin 4.1.2:

Invalid SQL:

UPDATE searchlog

I have removed all mods & reset skin & every option using tools.php but still i get this error
I get this error from when i have upgraded from 3.x to 4.x I thought this would be a bug but after every clean upgradation from 4.0 to 4.1

please help

[Lynne]

What is the FULL error message? UPDATE searchlog is only the beginning. Please see my previous post for what I want. I cannot help you if you do not provide that information.

[sweetguy2004]

Database error in vBulletin 4.1.2:

Invalid SQL:

UPDATE searchlog


__________ Information from ESET Smart Security, version of virus signature database 5940 (20110309) __________

The message was checked by ESET Smart Security.


this much only

[Lynne]

There is nothing I can do with that error. You will need to ask your host if you can actually see the real error somewhere on your server.

[sweetguy2004]

hey thanks for replying & your support I'm Hosting it on my own server its a window 2008

###### Apache Friends XAMPP (Basis Package) version 1.7.3 ######

  + Apache 2.2.14 (IPV6 enabled)
  + MySQL 5.1.41 (Community Server) with PBXT engine 1.0.09-rc
  + PHP 5.3.1 (PEAR, Mail_Mime, MDB2, Zend)
  + Perl 5.10.1 (Bundle::Apache2, Apache2::Request, Bundle::Apache::ASP, Bundle::Email, Bundle::DBD::mysql, DBD::SQlite, Randy Kobes PPM)
  + XAMPP Control Version 2.5.8 (ApacheFriends Edition)
  + XAMPP CLI Bundle 1.6
  + XAMPP Port Check 1.5
  + XAMPP Security 1.1
  + SQLite 2.8.17
  + SQLite 3.6.20
  + OpenSSL 0.9.8l
  + phpMyAdmin 3.2.4
  + ADOdb v5.10
  + FPDF v1.6
  + Zend Framework 1.9.6 Minimal Package (via PEAR)
  + Mercury Mail Transport System v4.72
  + msmtp 1.4.19 (a sendmail compatible SMTP client)
  + FileZilla FTP Server 0.9.33
  + Webalizer 2.21-02 (with GeoIP lite)
  + apc 3.1.3p1 for PHP
  + eAccelerator 0.9.6-rc1 for PHP
  + Ming 0.4.3 for PHP
  + PDF with pdflib lite v7.0.4p4 for PHP
  + rar 2.0.0-dev for PHP
  + Xdebug 2.0.6-dev for PHP
  + libapreq2 v2.12 (mod_apreq2) for Apache

---------------------------------------------------------------

I've reinstalled xampp many times but the prob still exist.

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

in admin option Error Handling & Logging settings i set Log Database Errors to a File

check this link
http://www.vedesi.com/logs/

its still creating logs in same folder

please help

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, March 17th 2011 @ 06:54:25 PM
Error Date : Thursday, March 17th 2011 @ 06:54:25 PM
Script : http://www.vedesi.com/tags.php?tag=hot&page=453
Referrer :
IP Address : xxxxxxxxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
================================================== ===

i think the prob is with tags

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

repaired / optimized this tables

tag 6.52 MB 7.03 MB 273.00 MB Yes
tagcontent 67.63 MB 164.92 MB 273.00 MB Yes
tagsearch 2.60 MB 3.47 MB 0

still processing logs

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

Originally Posted by Lynne

There is nothing I can do with that error. You will need to ask your host if you can actually see the real error somewhere on your server.

hey i have posted the error please can you give some solution???

[Videx]

Server problems are really beyond the scope of this forum, as it's really only about vbulletin mods. It sounds like you're just making more errors, with the new "MySQL server has gone away" error. There's a whole page about that error over on vb.com somewhere, and who knows that might be the whole problem.

[Lynne]

"MySQL Server has gone away" is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265 You will need to talk to your host about this in order to get it resolved. If the host is yourself, I suggest you read up on the error and the variables you will need to try modifying in mysql configuration file to fix this.

[sweetguy2004]

ok thanks it is solved changed max_allowed_packet=1 to max_allowed_packet=2 in my.ini

Thanks alot Lynne.