Good morning
When I try to add a certificate I get this error
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]
What is causing this, it only happens on this page.
James Aparicio
Fri, 11/18/2016 - 11:38
Hi wardpaul,
Hi wardpaul,
Would be helpfull to know the error itself :), what shows up just after that the [HY000].
Best regards
wardpaul
Fri, 11/18/2016 - 12:44
Sorry
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in C:\xampp\htdocs\drupal\includes\database\database.inc:2204 Stack trace: #0 C:\xampp\htdocs\drupal\includes\database\database.inc(2204): PDOStatement->execute(Array) #1 C:\xampp\htdocs\drupal\includes\database\database.inc(683): DatabaseStatementBase->execute(Array, Array) #2 C:\xampp\htdocs\drupal\includes\database\database.inc(2383): DatabaseConnection->query('SELECT expire, ...', Array, Array) #3 C:\xampp\htdocs\drupal\includes\lock.inc(167): db_query('SELECT expire, ...', Array) #4 C:\xampp\htdocs\drupal\includes\lock.inc(146): lock_may_be_available('theme_registry:...') #5 C:\xampp\htdocs\drupal\includes\theme.inc(449): lock_acquire('theme_registry:...') #6 C:\xampp\htdocs\drupal\includes\bootstrap.inc(455): ThemeRegistry->set(Array) #7 [internal function]: DrupalCacheArray->__destruct() #8 {main} thrown in C:\xampp\htdocs\drupal\includes\database\database.inc on line 2204
James Aparicio
Fri, 11/18/2016 - 13:56
Hi wardpaul,
Hi wardpaul,
Given the error i assume the error is when you are loading the page (node/add/certificate) and not when you actually try to save the node.
There are a lot of possible tokens in that specific page (node/add/certificate). A bit heavy on the database that specific page. That message error message means that the database stopped responding. This is a common issue with weak hardware or heavy loads. From "xampp" i assume you are also using Windows. This error is more common on Windows platforms given the default very low wait_timour setting.
From Mysql
"You are using a Windows client and the server had dropped the connection (probably because wait_timeout expired) before the command was issued."
So you can raise the wait_timeout. That will fix your issue.
Here is the page to help you out in case its not the wait_timout and it is the max_allowed_packet for example.
Hi wardpaul,
Hi wardpaul,
Would be helpfull to know the error itself :), what shows up just after that the [HY000].
Best regards
Sorry
Hi wardpaul,
Hi wardpaul,
Given the error i assume the error is when you are loading the page (node/add/certificate) and not when you actually try to save the node.
There are a lot of possible tokens in that specific page (node/add/certificate). A bit heavy on the database that specific page. That message error message means that the database stopped responding. This is a common issue with weak hardware or heavy loads. From "xampp" i assume you are also using Windows. This error is more common on Windows platforms given the default very low wait_timour setting.
From Mysql
"You are using a Windows client and the server had dropped the connection (probably because
wait_timeoutexpired) before the command was issued."So you can raise the wait_timeout. That will fix your issue.
Here is the page to help you out in case its not the wait_timout and it is the max_allowed_packet for example.
http://dev.mysql.com/doc/refman/5.7/en/gone-away.html
Best regards