Hi. First of all, thank you for looking into my problem.
I saw this issue in jira before, but didn't carefuly read the comments. Yes, I knew I have PHP 5.2.8 on my machine and 5.2.6 on server, man I should read all comments carefully :) You're also right, switching to mysqli fixed the problem. I just wander what is better PDO or mysqli, will read http://www.google.com/search?q=pdo+vs+mysqli&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a Thanks man, you saved my day. Regards, Saša Stamenković. tfk wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Zend_Db-and-very-strange-problem-with-executing-bulk-insert-query-tp24226472p24243690.html Sent from the Zend Framework mailing list archive at Nabble.com.
