Results 1 to 5 of 5

Database Errors

This is a discussion on Database Errors within the Off-Topic & Chit Chat forums, part of the Focus on Members category; The other day I reported that I lost an attachment. Today I got two database errors. Any ideas how to ...

  1. #1
    Senior Member majordude's Avatar
    Real Name
    majordude
    Join Date
    Aug 2006
    Posts
    182
    Liked
    0 times

    Unhappy Database Errors

    The other day I reported that I lost an attachment. Today I got two database errors.

    Any ideas how to fix this?

    ERROR 1

    Database error in vBulletin 3.6.0:

    Invalid SQL:

    REPLACE INTO useractivation
    VALUES
    (NULL , 77, 1158737043, 80794438, 0, 2);

    MySQL Error : Column count doesn't match value count at row 1
    Error Number : 1136
    Date : Wednesday, September 20th 2006 @ 12:24:03 AM
    Script : http://www... ...com/cron.php?rand=323190
    Referrer : http://www... ...com/introductions/
    IP Address : 124.xxx.xxx.xxx
    Username : Unregistered
    Classname : vb_database


    ERROR 2

    Database error in vBulletin 3.6.0:

    Invalid SQL:

    REPLACE INTO useractivation
    VALUES
    (NULL , 77, 1158674409, 63905929, 0, 2);

    MySQL Error : Column count doesn't match value count at row 1
    Error Number : 1136
    Date : Tuesday, September 19th 2006 @ 07:00:09 AM
    Script : http://www... ...com/cron.php?rand=396600
    Referrer :
    IP Address : 216.xxx.xxx.xxx
    Username : Unregistered
    Classname : vb_database
    .
    Go Packers!

  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Hello,

    you should check which cron job (executed at 7:00) performs modification of "useractivation" db table and disable or fix it (it's not vBSEO).
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #3
    vBSEO Staff Juan Muriente's Avatar
    Real Name
    Juan Carlos Muriente
    Join Date
    Jun 2005
    Location
    Puerto Rico
    Posts
    14,267
    Liked
    558 times
    **Moved to the troubleshooting forums**
    Juan Muriente / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  4. #4
    vBSEO Staff Ace Shattock's Avatar
    Real Name
    Ace Shattock
    Join Date
    Jul 2005
    Location
    Auckland, New Zealand, New Zealand
    Posts
    3,998
    Liked
    11 times
    I seem to recall this error on my own forums, when using an early release of one of the vBs.

    Effectively, the user activation wasn't working because there was an error in the php file.

    /upload/includes/cron/activate.php

    Try uploading this again, from your latest download of 3.6.0.

  5. #5
    Senior Member majordude's Avatar
    Real Name
    majordude
    Join Date
    Aug 2006
    Posts
    182
    Liked
    0 times
    Thanks. I believe that this is a reported bug in vBulletin 3.6. (There was a reply here that seems to have disappeared that said as much.)

    I'm glad it isn't a database error!
    .
    Go Packers!

Similar Threads

  1. Database Errors
    By Michael in forum Troubleshooting
    Replies: 11
    Last Post: 11-03-2005, 05:39 PM
  2. Database errors and problems with
    By drex in forum Bug Reporting
    Replies: 2
    Last Post: 11-02-2005, 09:02 PM
  3. lotsa database errors on vbseo
    By acers in forum General Discussion
    Replies: 1
    Last Post: 08-11-2005, 11:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •