Hi,
I've tried the install profile three times and it fails at the same point. Each time I completely wiped the database and installed a fresh download of the http://openchurchsite.com/download/96/195/openchurch_d7-02-15-12.zip . The last attempt was with the 7.x-1.x-dev
Each time it fails at the same point... when installing modules 63 of 107. when it reaches that point it throws the following error...
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: http://www.foo/install.php?profile=openchurch&locale=en&id=1&op=do StatusText: Internal Server Error ResponseText:
If I proceed to the error page (as per the link) I get a white screen, which if I keep hitting the refresh button on my browser (safari) eventually it will take me to the Configure site screen, which when I enter in the config data, I get more white screens then eventually this error message
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 464 of /foo/includes/menu.inc).
Any clue what is going on?
Looks like a great profile!
| Comment | File | Size | Author |
|---|---|---|---|
| #33 | screenshot.png | 528.89 KB | dbt102 |
| #14 | Capture.JPG | 45.08 KB | sschwab |
Comments
Comment #1
drupalninja99 commentedGoing to upload a new profile here in a minute, I will keep you posted.
Comment #2
drupalninja99 commentedThat is odd bc I have run that installation multiple times.
Here is the latest version that has some new features and fixes some bugs:
http://openchurchsite.com/download/137/212/openchurch_d7-03-03-12.zip
Make sure you have enough php memory to finish the install. You will need at least 256mb, maybe up to 512mb.
Comment #3
dbt102 commentedThanks
I upped the mem limit to 512mb and that got me to the very end of the install profile. However it then threw this error...
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null
I tried the newest March 3 profile.
Comment #4
Anonymous (not verified) commentedI also get this issue, tried installing it just now.
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null
Comment #5
drupalninja99 commentedInteresting, I ran the install again and it ran fine for me. That error usually involves trying to add a permission for a module that isn't enabled. I don't add permissions until the very end. I still wonder if this is a symptom of something else failing though. I have yet to be able to reproduce the error.
Comment #6
drupalninja99 commentedDo you know how to use drush?
If you ran
drush si -yv openchurchand gave me the output that might give me a better idea as to what's going on. Right now I can't reproduce the problem and I don't know enough ab the error to narrow it down.Comment #7
drupalninja99 commentedI still think the error could be resources related as in mysql settings.
This article has some suggestions for throttling up your mysql settings: http://drupal.org/node/259580
Comment #8
drupalninja99 commentedAlso what php version are you using?
Comment #9
sschwab commentedJust tried to install using webenabled in a empty environment and got the following error:
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://xxxx.dev4.webenabled.net/install.php?profile=openchurch&locale=en... StatusText: OK ResponseText: Home | Drupal @import url("http://xxxx.dev4.webenabled.net/modules/system/system.messages.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/system/system.base.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/system/system.theme.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/system/system.menus.css?0"); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/cale..."); @import url("http://xxxx.dev4.webenabled.net/modules/comment/comment.css?0"); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/date..."); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/date..."); @import url("http://xxxx.dev4.webenabled.net/modules/field/theme/field.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/node/node.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/user/user.css?0"); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/view..."); @import url("http://xxxx.dev4.webenabled.net/modules/system/system.admin.css?0"); @import url("http://xxxx.dev4.webenabled.net/modules/system/system.maintenance.css?0"); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/ctoo..."); @import url("http://xxxx.dev4.webenabled.net/profiles/openchurch/modules/contrib/pane..."); @import url("http://xxxx2.dev4.webenabled.net/themes/seven/reset.css?0"); @import url("http://xxxx.dev4.webenabled.net/themes/seven/style.css?0"); Home Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Install profile(active)Configure siteFinished Warning message The Date API requires that you set up the site timezone and first day of week settings and the date format settings to function correctly. Status message You can now configure the CAPTCHA module for your site. SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
Comment #10
drupalninja99 commentedI think this is maybe due to the storage engine, myisam or innodb hitting against some limit when it's trying to index the database maybe? I am still looking for what setting we could throttle to fix this.
I know when I run this on Omega8 it works fine.
Comment #11
drupalninja99 commentedOK I turned on innodb settings and I finally got the error, it seems to be caused by fusion styles maybe? I now have something I can play with to see what specifically is causing this.
Comment #12
drupalninja99 commentedOK I reopened a fusion accelerator ticket that had the same error. It looks like it was fixed in dev so I am going to use the dev version (until a stable one gets fixed) so that this can run in more environments.
Comment #13
drupalninja99 commentedAlright I have changed fusion accelerator to use the dev version for now until they patch a stable branch:
http://openchurchsite.com/download/138/213/openchurch_d7-03-04-12.zip
I was able to install locally with innodb enabled. Let me know if this works
Comment #14
sschwab commentedTried the new build of 3/4/12 this morning.
Got really excited as all the modules installed this time, then got this message:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null
I have attached a screen shot.
Again, I am using webenabled developer x1 host.
Can't wait to get this installed. I've been waiting patiently for d7 version. Really appreciate your hard work on this profile.
Comment #15
drupalninja99 commentedI think I fixed this issue: 1.3 alpha - http://openchurchsite.com/download/140/214/openchurch_d7-03-04-12-01.zip
I created a blank site on webenabled and ran the installer and got the same error. I saw that it was crashing on the 'administer files' permission granted to the editor role. When I removed that permission from the editor role it installed correctly. That permission is only of moderate benefit, so I just removed it for the sake of getting this working.
Let me know if this works for you.
Comment #16
sschwab commentedMade it through the module installs and then went to the initial set up screen without issue. After I submitted that data, I got error 500 back from the server. Here's what was in the server log files:
PHP Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 79 bytes) in /home/clients/websites/w_ollh2/public_html/ollh2/includes/menu.inc on line 3707
I don't really know how much memory you get by default on webenabled developer account. How much do you think is needed for this profile? I have a support ticket to find out if they will increase the memory. How much do you have on your webenabled account?
Thanks again for your quick replies. I'm getting closer...
Comment #17
dbt102 commentedThanks for the work. I installed the d7-03-04-12-01.zip you posted above. It installed OK and site seems to work well.
Nice job in troubleshooting this issue!!!
Comment #18
drupalninja99 commentedI think I just have the 1st level webenabled developer plan. I do need to do some more testing to see how much memory is the minimum amount needed to get through the installation.
The issue is that the install requires more memory than the actual site does once it is installed. I think it would be somewhere from 256-512mb likely. I think the D6 version would go around 300-400-ish when I ran it via Aegir whereas this one only peaks 125 via Aegir, but that is running via drush which I would suspect is more memory efficient.
Comment #19
sschwab commentedI bumped the max memory in php.ini to 256M and the install succeeded. I'm still learning and didn't know you could adjust mem limits yourself with webenabled. Thanks for your perseverance on this issue.
I'll play with it and let you know of any other issues that might come up.
Thanks again!
Comment #20
dbt102 commentedI've a question about the OpenChurch demo site ( http://demo.openchurchsite.com/ ). Is this what a raw install of this profile is going to look like?
The reason I ask is that the only item I have on my site after the install process completes is the large rotating picture and the menu at the menu at the top. All other regions appear to be there but other photos and blocks are not showing.
I've played some with edit's to the various regions, and they seem to be taking, but I'd like to have all the demo site stuff right off the bat to help move forward in planning.
Comment #21
drupalninja99 commentedYa even though the demo site is still D6 at the moment it looks very similar to the D7 version.
Make sure your files directory is writable. Can you send me a screenshot?
Comment #22
onwabineli commentedhi,
i have been trying to install open church for the last 72 hours on my shared hosting account on bluehost. I have done everything on this thread... i still get this error no matter what i do
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: http://nyediongministries.org/install.php?profile=openchurch&locale=en&i... StatusText: Internal Server Error ResponseText:
the above error always comes when it gets to 64 of 113 profile install.
please help, i need to sleep.
Comment #23
drupalninja99 commentedPlease check this page for some suggestions: http://openchurchsite.com/content/common-installation-problems
-Did you add ini_set('memory_limit','256M'); to your settings.php? I would try bumping up the memory from 256-512
Comment #24
onwabineli commentedyes i did that
Comment #25
onwabineli commenteda friend is using the same hosting company and did all the suggested settings and got it right. i honestly do not know why i can get it right.
i have started it over and over from scratch and still not getting results.
Comment #26
onwabineli commentedok I think i got it now. still seeing some errors....
let me re-trace my steps.
thanks. i think i will sleep tonight :)
Comment #27
tacoparty commentedI'm running into the same issues above on a GoDaddy shared hosting environment. I've started with a fresh database several times, I've deleted and re-uploaded all the install profile files and nothing seems to work. It always fails in a different spot. I have upped the memory in settings.php (I don't have access to php.ini) to 512M but that hasn't helped either. The closest I've gotten is it will say everything installed OK, but when I go to the home page the main slideshow images are missing and if I try to go to /user or any admin pages it gives me a 500 Internal Server Error. I've also tried the Drupal 6 version and have been even less successful. On that version, I can't even get past the screen to select an installation profile. After I click continue it just gives me the 500 server error. I've installed Drupal many, many times on my hosting account and have never run into this much trouble.
Comment #28
drupalninja99 commentedYa the difference is that these cheap hosts like GoDaddy & Bluehost are not optimized for Drupal and usually have very low php/mysql settings. Install profiles like OpenChurch & others take a fair amount of resources to install, but usually much less to run.
If you try to install OC on your local box and then import the database that might be another option. Alot of these hosts don't even give you access to modify mysql settings which is a problem. I can try to sign up for one of these and install, the problem is that I need a specific error message and the normal Drupal installer doesn't really give you that.
Comment #29
drupalninja99 commentedAnother thing to try in your settings.php to something really long like:
set_time_limit(280);The installer might be running up against the max execution time.
Comment #30
drupalninja99 commentedIf /user isn't coming up either a) your .htaccess isn't there or b) you don't have clean urls enabled which is a feature of apache mod rewrite which is usually enabled.
You can try /?q=user and see if that comes up. Also your files directory needs to be world writable. Try setting it to writable post-install.
Comment #31
tacoparty commentedThanks for the feedback. I will try that and let you know if any of that works. I'm not desperate to get it working or anything. I just thought it looked cool and wanted to play around with it. Thanks again!
Comment #32
tacoparty commentedIn case this helps anybody else using GoDaddy hosting, it seems adding set_time_limit(280); to settings.php helped with the install process. All of the modules installed just fine but when it was done it gave me a 500 Internal Server Error. I hit the back button and let it do its thing again a few times and eventually it took me to the screen where you enter your primary user info, time zone, etc. It took about 10 tries of setting that before it finally worked but now everything looks good.
Thanks
Comment #33
dbt102 commentedHey, Back in post #21 you asked for a screen shot. I've attached it to this post.
Is this what it should look like on initial install? The only thing I've done so far is just disabled the OpenChurch defaults so I could add in the Administration Menu module and disabled the Toolbar.
Comment #34
drupalninja99 commentedHmm that's weird. One thing that I get sometimes is that I have to change the files directory to writable (chmod -R 777 files) after the install sometimes to fix the images. Try that.
Comment #35
dbt102 commentedThanks for the tip, but It doesn't work. I blitzed the db and erased all files and started over from scratch with the latest OpenChurch 7x-1.3-alpha - stable, 03/04/2012 release. The installation went smoothly and the blocks came in with additional content, assuming the user permission fix fixed this. But the pictures still don't show as before.
I changed permissions from 755 to 777 on sites/default/files and ran an update.php. This had no effect. I noted the "Customize This Page" skin so I clicked there and saw the Homepage Promo 1 pane was pointing to...
/profiles/openchurch/images/homepage-rotator/winter_sermons.jpg
So I changed permissions on /profiles to 777 also and ran update.php. Still no pictures in these panes...
Is this what you meant for me to try as per #34 ?
(Thanks for your replies!!!)
Comment #36
Code Monkey commenteddbt102, I don't think the lack of image displaying is a permissions issue. I think the paths are just not finding the correct locations of the images.
I have temporarily edited the paths in Firebug (within Firefox) to add a period "." prior to the image path and the image would correctly display. The problem could be that you are installing this into a sub-directory of your web site, but the blocks are pointing to the root of the web site to start looking for the images.
Comment #37
drupalninja99 commentedOne thing to try is to install http://drupal.org/project/pathologic bc I believe that it will automatically fix 'bad paths' for you. If that works I will add it to the profile to install by default.
Comment #38
dbt102 commentedcodemonkey: Yes, adding the periods did the trick. All pics now displaying well. Thanks for the suggestion.
drupalninja99: I also tried adding the pathologic module before I tried adding in the periods. I always like trying out new modules. It did not produce the desired results. I tried both the .1 and .2 branches but did not mess with it very much.
Site looks great however, one last item...
I want to use the Administration Menu module in lieu of the core Toolbar. The dropdown menus are much quicker. However, if I disable the OpenChurch Defaults to disable the toolbar, then the side bar blocks don't work. Is there a way to selectively disable certain defaults?
Comment #39
drupalninja99 commentedOh that's a good point, I didn't realize OC defaults had a dependency on toolbar. I will try to remove that dependency.
Comment #40
drupalninja99 commentedChanging status
Comment #41
drupalninja99 commentedThis dependency is removed, so now you can disable toolbar safely:
http://openchurchsite.com/download/142/215/openchurch_d7-03-08-12.zip
Comment #42
dbt102 commentedThanks for removing the dependancy. I reinstalled the profile and it works well.
Thanks for all the help!
Comment #43
drupalninja99 commentedChanging to fixed.
Comment #44
drupalninja99 commentedChanging to fixed