Trying to Certificate

wardpaul
Forums
Support
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.

http://dev.mysql.com/doc/refman/5.7/en/gone-away.html

Best regards