TurnKey Linux Virtual Appliance Library

Drupal 6 CD Boot not working (SOLVED)

gnomic's picture
gnomic - Sun, 2009/04/05 - 11:19

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.

‹ File Server Virtual Appliance - Extplorer fails out of the box Revision Control ›
alon's picture

Drupal6 installation requires client side scripting enabled

Alon Swartz - Sun, 2009/04/05 - 11:17.
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.
pier's picture

How to reinstall

pier - Mon, 2009/05/04 - 22:32.
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's picture

Pretty much

Liraz Siri - Mon, 2009/05/04 - 22:57.
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.
pier's picture

If I want to erase the former instals ?

pier - Tue, 2009/05/05 - 17:40.
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 ?
frank0987's picture

Post it at drupal.org

frank0987 - Mon, 2009/06/22 - 23:19.
I recommend that it should be reported at drupal.org, it seems to be drupal itself, not Turnkey.
Guest's picture

You have to allow cookies

al - Sun, 2009/08/23 - 12:42.

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

Guest's picture

Huge thanks for the answers

HenrickB - Thu, 2009/10/29 - 23:55.

Huge thanks for the answers guys. I had the similar problem few weeks ago and thanks God that I have found this blog and this question with provided answers. I wanted to isntall Drupal so badly, and now, after reading your useful tips, I have succeded in that. Thanks one more time for your help.

 

Sincerely,

 

Henrick Buddson from software development company

Guest's picture

All the bugs have been solved

Dulcher - Fri, 2012/02/03 - 11:44.

All the bugs have been solved in later versions of Drupal.

____________

Dulcher from iPhone developer program

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)