When I tried to install Drupal 7, I got an error message below, or you can look at the screenshot I took:
"An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: http://d7.signwo.com/install.php?profile=standard&locale=en&id=1&op=do StatusText: Service unavailable (with message) ResponseText: 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 /home/signwo/tester/d7/includes/menu.inc)."

The installation carries on when you ignore the message, but it would be better if
1. The script should suggest a relevant solution for this error
2. The "continue to the error page" link should not take you the next installation step

related D7 issues:
https://www.drupal.org/node/1406868
https://www.drupal.org/node/1318304

related D8 issues:
https://www.drupal.org/node/2021029

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bfroehle’s picture

Status: Active » Closed (duplicate)

I'm pretty confident that this is the same issue as #619542: Malformed theme .info files break menu_router generation. Please read through the comments there, especially post #30 and if you want, try applying the patch in #33.

I'm going to mark this issue as a duplicate of that issue, but feel free to set back to active if you think your problem is different.

hmartens’s picture

I'm also struggling with this and bfroehle could not be more wrong :)

I'm trying to install Drupal 7.9 and get this error message straight after the "Set up database" step. I've looked at so many google entries and still nowhere near getting it right...

Note that this is a clean install and not an update...so there shouldn't really be any problems!

I hope someone can shed some proper light on this :)

hmartens’s picture

Ok I found the fix...well the one that sorted out my problem...In cPanel or KonsoleH whatever you are using with your service provider to log into your hosting package...go to your php Config Tool and increase the Memory limit and Maximum execution time PHP variables.

That fixed the problem for me :)

estepix’s picture

I had a similar issue but adding an extra language to Drupal, it seems to be a timeout problem, according to Apache logs:

[Fri Nov 11 20:14:01 2011] [warn] [client 111.222.333.444] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: http://example.com/batch?op=start&id=5&render=overlay
[Fri Nov 11 20:14:01 2011] [error] [client 111.222.333.444] Premature end of script headers: index.php, referer: http://example.com/batch?op=start&id=5&render=overlay

It happened to me using Apache + FCGI + ISPConfig, in order to fix it you need to apply a few directives to your virtual host.
1. ISPConfig: if you are using this software:

  • Login to your ISPConfig Web interface
  • Go to Sites > Websites > Your site > Options
  • And add these lines to Apache directives section:
<IfModule mod_fcgid.c>
  IPCCommTimeout 900
  FcgidMaxRequestLen 20971520
</IfModule>
  • Then click save.
  • 2. Otherwise just manually edit your virtual host file, add the directives above and reload apache:
    /etc/init.d/apache2 reload

    Note: you can increase the Directives values as required.

    You might also need to uncomment the following lines in your cgi script:

    vim /var/www/php-fcgi-scripts/<web-site>/.php-fcgi-starter
    PHP_FCGI_CHILDREN=8
    export PHP_FCGI_CHILDREN
    donok’s picture

    The fix for me was to quite and reopen MAMP (clean new local site Commerce Quickstart 7.12)

    infohari’s picture

    hi u may be create the data base first and then instal the drupal

    UrmasZ’s picture

    When getting errors while installing, try refreshing the page. Depending on error(memory problem) installing just continues.

    msamavi’s picture

    Thanks estepix, your fix worked for me.

    ubuntu277’s picture

    I got this error while installing Drupal 7 on MAMP 2.1.1

    dcrocks’s picture

    There is an interesting comment in the menu_get_item function in both drupal 7 and 8:

    Rebuild if we know it's needed, or if the menu masks are missing which occurs rarely, likely due to a race condition of multiple rebuilds.

    It just may be that 'rare' != 0. This should be closed or a bug reported on menu_get_item.

    klonos’s picture

    Version: 7.0 » 7.x-dev
    Status: Closed (duplicate) » Active

    ...turns out this is not a duplicate of #619542: Malformed theme .info files break menu_router generation and it still occurs (using latest dev of core). So, back to active.

    klonos’s picture

    I just got this error in a D7 installation while trying to enable translation for a custom field in the user profile (using Profile 2):

    An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /el/batch?id=61&op=do StatusText: Internal Server Error ResponseText:

    Translation for the field was successfully enabled. The very same error occurred when I tried to disable translatability of the same field, but this time translation was not disabled successfully.

    I am using a custom theme, so I switched to a core one (Bartik) and tried disabling translation for the same field. Still the same error. So, I guess this was not my theme's fault after all.

    Switched back to my custom theme, I applied the patch for D7 from #619542-87: Malformed theme .info files break menu_router generation:

    patching file modules/system/system.admin.inc
    Hunk #1 succeeded at 176 (offset 8 lines).
    Hunk #2 succeeded at 2749 (offset 80 lines).
    patching file modules/system/system.module
    Hunk #1 succeeded at 2509 (offset 39 lines).

    ...I did get a few hunks but it applied ok. Tried to disable translation of the custom field again and still got the same AJAX HTTP error.

    Any clues?

    klonos’s picture

    swentel’s picture

    Well, if the errors happens due to a contrib module, then you'll have to search there, because core doesn't even have the ability to set translations on a field. Also, there's a patch in the issue mentioned in #13 - which doesn't mean it will solve the AJAX error though.

    Are there any messages in the error log, that should at least give a clue, because status 500 is an internal server error, so it's PHP (or maybe apache) dying somewhere, and I'm pretty sure it's not core here at fault.

    swentel’s picture

    Status: Active » Closed (duplicate)

    Ok, so you actually have the error report, see http://drupal.org/node/1370900#comment-7180388 - that's not core's fault.

    klonos’s picture

    ...yeah, sorry. I needed to test things a bit further before coming back here to close it again. Sorry for the noise.

    adamcowboy’s picture

    Version: 7.x-dev » 8.x-dev

    This is also a problem with drupal 8:

    -I dropped and recreated database
    -I deleted settings.php
    -I ran the installer and got this error at step 37

    (refreshing the page continues the process and gets through 37 however it again stops at 39 and will not progress any further).

    DesireRoberts’s picture

    Any fix for this? I'm having the same issue with an URGENT Wordpress Migration...

    priyankprajapati’s picture

    Issue summary: View changes
    Status: Closed (duplicate) » Active
    swentel’s picture

    Status: Active » Closed (duplicate)

    Please don't reopen issues without any further information.

    Sahin’s picture

    Title: An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows... » During install, "An AJAX HTTP error occurred. HTTP Result Code: 500..."
    Project: Drupal core »
    Version: 8.0.x-dev »
    Component: system.module » Code
    Issue summary: View changes
    Priority: Critical » Normal
    Status: Closed (duplicate) » Active
    Issue tags: +#installation
    FileSize
    1005.33 KB

    For the error message see the attached image.

    Environment:
    * D7.34
    * PHP 5.5.6 / Upload progress: Not enabled (Your server is not capable of displaying file upload progress. File upload progress requires PHP be run with mod_php and not as FastCGI.)
    * Apache 2.4.7 (Win64) mod_fcgid/2.3.9
    * MySQL 5.6.14

    Some suggestions although unnecessary imho I've tried but didn't work are,

    1. increase the php memory limits by editing the following lines in the php.ini file as:
      max_execution_time = 30 --> 60 ;
      memory_limit = 32 --> 128, or even 256M ;
    2. add the following lines to the end of .htaccess file:
      php_value auto_append_file none
      php_value memory_limit 128M
    3. edit ProgramData/MySQL/MySQL Server 5.6/my.ini file to increase "max_allowed_packet" from 4M to 32M or even to 64M
    4. verify that your database tables are utf8_general_ci or utf8_*
    David_Rothstein’s picture

    Project: » Drupal core
    Version: » 8.0.x-dev
    Component: Code » system.module
    Status: Active » Closed (duplicate)

    If this is still an issue, I would recommend checking the PHP logs on the server for any error messages. It is going to be really hard to debug without that.

    This is still likely a duplicate of something else, so I'm restoring that status for now (and putting this back in the correct queue).