14,982
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
(+ERROR 1205: Lock wait timeout exceeded; try restarting transaction) |
(SQLSTATE[HY093]: Invalid parameter number: parameter was not defined) |
||
| Line 143: | Line 143: | ||
# If the MySQL service started successfully, edit the MySQL configuration file and mark this line : {{kbd | key=<nowiki>#innodb_force_recovery = 1</nowiki>}} | # If the MySQL service started successfully, edit the MySQL configuration file and mark this line : {{kbd | key=<nowiki>#innodb_force_recovery = 1</nowiki>}} | ||
# Restart the MySQL service | # Restart the MySQL service | ||
==== Caught exception: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined ==== | |||
Solutions | |||
* Number of question marks is not matched with the number of query values: [https://stackoverflow.com/questions/10966251/sqlstatehy093-invalid-parameter-number-parameter-was-not-defined php - SQLSTATE[HY093]: Invalid parameter number: parameter was not defined - Stack Overflow] | |||
* The array of query values should not be the associative array. | |||
==== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) ==== | ==== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) ==== | ||