mr_absinthe

No, this time it removed the correct items. It even works with the echo commented out - it is removing correct items, no idea why it didn't work yesterday. The calculation output is not showing the removed items however:

Store database has been optimized.
Customers tables were trimmed.
Initial size was 49209454.
Final, optimized, size is 49209454.

With about five years data the initial figure should be higher I guess.

It is and the same date is the oldest record in the table now - 20120104.

delete from customers_basket_attributes WHERE (`products_id`, `customers_id`) in (select `products_id`, `customers_id` from customers_basket where customers_basket_date_added < '20120104')

OK, it works now, however since I have 30 days set as value in settings, I was expecting to see one month old data in table customers_basket. After running the optimizer, there are only records from yesterday (oldest date_added is 20120201). Is there something I've missed?

Hi Jack, it appears that the customer basket is not being cleaned. Despite the fact that I have 30 days set as value in settings, I can still see records there from 2005. Same for the customers_basket_attributes, nothing is being deleted.

Thank you. I've found it and I've changed the following in sitemonitor_admin.php, from:

$invalidFiles = array_merge((array)glob(DIR_FS_CATALOG . DIR_WS_IMAGES . '*.php'),(array)glob(DIR_FS_CATALOG . DIR_WS_IMAGES . '*.txt'));
  if (!empty($invalidFiles)) {
	$messageStack->add(ERROR_IMAGES_HAS_PHP, 'error');
	foreach ($invalidFiles as $filename) {
	  echo $messageStack->add($filename);
	}
  }

to:

$invalidFiles = glob(DIR_FS_CATALOG . DIR_WS_IMAGES . '*.php');
  if(is_array($invalidFiles) && count($invalidFiles) > 0)
  {
		  $messageStack->add(ERROR_IMAGES_HAS_PHP, 'error');
   foreach($invalidFiles as $filename)
		  {
				echo $messageStack->add($filename);
		  }
  }
  $invalidFiles = glob(DIR_FS_CATALOG . DIR_WS_IMAGES . '*.txt');
  if(is_array($invalidFiles) && count($invalidFiles) > 0)
  {
		  $messageStack->add(ERROR_IMAGES_HAS_PHP, 'error');
   foreach($invalidFiles as $filename)
		  {
				echo $messageStack->add($filename);
		  }
  }

All is fine now, the message is gone, running fine on php 5.3.6