Announcement

Collapse
No announcement yet.

What does this error mean?

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

  • What does this error mean?

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT *
    FROM mailqueue
    ORDER BY mailqueueid DESC
    LIMIT 10
    mysql error: Table 'photodb.mailqueue' doesn't exist

    mysql error number: 1146
    This happens when a new user tries to register. I get this email and sometimes get the error mesg in my browser when I try to register myself to see what happens. The funny thing is though things seem to be working ok. I just installed photopost would that cause this? Any ideas on how to fix it?

  • #2
    This means that you are missing the default 'mailqueue' table for some reason. You can run this query to recreate that table:

    Code:
    CREATE mailqueue (
    		mailqueueid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    		dateline INT UNSIGNED NOT NULL DEFAULT '0',
    		toemail MEDIUMTEXT NOT NULL,
    		subject MEDIUMTEXT NOT NULL,
    		message MEDIUMTEXT NOT NULL,
    		header MEDIUMTEXT NOT NULL,
    		PRIMARY KEY (mailqueueid)
    );
    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
      Thanks for the speedy reply I did that and got this error message

      Error

      SQL-query :



      CREATE mailqueue( mailqueueid INT UNSIGNED NOT NULL AUTO_INCREMENT ,
      dateline INT UNSIGNED NOT NULL DEFAULT '0',
      toemail MEDIUMTEXT NOT NULL ,
      subject MEDIUMTEXT NOT NULL ,
      message MEDIUMTEXT NOT NULL ,
      header MEDIUMTEXT NOT NULL ,
      PRIMARY KEY ( mailqueueid )
      )


      MySQL said:


      #1064 - You have an error in your SQL syntax near 'mailqueue( mailqueueid INT UNSIGNED NOT NULL AUTO_INCREMENT ,
      dateline INT UNS' at line 1

      Comment


      • #4
        It looks like you didn't copy-n-paste that query exactly as written. I just tried it on a test database and it worked fine.
        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


        • #5
          same error I copied it here then pasted it in notepad and recopied it again the last time to make sure. This is all greek to me can I try something different

          Comment


          • #6
            How about adding the semi-colon at the end of the query. You know those are REQUIRED.... right...?

            Comment


            • #7
              its there when I paste it in

              Comment


              • #8
                Its kind of a wierd error anyway It only happened after I installed photopost, I then added a block to VBPortal page that shows the thumbs. Once I removed that block the errors went away

                Comment


                • #9
                  Missing a the word TABLE?

                  Originally posted by Steve Machol
                  It looks like you didn't copy-n-paste that query exactly as written. I just tried it on a test database and it worked fine.
                  Steve, I think you left out the word "TABLE" so it should probably read like this:

                  Code:
                  CREATE TABLE mailqueue (
                   mailqueueid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                   dateline INT UNSIGNED NOT NULL DEFAULT '0',
                   toemail MEDIUMTEXT NOT NULL,
                   subject MEDIUMTEXT NOT NULL,
                   message MEDIUMTEXT NOT NULL,
                   header MEDIUMTEXT NOT NULL,
                   PRIMARY KEY (mailqueueid)
                  );
                  Anyway it worked for me like that, but without the word TABLE I get the error Al described above.

                  In any case I appreciate the help. Is there a reason that this mailqueue table would be more likely to become corrupted than others? I am asking because I received a

                  mysql error: Can't open file: 'mailqueue.MYI'. (errno: 145)
                  mysql error number: 1016
                  error on the heels of a mysql disconnect that lasted about an hour.

                  I am on vB3.0.7 A couple people mentioned getting "double notifications" for awhile last week.

                  Regards,

                  Matt

                  Comment


                  • #10
                    Originally posted by memobug
                    Steve, I think you left out the word "TABLE" so it should probably read like this:
                    You're right. Thanks Matt.
                    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