Announcement

Collapse
No announcement yet.

AHH! Total meltdown HELLPPP!!!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • AHH! Total meltdown HELLPPP!!!

    Ive been getting these DB errors sent to the webmaster box the last 2 days, not many it just seems to happen to a select couple. The first one was an error from a FAQ search (I didn't save e-mail). But I woke up and there where THREE others in my box! Two of them happened when they where referred from 2 other sites, but the last one happened when the referer was my homepage. Take a look!

    Code:
    Database error in vBulletin 3.0.3:
    
    Invalid SQL: 
    		SELECT *
    		FROM session
    		WHERE userid = 0
    		AND host = '193.178.166.7'
    		AND idhash = 'fa192d7e04cfa9931ce7969d211f17d2'
    		LIMIT 1
    	
    mysql error: Record has changed since last read in table 'session'
    
    mysql error number: 1020
    
    Date: Sunday 21st of November 2004 08:43:30 AM
    Script: http://www.(mywebsite).com/
    Referer: http://www.(awebsitethatlinkstome).com/?f=a
    IP Address: 193.178.166.7
    Code:
    Database error in vBulletin 3.0.3:
    
    Invalid SQL: 
    		SELECT *
    		FROM session
    		WHERE userid = 0
    		AND host = '69.145.61.9'
    		AND idhash = '26e06ec391b4323bd0c7e4ae1ad0581b'
    		LIMIT 1
    	
    mysql error: Record has changed since last read in table 'session'
    
    mysql error number: 1020
    
    Date: Sunday 21st of November 2004 10:35:05 AM
    Script: http://www.(mywebsite).com/
    Referer: http://www.google.com/custom?q=(search+search+search)&cof=AH%3Acenter%3BAWFID%(numbers)%3B
    IP Address: 69.145.61.9
    Code:
    Database error in vBulletin 3.0.3:
    
    Invalid SQL: 
    		SELECT *
    		FROM session
    		WHERE sessionhash = '81d51b4707e9a616c97aead9198fa83f'
    		AND lastactivity > 1101053338
    		AND host = '68.202.202.182'
    		AND idhash = 'aacf77c4875d90cadf93938b98abad84'
    	
    mysql error: Record has changed since last read in table 'session'
    
    mysql error number: 1020
    
    Date: Sunday 21st of November 2004 11:23:58 AM
    Script: http://www.(mywebsite).com/forumdisplay.php?f=2
    Referer: http://www.(mywebsite).com/
    IP Address: 68.202.202.182
    Like I said this just seems to happens to few select couple, I have guests on my site every second but it's still un aceptable!

    I am using:
    MySQL 4.1.7
    ZendOptimizer 2.5.5
    httpd-2.0.52
    mod_security-1.8.6 (Disabled in config though)
    php-5.0.2

  • #2
    This is a bug in MySQL 4.1.7 concerning HEAP tables:

    http://www.vbulletin.com/forum/bugs....iew&bugid=3495

    Also at this time PHP5 is not certified for use with vB. Please read this announcement:

    http://www.vbulletin.com/forum/showthread.php?t=113325

    I recommending installing PHP 4.3.9 for now.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      What MySQL version should I use?

      Comment


      • #4
        I'd stick with 4.0.22 at this time.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X