MySQL Workbench error 1305 PROCEDURE doesn't exist

I'm trying to execute a statment in MySql to update a column in a table when the expiry date for one of the other columns surpasses the current date, this is then compared against something to make sure that there are no active people for it

but i keep getting this error , i can not see anything wrong with my syntax so im not sure what it is

Error 1305 PROCEDURE does not exist

UPDATE job j SET archived = 1 WHERE(SELECT count(*) FROM job_applied_candidates jac WHERE jac.jobID = j.id) = 0 AND enddate < now();

Answers


Add a space between WHERE an (Select...

Also check triggers on jobs table, since they could use a procedure that does not exist.


Need Your Help

Convert PFX to PEM and error "unable to load certificate"

ssl openssl amazon-cloudfront pem pfx

I am trying to converted a wildcard SSL certificate to PEM format so I can use it in Amazon's Cloudfront. The only file format I have available is pfx. I tried using the following commands:

Twitter Bootstrap: Printing a Badge

css twitter-bootstrap printing

I'm trying to print a badge from twitter bootstrap.