| # |
Sep 22nd 2011, 04:09 |
friskd |
NetersLandreau: no not pasted |
| # |
Sep 22nd 2011, 04:07 |
NetersLandreau |
friskd: is the exact query you are trying to execute? (pasted above?) if so, you have a single quote "closed" by a double quote.. |
| # |
Sep 22nd 2011, 04:07 |
Seguer |
friskd: see if you can turn off transactions before you run your dirty raw sql |
| # |
Sep 22nd 2011, 04:06 |
friskd |
if i do a find its fine |
| # |
Sep 22nd 2011, 04:06 |
friskd |
Seguer: no it doesn't do that |
| # |
Sep 22nd 2011, 04:05 |
cpgo |
hmm thats differnet, probably it |
| # |
Sep 22nd 2011, 04:04 |
cpgo |
yea haha |
| # |
Sep 22nd 2011, 04:04 |
Seguer |
oh yeah i removed it |
| # |
Sep 22nd 2011, 04:04 |
Seguer |
~cpgo |
| # |
Sep 22nd 2011, 04:04 |
cpgo |
cpgo is cpslow |
| # |
Sep 22nd 2011, 04:04 |
Seguer |
i have been doing that a lot these days :< |
| # |
Sep 22nd 2011, 04:04 |
cpgo |
remember |
| # |
Sep 22nd 2011, 04:04 |
cpgo |
yes lol |
| # |
Sep 22nd 2011, 04:04 |
Seguer |
cpgo: to tell you things you should already know? :P |
| # |
Sep 22nd 2011, 04:03 |
cpgo |
ah so that's why we keep you around |
| # |
Sep 22nd 2011, 04:03 |
Seguer |
cpgo: check tests? |
| # |
Sep 22nd 2011, 04:02 |
Seguer |
friskd: does it start transaction and rollback if you do a normal ->find()? |
| # |
Sep 22nd 2011, 04:02 |
cpgo |
can anyone else confirm cake 2.0 contain in pagination calls do not work |
| # |
Sep 22nd 2011, 04:02 |
Seguer |
friskd: what was the original select you were trying to do? |
| # |
Sep 22nd 2011, 04:02 |
Seguer |
friskd: normally transactions surround stuff that has an effect on the db (ie, delete/update) |
| # |
Sep 22nd 2011, 04:02 |
Seguer |
friskd: probably because the driver doesn't realise you are doing a select, and its checking for something that the select query doesn't return |
| # |
Sep 22nd 2011, 04:01 |
friskd |
ROLLBACK |
| # |
Sep 22nd 2011, 04:01 |
friskd |
Select * from users; |
| # |
Sep 22nd 2011, 04:01 |
friskd |
i see Start Transaction |
| # |
Sep 22nd 2011, 04:01 |
friskd |
So when i run it |
| # |
Sep 22nd 2011, 04:01 |
friskd |
Seguer: i need to raw sql for something... and i have simplified it down to this select statement to debug |
| # |
Sep 22nd 2011, 04:00 |
Seguer |
friskd: why are you running raw sql anyway |
| # |
Sep 22nd 2011, 04:00 |
friskd |
if i look in the query log i see |
| # |
Sep 22nd 2011, 04:00 |
friskd |
So for some reason when i run $this->Model->query('Select * from users"); |
| # |
Sep 22nd 2011, 04:00 |
NetersLandreau |
friskd: what do you mean it is doing a roll-back on a select? |
| # |
Sep 22nd 2011, 03:54 |
NetersLandreau |
ddoom: yes it is possible - http://book.cakephp.org/view/1395/options-multiple |
| # |
Sep 22nd 2011, 03:51 |
NetersLandreau |
hi CSdread_ |
| # |
Sep 22nd 2011, 03:51 |
cpgo |
$this->paginate['contain'] = array('Term', 'Department', 'Professor'); // it doesnt contain these |
| # |
Sep 22nd 2011, 03:50 |
NetersLandreau |
lemme guess Section58, table joins? |
| # |
Sep 22nd 2011, 03:50 |
cpgo |
in 2.0 |
| # |
Sep 22nd 2011, 03:50 |
cpgo |
has the way contain in pagination calls changed? |
| # |
Sep 22nd 2011, 03:41 |
friskd |
i am just doing a select * in the query and cake is auto rolling back |
| # |
Sep 22nd 2011, 03:40 |
friskd |
if the query is successful |
| # |
Sep 22nd 2011, 03:40 |
friskd |
What might cause $this->Query to auto rollback |
| # |
Sep 22nd 2011, 03:40 |
friskd |
thanks NetersLandreau |
| # |
Sep 22nd 2011, 03:40 |
friskd |
it was heredoc |