That's a really great idea. By running it as a php script I can get around the apache memory limitations as well. Thanks.
-Don- dpickerel On 10/29/2010 1:51 PM, Ted wrote:
You might also consider doing it with drush, e.g.
$ drush php-script delete_my_nodes
...where delete_my_nodes.php contains a query to get the node ids to delete, and a loop to node_delete each one.
Ted
On 10/29/2010 1:43 PM, Don wrote:
Thanks for the reply Brian. I'd thought of looking up the setting for content administration but not for vbo. I switched it to batch mode and then back, and it worked in short bursts of partial lists. Neither of the modules recommended were ready for that many nodes. I was getting a lot of out of memory errors last night in the mysql include. I'll look into debugging when I get some time. I've worked with vbo before and I'm pretty familiar with its internals.
-Don- dpickerel
On 10/29/2010 1:19 PM, Brian Choc wrote:
Tried changing the number of items per page?
On Thu, Oct 28, 2010 at 7:08 PM, Don <donald@fane.com mailto:donald@fane.com> wrote:
I have VBO installed and went to admin/content/node2. I filtered on the node type and came up with 97,000 nodes. I set it to delete node, and there's a button next to the "All *20* rows in this page are selected." text that says "Select all 99,000 rows in this view", but when I click it nothing happens. The most I can delete is 20 rows at a time. I'm guessing it's a configuration setting or something similar, but I have no clue. I'm logged in as user 1. There are no javascript errors and I've tried it in FF and IE8. Any suggestions? Thanks. -Don- On 10/28/2010 2:08 AM, sivaji j.g wrote:On Thu, Oct 28, 2010 at 6:33 AM, Don <donald@fane.com <mailto:donald@fane.com>> wrote: I have an ubercart ecommerce customer with over 100,000 products in their database. For testing, I need to quickly delete about 95,000 of them. Node, uc_product, etc.. Drupal 6.x Any good ideas? views bulk operation -- Sivaji +91 9941 571 690-- [ Drupal support list | http://lists.drupal.org/ ]