1. To0

    To0 New Member

    Feb 11, 2008
    2,271
    I am receiving an error when trying post a NEW THREAD on my forum. This error also occurs when trying to make a post. The forum will show the thread after the error occurs and will update the forum to show the number of threads, but will not update the number of posts.


    Error:

    Here's what I have done to try and resolve the issue so far..
    1.) Repaired / Optimized Tables - Didn't fix the error.
    2.) Turned off all plugins / hooks - Didn't stop the error.
    3.) Ran Queries to create proper indexes for all the tables - Didn't fix the error


    I am unsure as to what is causing the issue as usually this is caused by a plugin/hook, but like I said I disabled the plugin/hook system and it still has the error.


    If anyone can help me I'd appreciate it.


    Thanks in advance!
     
  2. blinkracer

    blinkracer New Member Member

    Jan 27, 2011
    307
    primary key must be unique, and the value 12 exist in your database.
    make "post id" in auto increment
    (sorry for my bad English)
     
  3. perfectRDP

    perfectRDP New Member Member

    Aug 3, 2013
    206
    I believe indexes and auto-increments were removed from post and thread
     
  4. Gavo

    Gavo Super Moderator Staff Member

    Jul 9, 2009
    3,151
    You don't need the data in that table, try to truncate it, if that doesn't fix it re-create the table
    PHP:
    CREATE TABLE IF NOT EXISTS `vb_postlog` (   `postidint(10unsigned NOT NULL DEFAULT '0',   `useragentchar(100NOT NULL DEFAULT '',   `ipint(10unsigned NOT NULL DEFAULT '0',   `datelineint(10unsigned NOT NULL DEFAULT '0',   PRIMARY KEY (`postid`),   KEY `dateline` (`dateline`),   KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
     
  5. -sky-

    -sky- New Member Member

    Oct 23, 2011
    799
    go to phpmyadmin and emty the postlog
     

Share This Page