Re: any one else having trouble with table prefixes in 2.0?

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 <dereurom...@googlemail.com> 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php