I got an err when I Save Policy about gorm-adapter HOT 3 CLOSED

Hi @HaoweiCh , it seems that Gorm's DropTable() fails to delete the table for MariaDB, maybe the SQL syntax is wrong for MariaDB. Can you provide a runnable example and your MariaDB version? So I can install the MariaDB and run your code to debug it.

from gorm-adapter.

func init() {
	DB = Connect(
		"123.106.169.37:3306",
		"p",
		"spiders",
	).Set("gorm:table_options", "CHARSET=utf8")
}

func Connect(hostAndPort, userNameAndPassword, databaseName string) (db *gorm.DB) {
	var err error
	if db, err = gorm.Open("mysql",
		fmt.Sprintf("%s@tcp(%s)/%s?charset=utf8mb4&collation=utf8mb4_unicode_ci&parseTime=true&loc=Local",
			userNameAndPassword, hostAndPort, databaseName)); err != nil {
		panic(err)
	}
	return
}

I guess .Set("gorm:table_options", "CHARSET=utf8") may cause this problem. but even remove it problem exists

10.3.13-MariaDB

if this info cannot help, I'll try provide more.

Even when this err issued, the data 've already wrote into database,,

from gorm-adapter.

This is not an issue of this repo. You should ask in in Gorm's issue tracker.

from gorm-adapter.