Database error in vBulletin 5.0.5 -

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jradar
    New Member
    • Dec 2011
    • 5
    • 4.1.x

    Database error in vBulletin 5.0.5 -

    I have no idea what to do with this? can someone please point me in the right direction? thanks!

    Database error in vBulletin 5.0.5:


    Invalid SQL:
    INSERT INTO firewire_searchtowords_t (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (40258,1014,0,10000,35)
    /**searchtowords_t**/;

    MySQL Error : Duplicate entry '1014-40258' for key 'wordid'
    Error Number : 1062
    Request Date : Friday, November 29th 2013 @ 05:47:46 PM
    Error Date : Friday, November 29th 2013 @ 05:47:46 PM
    Script : http:///f/create-content/Text/
    Referrer : http://www.firewiresurfboards.com/f/...674-uni-sizing
    IP Address : 111.240.186.217
    Username : Goodfish
    Classname : vB_Database_MySQLi
    MySQL Version :
    1. vBulletin Version: 5.0.5
    2. PHP Version: 5.4.20
    3. MySQL Version: 5.5.34-log
    4. Any Addons installed: no
    5. Does the issue occur in a default style? yes
    6. Error message on the screen: Invalid SQL:
    7. Browser and Browser version used.: unkown
    8. A list of steps that can be used to recreate the issue.: unknown
  • mbozio
    Member
    • Mar 2002
    • 55
    • 5.0.X

    #2
    Same error as reported here --> http://www.vbulletin.com/forum/forum...se-error-email

    no answer... yet ?

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73979

      #3
      Has to do with auto_increment values. What is the auto_increment set to on your words table? You should make sure this is higher than your max wordid value.

      You can find the auto_increment for the table by running this query:
      Code:
      SELECT AUTO_INCREMENT FROM information_schema.tables WHERE TABLE_NAME = 'words' and TABLE_SCHEMA = '%DATABASENAME%'
      ​
      You need to replace %DATABASENAME% with your database.

      You can find out the max wordid with this query:
      Code:
      SELECT max(wordid) FROM words.
      The Auto_increment value needs to be higher.. You can update it with this query:
      Code:
      ALTER TABLE tbl AUTO_INCREMENT = XXXX;
      Where XXXX is the value your want.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      • Jradar
        New Member
        • Dec 2011
        • 5
        • 4.1.x

        #4
        thanks for this help! i will try

        Comment

        Related Topics

        Collapse

        Working...