Announcement

Collapse
No announcement yet.

DELETE FROM tachyforumpost

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

  • 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

  • #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


    • #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


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

        Comment


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

          Comment


          • #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

            TalkNewsUK - My vBulletin 5.5.2 Demo
            AdminAmmo - My Cloud Demo

            Comment


            • #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


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

                Comment


                • #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

                  TalkNewsUK - My vBulletin 5.5.2 Demo
                  AdminAmmo - My Cloud Demo

                  Comment


                  • #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 21st Feb '16, 8:43pm.
                    Mortal Kombat Nexus
                    Pleae read before buying Ryan

                    Comment


                    • #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

                      TalkNewsUK - My vBulletin 5.5.2 Demo
                      AdminAmmo - My Cloud Demo

                      Comment


                      • #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


                        • #13
                          Bump
                          Mortal Kombat Nexus
                          Pleae read before buying Ryan

                          Comment


                          • #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

                            TalkNewsUK - My vBulletin 5.5.2 Demo
                            AdminAmmo - My Cloud Demo

                            Comment


                            • #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...
                              X