Hello all --
I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7.
My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs.
Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.)
Thanks in advance ...
The node numbers do not change if you use the upgrade process, so test going to /node/nnn on D7 side and see if you get the WSOD one.
You may also be able to find it in the Content view, or perhaps via the url aliases.
On Fri, Jan 17, 2014 at 10:34 AM, Darrell Eifert deifert@hampton.lib.nh.uswrote:
Hello all --
I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7.
My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs.
Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.)
Thanks in advance ...
-- Best,
Darrell Eifert Lane Memorial Library (603) 926-3368
-- [ Drupal support list | http://lists.drupal.org/ ]
Also if you can find it from the admin/content menu there is a bulk delete "update option" there that should work for you.
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Walt Daniels Sent: Friday, January 17, 2014 8:09 AM To: support@drupal.org Subject: Re: [support] Drupal 6 --> 7 upgrade - rogue PHP code / delete page?
The node numbers do not change if you use the upgrade process, so test going to /node/nnn on D7 side and see if you get the WSOD one.
You may also be able to find it in the Content view, or perhaps via the url aliases.
On Fri, Jan 17, 2014 at 10:34 AM, Darrell Eifert <deifert@hampton.lib.nh.usmailto:deifert@hampton.lib.nh.us> wrote: Hello all --
I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7.
My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs.
Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.)
Thanks in advance ...
-- Best,
Darrell Eifert Lane Memorial Library (603) 926-3368tel:%28603%29%20926-3368
-- [ Drupal support list | http://lists.drupal.org/ ]
Thanks to those who have responded. I added a module to D7 that allows me to search by Title in the admin/content menu. I am able to search for and find the "Page Count" node that has the rogue PHP code, but the result line under TITLE says "No content available." and does not give me an edit / delete option.
Best,
Darrell Eifert Lane Memorial Library (603) 926-3368
On 1/17/2014 11:17 AM, Metzler, David wrote:
Also if you can find it from the admin/content menu there is a bulk delete "update option" there that should work for you.
*From:*support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Walt Daniels *Sent:* Friday, January 17, 2014 8:09 AM *To:* support@drupal.org *Subject:* Re: [support] Drupal 6 --> 7 upgrade - rogue PHP code / delete page?
The node numbers do not change if you use the upgrade process, so test going to /node/nnn on D7 side and see if you get the WSOD one.
You may also be able to find it in the Content view, or perhaps via the url aliases.
On Fri, Jan 17, 2014 at 10:34 AM, Darrell Eifert <deifert@hampton.lib.nh.us mailto:deifert@hampton.lib.nh.us> wrote:
Hello all --
I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7.
My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs.
Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.)
Thanks in advance ...
-- Best,
Darrell Eifert Lane Memorial Library (603) 926-3368 tel:%28603%29%20926-3368
-- [ Drupal support list | http://lists.drupal.org/ http://lists.drupal.org/ ]
Option 1:
Disable the PHP filter module, find your node and delete it, then re-enable the module
Option 2: If you got the nid for it, then the quick fix would be a couple of lines in your custom module:
function module_init() { node_delete($nid); }
Put that in your module (of course changing module to your mode name), load a page and then remove that function.
Option 3: Find your node in your field_data_body table and change the input format to 1. That takes the PHP filter out of it. If you don't know the nid, you can search for all nodes with PHP code in them:
SELECT * FROM `field_data_body` WHERE `body_value` LIKE '%<?php%'
Jamie Holly http://hollyit.net
On 1/17/2014 12:14 PM, Darrell Eifert wrote:
Thanks to those who have responded. I added a module to D7 that allows me to search by Title in the admin/content menu. I am able to search for and find the "Page Count" node that has the rogue PHP code, but the result line under TITLE says "No content available." and does not give me an edit / delete option. Best,
Darrell Eifert Lane Memorial Library (603) 926-3368 On 1/17/2014 11:17 AM, Metzler, David wrote:
Also if you can find it from the admin/content menu there is a bulk delete "update option" there that should work for you.
*From:*support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Walt Daniels *Sent:* Friday, January 17, 2014 8:09 AM *To:* support@drupal.org *Subject:* Re: [support] Drupal 6 --> 7 upgrade - rogue PHP code / delete page?
The node numbers do not change if you use the upgrade process, so test going to /node/nnn on D7 side and see if you get the WSOD one.
You may also be able to find it in the Content view, or perhaps via the url aliases.
On Fri, Jan 17, 2014 at 10:34 AM, Darrell Eifert <deifert@hampton.lib.nh.us mailto:deifert@hampton.lib.nh.us> wrote:
Hello all --
I recently completed a test Drupal 6 to 7 upgrade on our library site, and all seemed to be well except that our old cron job will not run -- it appears to die on a white screen with the words "Number of pages". I did some digging via drush cron, and discovered that a page I had built in Drupal 6 with PHP code listing the total number of website pages contained a PHP function referencing "db_result", which apparently is not supported in Drupal 7.
My problem now is that I cannot delete the 'rogue' page from Drupal 7. I can find the page easily enough, but it displays only as white screen with text and none of the usual edit / delete tabs.
Is there a way to delete a Drupal node without actually landing on that node? (Note also that I have the node alias from the Drupal 6 install, but do not know the node number of the page in D7.)
Thanks in advance ...
-- Best,
Darrell Eifert Lane Memorial Library (603) 926-3368 tel:%28603%29%20926-3368
-- [ Drupal support list | http://lists.drupal.org/ http://lists.drupal.org/ ]