I am getting wiered Database errors, Help me fix it!!

Discussion in 'PHP' started by Jash Wani, Dec 13, 2010.

  1. #1
    My site is displaying some kind of message in every page

    INSERT command denied to user 'db13131'@'7.08.18.104' for table 'urls'
    INSERT INTO `urls` SET uid='', url='http://mysite.com', time='1292275555'

    or

    INSERT command denied to user 'db13131'@'7.08.18.104' for table 'clicks'
    INSERT INTO `clicks` SET urlid='3299', fromm='http://mysite.com/links.html', ip='mine', time='1292276172'

    What kind of error is this?? And how to fix it!!
     
    Jash Wani, Dec 13, 2010 IP
  2. olddocks

    olddocks Notable Member

    Messages:
    3,275
    Likes Received:
    165
    Best Answers:
    0
    Trophy Points:
    215
    #2
    have you assigned the CREATE permissions to the database user? you should select ALL in your cpanel under mysql section.
     
    olddocks, Dec 13, 2010 IP
  3. Jash Wani

    Jash Wani Peon

    Messages:
    135
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I dnt have cpanel, i use 1and1.com, which uses phpmyadmin. no such thing there!!
     
    Last edited: Dec 13, 2010
    Jash Wani, Dec 13, 2010 IP
  4. olddocks

    olddocks Notable Member

    Messages:
    3,275
    Likes Received:
    165
    Best Answers:
    0
    Trophy Points:
    215
    #4
    doesnt matter. use phpmyadmin and see what permissions are assisgned for the user db13131 to that particular database. if you can edit, be sure you tick insert.
    since you are getting "INSERT command denied to user" its defiitely got to do with the database access permissions given to the user.
     
    olddocks, Dec 14, 2010 IP
  5. senth

    senth Peon

    Messages:
    53
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Definitely this is permission issue.
    When you assign user to database, you might have missed to select that option.
     
    senth, Dec 16, 2010 IP
  6. openbytes

    openbytes Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You have to gran permissions to that user
     
    openbytes, Dec 16, 2010 IP
  7. Jash Wani

    Jash Wani Peon

    Messages:
    135
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I got it figured out, my limit was 150 mb, it exceeded that limit, so had to upgrade!! thanks for your suggestions guys!! :)
     
    Jash Wani, Dec 17, 2010 IP
  8. AcevedoAaron

    AcevedoAaron Peon

    Messages:
    49
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    try to reinstall you pages also cheek your mysql and other related database system you are using.otherwise you can make search on google for more result.
     
    AcevedoAaron, Dec 17, 2010 IP