kohana-minion/tasks-migrations — Issue #30: 3.2/develop fails to work
Author: Xobb
Created: 2011-10-25 20:39:20+00:00
State: open

First of all, I would like to thank you for an awesome module. That's what I was looking for a long time.

Basically 17 of 30 tests fail on 3.2/develop branch.

Most of the issues are caused because of this error:

Database_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group' at line 1 [ SELECT * FROM (SELECT *, CONCAT(`group`, ":", CAST(`timestamp` AS CHAR)) AS `id` FROM test_minion_migrations WHERE applied > 0 ORDER BY timestamp DESC) AS temp_table GROUP BY group ]

I think the problem is that you are using *GROUP BY group*, which is kind of weird. Maybe the column should be renamed to group_name or something?

It's not recommended to name to columns with the keywords of the sql, AFAIK, so you should avoid columns like description, user, group, etc.

Regards,
Paul Chubatyy