How you solve the problem?¡
El viernes, 15 de junio de 2012 09:51:58 UTC-4, chris7548 escribió:
>
> Hello,
>
> I have developed an cakephp application on an xampp installed on a
> windows 7 ios. On this configuration everything works fine. But when i
> try to run the application on a linux ios the model associations
> aren't interpreted anymore:
>
> Example:
>
> I've got a table user that has got a suffix_id for identifiying the
> email_suffix of the user. The user data is accessed by the
> EvaluationsController via the Evaluation model.
>
> class User extends AppModel {
> public $primaryKey = 'id';
> public $name = 'User';
> public $belongsTo = 'Suffix';
> public $hasMany = array('GroupMember', 'Result', 'Supervisor');
> public $useTable = 'users';
> }
>
> class Suffix extends AppModel {
> public $primaryKey = 'id';
> public $name = 'Suffix';
> public $hasMany = 'User';
> public $useTable = 'suffixes';
> }
>
> class Evaluation extends AppModel {
> public $useTable = false;
> public $hasOne = array('Exercise', 'GroupMember', 'Group',
> 'Result',
> 'Supervisor', 'User');
> }
>
> class EvaluationsController extends AppController {
>
> public $helpers = array('Html', 'Form');
>
> public function index() {
> ...
> $users = $this->Evaluation->User->findAllById(6);
> ...
> }
> }
>
>
> The generated SQL-Statement on linux is:
>
> SELECT `User`.`id`, `User`.`surname`, `User`.`forename`,
> `User`.`email_prefix`, `User`.`suffix_id`, `User`.`valid` FROM `This-
> is-GRADE`.`users` AS `User` WHERE `User`.`id` = 6
>
>
> The right SQL-Statement (generated on windows) is:
>
> SELECT `User`.`id`, `User`.`surname`, `User`.`forename`,
> `User`.`email_prefix`, `User`.`suffix_id`, `User`.`valid`,
> `Suffix`.`id`, `Suffix`.`suffix` FROM `This-is-GRADE`.`users` AS
> `User` LEFT JOIN `This-is-GRADE`.`suffixes` AS `Suffix` ON
> (`User`.`suffix_id` = `Suffix`.`id`) WHERE `User`.`id` = 6
>
>
> Anyone has got an idea why this code is just working on windows and
> linux don't understand it correctly?
--
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
