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
Comment | File | Size | Author |
---|---|---|---|
#22 | Drupal--An AJAX HTTP error occurred.png | 1005.33 KB | Sahin |
Comments
Comment #1
bfroehle CreditAttribution: bfroehle commentedI'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.
Comment #2
hmartens CreditAttribution: hmartens commentedI'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 :)
Comment #3
hmartens CreditAttribution: hmartens commentedOk 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 :)
Comment #4
estepix CreditAttribution: estepix commentedI had a similar issue but adding an extra language to Drupal, it seems to be a timeout problem, according to Apache logs:
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:
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:
Comment #5
donok CreditAttribution: donok commentedThe fix for me was to quite and reopen MAMP (clean new local site Commerce Quickstart 7.12)
Comment #6
infohari CreditAttribution: infohari commentedhi u may be create the data base first and then instal the drupal
Comment #7
UrmasZ CreditAttribution: UrmasZ commentedWhen getting errors while installing, try refreshing the page. Depending on error(memory problem) installing just continues.
Comment #8
msamavi CreditAttribution: msamavi commentedThanks estepix, your fix worked for me.
Comment #9
ubuntu277 CreditAttribution: ubuntu277 commentedI got this error while installing Drupal 7 on MAMP 2.1.1
Comment #10
dcrocks CreditAttribution: dcrocks commentedThere 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.
Comment #11
klonos...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.
Comment #12
klonosI 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:
...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?
Comment #13
klonos...at the same time, I get this: #1370900: Fatal Error: Cannot access empty property in /sites/all/modules/entity_translation/includes/translation.handler.inc
Comment #14
swentel CreditAttribution: swentel commentedWell, 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.
Comment #15
swentel CreditAttribution: swentel commentedOk, so you actually have the error report, see http://drupal.org/node/1370900#comment-7180388 - that's not core's fault.
Comment #16
klonos...yeah, sorry. I needed to test things a bit further before coming back here to close it again. Sorry for the noise.
Comment #17
adamcowboy CreditAttribution: adamcowboy commentedThis 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).
Comment #18
bannorb CreditAttribution: bannorb commentedRelated: #2021029: During Install, Inform User that they have Insufficient Memory Rather than Server Error: AJAX HTTP Result Code: 500
Comment #19
DesireRoberts CreditAttribution: DesireRoberts commentedAny fix for this? I'm having the same issue with an URGENT Wordpress Migration...
Comment #20
priyankprajapati CreditAttribution: priyankprajapati commentedComment #21
swentel CreditAttribution: swentel commentedPlease don't reopen issues without any further information.
Comment #22
Sahin CreditAttribution: Sahin commentedFor 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,
max_execution_time = 30 --> 60 ;
memory_limit = 32 --> 128, or even 256M ;
php_value auto_append_file none
php_value memory_limit 128M
Comment #23
David_Rothstein CreditAttribution: David_Rothstein as a volunteer commentedIf 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).