KEY id (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT '{$model_name}属性表'"; $this->db->query($sql_table); $sql_table = "CREATE TABLE IF NOT EXISTS {$table_cms_tag} ( tagid int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签ID', `name` varchar(80) NOT NULL DEFAULT '' COMMENT '标签名', `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '标签内容数量', content varchar(255) NOT NULL DEFAULT '' COMMENT '标签说明', pic varchar(255) NOT NULL DEFAULT '' COMMENT '标签缩略图', seo_title varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO标题', seo_keywords varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO关键词', seo_description varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO描述', orderby int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序值', PRIMARY KEY (tagid), UNIQUE KEY tagname (`name`), KEY content_count (`count`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT '{$model_name}标签表'"; $this->db->query($sql_table); $sql_table = "CREATE TABLE IF NOT EXISTS {$table_cms_tag_data} ( tagid int(10) unsigned NOT NULL COMMENT '标签ID', id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID', PRIMARY KEY (tagid,id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT '{$model_name}标签数据表'"; $this->db->query($sql_table); $sql_table = "CREATE TABLE IF NOT EXISTS {$table_cms_views} ( id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID', cid int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID', views int(10) unsigned NOT NULL DEFAULT '0' COMMENT '查看次数', PRIMARY KEY (id), KEY cid (cid,views), KEY views (views) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT '{$model_name}浏览量表'"; $this->db->query($sql_table); return ''; } //删除或清空模型 public function xdelete($mid = 0, $del_table = 1){ // 内容读取 $data = $this->get($mid); if(empty($data)) return lang('data_no_exists'); if( $data['system'] && $del_table ) return lang('system_model_no_delete'); if($del_table){ $ret = $this->delete($mid); }else{ $ret = true; } if($ret){ //删除模型时，删除自定义字段表里面的字段信息 $this->models_field->find_delete(array('mid'=>$mid)); //单页 if($mid < 2){ return ''; } $table = $data['tablename']; $tableprefix = $_ENV['_config']['db']['master']['tablepre']; //表前缀 $table_cms = $tableprefix.'cms_'.$table; $table_cms_attach = $tableprefix.'cms_'.$table.'_attach'; $table_cms_data = $tableprefix.'cms_'.$table.'_data'; $table_cms_flag = $tableprefix.'cms_'.$table.'_flag'; $table_cms_tag = $tableprefix.'cms_'.$table.'_tag'; $table_cms_tag_data = $tableprefix.'cms_'.$table.'_tag_data'; $table_cms_views = $tableprefix.'cms_'.$table.'_views'; if($del_table){ //删除相关表 $sql = "DROP TABLE IF EXISTS ".$table_cms; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_attach; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_data; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_flag; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_tag; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_tag_data; $this->db->query($sql); $sql = "DROP TABLE IF EXISTS ".$table_cms_views; $this->db->query($sql); //删除模型相关分类 $this->category->find_delete(array('mid'=>$mid)); }else{ $this->cms_content->table = 'cms_'.$table; $this->cms_content_data->table = 'cms_'.$table.'_data'; $this->cms_content_attach->table = 'cms_'.$table.'_attach'; $this->cms_content_flag->table = 'cms_'.$table.'_flag'; $this->cms_content_tag->table = 'cms_'.$table.'_tag'; $this->cms_content_tag_data->table = 'cms_'.$table.'_tag_data'; $this->cms_content_views->table = 'cms_'.$table.'_views'; $this->cms_content->truncate(); $this->cms_content_data->truncate(); $this->cms_content_attach->truncate(); $this->cms_content_flag->truncate(); $this->cms_content_tag->truncate(); $this->cms_content_tag_data->truncate(); $this->cms_content_views->truncate(); //清空模型相关分类内容数量 $this->category->find_update(array('mid'=>$mid), array('count'=>0)); } //删除模型内容的评论 $this->cms_content_comment->find_delete(array('mid'=>$mid)); $this->cms_content_comment_sort->find_delete(array('mid'=>$mid)); // 重新统计用户的内容数量 $pagenum = 500; $user_total = $this->user->count(); //所有内容模型的表名 $table_arr = $this->get_table_arr(); $maxpage = max(1, ceil($user_total/$pagenum)); for($i = 1; $i <= $maxpage; $i++){ $user_arr = $this->user->list_arr(array(), 'uid', 1, ($i-1)*$pagenum, $pagenum, $user_total); foreach ($user_arr as $user){ $this->user->update_user_contents($user, $table_arr); } } //清除缓存 $this->runtime->truncate(); $this->db->truncate('framework_count'); $this->db->truncate('framework_maxid'); return ''; }else{ return lang('delete_failed'); } } } Lecms 3.0.3 错误

错误信息

错误位置

基本信息

程序流程

SQL

$_GET

$_POST

$_COOKIE

包含文件

其他信息