Announcement

Collapse
No announcement yet.

LOCK TABLES cms_node

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

  • [CMS] LOCK TABLES cms_node

    Hi - i would appreciate an answer on:
    http://www.vbulletin.com/forum/showt...45#post1886145

    The problem occurs on my installation as well - with final version.
    No answer was given for the beta version.

    Since it is a problems issue maybe you should also move it here and delete this thread.

  • #2
    same
    while(true){
    if(
    $someone->needsHelp() && $i->canHelp()) $post->help();
    if(
    $i->findBug()) $post->bug();
    }

    Comment


    • #3
      OK here is the solution to the problem.

      I have been using an old version of SQLyog to manage the permissions on the tables.
      The old version didn't include the permission for LOCK TABLES hence it was not updated.
      Although you thought you had set permissions for everything on the database - that wasn't true.

      I updated to latest community version of sqlyog and then i saw that there were 5-6 more permissions - including LOCK TABLES.
      I updated the user with those permissions as well and now it works.

      Comment


      • #4
        I've installed CMS 4.0.8 from scratch on a Linux system and I receive the same error.

        I have not understood the solution, can you help me?

        Thank you in advance

        Comment


        • #5
          You need to give your database user permissions to lock tables. Your hosting provider can assist with assigning permissions on MySQL if you're not using CPanel or a similar control panel.
          Translations provided by Google.

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

          Comment


          • #6
            Originally posted by Wayne Luke View Post
            You need to give your database user permissions to lock tables. Your hosting provider can assist with assigning permissions on MySQL if you're not using CPanel or a similar control panel.
            Hi Wayne thank you for your support.

            Can I give my database user permissions to lock table with phpmyadmin?

            Thank you again.

            Comment


            • #7
              Only if you can log in with a user capable of assigning permissions like a root user. Usually phpMyAdmin is restricted.
              Translations provided by Google.

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

              Comment


              • #8
                Originally posted by Wayne Luke View Post
                Only if you can log in with a user capable of assigning permissions like a root user. Usually phpMyAdmin is restricted.
                OK

                The problem has been fixed with the help of my hosting provider

                Comment


                • #9
                  I am using 4.1.1 and having this same error and when I check permissions, my db user HAS lock table permissions?
                  Last edited by biancolaw; Thu 13 Jan '11, 7:52am.

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X