Look at http://book.cakephp.org/view/563/Setting-Auth-Component-Variables - you need to set the Auth fields ...
On Nov 20, 2:49 pm, DlEast <[EMAIL PROTECTED]> wrote: > Hi fellow bakers! > > I just grabbed the latest version of Cake and are looking to migrate a > old website to the new version and decided to use the auth component. > When following the guideline from the cookbook I get the following > database error: > > SQL Error: 1064: You have an error in your SQL syntax; > SELECT FROM AS `User` WHERE `User`.`username` = 'test' AND > `User`.`password` = 'b7eeb589dcc75ae3d55b157295de83a26f67d631' LIMIT 1 > > Obviously the users table before AS is missing, anyone experienced > this previously? I am using the exact code given > athttp://book.cakephp.org/view/172/Authentication. The only difference > is that I have some additional fields in my users table. > > Any help is welcome, > > Thanx! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
