I think he wasn't following the convention to have a table named 'Users' with at least to fields named 'username' and 'password'.
On Sep 10, 4:28 pm, Klesus <[EMAIL PROTECTED]> wrote: > Hi, > > Can you tell us how you solve the problem ? I think I have exactly > the same : > > SQL Error: 1054: Unknown column 'User.statu_id' in 'on clause' [CORE/ > cake/libs/model/datasources/dbo_source.php, line 512] > It is real that User.statu_id does not exist. But why CakePhp build > broken query ? > > Thanks for your help. > > Seb > > On 31 ago, 08:36, Jeroen <[EMAIL PROTECTED]> wrote: > > > No I didn't have. > > Thanks! Problem solved! > > What a stupid mistake!!!! > > > On 31 aug, 02:35, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote: > > > > Has your user table a field called `username` ? > > > > On Sat, Aug 30, 2008 at 6:00 PM, Jeroen <[EMAIL PROTECTED]> wrote: > > > > > I followed the instructions > > > > onhttp://book.cakephp.org/view/172/authentication > > > > to create a login. The problem is that I get the following error when > > > > I try to login: > > > > SQL Error: 1054: Unknown column 'User.username' in 'where clause' [CORE > > > > \cake\libs\model\datasources\dbo_source.php, line 512] > > > > > Cake (Auth) searches for the wrong table to login, it need to search > > > > for the table Users instead of User. > > > > I'm using Cake version 1.2.0.7296 RC2. > > > > > I use the following code: > > > > class AppController extends Controller { > > > > var $components = array('Auth'); > > > > > function beforeFilter(){ > > > > $this->Auth->loginAction = > > > > array(Configure::read('Routing.admin') => > > > > false, 'controller' => 'users', 'action' => 'login'); > > > > $this->Auth->allow('index','view'); > > > > } > > > > > } > > > > > Login view: > > > > <?php > > > > if ($session->check('Message.auth')) $session->flash('auth'); > > > > echo $form->create('User',array('action' => 'login')); > > > > echo $form->input('username'); > > > > echo $form->input('password'); > > > > echo $form->end('Login'); > > > > ?> > > > > > <?php > > > > class UsersController extends AppController { > > > > > var $name = 'Users'; > > > > var $helpers = array('Html', 'Form', 'Session' ); > > > > > /** > > > > * The AuthComponent provides the needed functionality > > > > * for login, so you can leave this function blank. > > > > */ > > > > function login() { > > > > } > > > > > function logout() { > > > > $this->redirect($this->Auth->logout()); > > > > } > > > > > } > > > > ?> > > > > > I tried the following things: > > > > 1. echo $form->create('Users',array('action' => 'login')); instead of > > > > echo $form->create('User',array('action' => 'login'));, but then Auth > > > > wopn't do anything at all. Comparing to other views the syntax echo > > > > $form->create('User',array('action' => 'login')); should be the > > > > correct synax. > > > > 2. Searching the Internet if anyone else had the same problem, but I > > > > can't find anyone with the same problem. > > > > > Three questions > > > > 1. Is this a bug of CakePHP 1.2.0.7296 RC2 or am I doing something > > > > wrong? > > > > 2. Is there amnyone else who uses the Auth-component successfully in > > > > version 1.2.0.7296 RC2? > > > > 3. The most important: anyone has a solution or got an idea?? :) > > > > > Thanks, > > > > > Jeroen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
