syntax error near unexpected token `('

[spinner0205]

I get the following error with a cron job I have set up:

/bin/sh: -c: line 0: syntax error near unexpected token `('

 

The cron job is:

DELETE\ FROM\ thatsact_sadadmins.sm_admins\ WHERE\ DonationDate\ <\ DATE_SUB(NOW(), INTERVAL 1 MONTH)

 

Any thoughts on what I need to fix?

[trq]

Cron jobs are executed by your systems shell, therefore your Cron makes NO SENSE at all.

[spinner0205]

Sorry for some stupid reason I posted the MySQL query. 

 

Here is the cron but the error I receive now is ERROR 1102 (42000): Incorrect database name. Is there a specific way to type the database name?

 

/usr/bin/mysql -u username -ppassword 'DELETE FROM thatsact_sadadmins.sm_admins WHERE DonationDate < DATE_SUB(NOW(), INTERVAL 1 MONTH)'

[trq]

Ah, that makes more sense.

 

/usr/bin/mysql -u username -ppassword -e 'DELETE FROM thatsact_sadadmins.sm_admins WHERE DonationDate < DATE_SUB(NOW(), INTERVAL 1 MONTH)' databasename

 

Note the query is being passed to the -e option and now your database name goers on the end.