Helo!
Készítettem egy honlapot és ahogy szerkesztgettem valami generálja ezt a hibaüzenetet:
"user warning: MySQL server has gone away query: "
... és utána még km hosszú sql lekérdezés hibák.
Ha valamilyen szerkesztésre rákattintok mindig vár kb fél percig és utána timeout, megint ez a sok hibaüzenet. Ilyenkor felül az admin_menu (modul) se jelenik meg.
Ha kiveszem az upload modulet, akkor minden jó.
Az upload-dal van valami, vagy más modullal lehet baj? Nézzem végig egyesével?
Dabsol
Fórum:
Ennek a hibajelenségnek
az SQL része a lényeg. Tehát pont azt lenne jó látni.
Nagy Gusztáv
user warning: MySQL server
user warning: MySQL server has gone away query: UPDATE cache_update SET data = 'a:26:{s:10:\"admin_menu\";a:10:{s:5:\"title\";s:19:\"Administration menu\";s:10:\"short_name\";s:10:\"admin_menu\";s:10:\"dc:creator\";s:3:\"sun\";s:11:\"api_version\";s:3:\"6.x\";s:17:\"recommended_major\";s:1:\"1\";s:16:\"supported_majors\";s:3:\"1,3\";s:13:\"default_major\";s:1:\"1\";s:14:\"project_status\";s:9:\"published\";s:4:\"link\";s:36:\"http://drupal.org/project/admin_menu\";s:8:\"releases\";a:14:{s:14:\"6.x-3.0-alpha4\";a:13:{s:4:\"name\";s:25:\"admin_menu 6.x-3.0-alpha4\";s:7:\"version\";s:14:\"6.x-3.0-alpha4\";s:3:\"tag\";s:20:\"DRUPAL-6--3-0-ALPHA4\";s:13:\"version_major\";s:1:\"3\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:6:\"alpha4\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/739026\";s:13:\"download_link\";s:69:\"http://ftp.drupal.org/files/projects/admin_menu-6.x-3.0-alpha4.tar.gz\";s:4:\"date\";s:10:\"1268274904\";s:6:\"mdhash\";s:32:\"ba93c801409700854965f87b5df72817\";s:8:\"filesize\";s:5:\"69865\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:14:\"6.x-3.0-alpha3\";a:13:{s:4:\"name\";s:25:\"admin_menu 6.x-3.0-alpha3\";s:7:\"version\";s:14:\"6.x-3.0-alpha3\";s:3:\"tag\";s:20:\"DRUPAL-6--3-0-ALPHA3\";s:13:
Ez az eleje, az összes modult felsorolja...
A vége:
.0-alpha1\";a:13:{s:4:\"name\";s:22:\"wysiwyg 6.x-2.0-alpha1\";s:7:\"version\";s:14:\"6.x-2.0-alpha1\";s:3:\"tag\";s:20:\"DRUPAL-6--2-0-ALPHA1\";s:13:\"version_major\";s:1:\"2\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:6:\"alpha1\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/464872\";s:13:\"download_link\";s:66:\"http://ftp.drupal.org/files/projects/wysiwyg-6.x-2.0-alpha1.tar.gz\";s:4:\"date\";s:10:\"1242523576\";s:6:\"mdhash\";s:32:\"a745141da5436606e8bdf848cfd6da20\";s:8:\"filesize\";s:5:\"80232\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:12:\"New features\";}}}s:11:\"6.x-2.x-dev\";a:11:{s:4:\"name\";s:19:\"wysiwyg 6.x-2.x-dev\";s:7:\"version\";s:11:\"6.x-2.x-dev\";s:3:\"tag\";s:11:\"DRUPAL-6--2\";s:13:\"version_major\";s:1:\"2\";s:13:\"version_extra\";s:3:\"dev\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/365590\";s:13:\"download_link\";s:63:\"http://ftp.drupal.org/files/projects/wysiwyg-6.x-2.x-dev.tar.gz\";s:4:\"date\";s:10:\"1284121407\";s:6:\"mdhash\";s:32:\"02866872ed73634d380e242387fe13dd\";s:8:\"filesize\";s:6:\"113450\";}s:7:\"6.x-1.2\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-1.2\";s:7:\"version\";s:7:\"6.x-1.2\";s:3:\"tag\";s:13:\"DRUPAL-6--1-2\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"2\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1242522960\";s:6:\"mdhash\";s:32:\"4d4e038fb609ad57b7430a563f03fd09\";s:8:\"filesize\";s:5:\"65875\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:9:\"Bug fixes\";}}}s:7:\"6.x-1.1\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-1.1\";s:7:\"version\";s:7:\"6.x-1.1\";s:3:\"tag\";s:13:\"DRUPAL-6--1-1\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"1\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1236562853\";s:6:\"mdhash\";s:32:\"e0d84b73c7f903d9f50e96ff39e15c4a\";s:8:\"filesize\";s:5:\"65534\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:9:\"Bug fixes\";}}}s:7:\"6.x-1.0\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-1.0\";s:7:\"version\";s:7:\"6.x-1.0\";s:3:\"tag\";s:13:\"DRUPAL-6--1-0\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"0\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1234552285\";s:6:\"mdhash\";s:32:\"47f4db6f8b9f711835203a1a04c4c287\";s:8:\"filesize\";s:5:\"59227\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:11:\"6.x-1.x-dev\";a:9:{s:4:\"name\";s:19:\"wysiwyg 6.x-1.x-dev\";s:7:\"version\";s:11:\"6.x-1.x-dev\";s:3:\"tag\";s:11:\"DRUPAL-6--1\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_extra\";s:3:\"dev\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1244161854\";s:6:\"mdhash\";s:32:\"88d40ccdebd0bb3dd21f6890adf60bfd\";s:8:\"filesize\";s:5:\"71871\";}s:7:\"6.x-0.5\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-0.5\";s:7:\"version\";s:7:\"6.x-0.5\";s:3:\"tag\";s:13:\"DRUPAL-6--0-5\";s:13:\"version_major\";s:1:\"0\";s:13:\"version_patch\";s:1:\"5\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1228142425\";s:6:\"mdhash\";s:32:\"dfc9b006642cda543fd17c841462cee2\";s:8:\"filesize\";s:5:\"54206\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:7:\"6.x-0.4\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-0.4\";s:7:\"version\";s:7:\"6.x-0.4\";s:3:\"tag\";s:13:\"DRUPAL-6--0-4\";s:13:\"version_major\";s:1:\"0\";s:13:\"version_patch\";s:1:\"4\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1224021920\";s:6:\"mdhash\";s:32:\"db01863f705e57477d6508bd083c75f2\";s:8:\"filesize\";s:5:\"50865\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:7:\"6.x-0.3\";a:10:{s:4:\"name\";s:15:\"wysiwyg 6.x-0.3\";s:7:\"version\";s:7:\"6.x-0.3\";s:3:\"tag\";s:13:\"DRUPAL-6--0-3\";s:13:\"version_major\";s:1:\"0\";s:13:\"version_patch\";s:1:\"3\";s:6:\"status\";s:11:\"unpublished\";s:4:\"date\";s:10:\"1221251441\";s:6:\"mdhash\";s:32:\"3fd04f042435a957e4abed89ab71e4ea\";s:8:\"filesize\";s:5:\"45967\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:9:\"Bug fixes\";}}}}s:14:\"latest_version\";s:7:\"6.x-2.1\";s:11:\"recommended\";s:7:\"6.x-2.1\";s:6:\"status\";i:5;}s:3:\"zen\";a:23:{s:4:\"name\";s:3:\"zen\";s:4:\"info\";a:5:{s:4:\"name\";s:3:\"Zen\";s:7:\"version\";s:7:\"6.x-2.0\";s:7:\"project\";s:3:\"zen\";s:9:\"datestamp\";s:10:\"1277583313\";s:16:\"_info_file_ctime\";i:1284584568;}s:9:\"datestamp\";s:10:\"1277583313\";s:8:\"includes\";a:1:{s:3:\"zen\";s:3:\"Zen\";}s:12:\"project_type\";s:5:\"theme\";s:10:\"sub_themes\";a:1:{s:6:\"planta\";s:6:\"planta\";}s:11:\"base_themes\";a:0:{}s:16:\"existing_version\";s:7:\"6.x-2.0\";s:14:\"existing_major\";s:1:\"2\";s:12:\"install_type\";s:8:\"official\";s:5:\"title\";s:3:\"Zen\";s:10:\"short_name\";s:3:\"zen\";s:10:\"dc:creator\";s:9:\"JohnAlbin\";s:11:\"api_version\";s:3:\"6.x\";s:17:\"recommended_major\";s:1:\"2\";s:16:\"supported_majors\";s:3:\"1,2\";s:13:\"default_major\";s:1:\"1\";s:14:\"project_status\";s:9:\"published\";s:4:\"link\";s:29:\"http://drupal.org/project/zen\";s:8:\"releases\";a:9:{s:7:\"6.x-2.0\";a:12:{s:4:\"name\";s:11:\"zen 6.x-2.0\";s:7:\"version\";s:7:\"6.x-2.0\";s:3:\"tag\";s:13:\"DRUPAL-6--2-0\";s:13:\"version_major\";s:1:\"2\";s:13:\"version_patch\";s:1:\"0\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/838400\";s:13:\"download_link\";s:55:\"http://ftp.drupal.org/files/projects/zen-6.x-2.0.tar.gz\";s:4:\"date\";s:10:\"1277583313\";s:6:\"mdhash\";s:32:\"f1c9043ab101550e16353ab33f22ee2f\";s:8:\"filesize\";s:6:\"180354\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:13:\"6.x-2.0-beta1\";a:13:{s:4:\"name\";s:17:\"zen 6.x-2.0-beta1\";s:7:\"version\";s:13:\"6.x-2.0-beta1\";s:3:\"tag\";s:19:\"DRUPAL-6--2-0-BETA1\";s:13:\"version_major\";s:1:\"2\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:5:\"beta1\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/628468\";s:13:\"download_link\";s:61:\"http://ftp.drupal.org/files/projects/zen-6.x-2.0-beta1.tar.gz\";s:4:\"date\";s:10:\"1257843993\";s:6:\"mdhash\";s:32:\"08015c0d0b040dba9721a05fc99768e4\";s:8:\"filesize\";s:6:\"153722\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:11:\"6.x-2.x-dev\";a:12:{s:4:\"name\";s:15:\"zen 6.x-2.x-dev\";s:7:\"version\";s:11:\"6.x-2.x-dev\";s:3:\"tag\";s:11:\"DRUPAL-6--2\";s:13:\"version_major\";s:1:\"2\";s:13:\"version_extra\";s:3:\"dev\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/373826\";s:13:\"download_link\";s:59:\"http://ftp.drupal.org/files/projects/zen-6.x-2.x-dev.tar.gz\";s:4:\"date\";s:10:\"1284510232\";s:6:\"mdhash\";s:32:\"9dadd71ff54cf2b042b736273510f37e\";s:8:\"filesize\";s:6:\"178979\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:12:\"New features\";}}}s:7:\"6.x-1.1\";a:12:{s:4:\"name\";s:11:\"zen 6.x-1.1\";s:7:\"version\";s:7:\"6.x-1.1\";s:3:\"tag\";s:13:\"DRUPAL-6--1-1\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"1\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/628480\";s:13:\"download_link\";s:55:\"http://ftp.drupal.org/files/projects/zen-6.x-1.1.tar.gz\";s:4:\"date\";s:10:\"1257845814\";s:6:\"mdhash\";s:32:\"1a64f7b9d24d520ba3ffca641937595c\";s:8:\"filesize\";s:6:\"134849\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:7:\"6.x-1.0\";a:12:{s:4:\"name\";s:11:\"zen 6.x-1.0\";s:7:\"version\";s:7:\"6.x-1.0\";s:3:\"tag\";s:13:\"DRUPAL-6--1-0\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"0\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/374119\";s:13:\"download_link\";s:55:\"http://ftp.drupal.org/files/projects/zen-6.x-1.0.tar.gz\";s:4:\"date\";s:10:\"1234555897\";s:6:\"mdhash\";s:32:\"334c0a648b2e1b5f80e9e5e0754869a4\";s:8:\"filesize\";s:6:\"383930\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:13:\"6.x-1.0-beta3\";a:13:{s:4:\"name\";s:17:\"zen 6.x-1.0-beta3\";s:7:\"version\";s:13:\"6.x-1.0-beta3\";s:3:\"tag\";s:19:\"DRUPAL-6--1-0-beta3\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:5:\"beta3\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/308618\";s:13:\"download_link\";s:61:\"http://ftp.drupal.org/files/projects/zen-6.x-1.0-beta3.tar.gz\";s:4:\"date\";s:10:\"1221475935\";s:6:\"mdhash\";s:32:\"af4627f4d61ec1f3642d6c6ddc38ac7f\";s:8:\"filesize\";s:6:\"337959\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:2:{i:0;s:12:\"New features\";i:1;s:9:\"Bug fixes\";}}}s:13:\"6.x-1.0-beta2\";a:13:{s:4:\"name\";s:17:\"zen 6.x-1.0-beta2\";s:7:\"version\";s:13:\"6.x-1.0-beta2\";s:3:\"tag\";s:19:\"DRUPAL-6--1-0-beta2\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:5:\"beta2\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/260642\";s:13:\"download_link\";s:61:\"http://ftp.drupal.org/files/projects/zen-6.x-1.0-beta2.tar.gz\";s:4:\"date\";s:10:\"1211289618\";s:6:\"mdhash\";s:32:\"18f3526daa89f623b17aee41336e92ce\";s:8:\"filesize\";s:6:\"327638\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:9:\"Bug fixes\";}}}s:13:\"6.x-1.0-beta1\";a:13:{s:4:\"name\";s:17:\"zen 6.x-1.0-beta1\";s:7:\"version\";s:13:\"6.x-1.0-beta1\";s:3:\"tag\";s:19:\"DRUPAL-6--1-0-beta1\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:5:\"beta1\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/258509\";s:13:\"download_link\";s:61:\"http://ftp.drupal.org/files/projects/zen-6.x-1.0-beta1.tar.gz\";s:4:\"date\";s:10:\"1210787719\";s:6:\"mdhash\";s:32:\"a99d11312abcc0e057ceb664f3c6ac90\";s:8:\"filesize\";s:6:\"327549\";s:5:\"terms\";a:1:{s:12:\"Release type\";a:1:{i:0;s:12:\"New features\";}}}s:11:\"6.x-1.x-dev\";a:11:{s:4:\"name\";s:15:\"zen 6.x-1.x-dev\";s:7:\"version\";s:11:\"6.x-1.x-dev\";s:3:\"tag\";s:11:\"DRUPAL-6--1\";s:13:\"version_major\";s:1:\"1\";s:13:\"version_extra\";s:3:\"dev\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:28:\"http://drupal.org/node/96810\";s:13:\"download_link\";s:59:\"http://ftp.drupal.org/files/projects/zen-6.x-1.x-dev.tar.gz\";s:4:\"date\";s:10:\"1284510231\";s:6:\"mdhash\";s:32:\"4b3b0143a60f9d4733b864e0f44338a2\";s:8:\"filesize\";s:6:\"135762\";}}s:14:\"latest_version\";s:7:\"6.x-2.0\";s:11:\"recommended\";s:7:\"6.x-2.0\";s:6:\"status\";i:5;}}', created = 1284731601, expire = 1284735201, serialized = 1 WHERE cid = 'update_project_data' in /web/PAH/plant.hu/modules/update/update.module on line 554.
user warning: MySQL server has gone away query: SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'hu' WHERE s.source = 'There are updates available for one or more of your modules or themes. To ensure the proper functioning of your site, you should update as soon as possible.' AND s.textgroup = 'default' in /web/PAH/plant.hu/modules/locale/locale.module on line 375.
user warning: MySQL server has gone away query: INSERT INTO locales_source (location, source, textgroup, version) VALUES ('/hu/admin/build/modules', 'There are updates available for one or more of your modules or themes. To ensure the proper functioning of your site, you should update as soon as possible.', 'default', '6.19') in /web/PAH/plant.hu/modules/locale/locale.module on line 391.
user warning: MySQL server has gone away query: DELETE FROM cache WHERE cid LIKE 'locale:%' in /web/PAH/plant.hu/includes/cache.inc on line 175.
user warning: MySQL server has gone away query: SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'hu' WHERE s.source = 'See the available updates page for more information.' AND s.textgroup = 'default' in /web/PAH/plant.hu/modules/locale/locale.module on line 375.
user warning: MySQL server has gone away query: INSERT INTO locales_source (location, source, textgroup, version) VALUES ('/hu/admin/build/modules', 'See the available updates page for more information.', 'default', '6.19') in /web/PAH/plant.hu/modules/locale/locale.module on line 391.
user warning: MySQL server has gone away query: DELETE FROM cache WHERE cid LIKE 'locale:%' in /web/PAH/plant.hu/includes/cache.inc on line 175.
user warning: MySQL server has gone away query: SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'hu' WHERE s.source = 'See the available updates page for information on installed modules and themes with new versions released.' AND s.textgroup = 'default' in /web/PAH/plant.hu/modules/locale/locale.module on line 375.
user warning: MySQL server has gone away query: INSERT INTO locales_source (location, source, textgroup, version) VALUES ('/hu/admin/build/modules', 'See the available updates page for information on installed modules and themes with new versions released.', 'default', '6.19') in /web/PAH/plant.hu/modules/locale/locale.module on line 391.
user warning: MySQL server has gone away query: DELETE FROM cache WHERE cid LIKE 'locale:%' in /web/PAH/plant.hu/includes/cache.inc on lin
Lebukott az update modul.
Lebukott az update modul. Visszatettem egy korábbi admin menűt, azzal más, kevesebb hibaüzenet jelent meg. Aztán az update modulnál bekapcsoltam a visszafogót és megszűntek a hibák. Úgy gondolom túl sok sql lekérdezés történik és ez inkább szerver beállítási hiba.
MySQL server has gone away query
Napok ota en is pont ilyen problemaval kuzdok, de nem sokat ertek hozza. Egy dolgot nem ertek. Hogyan lehet, hogy tobb drupalos oldalomon is az egyik naprol a masikra ekezdodott a hibauzenetek kilometer hosszu kiirasa, mikozben van olyan oldal, amihez honapok ota hozza sem nyultam? Nem a szerveren tortent valami? Olvasgatom a hiba javitasarol szolo valaszokat, de valaki nem irna le egyszerubben?
Elore is kosszonom a segitseget! Szabolcs
Szabolcs