| # |
Sep 22nd 2011, 04:11 |
friskd |
the cake dc migration plugin |
| # |
Sep 22nd 2011, 04:10 |
Seguer |
friskd: /tell me/ |
| # |
Sep 22nd 2011, 04:10 |
Seguer |
friskd: what are you using for your migrations in cake? |
| # |
Sep 22nd 2011, 04:10 |
friskd |
for the up/down |
| # |
Sep 22nd 2011, 04:09 |
friskd |
This actually some code in a migration |
| # |
Sep 22nd 2011, 04:09 |
Seguer |
CakeBot: dsql is direct sql, raw sql, or more commonly, dirty sql |
| # |
Sep 22nd 2011, 04:09 |
NetersLandreau |
i figured as much.. wouldn't run if it was |
| # |
Sep 22nd 2011, 04:09 |
Seguer |
friskd: *shrug* |
| # |
Sep 22nd 2011, 04:09 |
Seguer |
friskd: what are you actually trying to accomplish with your dirty sql? |
| # |
Sep 22nd 2011, 04:09 |
friskd |
Seguer: how do i disable transactions |
| # |
Sep 22nd 2011, 04:09 |
friskd |
that was my typo |
| # |
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? |