PDOException thrown “SQLSTATE[HY093]: Invalid parameter”
General News June 15th, 2007Recently just had the ” PDOException thrown “SQLSTATE[HY093]: Invalid parameter” ” error.
This caused due to me having a query like this.
$dbq->prepare(’some query with :some vars in it like :this’)
$dbq->bindParam(:some, ’some string’);
$dbq->bindParam(:this, ‘another string’);
$dbq->bindParam(:oops, ‘this string is not in the prepared statement’);
$dbq->execute();
When i removed the :oops bind param it worked. Hope this helps someone else and saves time. PHP v 5.2, Mysql v5
June 22nd, 2007 at 2:08 pm
Will keep that in mind. Unfortunatly because we didn’t realise 1&1 supported PHP5, we use our own database object: md_db.
June 24th, 2007 at 1:41 pm
Yeahs, for anyone out there, to get PHP5, also called PHP 5, v5, or v5.2 or whatever running on 1&1 web hosting for PHP then use the following mod rewrite:
AddType x-mapp-php5 .php
However, one of the problems is that although this works for Http, this does not work for the https and their technical support have been most unhelpful.
If you want to run https on php5 for 1&1 then i suggest you simply change the file extension to:
.php5, and this means that both http, and https will run the page as PHP 5.