On Fri, Jun 26, 2009 at 10:01 PM, umpirsky<[email protected]> wrote: > > Hi zf gurus. > > I have large amount of data which I'm inserting into MySQL db. That is array > of urls and I'm iterating and manually hammering bulk insert qury for better > performances. > > So, Im running query with > > $zdb->query('INSERT INTO `Content` (`FeedId`, `ContentValue`) VALUES (..), > (..)'); > > This works perfect on my Win XP maxhine, but on Cent OS server I get: > > exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY093]: > Invalid parameter number: no parameters were bound' in
You'll need to break up the bulk insert to figure out which statement it chokes on. My un-educated guess is that the string contains something like, 'foo?bar' and PDO attempts to bind something to the '?' but no parameters are provided. >From what I remember (there was an issue in jira), the problem was within PDO and not in the framework code. A fix for this has been committed and released in 5.2.7 or 5.2.8, so your options are either upgrading (if you haven't already) or switching Zend_Db to use the MySQLi driver. Just start off by verifying that the PHP versions on your local box and Cent OS server match. I'd almost bet they do not. Let me know if this helps! Till
