Announcement

Collapse
No announcement yet.

MySQL Error

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

  • MySQL Error

    Hey,

    I was changing the view permissions of several of my forums today, when it suddenly started giving me this error message...

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    ### INSERT QUERY GENERATED BY fetch_query_sql() ###
    INSERT INTO forumpermission
    (usergroupid, forumpermissions, forumid)
    VALUES
    ('1', '131075', '7')
    mysql error: Duplicate entry '1-7' for key 2

    mysql error number: 1062

    Date: Wednesday 08th of June 2005 04:29:49 AM
    Script: http://www.tokyomonsters.com/forums/...permission.php
    Referer: http://www.tokyomonsters.com/forums/...o=edit&f=7&u=1
    Username: James Ballard
    IP Address: **.**.***.***
    A bit akward now, as I was half way through changing them, and now my guests can't see anything.

    Thanks in advance for any advice. I'm a total noob with MySQL stuff.
    - James Ballard

  • #2
    Nevermind, I figured it out in PHP Admin. Sorry for wasting your time

    Comment


    • #3
      Glad you got it fixed You had an additional index on the column?

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X