Deleting cdr records

I tried the following commands on two freepbx systems

mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < ‘2017-12-04 00:00:00’;

Strangely enough on the first system the cdr records were delete, but not on the second. There’s no error message. Any ideas?

never mind, I just changed it to

DELETE from cdr WHERE calldate < ‘2017-12-06 00:00:00’;