drupal 视图模块 mysql 错误

2021-12-29 00:00:00 mysql drupal views mysql-error-2006

我已启用视图模块并在我转到结构>drupal 7 中的视图时得到这个

i have enabled the view module and get this when i go to structure>views in drupal 7

处理异常时抛出的其他未捕获异常.原创

Additional uncaught exception thrown while handling exception. Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has away: DELETE FROM {cache_form} WHERE (cid = :db_condition_placeholder_0) ;cache_clear_all() 中的数组( [:db_condition_placeholder_0] => form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o )(/home/tennis/public_html/includes/cache.inc 的第 170 行).附加

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {cache_form} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o ) in cache_clear_all() (line 170 of /home/tennis/public_html/includes/cache.inc). Additional

PDOException:SQLSTATE[HY000]:一般错误:2006 MySQL 服务器已经消失:INSERT INTO {watchdog}(uid、类型、消息、变量、严重性、链接、位置、引用、主机名、时间戳)值(: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, :d_insert_placeholder_98);数组 ( [: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:240:"SQLSTATE[HY000]: 一般错误:2006 MySQL 服务器已消失:DELETE FROM {cache_form} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o :"%function":;s:17:"cache_clear_all()";s:5:"%file";s:43:"/home/tennis/public_html/includes/cache.inc";s:5:"%行";i:170;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://192.168.1.66/~tennis/admin/structure/views [:db_insert_placeholder_7] =>http://192.168.1.66/~tennis/user/1 [:db_insert_placeholder_8] =>192.168.1.172 [:db_insert_placeholder_9] =>1309366098 ) 在 dblog_watchdog() 中(/home/tennis/public_html/modules/dblog/dblog.module 的第 155 行).

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:240:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {cache_form} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o ) ";s:9:"%function";s:17:"cache_clear_all()";s:5:"%file";s:43:"/home/tennis/public_html/includes/cache.inc";s:5:"%line";i:170;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://192.168.1.66/~tennis/admin/structure/views [:db_insert_placeholder_7] => http://192.168.1.66/~tennis/user/1 [:db_insert_placeholder_8] => 192.168.1.172 [:db_insert_placeholder_9] => 1309366098 ) in dblog_watchdog() (line 155 of /home/tennis/public_html/modules/dblog/dblog.module).

我的问题是什么?

推荐答案

以下是有关该错误的一些信息:http://dev.mysql.com/doc/refman/5.1/en/gone-away.html 和 Drupal.org 上的类似问题:http://drupal.org/node/984112

Here is some information on that error: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html and a similar issue on Drupal.org: http://drupal.org/node/984112

关于此错误的另一篇有用的帖子:http://madhavvyas.blogspot.com/

Another helpful post regarding this error: http://madhavvyas.blogspot.com/

问题似乎出在 MySQL 配置中的 max_allowed_pa​​cket.

It seems that the problem lies with max_allowed_packet in the configuration for MySQL.

从 Drupal 问题中，另一个用户提供了一些可能对您有帮助的步骤(该用户使用的是 XAMPP，但步骤类似):

From the Drupal issue, another user provides some steps that may assist you (this user is using XAMPP but steps are similar):

如何解决这个问题

  • 转到 xamppmysqlin
  • 打开 my.ini
  • 将max_allowed_pa​​cket"从1m"更改为16m"(或更大)
  • 保存 my.ini 现在通过 XAMPP 控制面板重新启动 MySql.

相关文章