drupal视图模块mysql错误 [英] drupal views module mysql error

问题描述

我已经启用了视图模块，当我去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]：常规错误：2006 MySQL服务器已经消失：DELETE FROM {cache_form} （cid =：db_condition_placeholder_0）;阵列（[：db_condition_placeholder_0] => form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o）中cache_clear_all（）（/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，type，message，variables ，严重性，链接，位置，引荐，主机名，时间戳）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（！％）（％文件的行％行）[：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）;阵列（[：db_condition_placeholder_0] =&安培; GT; form_form-MKcd7j8VJkLHaG7-JGW-vREo_XeUngdnLcqlKOn-02o）英寸; S：9："％功能" ; S：17：" cache_clear_all（）英寸; S：5："％文件英寸; 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):

如何解决此问题

How to fix this problem

• 转到xampp \mysq l\bin


• 打开my.ini


• 将max_allowed_pa​​cket从1m更改为16m（或更大）


• 保存my.ini现在通过XAMPP控制面板重新启动MySql。

• Go to xampp\mysql\bin
• Open my.ini
• Change "max_allowed_packet" from "1m" to "16m" (or larger)
• Save my.ini Now restart MySql through the XAMPP control panel.

这篇关于drupal视图模块mysql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！