My Blog

I’ve been working with PDO at my new job and encountered this HY093 error. Infact that was the only information I received back from my PDO object. Usually there is a lot more information. My guess is that generally PDO is passing back the MySQL error directly from the MySQL server. However, HY093 is strictly an error issued by PDO.

In this case I received the HY093 error because I had improperly binded a data type to a variable.

I was using the form:

$db->prepare("SELECT * FROM tbl WHERE name = :name");
$pdo->bindValue(':name',$phpVar,PARAM_STR);
$pdo->execute();

Notice on line 2 I used “PARAM_STR” this should be PDO::PARAM_STR likewise had this been an integer it would have been PDO:PARAM_INT. Hopefully that helps some people.

Drop me a comment if this helped your or if you feel I missed something, thanks for reading.

Related posts:

1. Using perror to Help Debug Mysql Errors
2. using firephp to debug php web applications
3. Use MySQL HAVING to Get Past Error 1111 Invalid Use of Group Function
4. setting up iis7 w/ mysql and php
5. Optimize MySQL Queries – Fast Inserts With Multiple Rows

Tags: mysql, pdo, php, prepared statements

This entry was posted on Wednesday, August 11th, 2010 at 4:02 pm and is filed under Programming, SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.