bee api gogps -driver=mysql -conn="..." generate error import file

[Gnails]

[flycash]

please provide the database schema (you can delete some columns), mysql version.

[Gnails]

please provide the database schema (you can delete some columns), mysql version.

+----------+-----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| username | char(8) | YES | | NULL | |
| passwd | char(225) | YES | | NULL | |
+----------+-----------+------+-----+---------+----------------+

+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| seq | int unsigned | NO | PRI | NULL | auto_increment |
| userid | char(11) | YES | | NULL | |
| longtitude | double | YES | | NULL | |
| latitude | double | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+

mysql Ver 8.0.26 for Linux on x86_64 (MySQL Community Server - GPL)

[flycash]

It's a historical BUG, bee has some problems with MySQL 8.x. I plan to fix them in next release.

[lghuahua]

It's a historical BUG, bee has some problems with MySQL 8.x. I plan to fix them in next release.

The package path is calculated incorrectly on windows, and there is no such problem on Linux

// g_appcode.go

func getPackagePath(curpath string) (packpath string) {
    ...
    packpath = strings.Join(strings.Split(curpath[len(appsrcpath)+1:], string(filepath.Separator)), "/")
    return
}

E.g
The project code is in F:\share The packpath obtained by this method is ‘:\share’