Announcement

Collapse
No announcement yet.

mysql error number: 1146

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

  • mysql error number: 1146

    I just woke up, and my forums spit this out at me. It was working fine a few hours ago. Help?
    Code:
    Database error in vBulletin 3.0.0:
    Invalid SQL: 
    			SELECT title, template
    			FROM template
    			WHERE templateid IN (5480,6021,5481,6023,6024,6025,5482,6027,6028,0,6029,6030,6031,6032,6362,5488,6234,6113,6112,6123,6251,6091,6229,6232,6239,6109,6110,6111,6200,6244,6243,6250,6249,6248,6245,6247)
    		
    mysql error: Table 'hmotaku_invision1copy.template' doesn't exist
    mysql error number: 1146
    Date: Tuesday 01st of June 2004 04:24:00 AM
    Script: http://hmforums.net/
    Referer:

  • #2
    Looks like your table has dissapeard... this is odd.. a table rarely just dies, has your host changed any of the mysql info such as your databases or have you?

    Comment


    • #3
      I don't think so, our host doesn't change anything without telling us first in advance. I haven't been doing anything either, was asleep.

      At one time it displayed a different error, 1054, I think.

      Comment


      • #4
        that error number doesnt tell us so much,

        If you have phpmyadmin go into it and make sure that the table template is inside of it

        Comment


        • #5
          Yes, it is. Both template, and templates.

          Comment


          • #6
            No wait, table "template" just disappeared!

            Comment


            • #7
              Do you have a backup of your database?

              Comment


              • #8
                No, I don't, but the person in charge of backups does, I hope. We haven't had much problems recently. Will the default vb3 template table do? Will upgrading the 3.0.1 do any good? I don't care about my styles, I can always reinstall them..

                Comment


                • #9
                  Well if you dont care about the styles, Ill go and get the default table after an install.

                  Edit: ive attached the sql file, hopefully this should help.
                  Attached Files
                  Last edited by Zachery; Tue 1 Jun '04, 4:47am.

                  Comment

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