Over a million developers have joined DZone.

Problems setting up Drupal? Maybe this will Help

DZone's Guide to

Problems setting up Drupal? Maybe this will Help

· Web Dev Zone ·
Free Resource

Learn how error monitoring with Sentry closes the gap between the product team and your customers. With Sentry, you can focus on what you do best: building and scaling software that makes your users’ lives better.

I sometimes feel that I have an uncanny affinity for problems. Almost nothing that I do, seems to work on the first go.

Lets take for instance, Installing and creating Drupal on my local machine.

I am using Drupal 7.4.4.

I got this cool error when I tried to import drupal.


The website encountered an unexpected error. Please try again later.

Error message

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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1: SELECT * FROM {menu_router} WHERE path IN () ORDER BY fit DESC LIMIT 0, 1; Array ( ) in menu_get_item() (line 445 of D:\personal\drupal\drupal-7.4\includes\menu.inc).

Now that is frickin cool because, I dont know head or tail of drupal and I was simply following instructions from a video tutorial from youtube. And it seemed to work out quite nicely there.

So, what I did was, when trying to import, i changed the sub domain name and the database name to REMOVE the underscore.

Now, i really like underscores. They work well in linux and in windows. Since using spaces for directory names in windows is one of the worst habits that you can have as a developer, underscores became kind of my closest friends.

But oh no, this damn thing wont accept underscores. Anyways, so I had to simply do it without the underscore and now the hostname looks like a congested orgy of characters. I guess Ill just have to deal with it that way!

So, if you have this same problem, you now know how to deal with it.

If it still does not work our for you, take a peek at this

Happy Programming :)
Signing Off

Ryan Sukale

What’s the best way to boost the efficiency of your product team and ship with confidence? Check out this ebook to learn how Sentry's real-time error monitoring helps developers stay in their workflow to fix bugs before the user even knows there’s a problem.


Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}