项目插件无法使用，数据库报错

mengkun

重装项目插件试过了也不行……

出错了! (warning!)
no such table: plugin_project_user[ SQL语句 ] :SELECT projectID FROM `plugin_project_user` WHERE ( taskID = 0 ) AND ( userID = 1 )
系统错误 (plugin.project.projectListSelf)
bin/data.bin[2] DbSqlite3->query("SELECT projectID FROM `plugin_project_user` WHERE ( taskID = 0 ) AND ( userID = 1 ) ")
bin/data.bin[2] DbSqlite3->error()
[Linux 3.10.0-1160.62.1.el7.x86_64/7.4.33/sqlite3/1.56.02]

mengkun

经过排查，是 plugin_project_sqlit.sql 里的 plugin_project_user 建表语句存在问题（创建了两个主键，存在冲突），导致数据库表没有创建成功

table "plugin_project_user" has more than one primary key[ SQL语句 ] :CREATE TABLE "plugin_project_user" ( "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "projectID" integer NOT NULL, "taskID" integer NOT NULL, "userID" integer NOT NULL, "authType" integer NOT NULL, "createTime" integer NOT NULL, "modifyTime" integer NOT NULL, PRIMARY KEY ("id"), KEY "projectID" ("projectID"), KEY "userID" ("userID"), KEY "createTime" ("createTime"), KEY "modifyTime" ("modifyTime"), KEY "taskID" ("taskID")) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目成员表';

nemo

mengkun 确实这张表创建索引部分有问题，mysql转sqlite没转完全。

warlee

sqlite 兼容问题,已兼容更新.

mengkun

warlee

还是有 BUG，进入项目后台管理中会报错

出错了! (warning!)
no such function: FROM_UNIXTIME[ SQL语句 ] :SELECT FROM_UNIXTIME(createTime,'%Y-%m-%d') AS day,count(*) AS _count FROM `plugin_project_task` GROUP BY day ORDER BY day desc LIMIT 360
系统错误 (plugin.project.adminInfo)
bin/data.bin[2] DbSqlite3->query("SELECT FROM_UNIXTIME(createTime,'%Y-%m-%d') AS day,count(*) AS _count FROM `plugin_project_task` GROUP BY day ORDER BY day desc LIMIT 360 ")
bin/data.bin[2] DbSqlite3->error()
[Linux 3.10.0-1160.62.1.el7.x86_64/7.4.33/sqlite3/1.57.01]

sqlite 不支持 FROM_UNIXTIME 函数……

warlee

mengkun
已兼容处理.

mengkun

另外之前安装过旧版的要进入 plugins/project/app.php

先注释掉如下两行：

	// 检测并创建数据表;
	private function checkInstall(){
		// if($this->isInstall()) return;  // 注释这行
		$db = $this->config['database'];
		$tableHas = 'plugin_project';
		$tables = Model()->db()->getTables();
		// if(in_array($tableHas, $tables)){return $this->installSet('1');}  // 注释这行
		$sqlFile = $this->pluginPath.'lib/plugin_project.sql';
		if(stristr($this->config['database']['DB_TYPE'],'sqlite')){
			$sqlFile = $this->pluginPath.'lib/plugin_project_sqlit.sql';
		}
		$sqlArr = sqlSplit(file_get_contents($sqlFile));
		foreach($sqlArr as $sql){
			Model()->db()->execute($sql);
		}

		$tables = Model()->db()->getTables();
		if(in_array($tableHas,$tables)){$this->installSet('1');}
	}

再重新启用项目插件，让数据库重新导入，然后取消这两行的注释
再重新启用项目插件，让数据库重新导入，然后取消这两行的注释
再重新启用项目插件，让数据库重新导入，然后取消这两行的注释