Community Q&A:
Difficulty installing Drupal through Softaculous
I have an account that I use often for sandboxing and dev of sites that I'm working on. At webhostinghub, I have never been able to install Drupal (my CMS of choice for most sites) with softaculous successfully. I have made several successful manual installations, but would like to not have to do that every time I start a new site. Whenever I try to install through softaculous, it will complete the installation, but when I go to the site I get the following error:
Uncaught exception thrown in shutdown function.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-semaphore WHERE (value = '104100677751a7596608c8a3.28790430')' at line 1: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 104100677751a7596608c8a3.28790430 ) in lock_release_all() (line 269 of /home/ourcra5/public_html/rtb/includes/lock.inc).
I've tried some basic troubleshooting, but can't find the root of the error. Any suggestions?
Uncaught exception thrown in shutdown function.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-semaphore WHERE (value = '104100677751a7596608c8a3.28790430')' at line 1: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 104100677751a7596608c8a3.28790430 ) in lock_release_all() (line 269 of /home/ourcra5/public_html/rtb/includes/lock.inc).
I've tried some basic troubleshooting, but can't find the root of the error. Any suggestions?
ANSWERS
|
0
|
Hello ryrobert, I have tested installations for Drupal on both y own private server and the production servers. I cannot duplicate the error. I can tell you what it means, however. The error is saying that there is a syntax error in the database statement it is trying to execute. This occurs most often when either a text is used for a number field, or vice-versa. It can also occur if a 'reserved' word is included without backticks (``) around it, however I see no reserved words in the query. My guess is it is something in the settings that is offsetting the syntax in the query. Without being able to log into your account and perform the install, I cannot say for sure. If you can list the exact settings you are entering when installing (barring any security information such as username or password) I could try again on my testing platform. Alternatively, you can send me the username and password for your cpanel, along with verification of the account (either current AMP password or last 4 of the current credit card on file) and I can then log into your account directly and perform the install, tracking the steps to see where it fails. Should you choose to do so, send it directly to docs@webhostinghub.com and then comment below that it was sent, Best Regards, Scott M
|
|
0
|
Hi, I am from the Softaculous team. We have added validation for table prefix to allow only alphanumeric characters and _ This will be available in the next version of Softaculous which will be launched this week. Thanks for pointing towards this issue. |
Want to share this Question?
Tweet
Help Center Login
Related Articles
It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
