Difficulty installing Drupal through Softaculous

Asked by:
ryrobert / 8 Points
2013-05-30 9:58 am EST
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?

To ask this user for more information, please first login.

To submit an answer, please login.



16,266 Points
2013-05-30 11:12 am EST
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

To submit a comment on this answer, please first login.

Thanks for your help, Scott. I figured out what I was doing wrong. I tracked the problem down to using a hyphen ('-') in the table prefix in the softaculous setup. When I get rid of the hyphen, I don't get the error.

Always the details that matter!


8 Points

2013-05-30 12:05 pm EST
Hello Ryan,

I'm glad it led you to a solution! Now that I know exactly what happened I am able to create the exact error. I will be sure to write an article about that error and how to fix it for anyone else that may run across it. Thank you for getting back with us!

Best Regards,
Scott M
16,266 Points
2013-05-30 12:22 pm EST

2013-05-31 3:07 am EST

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.

To submit a comment on this answer, please first login.

Want to share this Question?

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.