I am running Drupal 7.34 in a Linux based shared hosting environment provided by GoDaddy. I begin receiving the following error whenever I load the page after working with my hosting provider to fix a network traffic violation caused by a table that had exceeded size restrictions.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ' [USER NAME] '@' [IP] ' for table 'semaphore': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home/content/37/11927937/html/includes/lock.inc).
Uncaught exception thrown in shutdown function.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1143 SELECT command denied to user ' [USER NAME] '@' [IP] ' for column 'value' in table 'semaphore': DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 208955237357760858eabe70.46766654 ) in lock_release_all() (line 269 of /home/content/37/11927937/html/includes/lock.inc).
Prior to this issue the site has been stable for several months and I have not made any module or database changes in the last two weeks. I can access the database through phpMyAdmin and the data appears to be intact. However on some of the tables, including the semaphore table referenced in this error I can view the table structure, but cannot browse the actual data (option is grayed out).
The first Godaddy representative I spoke with seemed confident that this was a database permission issue, after consulting another department he told me that the issue was resolved, and my site was restored. An hour after hanging up it went down with the same error. The second representative told me that the database permissions were fine and that I should perform the repair table action on the affected tables. However, the storage engine is InnoDB and the repair table action cannot be performed. The third representative also consulted another department and then informed me that this was a Drupal script problem, not a permission issue, had nothing to do with Godaddy’s earlier action and essentially told me to stop calling. In the midst of this conversation the site came back up and then went down again around an hour later with the exact same error and behavior, over the last 6 hours is has not been up at all, so this is not an intermittent issue.
I have tried restoring the effected table from a backup, but nothing changed. During the brief time I was able to login to the site everything appeared to be operating correctly.
I am at a loss here, based on my admittedly limited knowledge this really does seem like a permission issue on my host’s end. I am hoping someone can point me in the direction of a solution or help me understand what might cause this error.
Comments
It looks like some sort of
It looks like some sort of permission in accessing the {semaphore} table. Ask Godaddy to look at that.
I agree it does look like a
I agree it does look like a permission issue, but how do I convince someone at Godaddy of that? The last two representatives I talked to were set on the idea that it is my problem not theirs and seemed to think that since I can log in to phpMyAdmin the database is fine on their end – even after I explained that I can’t actually access the data in some tables. The fact that the browse option was disabled on the semaphore table and the error references that specific table didn’t seem to mean anything to them.
PDOException: SQLSTATE[42000]: Syntax error or access violation:
Were you able to fix your issue.. Im having the same issue with go daddy.
Re:It looks like some sort of
You should connect with godaddy . This issue is related database permission.