OK... it happens on normal views as well just a simple find(first) with 2 contained hasMany relations
same problem even worse - it has nothing to do with the cache here (cache deactivated) joins seem to kill the site_ prefix! this is quite a problem since the whole application seems to be pretty non-functional now On 31 Okt., 14:37, euromark <[email protected]> wrote: > if the model cache is renewed everything is fine > but as soon as cake uses the model cache the table prefix is lost and > causes sql errors > > the prefix is "site_" > > query with cached data from /tmp/cache/models: > > Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table > 'cake.addresses' doesn't exist > > SQL Query: SELECT `Address`.`id`, `Address`.`foreign_id`, > `Address`.`model`, `Address`.`country_id`, `Address`.`first_name`, > `Address`.`last_name`, `Address`.`street`, `Address`.`postal_code`, > `Address`.`city`, `Address`.`lat`, `Address`.`lng`, > `Address`.`last_used`, `Address`.`formatted_address`, > `Address`.`type_id`, `Address`.`created`, `Address`.`modified` FROM > `addresses` AS `Address` WHERE `Address`.`foreign_id` = 4 AND > `Address`.`model` = 'Restaurant' > > Notice: If you want to customize this error message, create site/View/ > Errors/pdo_error.ctp > > Stack Trace > > #0 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(436): > PDOStatement->execute(Array) > #1 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(403): > DboSource->_execute('SELECT `Address...', Array) > #2 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(645): > DboSource->execute('SELECT `Address...', Array, Array) > #3 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(1205): > DboSource->fetchAll('SELECT `Address...', false) > #4 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(1226): > DboSource->queryAssociation(Object(Restaurant), Object(Address), > 'hasOne', 'Address', Array, Array, true, Array, 0, Array) > #5 /srv/www/.../trunk/lib/Cake/Model/Datasource/DboSource.php(1065): > DboSource->queryAssociation(Object(Coupon), Object(Restaurant), > 'belongsTo', 'Restaurant', Array, Array, true, Array, 1, Array) > #6 /srv/www/.../trunk/lib/Cake/Model/Model.php(2458): > DboSource->read(Object(Coupon), Array) > > #7 /srv/www/.../trunk/site/Plugin/Tools/Lib/MyModel.php(417): > Model->find('all', Array, NULL, NULL) > > #8 /srv/www/.../trunk/site/Controller/CouponsController.php(470): > MyModel->find('all', Array) > #9 [internal function]: CouponsController->homepage() > #10 /srv/www/.../trunk/lib/Cake/Controller/Controller.php(473): > ReflectionMethod->invokeArgs(Object(CouponsController), Array) > #11 /srv/www/.../trunk/lib/Cake/Routing/Dispatcher.php(107): > Controller->invokeAction(Object(CakeRequest)) > #12 /srv/www/.../trunk/lib/Cake/Routing/Dispatcher.php(89): > Dispatcher->_invoke(Object(CouponsController), Object(CakeRequest), > > Object(CakeResponse)) > #13 /srv/www/.../trunk/site/webroot/index.php(96): > Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse)) > > #14 {main} > > it should have been > "FROM `site_addresses` AS `Address`" -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
