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/conferences/main');
>> exit;
>> }
>> $this->Confcommittee->myFunction();
>>         }
>> }
>>
>> 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\DboSource.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\DboSource.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\DboSource.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\DboSource.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\ConferencesController.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\ConferencesController.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->admin_manage(string)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>
>>
>>    - CORE\Cake\Controller\Controller.php line 
>> 485<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>     → ReflectionMethod->invokeArgs(ConferencesController, 
>> array)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>
>>
>>    - CORE\Cake\Routing\Dispatcher.php line 
>> 103<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>     → 
>> Controller->invokeAction(CakeRequest)<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>
>>
>>    - CORE\Cake\Routing\Dispatcher.php line 
>> 85<http://localhost/IAAD_New/admin/conferences/manage/1#>
>>     → Dispatcher->_invoke(ConferencesController, 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(CakeRequest, 
>> 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
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to