I have a new production site up at http://www.nscfundalaska.org/
I have one group, the Ecovillage Training Center that has developed an unusual problem. Any attempt to edit the content of the group will trigger a 501 error, which ultimately results in a Page Not Found error message. 501 not implemented means the server will not support the ability that is required to fill the original request. This is the best fitted response when a web server is not familiar with the request method and is not capable of supporting it for any resource.
Redirecting the error to phpinfo() shows that the HTTP Method is, in fact, POST, which is what you expect. I've tracked discussions that talk about permissions and alias and tried all those tricks, to no avail.
_SERVER["REDIRECT_REQUEST_METHOD"] POST
_SERVER["REDIRECT_STATUS"] 501
_SERVER["REDIRECT_UNIQUE_ID"] TwehD9HsR0IACNLKJ5cAAABA
_SERVER["REDIRECT_URL"] /node/21/edit
_SERVER["REMOTE_ADDR"] 72.208.46.28
_SERVER["REMOTE_PORT"] 54381
_SERVER["REQUEST_METHOD"] GET
_SERVER["REQUEST_URI"] /node/21/editYou can see the page at:
http://www.nscfundalaska.org/group/north-star-ecovillage-training-center
When I hit the save or preview button, all I get is:
Page not found
The requested page could not be found.
It has some feeds, other than that it is just like all the rest of the groups and editing them works just fine. The other group configured with feeds edits.
ANY ideas on how to debug to find what is wrong or figure out why this one group won't edit would be appreciated.
Comments
Comment #1
ezra-g commentedAre there any errors in PHP/Apache error log or Drupal DB/Syslog at admin/reports?
Comment #2
Cyberflyer commentedGood question, Ezra-g!
I cleared all the logs, provoked the error and found three entries in the System Log in this order:
1:
Unknown column 'nscf_prod_activity_log_templates.pid' --- Error deleted. Part of Activity Stream display bug.2:
Unknown column 'nscf_prod_activity_log_templates.pid' --- Error deleted. Part of Activity Stream display bug.3:
501.shtmlThere were no access denied errors logged.
There was one 'File not Found" error logged, for page "501.shtml'.
And here are the relevant time period server access logs, FWIW:
Hope this helps. I appreciate your looking into this.
Cy
Comment #3
Cyberflyer commentedOddly, there was nothing in the Server Error Log file in Control Panel, which claims to show the last 300 errors for the site.
Comment #4
Cyberflyer commentedOK. The problem seems to have to do with using table prefixes.
This thread http://drupal.org/node/1317814 talks about the activity stream.
I applied the patch and the activity stream showed up. I was wondering why it was not reporting. So that patch works.
Searching for similar problems to see if I can find an existing thread or patch.
Comment #5
Cyberflyer commentedTurns out that (a) the first two reports were associated with the activity stream bug. The patch above fixed that on both my local server and my production server.
The editing bug does NOT appear on my local machine, but is still in place on the Production server. But we can disregard the two error log entries that worry about a missing table.
Just double checked and the group configuration is identical on local host for dev as it is on production server.
Comment #6
ezra-g commentedDoes this problem persist with the latest nightly dev snapshot of Commons?
Comment #7
Cyberflyer commentedLet me check.
Problem only evidences itself on my production server. Nervous about going to a dev release there.
The link you sent includes : 6.x-2.4 tar.gz (16 MB) 2012-Jan-18 as the latest recommended and a bunch of devs.
I'd assume the 6.x-2.4 is later than what I have, which is 6.x-2.3. That is recommended, right, safe to use on production systems?
Comment #8
Cyberflyer commentedI installed 6.x-2.4 on my local dev version and when Update completed I got this:
user warning: Duplicate key name 'uid' query: ALTER TABLE nscf_prod_og_uid ADD INDEX uid (uid) in /Users/larrylowe/Sites/nscf-prod/includes/database.mysql-common.inc on line 442.Do I worry? Or did MySQL prevent the duplicate key name -- because the index was already there?
Further down, among the confirmations, was this:
PHP MyAdmin shows this:
Comment #9
ezra-g commentedNo need to worry - as per the release notes, it is safe to ignore that error.
Comment #10
Cyberflyer commentedOK, thanks.
1) Read the release notes, ;-)
2) Installed 6.x-2.4 on production.
3) Completed the update, cache flush and all reset procedures in the release notes.
4) Cleared the cache again, for good luck/safety's sake.
5) Went to the target page, which has a custom URL based on title.
6) Pressed the 'Edit' tab which loaded the /node/21/edit page, based on the node number.
7) Did a minor edit.
8) Clicked 'save' button
9) Got a page containing the error "File not Found" at the same URL I was just on.
10) Put the cursor in the browser address field and hit the return key.
11) Got the same URL with the editor fully populated.
12) The edited data had not been stored.
So the error is now friendlier -- it does not invoke the 501 error visibly.
But I am in the same state in this page on this installation -- I cannot edit this group.
Comment #10.0
Cyberflyer commentedAdded more info on output.
Comment #11
japerryMarking as won't fixed as this is no longer relevant for newest versions of commons, and the 6.x-2.x is only getting security fixes. You can also visit #2142923: Upgrading From Drupal 1.5 to 2.x or 3.x for the update status of legacy commons installs and more information on upgrading to the latest version of Commons.