mysql error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mazinger
    Senior Member
    • Jul 2005
    • 2399
    • 3.7.x

    mysql error

    Code:
    MySQL Error   : INSERT command denied to user for table 'datastore'
    $post[signature]
  • IBxAnders
    Senior Member
    • Aug 2001
    • 1172
    • 4.0.x

    #2
    Not sure what the question is exactly; the user does not have or lost the access privileges.
    anders | vbulletin team | check out the new vbulletin facebook app
    Proudly vBulletin'ing since 2001
    Please be my friend!
    http://www.twitter.com/inetskunkworks
    vBulletin Performance Articles:
    Click here to read

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      You need to grant your user access to run the INSERT command, more or less you'll need most privlages except for maybe flush on your vbulletin MySQL user.

      Comment

      • Mazinger
        Senior Member
        • Jul 2005
        • 2399
        • 3.7.x

        #4
        That error appears to a user with an admin privileges, so I'm pretty sure it has whatever privileges needed.

        I think this is a problem with that table, but I don't know how to fix it even I can't log into the admincp.
        $post[signature]

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          Its an issue with the mysql user and his permissions on the database.

          Comment

          • Mazinger
            Senior Member
            • Jul 2005
            • 2399
            • 3.7.x

            #6
            Yeah, I was thinking about this too.

            The solution?
            $post[signature]

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24325
              • 5.7.X

              #7
              Have you tried creating a new user then updating the config.php file to use the new details?
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • Mazinger
                Senior Member
                • Jul 2005
                • 2399
                • 3.7.x

                #8
                Unfortunately, I'm hosted with Servage so there's limitations with such options.

                Anyway I'll consider contacting them since it's a pure database error.
                $post[signature]

                Comment

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