Thank you for the suggestion guys but it did not solve my problem. I use the standard field names (username, password) and setting them manually did not change anything. The problem is that the query lacks the actual database name "users".
SELECT FROM AS `User` WHERE `User`.`username`...... should be: SELECT FROM users AS `User` WHERE `User`.`username`.... Any ideas why the database name is lacking? Thanx On Nov 21, 5:45 am, Rob <[EMAIL PROTECTED]> wrote: > Look athttp://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 -~----------~----~----~----~------~----~------~--~---
