4

When I am trying to run cron.php I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'host' in 'where clause', query was: SELECT main_table.* FROM cron_schedule AS main_table WHERE (status = 'running') AND (host = 'web02.myhost.ro')

The message is correct, there is no 'host' column in the 'cron_schedule' but why is it looking for it and where is this set up? Or what else can I do to get cron running.

I am using Magento 1.9.1.0

Improve this question
1
  • a magento developer was able to take a look at our system and found the issue was within a 3rd party magento plugin that had a corrupt row in the database table that was causing the Mage__Helper_Data error.
    – Ashvin Monpara
    Commented Jul 2, 2015 at 9:01

1 Answer 1

Reset to default
4

The popular cronjob management extension Aoe_Scheduler adds this column, either you installed it but it didn't get set up correctly or other code assumes that it has been installed.

Either way, I recommend to (re-)install the extension, it's a must have for every shop to monitor your cronjob activity and also improves cronjob reliability.

Improve this answer
2
  • how do i reinstall I had just copied all the files through FTP. Shall i overwrite those file with the ones you have linked in your answer?
    – Wasiq Shahrukh
    Commented Sep 18, 2017 at 7:44
  • 1
    @WasiqShahrukh Yes, then make sure the upgrade scripts are executed (i.e. clear config cache and refresh page OR use n98-magerun with the sys:setup:run command). If there's still not host column, you might have to delete the aoe_scheduler_setup row in the core_resource database table and try again.
    – Fabian Schmengler
    Commented Sep 18, 2017 at 7:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.