Announcement

Collapse
No announcement yet.

DELETE FROM tachyforumpost

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

  • Paul M
    replied
    Good.

    In future, dont randomly delete things when you dont really understand what you are doing - it never works out well.

    Leave a comment:


  • Tariq Rathore
    replied
    Fixed now all things

    Leave a comment:


  • Mark.B
    replied
    Make sure you remove the tables you created incorrectly first.

    Leave a comment:


  • Tariq Rathore
    replied
    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

    Leave a comment:


  • Mark.B
    replied
    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)

    Leave a comment:


  • Tariq Rathore
    replied
    Bump

    Leave a comment:


  • Tariq Rathore
    replied
    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

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • Tariq Rathore
    replied
    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.

    Leave a comment:


  • Mark.B
    replied
    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)
    )

    Leave a comment:


  • Tariq Rathore
    replied
    Bump please share table query?

    Leave a comment:


  • Tariq Rathore
    replied
    I have backup from Last September 2015 that's why i am asking how to make table via query?

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • Tariq Rathore
    replied
    Plz Someone response but my site not works since 12th February

    Leave a comment:


  • Tariq Rathore
    replied
    What is recreate table query?

    Leave a comment:

Related Topics

Collapse

Working...
X