Re: OthAuth and sql error

2006-08-03 Thread lorenzo
CraZyLeGs ha scritto: > you need at least mySQL 4.x for the joins. ah, ok, tnk you :) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.co

Re: OthAuth and sql error

2006-08-03 Thread CraZyLeGs
you need at least mySQL 4.x for the joins. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email

Re: OthAuth and sql error

2006-08-02 Thread lorenzo
CraZyLeGs ha scritto: > what version of mySQL ? 3.23.58 do you have the models ? the tables in the db ? yes, of course > defined the associations well ? yes, of course Cut & paste from tutorial --~--~-~--~~~---~--~~ You received this message because you are sub

Re: OthAuth and sql error

2006-08-02 Thread CraZyLeGs
what version of mySQL ? do you have the models ? the tables in the db ? defined the associations well ? this is some of the questions you need to answer. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" gr

Re: OthAuth and sql error

2006-08-01 Thread lorenzo
kestrelid ha scritto: > not known to me, but you might want to try putting brackets around Should work without modifed anything ... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this

Re: OthAuth and sql error

2006-08-01 Thread kestrelid
not known to me, but you might want to try putting brackets around (`groups_permissions`.`group_id` = '1' AND `groups_permissions`.`permission_id` = `Permission`.`id`). shot in the dark? haven't tried this myself! --~--~-~--~~~---~--~~ You received this message b

OthAuth and sql error

2006-08-01 Thread lorenzo
I'am try OthAuth; i can login but this query failed : SELECT `Permission`.`id`, `Permission`.`name`, `Permission`.`created`, `Permission`.`modified` FROM `permissions` AS `Permission` JOIN `groups_permissions` ON `groups_permissions`.`group_id` = '1' AND `groups_permissions`.`permission_id` = `Per