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’