Announcement

Collapse
No announcement yet.

Database error in vBulletin 5.0.5 -

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

  • 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

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

    no answer... yet ?

    Comment


    • #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 - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        thanks for this help! i will try

        Comment

        Related Topics

        Collapse

        Working...
        X