jeesite mysql_Jeesite框架mysql数据库初始报错

2023-05-16

[INFO] Scanning for projects...

[WARNING]

[WARNING] Some problems were encountered while building the effective model for com.thinkgem.jeesite:jeesite:war:1.2.7

[WARNING] 'dependencies.dependency.systemPath' for com.oracle:ojdbc14:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ojdbc14-10.2.0.4.0.jar will be unresolvable by dependent projects @ line 200, column 16

[WARNING] 'dependencies.dependency.systemPath' for org.wltea:analyzer:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/analyzer-2012_u6.jar will be unresolvable by dependent projects @ line 538, column 16

[WARNING] 'dependencies.dependency.systemPath' for net.coobird:thumbnailator:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/thumbnailator-0.4.2.jar will be unresolvable by dependent projects @ line 548, column 16

[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:apache-ant-zip:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/apache-ant-zip-2.3.jar will be unresolvable by dependent projects @ line 555, column 16

[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinder:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinder-2.3.jar will be unresolvable by dependent projects @ line 562, column 16

[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinderplugin-fileeditor:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinderplugin-fileeditor-2.3.jar will be unresolvable by dependent projects @ line 569, column 16

[WARNING] 'dependencies.dependency.systemPath' for com.ckfinder:ckfinderplugin-imageresize:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ckfinderplugin-imageresize-2.3.jar will be unresolvable by dependent projects @ line 576, column 16

[WARNING] 'dependencies.dependency.systemPath' for bitwalker:UserAgentUtils:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/UserAgentUtils-1.13.jar will be unresolvable by dependent projects @ line 599, column 16

[WARNING]

[WARNING] It is highly recommended to fix these problems because they threaten the stability of your build.

[WARNING]

[WARNING] For this reason, future Maven versions might no longer support building such malformed projects.

[WARNING]

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building JeeSite 1.2.7

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] --- maven-antrun-plugin:1.7:run (default-cli) @ jeesite ---

[INFO] Executing tasks

main:

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\sys\jeesite_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\cms\jeesite_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\oa\jeesite_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\gen\jeesite_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\gen\example_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\test\jeesite_mysql.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.engine.sql

[sql] Failed to execute: drop index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_TASK_CREATE on ACT_RU_TASK

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PROCINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PARENT

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_SUPER

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION drop FOREIGN KEY ACT_FK_EXE_PROCDEF

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_EXE

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_PROCINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK drop FOREIGN KEY ACT_FK_TASK_PROCDEF

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_JOB drop FOREIGN KEY ACT_FK_JOB_EXCEPTION

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_job' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EVENT_SUBSCR drop FOREIGN KEY ACT_FK_EVENT_EXEC

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_SOURCE

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_SOURCE_EXTRA

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL drop FOREIGN KEY ACT_FK_MODEL_DEPLOYMENT

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.history.sql

[sql] Failed to execute: drop index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: drop index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_taskinst' doesn't exist

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\drop\activiti.mysql.drop.identity.sql

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.engine.sql

[sql] Failed to execute: create table ACT_RE_DEPLOYMENT ( ID_ varchar(64), NAME_ varchar(255), CATEGORY_ varchar(255), TENANT_ID_ varchar(255) default '', DEPLOY_TIME_ timestamp(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bi' at line 1

[sql] Failed to execute: create table ACT_RE_MODEL ( ID_ varchar(64) not null, REV_ integer, NAME_ varchar(255), KEY_ varchar(255), CATEGORY_ varchar(255), CREATE_TIME_ timestamp(3) null, LAST_UPDATE_TIME_ timestamp(3) null, VERSION_ integer, META_INFO_ varchar(4000), DEPLOYMENT_ID_ varchar(64), EDITOR_SOURCE_VALUE_ID_ varchar(64), EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) null, LAST_UPDATE_TIME_ timestamp(3) null, VERSION_ integer, META_INFO_ varc' at line 1

[sql] Failed to execute: create table ACT_RU_EXECUTION ( ID_ varchar(64), REV_ integer, PROC_INST_ID_ varchar(64), BUSINESS_KEY_ varchar(255), PARENT_ID_ varchar(64), PROC_DEF_ID_ varchar(64), SUPER_EXEC_ varchar(64), ACT_ID_ varchar(255), IS_ACTIVE_ TINYINT, IS_CONCURRENT_ TINYINT, IS_SCOPE_ TINYINT, IS_EVENT_SCOPE_ TINYINT, SUSPENSION_STATE_ integer, CACHED_ENT_STATE_ integer, TENANT_ID_ varchar(255) default '', NAME_ varchar(255), LOCK_TIME_ timestamp(3) NULL, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] Failed to execute: create table ACT_RU_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, TYPE_ varchar(255) NOT NULL, LOCK_EXP_TIME_ timestamp(3) NULL, LOCK_OWNER_ varchar(255), EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64), PROCESS_INSTANCE_ID_ varchar(64), PROC_DEF_ID_ varchar(64), RETRIES_ integer, EXCEPTION_STACK_ID_ varchar(64), EXCEPTION_MSG_ varchar(4000), DUEDATE_ timestamp(3) NULL, REPEAT_ varchar(255), HANDLER_TYPE_ varchar(255), HANDLER_CFG_ varchar(4000), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, LOCK_OWNER_ varchar(255), EXCLUSIVE_ boolean, EXECUTION_ID_ varchar(64' at line 1

[sql] Failed to execute: create table ACT_RU_TASK ( ID_ varchar(64), REV_ integer, EXECUTION_ID_ varchar(64), PROC_INST_ID_ varchar(64), PROC_DEF_ID_ varchar(64), NAME_ varchar(255), PARENT_TASK_ID_ varchar(64), DESCRIPTION_ varchar(4000), TASK_DEF_KEY_ varchar(255), OWNER_ varchar(255), ASSIGNEE_ varchar(255), DELEGATION_ varchar(64), PRIORITY_ integer, CREATE_TIME_ timestamp(3) NULL, DUE_DATE_ datetime(3), CATEGORY_ varchar(255), SUSPENSION_STATE_ integer, TENANT_ID_ varchar(255) default '', FORM_KEY_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) NULL, DUE_DATE_ datetime(3), CATEGORY_ varchar(255), SUSPENSION_STATE_ integ' at line 1

[sql] Failed to execute: create table ACT_RU_EVENT_SUBSCR ( ID_ varchar(64) not null, REV_ integer, EVENT_TYPE_ varchar(255) not null, EVENT_NAME_ varchar(255), EXECUTION_ID_ varchar(64), PROC_INST_ID_ varchar(64), ACTIVITY_ID_ varchar(64), CONFIGURATION_ varchar(255), CREATED_ timestamp(3) not null DEFAULT CURRENT_TIMESTAMP(3), PROC_DEF_ID_ varchar(64), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null DEFAULT CURRENT_TIMESTAMP(3), PROC_DEF_ID_ varchar(64), TENANT_ID_ ' at line 1

[sql] Failed to execute: create table ACT_EVT_LOG ( LOG_NR_ bigint auto_increment, TYPE_ varchar(64), PROC_DEF_ID_ varchar(64), PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), TIME_STAMP_ timestamp(3) not null, USER_ID_ varchar(255), DATA_ LONGBLOB, LOCK_OWNER_ varchar(255), LOCK_TIME_ timestamp(3) null, IS_PROCESSED_ tinyint default 0, primary key (LOG_NR_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, USER_ID_ varchar(255), DATA_ LONGBLOB, LOCK_OWNER_ varchar(255), L' at line 1

[sql] Failed to execute: create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PARENT foreign key (PARENT_ID_) references ACT_RU_EXECUTION (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_SUPER foreign key (SUPER_EXEC_) references ACT_RU_EXECUTION (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_execution' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK add constraint ACT_FK_TASK_EXE foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_task' doesn't exist

[sql] Failed to execute: alter table ACT_RU_JOB add constraint ACT_FK_JOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_job' doesn't exist

[sql] Failed to execute: alter table ACT_RU_EVENT_SUBSCR add constraint ACT_FK_EVENT_EXEC foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION(ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_ru_event_subscr' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE foreign key (EDITOR_SOURCE_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE_EXTRA foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Failed to execute: alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_DEPLOYMENT foreign key (DEPLOYMENT_ID_) references ACT_RE_DEPLOYMENT (ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_re_model' doesn't exist

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.history.sql

[sql] Failed to execute: create table ACT_HI_PROCINST ( ID_ varchar(64) not null, PROC_INST_ID_ varchar(64) not null, BUSINESS_KEY_ varchar(255), PROC_DEF_ID_ varchar(64) not null, START_TIME_ datetime(3) not null, END_TIME_ datetime(3), DURATION_ bigint, START_USER_ID_ varchar(255), START_ACT_ID_ varchar(255), END_ACT_ID_ varchar(255), SUPER_PROCESS_INSTANCE_ID_ varchar(64), DELETE_REASON_ varchar(4000), TENANT_ID_ varchar(255) default '', NAME_ varchar(255), primary key (ID_), unique (PROC_INST_ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, END_TIME_ datetime(3), DURATION_ bigint, START_USER_ID_ varchar(25' at line 1

[sql] Failed to execute: create table ACT_HI_ACTINST ( ID_ varchar(64) not null, PROC_DEF_ID_ varchar(64) not null, PROC_INST_ID_ varchar(64) not null, EXECUTION_ID_ varchar(64) not null, ACT_ID_ varchar(255) not null, TASK_ID_ varchar(64), CALL_PROC_INST_ID_ varchar(64), ACT_NAME_ varchar(255), ACT_TYPE_ varchar(255) not null, ASSIGNEE_ varchar(255), START_TIME_ datetime(3) not null, END_TIME_ datetime(3), DURATION_ bigint, TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, END_TIME_ datetime(3), DURATION_ bigint, TENANT_ID_ varchar(255) d' at line 1

[sql] Failed to execute: create table ACT_HI_TASKINST ( ID_ varchar(64) not null, PROC_DEF_ID_ varchar(64), TASK_DEF_KEY_ varchar(255), PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), NAME_ varchar(255), PARENT_TASK_ID_ varchar(64), DESCRIPTION_ varchar(4000), OWNER_ varchar(255), ASSIGNEE_ varchar(255), START_TIME_ datetime(3) not null, CLAIM_TIME_ datetime(3), END_TIME_ datetime(3), DURATION_ bigint, DELETE_REASON_ varchar(4000), PRIORITY_ integer, DUE_DATE_ datetime(3), FORM_KEY_ varchar(255), CATEGORY_ varchar(255), TENANT_ID_ varchar(255) default '', primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, CLAIM_TIME_ datetime(3), END_TIME_ datetime(3), DURATION_ bigint, ' at line 1

[sql] Failed to execute: create table ACT_HI_VARINST ( ID_ varchar(64) not null, PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), NAME_ varchar(255) not null, VAR_TYPE_ varchar(100), REV_ integer, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ varchar(4000), TEXT2_ varchar(4000), CREATE_TIME_ datetime(3), LAST_UPDATED_TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3), LAST_UPDATED_TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT C' at line 1

[sql] Failed to execute: create table ACT_HI_DETAIL ( ID_ varchar(64) not null, TYPE_ varchar(255) not null, PROC_INST_ID_ varchar(64), EXECUTION_ID_ varchar(64), TASK_ID_ varchar(64), ACT_INST_ID_ varchar(64), NAME_ varchar(255) not null, VAR_TYPE_ varchar(255), REV_ integer, TIME_ datetime(3) not null, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ varchar(4000), TEXT2_ varchar(4000), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, BYTEARRAY_ID_ varchar(64), DOUBLE_ double, LONG_ bigint, TEXT_ var' at line 1

[sql] Failed to execute: create table ACT_HI_COMMENT ( ID_ varchar(64) not null, TYPE_ varchar(255), TIME_ datetime(3) not null, USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64), ACTION_ varchar(255), MESSAGE_ varchar(4000), FULL_MSG_ LONGBLOB, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) not null, USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar' at line 1

[sql] Failed to execute: create table ACT_HI_ATTACHMENT ( ID_ varchar(64) not null, REV_ integer, USER_ID_ varchar(255), NAME_ varchar(255), DESCRIPTION_ varchar(4000), TYPE_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64), URL_ varchar(4000), CONTENT_ID_ varchar(64), TIME_ datetime(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin' at line 1

[sql] Failed to execute: create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_procinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_detail' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_varinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_actinst' doesn't exist

[sql] Failed to execute: create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_)

[sql] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeesite.act_hi_taskinst' doesn't exist

[sql] Executing resource: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\act\create\activiti.mysql.create.identity.sql

[sql] 280 of 352 SQL statements executed successfully

[dbunit] Executing operation: INSERT

[dbunit] on file: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\sys\jeesite_data.xls

[dbunit] with format: xls

[dbunit] Executing operation: INSERT

[dbunit] on file: D:\Tomcat\Demo\apache-tomcat-7.0.77\wtpwebapps\jeesite\db\cms\jeesite_data.xls

[dbunit] with format: xls

[INFO] Executed tasks

[INFO] ------------------------------------------------------------------------

[INFO] BUILD SUCCESS

[INFO] ------------------------------------------------------------------------

[INFO] Total time: 40.745s

[INFO] Finished at: Mon Apr 24 10:31:21 CST 2017

[INFO] Final Memory: 18M/201M

[INFO] ------------------------------------------------------------------------

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)

jeesite mysql_Jeesite框架mysql数据库初始报错的相关文章

HTAccess - 令人困惑的干净网址

如果我想简单地重定向 clients page to clients php view page我会使用像这样简单的东西它效果很好 Options FollowSymlinks RewriteEngine on RewriteRule c
Hibernate 可以使用 MySQL 的“ON DUPLICATE KEY UPDATE”语法吗？

MySQL 支持 INSERT ON DUPLICATE KEY UPDATE 语法允许您盲目插入数据库并回退到更新现有记录如果存在当您想要快速事务隔离并且想要更新的值取决于数据库中已有的值时这非常有用作为一个人为的示例假设
Mysql - Mysql2::错误：字符串值不正确：

所以我建造了一个刮刀并拉动一些物体问题是有些是外语它使 mysql 数据库有点崩溃这是我得到的错误知道我能用这个做什么吗谢谢 Mysql2 错误列的字符串值不正确 xC5 x8Dga 第 1 行的描述插入sammiches
通过我的java代码导出数据库

我想使用我的 java 代码导出我的 MySQL 数据库但我还没有找到任何办法我想要做的就是我的应用程序中有一个按钮作为导出数据库单击该按钮时我的数据库应导出到指定的路径我使用了以下代码但它不起作用 Runtime runti
MySQL Workbench 6.0 错误无法获取管理员的管理访问权限？

我在这里使用 MySQL Workbench 6 0 当我选择服务器状态时出现此错误对此我尝试在Google和StackOverflow上寻找解决方案 e g 这个结果 https stackoverflow com question
MYSQL中收盘价的简单移动平均线计算和更新表

我可以使用一些帮助最好是虚拟指南来更新下表 CREATE TABLE SYMBOL day date NOT NULL open decimal 8 3 DEFAULT NULL high decimal 8 3 DEFAULT NUL
MYSQL 查询返回“资源 id#12”而不是它应返回的数值

不知道为什么但这返回了错误的值我正在取回此资源 ID 12 而不是我正在寻找的数值 1 执行此操作的代码是 type SELECT account type from user attribs WHERE username userna
通过连接从两个表中删除？

我有两个表如下 tbl1 tbl2 id article id title image whole news tags author older datetime 其中 tbl1 id gt tbl2 article id 如何从两个表中删
如何将 MySQL 数据库更改为 UTC？

我使用的是 Windows 7 对数据库方面的东西有点陌生我尝试在 Google 上搜索如何将系统时区更改为 UTC 但文档有些高级我不太确定如何更改此字段在 my ini 文件的 mysqld 部分下添加以下行 default t
在 MacOSX10.6 上运行 python 服务器时 MySQLdb 错误

运行我的服务器 python manage py runserver 产生以下错误 django core exceptions ImproperlyConfigured 加载 MySQLdb 模块时出错没有名为 MySQLdb 的模块
ActiveRecord3死锁重试

Rails 3 或 ActiveRecord 3 是否有任何插件可以复制旧版本死锁重试 http agilewebdevelopment com plugins deadlock retry插入或者该插件仍然适用于 Rails 3 吗
显示表 FULLTEXT 索引列

我希望运行一个查询该查询将返回表中全文索引的列列表该表采用 MyISAM 格式我将使用 php 来构建查询理想情况下我会运行查询它会返回信息以便我可以构造一个以逗号分隔的列字符串例如名姓电子邮箱这在 MySQL 中可
使 pdo::query 静态

当我运行下面的代码时出现此错误我通常使用 msql 函数但我尝试使用 PDO 代替怎么了致命错误第 14 行无法静态调用非静态方法 PDO query
为什么 MySQL 创建带有 _seq 后缀的表？

我创建了一个 InnoDB 表名为foo在 MySQL 中一旦我对表执行插入操作我就会看到另一个表foo seq被建造如果我删除自动生成的表它会在下一次插入后出现是什么原因造成的听起来像是正在创建一个序列您是否有自动生成的主
查询中列的顺序重要吗？

当从 MySQL 表中选择列时与表中的顺序相比选择列的顺序是否会影响性能不考虑可能覆盖列的索引例如您有一个包含行 uid name bday 的表并且有以下查询 SELECT uid name bday FROM table M
如何使用 MySQL 的 LOAD DATA LOCAL INFILE 在导入 CSV 时将字符串日期更改为 MySQL 日期格式

我正在使用 MySQL 的 LOAD DATA LOCAL INFILE SQL 语句将数据从 CSV 文件加载到现有数据库表中下面是一个 SQL 语句示例 LOAD DATA LOCAL INFILE file csv INTO TAB
如何在 Laravel 查询中使用多个 OR,AND 条件

我需要 Laravel 查询帮助我的自定义查询返回正确结果 Select FROM events WHERE status 0 AND type public or type private 如何写这个查询Laravel Event w
阻止注销页面后的后退按钮

我有 php 注销页面当用户单击注销链接时请参阅此页面并重定向到索引页面但是当单击后退按钮时我会看到带有用户数据的上一页当然当我刷新页面时我看不到以前的页面和数据我在单击注销并单击后退按钮后检查了其他代码 drupal 但我
第三个下拉菜单不从数据库填充

我有以下 Index php
Mysql 检索所有有限制的行

我想检索特定用户的所有行限制为 0 x 所以我只是想问是否有任何方法可以检索 mysql 中的所有行而不调用返回 x 的 count id 的方法而不重载现有函数该函数在查询中根本没有限制与我们的 string Relace 功能

随机推荐

服务器刹车响应时间,刹车不灵如何界定？“制动响应时间”了解一下~

车辆的制动响应时间是指从制动踏板动作起至最不利的制动气室内压力达到其稳态值的75 所经历的时间由于评价车辆制动性能的指标主要是制动距离和制动减速度 xff0c 而制动响应时间的长短直接影响着制动距离但要如何操做以及数据如何采集还都是空白
【Python】安装pillow后仍显示 no module named PIL的解决办法

在File gt gt Setting gt gt Python Interpreter里点击下三角 xff0c 切换编译器即可
Mysql使用SSL进行安全连接

一服务器端强制每个接入系统网络的用户使用SSL TLS安全传输协议这时候就不用管客户端配置了使用GRANT语句使所有用户均使用SSL GRANT USAGE ON TO lt my user gt 64 REQUIRE SSL 检查每
塔科夫帧数测试软件,逃离塔科夫如何优化游戏FPS_画面优化设置详解_52pk

逃离塔科夫怎么设置最大化FPS 怎样才能优化游戏画面呢快跟小编一起去看看设置技巧吧这游戏对于cpu资源分配和内存管理反面有很大问题 xff0c 优化也主要是在这俩方面先来看看优化前后效果图 xff0c 玩的是自己帧数最低的一张图优化
c语言枚举做字符类型转换,C# 枚举类型转换字符串 Enum to string

c 枚举类型转换字符串 enum to string 枚举类型都是值类型 system enum是一个抽象类 abstract class xff0c 所有枚举类型都直接继承自它 xff0c 当然也同时继承了它的所有成员所有的值类型都是s
centos 7 mysql 源码安装_CentOS 7下源码安装MySQL 5.7

网上说linux安装mysql服务分两种安装方法 xff1a 源码安装 xff0c 优点是安装包比较小 xff0c 只有几十M左右 xff0c 缺点是安装依赖的库多 xff0c 安装编译时间长 xff0c 安装步骤复杂容易出错 xff1b
【深度学习】经典网络之GoogLeNet：Going deeper with convolutions

本文专栏点击查看本专栏文章论文 Going deeper with convolutions https www researchgate net publication 305196650 Going deeper with conv
linux远程桌面双屏,Windows 7用远程桌面（RDP+VNC）连接Ubuntu11.04

Ubuntu 11 04已经发布了 xff0c 想必很多同志已经迫不及待的尝鲜了对于有2台电脑的同志 xff0c 一台win7 xff0c 一台Ubuntu可能是比较实际 xff0c 比较符合国情的搭配于是乎 xff0c 怎样高效的同时
armbian 斐讯n1_斐讯N1刷入Armbian 更换国内系统源更换国内软件源修改DNS

修改方法 xff1a nano etc apt sources list d armbian list deb http mirrors nju edu cn armbian bionic main bionic utils bionic
c语言点亮1个led,编写一个点亮LED的小程序，没你想象的那么复杂！

编写一个点亮LED的小程序 xff0c 没你想象的那么复杂 xff01 在刚开始入门学习时 xff0c 其中一个制作就是2032电池点亮LED xff0c 那么如何编写程序控制单片机I O点亮LED呢 xff1f 单片机I O 即IN OU
vs自带windbg_VS 2013驱动开发 + Windbg + VM双机调试（亲测+详解）

VS 2013驱动开发 43 Windbg 43 VM双机调试亲测 43 详解 WIN10已上线 xff0c 随之而来的是VS2015 xff1b 微软在 WDK7600 以后就不再提供独立的内核驱动开发包了 xff0c 而是必须首先安装
torch.detach() torch.item()

torch detach torch item torch detach 用于将当前的tensor从计算图中取出通俗点解释就是经过detach返回的张量将不会进行反向传播计算梯度 torch item 用于将单个的tensor值返回成
Python错误之 SyntaxError: invalid syntax的解决方法总结

Python错误之 SyntaxError invalid syntax的解决方法总结 SyntaxError invalid syntax 的意思就是语法错误 xff1b 经过查询解决了这个问题 xff0c 所以总结一个这个问题的解决方
ubuntu18.04安装anaconda环境变量sudo gedit ~/.bashrc和source ~/.bashrc解析

全程学习这个连接 https blog csdn net qq 15192373 article details 81091098 最后环境变量设置的时候 xff0c 有些问题记录下来这几个命令解释一下 sudo gedit bashrc
MySQL分组后拿到所有数据_mysql分组后获取若干数据

最近做一个链表分组查询 xff0c 并且取每个分组的前几位数据的业务例如有商品表 xff0c 订单表 xff0c 品类表 xff0c 商品表中有自己的分类 xff0c 并且商品表外键关联品类表主键 xff0c 订单表外键关联商品表中的商品
win7系统里的服务器在哪个文件夹下,Win7 cookie存放位置：Win7系统cookies文件夹在哪？...

Win7系统cookie存放位置 xff1a Win7系统cookies文件夹在哪 xff1f Cookie xff0c 有时也用其复数形式Cookies xff0c 指某些网站为了辨别用户身份进行session跟踪而储存在用户本地终端上
mojave时间机器文件服务器,年轻人的第一台NAS——群晖DS218j 篇二：配置 Time Machine 时间机器为macOS备份...

年轻人的第一台NAS 群晖DS218j 篇二 xff1a 配置 Time Machine 时间机器为macOS备份 2019 12 15 16 52 16 9点赞 105收藏 34评论创作立场声明 xff1a 参考了群晖知识数据库的文章
【Spring Boot组件集成实战】集成七牛云文件上传

更多精彩内容 xff0c 请访问 Spring Boot组件集成实战专栏 xff01 推荐项目 xff1a 一套基于Spring Boot 43 Layui的内容管理系统快速开发脚手架 xff08 含完整的开发文档演示网址等 xff09
wsl Ubuntu20.04 安装 ROS2

注意事项 xff1a 1 本来想要安装 ros humble desktop xff0c 但执行这一行命令时 sudo apt install ros humble desktop 报错 Unable to locate package r
jeesite mysql_Jeesite框架mysql数据库初始报错

INFO Scanning for projects WARNING WARNING Some problems were encountered while building the effective model for com thi

jeesite mysql_Jeesite框架mysql数据库初始报错

jeesite mysql_Jeesite框架mysql数据库初始报错 的相关文章

随机推荐

热门标签

jeesite mysql_Jeesite框架mysql数据库初始报错的相关文章