CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version
i’ve followed http://stackoverflow.com/questions/10762239/enable-load-data-local-infile
and this http://www.yiiframework.com/forum/index.php/topic/33612-load-data-local-infile-forbidden/
update php to
PHP 5.4.14-1~precise+1 (cli) (built: Apr 11 2013 14:30:34)
mysql> SHOW VARIABLES LIKE "%version%";
±------------------------±------------------------+
| Variable_name | Value |
±------------------------±------------------------+
| innodb_version | 5.5.31 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.31-0ubuntu0.12.04.1 |
| version_comment | (Ubuntu) |
| version_compile_machine | i686 |
| version_compile_os | debian-linux-gnu |
±------------------------±------------------------+
need help on this
thanks