Hi there, Micheal

I have read the forums and seem to do with the database. I haven't done the tuning yet, and it is only on my local machine with plenty of ram...etc.

The problem is after creating the 34 fileds (admin/content/node-type/uprofile/fields), 100s of the following warning appears on the screen and whenever i any other filed then it backs to normal...... , do u have any idea to fix this without tuning the db? or do u know what exactly cause that happen??

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:119:\"MySQL server has gone away\nquery: SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1258109315 AND uid = 0\";s:5:\"%file\";s:51:\"C:\\xampp\\htdocs\\qbs_v01r01_dev\\includes\\session.inc\";s:5:\"%line\";i:119;}', 3, '', 'http://localhost:8080/qbs_v01r01_dev/admin/content/node-type/uprofile/fi...', 'http://localhost:8080/qbs_v01r01_dev/admin/content/node-type/uprofile/fi...', '127.0.0.1', 1258110215) in C:\xampp\htdocs\qbs_v01r01_dev\includes\database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:122:\"MySQL server has gone away\nquery: SELECT COUNT(DISTINCT uid) FROM sessions WHERE uid > 0 AND timestamp >= 1258109315\";s:5:\"%file\";s:81:\"C:\\xampp\\htdocs\\qbs_v01r01_dev\\sites\\default\\modules\\admin_menu\\admin_menu.module\";s:5:\"%line\";i:473;}', 3, '', 'http://localhost:8080/qbs_v01r01_dev/admin/content/node-type/uprofile/fi...', 'http://localhost:8080/qbs_v01r01_dev/admin/content/node-type/uprofile/fi...', '127.0.0.1', 125811 in C:\xampp\htdocs\qbs_v01r01_dev\includes\database.mysqli.inc on line 128

Comments

foodbo’s picture

foodbo commented

when i set the php.in 's mysqli.reconnect = on, now it gaves me "MySQL server has gone away", i can use most of page, except editing anything.

user warning: MySQL server has gone away query: UPDATE cache_menu SET data = 'a:2:{s:4:\"tree\";a:89:{i:1993;a:2:{s:4:\"link\";a:37:{s:14:\"load_functions\";s:0:\"\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"user_access\";s:16:\"access_arguments\";s:45:\"a:1:{i:0;s:27:\"access administration pages\";}\";s:13:\"page_callback\";s:22:\"system_main_admin_page\";s:14:\"page_arguments\";s:6:\"a:0:{}\";s:5:\"title\";s:10:\"Administer\";s:14:\"title_callback\";s:1:\"t\";s:15:\"title_arguments\";s:0:\"\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:10:\"admin_menu\";s:4:\"mlid\";s:4:\"1993\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:5:\"admin\";s:11:\"router_path\";s:5:\"admin\";s:10:\"link_title\";s:10:\"Administer\";s:7:\"options\";s:6:\"a:0:{}\";s:6:\"module\";s:6:\"system\";s:6:\"hidden\";s:2:\"-1\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"0\";s:8:\"expanded\";s:1:\"0\";s:6:\"weight\";s:1:\"9\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"0\";s:2:\"p1\";s:4:\"1993\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:0;}s:5:\"below\";b:0;}i:1994;a:2:{s:4:\"link\";a:37:{s:14:\"load_functions\";s:0:\"\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"user_access\";s:16:\"access_arguments\";s:42:\"a:1:{i:0;s:24:\"view advanced help.............................................

and then, when i change the mysql.ini then seems back to normal. "HELP"!, as it is just a local server and i can change anything i want but i won't be able to do anything when i upload to the share host..

from 

port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql" 
tmpdir="C:/xampp/tmp" 
datadir="C:/xampp/mysql/data"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"

to 

[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql" 
tmpdir="C:/xampp/tmp" 
datadir="C:/xampp/mysql/data"
skip-locking
key_buffer = 32M
max_allowed_packet = 2M
table_cache = 128
sort_buffer_size = 1M
net_buffer_length = 8K
read_buffer_size = 1MK
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented
Project: Advanced Profile Kit » Content Construction Kit (CCK)
Version: 6.x-1.0-alpha3 » 6.x-2.6
Component: Code » content_copy.module

Who's Michael? :P

I really have no idea. You're getting errors after adding too many CCK fields to a node type, which is really nothing to do with APK. Moving this over to the CCK queue to see if they have any ideas.

Michelle

markus_petrux’s picture

markus_petrux commented
Status: Active » Fixed

Try to increase the value of wait_timeout or max_allowed_packet in your MySQL settings.

This is often an issue caused by lack of resources available to MySQL. Please, read:

http://drupal.org/node/364451

foodbo’s picture

foodbo commented

thanks Michelle :-)

and Markus,

i have tried the mysql settings and seem fixed on my local server but i can't do much on the shared hosting server, so is there anything else i could do instead??

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.