![]() ![]() Trigger_error('Wrong parameters type in :'. $command -> setFetchMode ( Zend_Db::FETCH_ASSOC ) $command = $this -> Db -> prepare( $sp_str ) Public function ExecuteStoredProcedure($spName, $args) Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome. Open Edit Preferences SQL Editor DBMS connection read time out (in seconds): 600. I just stupidly catch the required error, make re-init of the Zend_Db and run this quesry once again.Really stupidly, but this bug meets on Windows only and for Nix this case wont' work so nothing serious:) Change specific timeouts value to 6000 its available in all new versions of MySQL Workbench. I have had the same problem but as far as I use PHP 5 why do not create your own class to work with PDO. denis dot podgurskiy at cofelab dot ru Hi there I'm running on a celeron 2.4GHz with 512 ram. When running through the PHP command line interface, I get it about 50% of the time, so perhaps there are performance issues here. When running through apache I get this error 100% of the time. When using MySQL's libmysql.dll the error is: SQLSTATE: General error: 2014 Cannot execute queries while other ![]() General error: 2013 Lost connection to MySQL server during query When using PHP's libmysql.dll the error is: SQLSTATE: I've tested with the libmysql.dll files that php ships with, as well as the libmysql.dll that mysql ships with - they produce two different errors but the problem is the same. I've tested this with php 5.2 release, as well as various recent snapshots. My bug report here: has some more information. mike at we11er dot co dot uk I'm having this issue as well. Warning: PDOStatement::execute() : SQLSTATE: General error: 2013 Lost connection to MySQL server during query in C:\home\test\www\pdo.php on line 12 $Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING) $Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC) "SET NAMES 'utf8'", PDO::ATTR_PERSISTENT => true)) I read #35333 #35637 #35203, but why the given code fine works in Debian? The second call stored procedures causes an error "SQLSTATE: General error: 2013 Lost connection to MySQL server during query" with probability of 50%.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |