nclundsten
commented
11 years ago that looks right, could you add a pr?
Open dranzd opened 11 years ago
nclundsten
commented
11 years ago that looks right, could you add a pr?
After creating a contact record, viewing the details with url: localhost/contact/1 generates an error message.
File: myapp/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:216
Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'myapp.address' doesn't exist
Stack trace:
0 /myapp/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php(216): PDOStatement->execute()
1 /myapp/vendor/ZfcBase/src/ZfcBase/Mapper/AbstractDbMapper.php(118): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
2 /myapp/vendor/SpeckContact/src/SpeckContact/Mapper/AddressMapper.php(30): ZfcBase\Mapper\AbstractDbMapper->select(Object(Zend\Db\Sql\Select))
3 /myapp/vendor/SpeckContact/src/SpeckContact/Service/ContactService.php(72): SpeckContact\Mapper\AddressMapper->findByContactId('1')
4 /myapp/vendor/SpeckContact/src/SpeckContact/Service/ContactService.php(27): SpeckContact\Service\ContactService->getExtras(Object(SpeckContact\Entity\Contact))
5 /myapp/vendor/SpeckContact/src/SpeckContact/Controller/ContactController.php(55): SpeckContact\Service\ContactService->findById('1')
6 /myapp/vendor/ZF2/library/Zend/Mvc/Controller/AbstractActionController.php(87): SpeckContact\Controller\ContactController->viewAction()
7 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
8 /myapp/vendor/ZF2/library/Zend/EventManager/EventManager.php(469): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
9 /myapp/vendor/ZF2/library/Zend/EventManager/EventManager.php(209): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
10 /myapp/vendor/ZF2/library/Zend/Mvc/Controller/AbstractController.php(108): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
11 /myapp/vendor/ZF2/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 /myapp/vendor/ZF2/library/Zend/EventManager/EventManager.php(469): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
14 /myapp/vendor/ZF2/library/Zend/EventManager/EventManager.php(209): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
15 /myapp/vendor/ZF2/library/Zend/Mvc/Application.php(298): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
16 /myapp/public/index.php(12): Zend\Mvc\Application->run()
17 {main}
Replacing line 25 of file SpeckContact/src/SpeckContact/Mapper/AddressMapper.php from ->join(array('a' => 'address'), 'a.address_id = ca.address_id'); to ->join(array('a' => 'contact_addresses'), 'a.address_id = ca.address_id'); seems to fix the problem.