Tags/topics: 
2
Answers
Vote up!
0
Vote down!

Why can't i add a content type?

Hello everybody,

A few days ago, i installed Drupal Commerce Kickstart with products examples.. Great piece of software! I then installed the Subs module as well as Organic Group. Everything went well and i've got everything uptodate.

However, when i want to "add a content type", it displays a blank screen with these errors:

"Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {commerce_tax_rate}; Array ( ) in commerce_tax_ui_commerce_tax_rate_info() (line 347 of ../profiles/commerce_kickstart/modules/contrib/commerce/modules/tax/commerce_tax_ui.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:110:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {commerce_tax_rate}; Array ( ) ";s:9:"%function";s:40:"commerce_tax_ui_commerce_tax_rate_info()";s:5:"%file";s:123:"../profiles/commerce_kickstart/modules/contrib/commerce/modules/tax/commerce_tax_ui.module";s:5:"%line";i:347;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => ../admin/commerce/config/types/content/add [:db_insert_placeholder_7] => ../ [:db_insert_placeholder_8] => ::1 [:db_insert_placeholder_9] => 1351170037 ) in dblog_watchdog() (line 154 of ../modules/dblog/dblog.module)."

Could anyone help me on this... Unfortunately i'm no developer (just a humble site builder) with little knowledge of PHP/SQL... but if someone can help me, i'll be more than happy to get my hands dirty!

Thanks!

Asked by: cicampemu
on October 25, 2012

2 Answers

Vote up!
0
Vote down!

Ok, so i did try to MySQL's max_allowed_packet to 64M (working with MAMP) but this didn't change anything.

Answer by: cicampemu
Posted: Oct 25, 2012
Vote up!
0
Vote down!

Ok, so i did it!It's working... what i did was:

in MAMP, i opened ...\MAMP\bin\startMysql.sh and i copied and paste:

# /bin/sh
/Applications/MAMP/Library/bin/mysqld_safe --port=3306 --max_allowed_packet=268435456 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=0 --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log &

That's it! The idea is to rise MySQL's max_allowed_packet.

check: http://snipplr.com/view/65272/

Answer by: cicampemu
Posted: Oct 25, 2012