TurnKey Linux Virtual Appliance Library

Drupal 6 CD Boot not working (SOLVED)

I boot off of the Drupal 6 CD and can login as root to the admin page. Everything seems to be working.

I login to the user page, select the only option I can "Install Drupal in English" and get this error immediately.

  • user warning: 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 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /usr/share/drupal6/includes/menu.inc on line 315.
  • user warning: 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 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /usr/share/drupal6/includes/menu.inc on line 315.

Suggestions? MySQL appears to be running.

Alon Swartz's picture

Drupal6 installation requires client side scripting enabled

This happens if the installation fails.

I managed to replicate the same issue as you mentioned above by configuring my browser to forbid script execution, which is the default configuration when using the firefox extension - noscript.

This issue should be fixed upstream, in the drupal6 installation itself by requiring scripting and not proceeding with it. I'll file a bug report.

In the meantime, just reinstall the appliance and allow scripting in your browser prior to clicking "Install Drupal in English".

Side note: If you really don't want to re-install the appliance (which I urge you to do), you can drop the drupal6 database, the reconfigure the drupal6 package to recreate the database: dpkg-reconfigure drupal6

I'll make a note of this on the appliance page, thanks for reporting it.

How to reinstall

Hi,
I need to reinstall drupal. Is it just running a new VM from within Virtualbox with the same settings as the former installation in order to supercede it?
Liraz Siri's picture

Pretty much

The VMs are isolated from one another (like separate physical machines), so it doesn't matter that you previously tried to install Drupal in another VM. Just start over in a fresh instance.

If I want to erase the former instals ?

It seems to work after much ado.
What if I want to get rid of the instals that are not working and that I meant to replace ?
Shall I just delete the .iso ?
What about the directories and dynamic virtual hard disks ?

You have to allow cookies

You have to allow cookies before starting the install process. Would be nice if drupal had a little warning.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)