DELETE FROM tachyforumpost

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tariq Rathore
    Senior Member
    • Mar 2008
    • 337
    • 3.8.x

    DELETE FROM tachyforumpost

    I am getting below error when i make new topic or reply post.

    Database error in vBulletin 3.8.2:


    Invalid SQL:

    DELETE FROM tachyforumpost
    WHERE forumid = 33;

    MySQL Error : Table 'mxxx_forums.tachyforumpost' doesn't exist
    Error Number : 1146
    Request Date : Monday, February 15th 2016 @ 09:12:17 AM
    Error Date : Monday, February 15th 2016 @ 09:12:17 AM
    Script : http://www.mknexusonline.com/forums/...streply&t=6026
    Referrer : http://www.mknexusonline.com/forums/...uote=1&p=45112
    IP Address : 113.203.238.114
    Username : MKRayden
    Classname : vB_Database
    MySQL Version : 5.5.44-MariaDB-cll-lve
    Mortal Kombat Nexus
    Pleae read before buying Ryan
  • Tariq Rathore
    Senior Member
    • Mar 2008
    • 337
    • 3.8.x

    #2
    Bump more then 12 hours i droped all Tachy table kindly help my users can't make new post and thread as wel
    Mortal Kombat Nexus
    Pleae read before buying Ryan

    Comment

    • Paul M
      Former Lead Developer
      vB.Com & vB.Org
      • Sep 2004
      • 9886

      #3
      Well if you dropped the table its hardly surprising it now fails saying it cannot find the table .....

      You need to restore or recreate what you dropped.
      Baby, I was born this way

      Comment

      • Tariq Rathore
        Senior Member
        • Mar 2008
        • 337
        • 3.8.x

        #4
        What is recreate table query?
        Mortal Kombat Nexus
        Pleae read before buying Ryan

        Comment

        • Tariq Rathore
          Senior Member
          • Mar 2008
          • 337
          • 3.8.x

          #5
          Plz Someone response but my site not works since 12th February
          Mortal Kombat Nexus
          Pleae read before buying Ryan

          Comment

          • Mark.B
            vBulletin Support
            • Feb 2004
            • 24286
            • 6.0.X

            #6
            Do you have a backup from before you did this?

            That would be your safest bet. Manually restoring tables is not always a trivial task, and is not guaranteed to fix the problem, since many vBulletin tables are interdependent and even if you recreate the tables, you will be missing the data. That data may be required by other tables and thus the site could still fail.
            MARK.B
            vBulletin Support
            ------------
            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

            Comment

            • Tariq Rathore
              Senior Member
              • Mar 2008
              • 337
              • 3.8.x

              #7
              I have backup from Last September 2015 that's why i am asking how to make table via query?
              Mortal Kombat Nexus
              Pleae read before buying Ryan

              Comment

              • Tariq Rathore
                Senior Member
                • Mar 2008
                • 337
                • 3.8.x

                #8
                Bump please share table query?
                Mortal Kombat Nexus
                Pleae read before buying Ryan

                Comment

                • Mark.B
                  vBulletin Support
                  • Feb 2004
                  • 24286
                  • 6.0.X

                  #9
                  Try this:
                  Code:
                  CREATE TABLE tachyforumpost (
                      userid INT UNSIGNED NOT NULL DEFAULT '0',
                      forumid INT UNSIGNED NOT NULL DEFAULT '0',
                      lastpost INT UNSIGNED NOT NULL DEFAULT '0',
                      lastposter VARCHAR(100) NOT NULL DEFAULT '',
                      lastposterid INT UNSIGNED NOT NULL DEFAULT '0',
                      lastpostid INT UNSIGNED NOT NULL DEFAULT '0',
                      lastthread VARCHAR(250) NOT NULL DEFAULT '',
                      lastthreadid INT UNSIGNED NOT NULL DEFAULT '0',
                      lasticonid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                      lastprefixid VARCHAR(25) NOT NULL DEFAULT '',
                      PRIMARY KEY (userid, forumid),
                      KEY (forumid)
                  )
                  MARK.B
                  vBulletin Support
                  ------------
                  My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                  My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                  Comment

                  • Tariq Rathore
                    Senior Member
                    • Mar 2008
                    • 337
                    • 3.8.x

                    #10
                    Done now I recreate all tachyable using above query just rename the table there were 3 tachy table were missing.
                    tachythreadcounter
                    tachyforumpost
                    tachynewthread
                    but when i uthread i am getting below error on Admincp
                    Database error in vBulletin 3.8.2:

                    Invalid SQL:
                    DELETE FROM tachythreadcounter WHERE threadid = 4;

                    MySQL Error : Unknown column 'threadid' in 'where clause'
                    Error Number : 1054
                    Request Date : Monday, February 22nd 2016 @ 05:41:50 AM
                    Error Date : Monday, February 22nd 2016 @ 05:41:50 AM
                    Script : http://www.mknexusonline.com/forums/...o=updatethread
                    Referrer : http://www.mknexusonline.com/forums/...php?do=chooser
                    IP Address : 113.203.235.250
                    Last edited by Tariq Rathore; Sun 21 Feb '16, 8:43pm.
                    Mortal Kombat Nexus
                    Pleae read before buying Ryan

                    Comment

                    • Mark.B
                      vBulletin Support
                      • Feb 2004
                      • 24286
                      • 6.0.X

                      #11
                      You cannot do that, different tables have different structures, you cannot just take the structure for one table and apply it to another.

                      So what other tables did you delete please? I need a full list. Every. Single One.
                      Otherwise your only option will be to restore from backup.

                      Please don't EVER randomly delete database tables from your database unless instructed to by support. You will break everything.
                      MARK.B
                      vBulletin Support
                      ------------
                      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                      Comment

                      • Tariq Rathore
                        Senior Member
                        • Mar 2008
                        • 337
                        • 3.8.x

                        #12
                        ok, i deleted others table except "tachyforumpost" now could you please tachythreadcounter, even all 3 tachytable because by mistake i deleted, so please help me to fix this issue so i can run my website proplery thankx.

                        below error getting post reply
                        DELETE FROM tachythreadpost
                        WHERE threadid = 6023;

                        MySQL Error : Table 'xxxx.tachythreadpost' doesn't
                        Mortal Kombat Nexus
                        Pleae read before buying Ryan

                        Comment

                        • Tariq Rathore
                          Senior Member
                          • Mar 2008
                          • 337
                          • 3.8.x

                          #13
                          Bump
                          Mortal Kombat Nexus
                          Pleae read before buying Ryan

                          Comment

                          • Mark.B
                            vBulletin Support
                            • Feb 2004
                            • 24286
                            • 6.0.X

                            #14
                            Code:
                            CREATE TABLE tachyforumcounter (
                              userid int(10) unsigned NOT NULL default '0',
                              forumid smallint(5) unsigned NOT NULL default '0',
                              threadcount mediumint(8) unsigned NOT NULL default '0',
                              replycount int(10) unsigned NOT NULL default '0',
                              PRIMARY KEY  (userid,forumid)
                            Code:
                            CREATE TABLE tachythreadpost (
                                userid INT UNSIGNED NOT NULL DEFAULT '0',
                                threadid INT UNSIGNED NOT NULL DEFAULT '0',
                                lastpost INT UNSIGNED NOT NULL DEFAULT '0',
                                lastposter VARCHAR(100) NOT NULL DEFAULT '',
                                lastposterid INT UNSIGNED NOT NULL DEFAULT '0',
                                lastpostid INT UNSIGNED NOT NULL DEFAULT '0',
                                PRIMARY KEY (userid, threadid),
                                KEY (threadid)
                            Code:
                            CREATE TABLE tachythreadcounter (
                              userid int(10) unsigned NOT NULL default '0',
                              threadid int(10) unsigned NOT NULL default '0',
                              replycount int(10) unsigned NOT NULL default '0',
                              PRIMARY KEY  (userid,threadid)
                            MARK.B
                            vBulletin Support
                            ------------
                            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                            Comment

                            • Tariq Rathore
                              Senior Member
                              • Mar 2008
                              • 337
                              • 3.8.x

                              #15
                              getting error in all above tables
                              #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5

                              Mortal Kombat Nexus
                              Pleae read before buying Ryan

                              Comment

                              Related Topics

                              Collapse

                              Working...