On Sun, Jun 28, 2009 at 7:20 PM, till<[email protected]> wrote: > 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 >
OK, found the issue after I hit "send": http://framework.zend.com/issues/browse/ZF-1343 The second comment from the bottom contains another "fix". Till
