By karmstrn on

Every time I click the "Add content type" link in Commerce Kickstart, I get the following error message:

Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {commerce_flat_rate_service}; Array ( ) in commerce_flat_rate_commerce_shipping_service_info() (line 120 of /Applications/MAMP/nsna1/profiles/commerce_kickstart/modules/contrib/commerce_flat_rate/commerce_flat_rate.module).
Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:119:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {commerce_flat_rate_service}; Array ( ) ";s:9:"%function";s:51:"commerce_flat_rate_commerce_shipping_service_info()";s:5:"%file";s:113:"/Applications/MAMP/nsna1/profiles/commerce_kickstart/modules/contrib/commerce_flat_rate/commerce_flat_rate.module";s:5:"%line";i:120;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://localhost:8888/nsna1/admin/commerce/config/types/content/add [:db_insert_placeholder_7] => http://localhost:8888/nsna1/ [:db_insert_placeholder_8] => 127.0.0.1 [:db_insert_placeholder_9] => 1350849369 ) in dblog_watchdog() (line 154 of /Applications/MAMP/nsna1/modules/dblog/dblog.module).

Does anybody have any idea what's going on here and what I should do?

⋅ Categories: Drupal 7.x

Comments

vm’s picture

vm commented

looks like your watchdog table is crashing or is crashed. Perhaps due to too many errors being produced. Inpect the table in question with phpmyadmin and repair or empty.

then test an pay strict attention to what errors are being generated before the watchdog table acts up again.

karmstrn’s picture

karmstrn commented

Thanks, I will try that. Right now I'm going for a simpler e-commerce solution with ubercart.

odin88’s picture

odin88 commented

I resolve this issue by using this method :

To resolve that problem you need to increase max_allowed_packet variable in MySQL. Add following line in my.ini
max_allowed_packet=100M

Source : http://drupal.org/node/1787038