Column not found: 1054 Unknown column 'Array' in 'where clause

[JensBourgeois]

Hi,

On Magento 1.6.2.0, I got the following error after installation (using modman)

a:5:{i:0;s:80:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause'";i:1;s:3066:"#0 /lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT main_ta...', Array)
#4 /lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('SELECT main_ta...', Array) #5 /lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT main_ta...', Array)
#6 /lib/Varien/Data/Collection/Db.php(687): Zend_Db_Adapter_Abstract->fetchAll('SELECT main_ta...', Array) #7 /app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(520): Varien_Data_Collection_Db->_fetchAll('SELECT main_ta...', Array)
#8 /lib/Varien/Data/Collection/Db.php(521): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 .modman/Aoe_Scheduler/app/code/community/Aoe/Scheduler/Helper/Data.php(156): Varien_Data_Collection_Db->load()
#10 modman/Aoe_Scheduler/app/code/community/Aoe/Scheduler/Helper/Data.php(131): Aoe_Scheduler_Helper_Data->getLastExecutionTime('aoescheduler_he...')
#11 Aoe_Scheduler/app/code/community/Aoe/Scheduler/Controller/AbstractController.php(76): Aoe_Scheduler_Helper_Data->getLastHeartbeat()
#12 /.modman/Aoe_Scheduler/app/code/community/Aoe/Scheduler/Controller/AbstractController.php(36): Aoe_Scheduler_Controller_AbstractController->checkHeartbeat()
#13 .modman/Aoe_Scheduler/app/code/community/Aoe/Scheduler/controllers/Adminhtml/InstructionsController.php(16): Aoe_Scheduler_Controller_AbstractController->_initAction()
#14 /app/code/core/Mage/Core/Controller/Varien/Action.php(420): Aoe_Scheduler_Adminhtml_InstructionsController->indexAction()
#15 app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#16 /Applications/MAMP/htdocs/debanier-shop/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#18 /app/Mage.php(640): Mage_Core_Model_App->run(Array)
#19 /index.php(90): Mage::run('', 'store')
#20 {main}";s:3:"url";s:73:"/index.php/admin/instructions/index/key/725b05992a1061af2511bcac0965f9e0/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:5:"admin";}`

I was able to fix this by changing the following lines:

$schedules->addFieldToFilter( array('status'), array( array('eq' => Aoe_Scheduler_Model_Schedule::STATUS_SUCCESS), array('eq' => Aoe_Scheduler_Model_Schedule::STATUS_REPEAT) ) );
to this:

$schedules->addFieldToFilter( 'status', array( array('eq' => Aoe_Scheduler_Model_Schedule::STATUS_SUCCESS), array('eq' => Aoe_Scheduler_Model_Schedule::STATUS_REPEAT) ) );

in .modman/Aoe_Scheduler/app/code/community/Aoe/Scheduler/Helper/Data.php:147