雷伦特 2023-06-10 14:24:34 回复

启动报错，应该是初始化数据库有问题，这个怎么破解
13:40:55.617 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - [refresh,554] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'luckyFrameWebApplication': Unsatisfied dependency expressed through field 'server'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'nettyServer': Unsatisfied dependency expressed through field 'serverChannelInitializer'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverChannelInitializer': Unsatisfied dependency expressed through field 'serverHandler'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'ServerHandler': Unsatisfied dependency expressed through field 'clientService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'clientServiceImpl': Unsatisfied dependency expressed through field 'jobService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jobServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayConfig': Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException:
Unable to check whether schema `luckyframe` is empty
----------------------------------------------------
SQL State : HY000
Error Code : 1577
Message : Cannot proceed, because event scheduler is disabled

13:40:55.632 [main] INFO c.a.d.p.DruidDataSource - [close,1825] - {dataSource-1} closed
13:40:55.639 [main] INFO o.a.c.c.StandardService - [log,173] - Stopping service [Tomcat]
13:40:55.664 [main] ERROR o.s.b.SpringApplication - [reportFailure,858] - Application run failed

may 2023-04-18 08:33:47 回复

3.5.1版本的安装包，并没有自动执行sql

may 2023-04-18 08:31:49 回复

3.5.1启动服务端程序并没有自动建库建表

rh 2021-10-08 11:54:22 回复

你好，下载了3.4的jar包，不用手动执行MySQL语句吗，直接运行Jar包就可以了？

2021-11-01 17:14:54 回复

是的，不需要手动执行SQL

mmx 2021-06-10 18:51:51 回复

MariaDB [(none)]> source /home/luckyframefiles/v3.2.sql
ERROR: Failed to open file '/home/luckyframefiles/v3.2.sql', error: 2

执行sql 提示不能打开啊，求救！！！

灵儿的逍遥哥哥 2021-05-16 19:26:26 回复

执行sql之前应该还需要启动数据库，idea中配置项目的mysql数据库吧，不讲一下，我这个新手心里还真没底。。。。

2021-05-20 16:44:25 回复

执行SQL，需要先启动数据库，这个.....不需要单独说明吧~—~

zhubo 2020-11-17 14:48:50 回复

master分支启动报错,3.2.1 3.1.1 版本都报错， sql脚本有问题呀 ~~~ 无语了

speedcom 2020-05-12 13:04:16 回复

idea环境安装启动，db初始化3.2sql没有问题，idea启动很多错误。清数据库，换成初始化3.1.1sql，idea顺利启动

2020-05-13 13:50:57 回复

3.2以上的版本，不再需要单独执行SQL了，应用启动的时候会自动检测并创建对应的表结构。

老男人 2020-02-18 16:32:29 回复

你好执行3.1.1版本，初始化数据的时候报这个错误，请问是什么原因？[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

jia 2020-01-29 23:17:25 回复

执行3.1.1sql，在导入的时候，部分字段会报1406和1366的错误，如下。还有数据库名字必须是luckyframedb，怎么在数据库安装配置说的是数据库名是luckyframe，懵了。。。

ERROR 1406 (22001): Data too long for column 'dict_label' at row 1
ERROR 1406 (22001): Data too long for column 'dict_label' at row 1
ERROR 1406 (22001): Data too long for column 'dict_label' at row 1
ERROR 1366 (HY000): Incorrect string value: '\x80\x81Post...' for column 'dict_label' at row 1
ERROR 1366 (HY000): Incorrect string value: '\x80\x81Get\xE8...' for column 'dict_label' at row 1
ERROR 1366 (HY000): Incorrect string value: '\x80\x81JSON...' for column 'dict_label' at row 1
ERROR 1366 (HY000): Incorrect string value: '\x80\x81Put\xE8...' for column 'dict_label' at row 1
ERROR 1366 (HY000): Incorrect string value: '\x80\x81JSON...' for column 'dict_label' at row 1

2020-02-05 18:29:35 回复

看下你的数据库版本是不是5.7，建议使用5.7的版本

2020-05-20 17:39:47 回复

数据库版本一定要是5.7么？看说明是大于5.7 就行？我是8.0的
出错：
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 7 warnings (0.02 sec)

ERROR 1406 (22001): Data too long for column 'dept_name' at row 1
ERROR 1406 (22001): Data too long for column 'dept_name' at row 1
ERROR 1406 (22001): Data too long for column 'dept_name' at row 1
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 3 warnings (0.01 sec)

ERROR 1406 (22001): Data too long for column 'project_name' at row 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 13 warnings (0.01 sec)

ERROR 1406 (22001): Data too long for column 'remark' at row 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 4 warnings (0.01 sec)

Query OK, 1 row affected (0.00 sec)

ERROR 1366 (HY000): Incorrect string value: '\x80\xE5\x8F\x91\xE5\xB7...' for column 'post_name' at row 1
Query OK, 1 row affected (0.00 sec)

ERROR 1406 (22001): Data too long for column 'post_name' at row 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 7 warnings (0.02 sec)

ERROR 1406 (22001): Data too long for column 'role_name' at row 1
ERROR 1366 (HY000): Incorrect string value: '\xAE\xE9\x80\x9A\xE8\xA7...' for column 'role_name' at row 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 6 warnings (0.03 sec)

ERROR 1366 (HY000): Incorrect string value: '\xAE\xE5\xBD\x95' for column 'remark' at row 1
ERROR 1366 (HY000): Incorrect string value: '\xAE\xE5\xBD\x95' for column 'remark' at row 1
ERROR 1366 (HY000): Incorrect string value: '\xAE\xE5\xBD\x95' for column 'remark' at row 1
Query OK, 1 row affected (0.00 sec)

ERROR 1366 (HY000): Incorrect string value: '\xA1\x8C' for column 'menu_name' at row 1
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

ERROR 1366 (HY000): Incorrect string value: '\xAF\xE7\xAE\xA1\xE7\x90...' for column 'menu_name' at row 1
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

ERROR 1366 (HY000): Incorrect string value: '\xAC\xE5\x91\x8A' for column 'menu_name' at row 1
Query OK, 1 row affected (0.00 sec)