1.7.0 handling mysql queries differently ... breaking a few of mine |
[eluser]skattabrain[/eluser]
So this used to work on 1.6.3, it should do the following ... get from the table 'entries' that have 'active' = 1 that also have either 1 of the 2 items ... entries.user_id = '.$this->session->userdata('user_id') OR entries.public = "1" Code: $this->db->from('entries'); this is the code it creates ... Code: SELECT * FROM (`entries`) this is what it should create ... Code: SELECT * FROM (`entries`)
[eluser]skattabrain[/eluser]
btw ... i have several queries no longer working. i use active record but probably do things it wasn't intended too ... this also no longer works ... Code: $this->db->select('ingredient_item.ingredient_id, what it creates ... Code: SELECT `ingredient_item`.`ingredient_id`, `ingredient_to_product`.`ingredient_id` as liveing_id, `ingredient_item`.`ingredient` as name, `ingredient_type`.`ingredient_type`, `ingredient_to_product`.`product_id`
[eluser]thespy[/eluser]
You should look at this thread (bug report), seems to be the same problem : http://ellislab.com/forums/viewthread/94808/
|
Welcome Guest, Not a member yet? Register Sign In |