Fatal error: Uncaught exception 'PDOException'
Bonjour à tous,
j'essaye de créer un formulaire qui permet à un utilisateur de pouvoir s'inscrire sur le site que je développe avec zend framework en ce moment, mais j'ai une erreur que je n'arrive pas à résoudre.:cry:
Je vous donne l'erreur que j'ai :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| ( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound' in C:\wamp\www\sondage\library\Zend\Db\Statement\Pdo.php on line 234
( ! ) PDOException: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in C:\wamp\www\sondage\library\Zend\Db\Statement\Pdo.php on line 228
Call Stack
# Time Memory Function Location
1 0.0029 376960 {main}( ) ..\index.php:0
2 0.2365 7213184 Zend_Application->run( ) ..\index.php:35
3 0.2365 7213184 Zend_Application_Bootstrap_Bootstrap->run( ) ..\Application.php:366
4 0.2367 7213240 Zend_Controller_Front->dispatch( ) ..\Bootstrap.php:97
5 2.4707 12463920 Zend_Controller_Plugin_Broker->postDispatch( ) ..\Front.php:965
6 2.4707 12463920 Zend_Layout_Controller_Plugin_Layout->postDispatch( ) ..\Broker.php:331
7 2.4709 12464160 Zend_Layout->render( ) ..\Layout.php:143
8 2.4712 12464376 Zend_View_Abstract->render( ) ..\Layout.php:796
9 2.4719 12505704 Zend_View->_run( ) ..\Abstract.php:880
10 2.4729 12568080 include( 'C:\wamp\www\sondage\application\layouts\scripts\layout.phtml' ) ..\View.php:108
11 2.4824 12568712 Zend_View->loggedInAs( ) ..\layout.phtml:36
12 2.4824 12568864 Zend_View_Abstract->__call( ) ..\Abstract.php:0
13 2.4825 12569112 call_user_func_array ( ) ..\Abstract.php:342
14 2.4825 12569248 Zend_View_Helper_LoggedInAs->loggedInAs( ) ..\Abstract.php:0
15 2.4843 12597584 App_Facade_Lecture->getUtilisateurById( ) ..\loggedInAs.php:12
16 2.5021 12609712 Application_Model_DbTable_Infoutilisateur->getByUtilisateur( ) ..\Lecture.php:68
17 2.5021 12609896 Zend_Db_Table_Abstract->fetchAll( ) ..\Infoutilisateur.php:10
18 2.5130 12632384 Zend_Db_Table_Abstract->_fetch( ) ..\Abstract.php:1321
19 2.5130 12632384 Zend_Db_Adapter_Pdo_Abstract->query( ) ..\Abstract.php:1505
20 2.5130 12632384 Zend_Db_Adapter_Abstract->query( ) ..\Abstract.php:238
21 2.5144 12635976 Zend_Db_Statement->execute( ) ..\Abstract.php:468
22 2.5144 12635976 Zend_Db_Statement_Pdo->_execute( ) ..\Statement.php:300
23 2.5144 12636008 PDOStatement->execute( ) ..\Pdo.php:228
( ! ) Zend_Db_Statement_Exception: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in C:\wamp\www\sondage\library\Zend\Db\Statement\Pdo.php on line 234
Call Stack
# Time Memory Function Location
1 0.0029 376960 {main}( ) ..\index.php:0
2 0.2365 7213184 Zend_Application->run( ) ..\index.php:35
3 0.2365 7213184 Zend_Application_Bootstrap_Bootstrap->run( ) ..\Application.php:366
4 0.2367 7213240 Zend_Controller_Front->dispatch( ) ..\Bootstrap.php:97 |
et là, la fonction d'où l'erreur vient :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| /**
* Executes a prepared statement.
*
* @param array $params OPTIONAL Values to bind to parameter placeholders.
* @return bool
* @throws Zend_Db_Statement_Exception
*/
public function _execute(array $params = null)
{
try {
if ($params !== null) {
return $this->_stmt->execute($params);
} else {
return $this->_stmt->execute();
}
} catch (PDOException $e) {
require_once 'Zend/Db/Statement/Exception.php';
throw new Zend_Db_Statement_Exception($e->getMessage(), (int) $e->getCode(), $e);
}
} |
Merci d'avance:calim2:
