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

Jumpstart your Angular applications with Indigo.Design, a unified platform for visual design, UX prototyping, code generation, and app development.

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

Take a look at an Indigo.Design sample application to learn more about how apps are created with design to code software.


Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}