Yii Framework/PDO getting error CDbCommand failed to execute the SQL statement: SQLSTATE[42000]

Question

I'm trying to insert some data into a table using the Yii Framework together with the PDO object and get the following error

I'm building the query using this code

$connection = CActiveRecord::getDbConnection();

        $sql="INSERT INTO sms_logs (to, from, message,error_code,date_send) VALUES (:to,:from,:message,:error_code,:date_send)";
        $command=$connection->createCommand($sql);
        $command->bindParam(":to",$to,PDO::PARAM_STR);
        $command->bindParam(":from",$from,PDO::PARAM_STR);
        $command->bindParam(":message",$message,PDO::PARAM_STR);
        $command->bindParam(":error_code",$code,PDO::PARAM_STR);
        $command->bindParam(":date_send",date("Y-m-d H:i:s"),PDO::PARAM_STR);
        $command->execute();

And then as soon as I run the code I get

CDbCommand failed to execute the SQL statement: 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 'to, from, message,error_code,date_send) VALUES ('27724963345','27723663542','Hap' at line 1INSERT INTO sms_logs (to, from, message,error_code,date_send) VALUES (:to,:from,:message,:error_code,:date_send)

any suggestions will be welcome! using mySql as the db

Blair McMillan · Accepted Answer · 2010-02-23 16:52:42Z

2

You need to escape the word from in your $sql. It is a reserved word.

answered Feb 23, 2010 at 16:52

Blair McMillan

5,3492 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Elitmiar Over a year ago

Thanks, I can't believe I overlooked the reserved words, problem solved ;-)

Blair McMillan Over a year ago

Glad that sorted it. Don't forget about the CProfileLogRoute log route. It shows you exactly what queries are being run, which can help in tracking down problems.

Collectives™ on Stack Overflow

Yii Framework/PDO getting error CDbCommand failed to execute the SQL statement: SQLSTATE[42000]

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related