Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    I keep getting this error
    Database error in vBulletin 3.6.0:

    Invalid SQL:

    REPLACE INTO useractivation
    VALUES
    (NULL , 169, 1155579607, 43310451, 0, 2);

    MySQL Error : Column count doesn't match value count at row 1
    Error Number : 1136
    Date : Monday, August 14th 2006 @ 07:20:07 PM
    Script : http://www.boardsie.com/forum/cron.php?&rand=688745
    Referrer : http://www.boardsie.com/forum/newthread.php?do=newthread&f=73
    IP Address : 213.202.180.241
    Username : Unregistered
    Classname : vb_database

    Any Ideas??
    Boards IrEland
    TopLists-add your site

  • #2
    First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Hi Colin..
      The strange thing is it only seems to be when I am online. Admin userid:1
      I have a secone admin account & I get no errors sent to me.
      BTW the DB error does not show up when viewing the forum I just get the email report.
      Boards IrEland
      TopLists-add your site

      Comment


      • #4
        Any ideas on this would be greatly appriciated..
        Boards IrEland
        TopLists-add your site

        Comment


        • #5
          Did you follow my previous suggestion?
          Best Regards
          Colin Frei

          Please don't contact me per PM.

          Comment


          • #6
            Yes Colin I did. this if what i,ve discovered so far..
            Originally posted by Beller View Post
            The strange thing is it only seems to be when I am online. Admin userid:1
            I have a secone admin account & I get no errors sent to me.
            BTW the DB error does not show up when viewing the forum I just get the email report.
            Boards IrEland
            TopLists-add your site

            Comment


            • #7
              Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

              Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

              If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.
              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


              • #8
                Actually Freddie just pointed out to me this is a bug:

                http://www.vbulletin.com/forum/bugs3...view&bugid=639
                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


                • #9
                  when I run this query:
                  REPLACE INTO " . TABLE_PREFIX . "useractivation
                  (userid, dateline, activationid, type, usergroupid)
                  VALUES
                  ($user[userid], " . TIMENOW . ", $user[activationid], 0, 2)
                  I get this error:
                  An error occurred while attempting to execute your query. The following information was returned.
                  error number: 1064
                  error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "useractivation
                  (userid, dateline, activationid, typ' at line 1

                  Is it ok to run this query from ACP>Maintenance>Execute SQL Query ?
                  Boards IrEland
                  TopLists-add your site

                  Comment


                  • #10
                    You need to change:

                    " . TABLE_PREFIX . "

                    ...to whatever table prefix you are using, If you are not using a table prefix, remove that.
                    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


                    • #11
                      Sorry Steve if this is a bit of a newbie question...
                      I'm not that well up on MySQL TBH..
                      I have removed Table Prefix (I can't see a prefix)
                      I now get this error..:

                      An error occurred while attempting to execute your query. The following information was returned.
                      error number: 1064
                      error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[userid], " . TIMENOW . ", $user[activationid], 0, 2)' at line 4

                      Sorry if its something stupid.. You time is greatly appriciated.
                      Boards IrEland
                      TopLists-add your site

                      Comment


                      • #12
                        I believe you also have to replace:

                        " . TIMENOW . "

                        ...with the current time in Unix timestamp. You can use this online tool to convert dates and times to Unix
                        Timestamps:

                        http://www.onlineconversion.com/unix_time.htm

                        If you have further questions about this it's probably better to post them in that bug report.
                        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


                        • #13
                          Originally posted by Steve Machol View Post

                          If you have further questions about this it's probably better to post them in that bug report.

                          Will do.. Thanks Steve!
                          Boards IrEland
                          TopLists-add your site

                          Comment


                          • #14
                            Actually, that code is meant to be replaced in the file.
                            I'll post more exact instructions in the bug report.
                            Best Regards
                            Colin Frei

                            Please don't contact me per PM.

                            Comment


                            • #15
                              D'oh!
                              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

                              Loading...
                              Working...
                              X