Hi,
You are using var $belongsTo = array('Conference') for association the
table so when it create the it find the associated column and i think this
is not exist so it will say SQL error.
you should create associate colunm in teh table.
Cheers...
Saran Pal
On Thu, Aug 2, 2012 at 2:11 AM, majna <[email protected]> wrote:
> If it's not the plugin issue, then Conference model is associated with
> Confcommittee with wrong 'class' name.
> You can test that if you change order in $uses:
> public $uses = array('Confcommittee', 'Conference');
>
>
> On Wednesday, August 1, 2012 10:35:12 PM UTC+2, majna wrote:
>>
>> Is this code inside a plugin?
>>
>> 2012/8/1 WhyNotSmile <[email protected]>
>>
>>> Thanks for the help, but it hasn't made any difference. I'm totally
>>> baffled, because I've used the same code in other places with different
>>> model names, and it seems fine... I must have just missed something on
>>> copying it.
>>>
>>>
>>>
>>> On Wednesday, 1 August 2012 20:58:42 UTC+1, majna wrote:
>>>>
>>>> Model Confcommittee is not found, so Cake creates an instance of
>>>> AppModel.
>>>> You are using $uses property, so try to add in Model/Confcommittee.php:
>>>>
>>>> App::uses('Confcommittee ', 'Model');
>>>>
>>>> class Confcommittee extends AppModel { ...
>>>>
>>>> Btw, you don't need to call exit() after redirect() in that controller.
>>>>
>>>>
>>>> On Wednesday, August 1, 2012 5:44:18 PM UTC+2, WhyNotSmile wrote:
>>>>>
>>>>> I'm using Cake 2.0, and getting a database error when I call a
>>>>> particular model. I think I've probably named something wrongly, but I
>>>>> can't see what!
>>>>>
>>>>> I have the following:
>>>>>
>>>>> *DB table:* confcommittees
>>>>>
>>>>> *Model/Confcommittee.php:*
>>>>>
>>>>>> class Confcommittee extends AppModel {
>>>>>> public $name = 'Confcommittee';
>>>>>>
>>>>>> var $belongsTo = array('Conference');
>>>>>>
>>>>>> public function myFunction() {
>>>>>> return false;
>>>>>> }
>>>>>> }
>>>>>
>>>>>
>>>>> *Controller/ConferencesController.php:*
>>>>>
>>>>>> App::uses('AppController', 'Controller');
>>>>>>
>>>>>> class ConferencesController extends AppController {
>>>>>> public $name = 'Conferences';
>>>>>> public $helpers = array('Html', 'Session');
>>>>>> public $uses = array('Conference', 'Confcommittee');
>>>>>>
>>>>>> /* Filters and callbacks */
>>>>>> function beforeFilter() {
>>>>>> parent::beforeFilter();
>>>>>> }
>>>>>> /*
>>>>>> * admin_manage
>>>>>> * Allows the admin user to manage any given conference
>>>>>> */
>>>>>> function admin_manage($conference_id = null) {
>>>>>> if(!$conference_id) {
>>>>>> $this->redirect('/admin/**confer**ences/main');
>>>>>> exit;
>>>>>> }
>>>>>> $this->Confcommittee->**myFuncti**on();
>>>>>> }
>>>>>> }
>>>>>>
>>>>>> When I access admin/conferences/manage, I get the following error:
>>>>>
>>>>>> Database Error
>>>>>> *Error: *SQLSTATE[42000]: Syntax error or access violation: 1064 You
>>>>>> have an error in your SQL syntax; check the manual that corresponds to
>>>>>> your
>>>>>> MySQL server version for the right syntax to use near 'myFunction' at
>>>>>> line 1
>>>>>> *SQL Query: *myFunction
>>>>>> *Notice: *If you want to customize this error message, create
>>>>>> app\View\Errors\pdo_error.ctp
>>>>>> Stack Trace
>>>>>>
>>>>>> - CORE\Cake\Model\Datasource\**Dbo**Source.php line
>>>>>> 437<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> →
>>>>>> PDOStatement->execute(**array**)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Model\Datasource\**Dbo**Source.php line
>>>>>> 403<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → DboSource->_execute(string,
>>>>>> array)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Model\Datasource\**Dbo**Source.php line
>>>>>> 647<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → DboSource->execute(string, array,
>>>>>> array)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Model\Datasource\**Dbo**Source.php line
>>>>>> 589<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → DboSource->fetchAll(string, array,
>>>>>> array)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Model\Model.php line
>>>>>> 775<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → DboSource->query(string, array,
>>>>>> AppModel)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - APP\Controller\**ConferencesCont**roller.php line
>>>>>> 96<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → Model->__call(string,
>>>>>> array)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - APP\Controller\**ConferencesCont**roller.php line
>>>>>> 96<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> →
>>>>>> AppModel->myFunction()<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - [internal
>>>>>> function]<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> →
>>>>>> ConferencesController->**admi**n_manage(string)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Controller\**Controlle**r.php line
>>>>>> 485<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → ReflectionMethod->**invokeArg**s(**ConferencesController,
>>>>>> array) <http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Routing\Dispatcher.**p**hp line
>>>>>> 103<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> →
>>>>>> Controller->invokeAction(**Ca**keRequest)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - CORE\Cake\Routing\Dispatcher.**p**hp line
>>>>>> 85<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → Dispatcher->_invoke(**Confere**ncesController, CakeRequest,
>>>>>> CakeResponse)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>>> - APP\webroot\index.php line
>>>>>> 92<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>> → Dispatcher->dispatch(**CakeRe**quest,
>>>>>> CakeResponse)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>>>>>
>>>>>>
>>>>> As I said, I think I've given something the wrong name, but I can't
>>>>> find it. Can anyone help?!
>>>>>
>>>> --
>>> 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<cake-php%[email protected]>For
>>> more options, visit this group at
>>> http://groups.google.com/**group/cake-php<http://groups.google.com/group/cake-php>
>>>
>>
>> --
> 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
>
--
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
