joshribakoff
commented
10 years ago Can you try and run vendor/bin/phinx, it runs the migrations in this folder - https://github.com/bookingbat/application/tree/master/migrations
These are there for when I need to add new columns, and the code changes, you can use that tool to update the DB.
dazzyweb
Hi
I installed everything as layed out and receive the following error. Any ideas?
An error occurred
An error occurred during execution; please try again later.
Additional information:
Zend_Db_Statement_Exception
File: C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Statement\Pdo.php:234
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'where clause'
Stack trace:
0 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
1 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
2 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
3 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Select.php(686): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
4 C:\xampp\htdocs\bookingbat-app\module\Application\src\Application\Service\DataMapper.php(52): Zend_Db_Select->query()
5 C:\xampp\htdocs\bookingbat-app\module\Application\src\Application\Controller\ServicesController.php(10): Application\Service\DataMapper->findValid()
6 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractActionController.php(83): Application\Controller\ServicesController->chooseAction()
7 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
8 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
9 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
10 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
11 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
12 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
13 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
14 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
15 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Application.php(309): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
16 C:\xampp\htdocs\bookingbat-app\public\index.php(18): Zend\Mvc\Application->run()
17 {main}
Previous exceptions:
PDOException
File: C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Statement\Pdo.php:228
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'where clause'
Stack trace:
0 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array)
1 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
2 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
3 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
4 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework1\library\Zend\Db\Select.php(686): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
5 C:\xampp\htdocs\bookingbat-app\module\Application\src\Application\Service\DataMapper.php(52): Zend_Db_Select->query()
6 C:\xampp\htdocs\bookingbat-app\module\Application\src\Application\Controller\ServicesController.php(10): Application\Service\DataMapper->findValid()
7 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractActionController.php(83): Application\Controller\ServicesController->chooseAction()
8 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
9 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
10 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
11 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
12 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
13 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
14 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
15 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
16 C:\xampp\htdocs\bookingbat-app\vendor\zendframework\zendframework\library\Zend\Mvc\Application.php(309): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
17 C:\xampp\htdocs\bookingbat-app\public\index.php(18): Zend\Mvc\Application->run()
18 {main}