1 respuesta en este tema

[wasimh]

hola compañeros he estado siguiendo el tutorial de cesar cansino sobre programcion web usando zend framework he logrado una conexion a la base de datos pero cuando deseo consultar los datos de una table en mysql se me sale un error typo :
Warning: PDO::__construct(): MySQL server has gone away in C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Db\Adapter\Driver\Pdo\Connection.php on line 320
Call Stack
# Time Memory Function Location
1 0.0023 243576 {main}( ) ..\index.php:0
2 0.4657 6158936 Zend\Mvc\Application->run( ) ..\index.php:17
3 0.4773 6285312 Zend\EventManager\EventManager->trigger( ) ..\Application.php:313
4 0.4774 6285312 Zend\EventManager\EventManager->triggerListeners( ) ..\EventManager.php:207
5 0.4780 6287376 call_user_func:{C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php:468} ( ) ..\EventManager.php:468
6 0.4780 6287944 Zend\Mvc\DispatchListener->onDispatch( ) ..\EventManager.php:468
7 0.4883 6396280 Zend\Mvc\Controller\AbstractController->dispatch( ) ..\DispatchListener.php:114
8 0.4884 6396696 Zend\EventManager\EventManager->trigger( ) ..\AbstractController.php:117
9 0.4884 6396696 Zend\EventManager\EventManager->triggerListeners( ) ..\EventManager.php:207
10 0.4901 6408240 call_user_func:{C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php:468} ( ) ..\EventManager.php:468
11 0.4902 6408368 Zend\Mvc\Controller\AbstractActionController->onDispatch( ) ..\EventManager.php:468
12 0.4904 6408632 Application\Controller\IndexController->testAction( ) ..\AbstractActionController.php:83
13 0.5365 6936064 Zend\Db\Adapter\Adapter->query( ) ..\IndexController.php:38
14 0.5366 6936416 Zend\Db\Adapter\Driver\Pdo\Connection->execute( ) ..\Adapter.php:189
15 0.5366 6936840 Zend\Db\Adapter\Driver\Pdo\Connection->connect( ) ..\Connection.php:428
16 0.5368 6938288 __construct ( ) ..\Connection.php:320

( ! ) Warning: PDO::__construct(): Error while reading greeting packet. PID=1504 in C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Db\Adapter\Driver\Pdo\Connection.php on line 320
Call Stack
# Time Memory Function Location
1 0.0023 243576 {main}( ) ..\index.php:0
2 0.4657 6158936 Zend\Mvc\Application->run( ) ..\index.php:17
3 0.4773 6285312 Zend\EventManager\EventManager->trigger( ) ..\Application.php:313
4 0.4774 6285312 Zend\EventManager\EventManager->triggerListeners( ) ..\EventManager.php:207
5 0.4780 6287376 call_user_func:{C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php:468} ( ) ..\EventManager.php:468
6 0.4780 6287944 Zend\Mvc\DispatchListener->onDispatch( ) ..\EventManager.php:468
7 0.4883 6396280 Zend\Mvc\Controller\AbstractController->dispatch( ) ..\DispatchListener.php:114
8 0.4884 6396696 Zend\EventManager\EventManager->trigger( ) ..\AbstractController.php:117
9 0.4884 6396696 Zend\EventManager\EventManager->triggerListeners( ) ..\EventManager.php:207
10 0.4901 6408240 call_user_func:{C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php:468} ( ) ..\EventManager.php:468
11 0.4902 6408368 Zend\Mvc\Controller\AbstractActionController->onDispatch( ) ..\EventManager.php:468
12 0.4904 6408632 Application\Controller\IndexController->testAction( ) ..\AbstractActionController.php:83
13 0.5365 6936064 Zend\Db\Adapter\Adapter->query( ) ..\IndexController.php:38
14 0.5366 6936416 Zend\Db\Adapter\Driver\Pdo\Connection->execute( ) ..\Adapter.php:189
15 0.5366 6936840 Zend\Db\Adapter\Driver\Pdo\Connection->connect( ) ..\Connection.php:428
16 0.5368 6938288 __construct ( ) ..\Connection.php:320
Zend Framework 2 Skeleton Application
Home
An error occurred
An error occurred during execution; please try again later.
Additional information:
Zend\Db\Adapter\Exception\RuntimeException
File:
C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Db\Adapter\Driver\Pdo\Connection.php:328
Message:
Connect Error: SQLSTATE[HY000] [2006] MySQL server has gone away
Stack trace:
#0 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Db\Adapter\Driver\Pdo\Connection.php(428): Zend\Db\Adapter\Driver\Pdo\Connection->connect()
#1 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT * FROM f...')
#2 C:\wamp\www\www\zfprac\module\Application\src\Application\Controller\IndexController.php(38): Zend\Db\Adapter\Adapter->query('SELECT * FROM f...', 'execute')
#3 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractActionController.php(83): Application\Controller\IndexController->testAction()
#4 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#5 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#6 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#7 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Mvc\Controller\AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#8 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Mvc\DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#9 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#10 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#11 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\EventManager\EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#12 C:\wamp\www\www\zfprac\vendor\zendframework\zendframework\library\Zend\Mvc\Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#13 C:\wamp\www\www\zfprac\public\index.php(17): Zend\Mvc\Application->run()
#14 {main}

y por tanto el php_pdo_mysql.dll del wamp lo tengo habilitado

[enecumene]

Eso se debe a que el tiempo de espera se agoto o que el servidor MySQL esta apagado mas al respecto:

http://dev.mysql.com.../gone-away.html

Saludos.