By JLambrecht on

Hi,

While i've done so for several older versions this time i cannot get around the installation proces for drupal. To me the error is not really meaningfull at any stage. I'm no drupal developer.

I've read the installation notes and acted accordingly by copying > settings.php

Path = /var/www/drupal6 and /var/www/drupal7 respectively.
System = Debian Lenny

MySQL 5. 0.51a
Apache 2.2.9
php5 5.2.6 with suhoshin patch

For Drupal6 - gives a warning regarding menu.inc line 315 then fails to proceed.

Process then stops after installing datase or Configure

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 2: SELECT menu_router.* FROM {menu_router} menu_router WHERE (path IN ()) ORDER BY fit DESC LIMIT 0, 1; Array ( ) in menu_get_item()

Best Regards,

J.L.

⋅ Categories: Drupal 6.x, Drupal 7.x

Comments

JLambrecht’s picture

JLambrecht commented

Fix was to convert mysql to innodb

JLambrecht’s picture

JLambrecht commented

overcourageously I retried the installation proces and saw it fail

This is what i get. The first install worked but later with /batch?q=..... something, ajax error 403 ... something

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 443 of /var/www/drupal7/includes/menu.inc).

This is awfull. If anything i can do to help locate or document the problem let me know.

JLambrecht’s picture

JLambrecht commented

line 25 in .htaccess was missing a closing "

test = added install.php to line 29

JLambrecht’s picture

JLambrecht commented

i've retried for drupal installation after the language selection, this shows the configuration page

clicking on continue results in a blank page
reload of the blank page results in Drupal Allready installed notification like from update.php

JLambrecht’s picture

JLambrecht commented

on a Debian system the solution is one or more off

{required}

define
cookie_domain in settings.php with your domainname for the site to be installed
also
set session.cookie.secure=0 in /etc/php5/apache2/php.ini
when not running over an https host http://drupal.org/https-information

{recommended} or any value between 16 and equal to 64M

memory_limit = 64M ; Maximum amount of memory a script may consume (16MB)

{possible} *** ? temporary disable mod-security ? at install time ****

max_execution_time = 0 ; Maximum execution time of each script, in seconds
;max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 560 ; Maximum amount of time each script may spend parsing request data
;max_input_time = 60 ; Maximum amount of time each script may spend parsing request data

make sure libapache2-mod-auth-mysql is installed

{apache2.2}

DocumentRoot "/var/www/drupal7/"
ServerName hosting.domain.tld
AccessFileName .htaccess

RewriteEngine on
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
DirectoryIndex index.php
Options +FollowSymLinks +Indexes
AllowOverride All
Order Deny,Allow
Allow from All