QOR is a set of libraries written in Go that abstracts common features needed for business applications, CMSs, and E-commerce systems.
I got the key error and "widget FullWidthBannerEditor not exists" error, when I was seeding it. Any idea how to fix it?
$ go run config/db/seeds/main.go config/db/seeds/seeds.go
Failed to create unique index for translations key & locale, got: Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
(/Users/jwong3/go/src/github.com/qor/i18n/backends/database/database.go:20)
[2019-10-26 09:32:44] Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
WARNING: AssetFS is used before overwrite it!
goroutine 1 [running, locked to thread]:
runtime/debug.Stack(0x2e, 0x0, 0x0)
/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
runtime/debug.PrintStack()
/usr/local/go/src/runtime/debug/stack.go:16 +0x22
github.com/qor/assetfs.SetAssetFS(0x6a57910, 0x24938e0)
/Users/jwong3/go/src/github.com/qor/assetfs/assetfs.go:33 +0xc5
github.com/qor/qor-example/config/bindatafs.init.0()
/Users/jwong3/go/src/github.com/qor/qor-example/config/bindatafs/bindatafs.go:26 +0x5d
Need to have gorm DB in the configuration in order to run migrations
Start create sample data...
--> Created setting.
--> Created seo.
--> Created admin users.
--> Created users.
--> Created addresses.
--> Created categories.
--> Created collections.
--> Created colors.
--> Created sizes.
--> Created material.
--> Created medialibraries.
--> Created products.
--> Created stores.
--> Created orders.
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
--> Created widgets.
--> Created articles.
--> Created helps.
--> Done!
$ go run config/db/seeds/main.go config/db/seeds/seeds.go
Failed to create unique index for translations key & locale, got: Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
(/Users/jwong3/go/src/github.com/qor/i18n/backends/database/database.go:20)
[2019-10-26 09:32:44] Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
WARNING: AssetFS is used before overwrite it!
goroutine 1 [running, locked to thread]:
runtime/debug.Stack(0x2e, 0x0, 0x0)
/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
runtime/debug.PrintStack()
/usr/local/go/src/runtime/debug/stack.go:16 +0x22
github.com/qor/assetfs.SetAssetFS(0x6a57910, 0x24938e0)
/Users/jwong3/go/src/github.com/qor/assetfs/assetfs.go:33 +0xc5
github.com/qor/qor-example/config/bindatafs.init.0()
/Users/jwong3/go/src/github.com/qor/qor-example/config/bindatafs/bindatafs.go:26 +0x5d
Need to have gorm DB in the configuration in order to run migrations
Start create sample data...
--> Created setting.
--> Created seo.
--> Created admin users.
--> Created users.
--> Created addresses.
--> Created categories.
--> Created collections.
--> Created colors.
--> Created sizes.
--> Created material.
--> Created medialibraries.
--> Created products.
--> Created stores.
--> Created orders.
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
--> Created widgets.
--> Created articles.
--> Created helps.
--> Done!
Is this qor project still active? How come no one is responding my questions?
quick start bug
I don nor know how to do
Can you suggest some solution?
This is the first filter
userQueries.Filter(&admin.Filter{
Label: "Account Manager",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetAccountManagers},
Handler: func(db gorm.DB, filter admin.FilterArgument) *gorm.DB {
db = configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
return db.Joins(" JOIN products ON products.id = user_queries.product_id JOIN users ON users.id = products.user_id AND users.deleted_at is null AND users.account_manager_id = ? ", filterValue)
},
})
Label: "Account Manager",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetAccountManagers},
Handler: func(db gorm.DB, filter admin.FilterArgument) *gorm.DB {
db = configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
return db.Joins(" JOIN products ON products.id = user_queries.product_id JOIN users ON users.id = products.user_id AND users.deleted_at is null AND users.account_manager_id = ? ", filterValue)
},
})
and this is second one
userQueries.Filter(&admin.Filter{
Label: "Vendor User ID",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetUsers},
Handler: func(db gorm.DB, filter admin.FilterArgument) gorm.DB {
//db1 := configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
//return db1.Exec("select from user_queries JOIN products ON products.id = user_queries.product_id where products.user_id is not null AND products.user_id = ? ", filterValue)
return db.Joins(" JOIN products ON products.id = user_queries.product_id and products.user_id is not null AND products.user_id = ? ", filterValue)
},
})
Label: "Vendor User ID",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetUsers},
Handler: func(db gorm.DB, filter admin.FilterArgument) gorm.DB {
//db1 := configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
//return db1.Exec("select from user_queries JOIN products ON products.id = user_queries.product_id where products.user_id is not null AND products.user_id = ? ", filterValue)
return db.Joins(" JOIN products ON products.id = user_queries.product_id and products.user_id is not null AND products.user_id = ? ", filterValue)
},
})
How can I implement the second filter?
Hi guys, has anyone used github.com/qor/page_builder ? Looking for documentation to hook it to a request handler.
I have created a pull request qor/auth#39
Can some one please merge the pull
I fixed this by setting invisible to true on the resource and copying code from the AddResource:
Admin.AddMenu(&admin.Menu{Name: inflection.Plural(res.Config.Name), IconName: res.Config.IconName, Permissioner: res, Priority: res.Config.Priority, Ancestors: res.Config.Menu, RelativePath: res.ToParam()})
Admin.RegisterResourceRouters(res, "create", "update", "read")
For those who cannot login (see message "You have to confirm your account before continuing"), pls make a change on auth as this PR https://github.com/qor/auth/pull/39/files#diff-74d143ebc83607521c0db57e6225668d
can you see the image on the system? all the images on my local cannot be loaded, pls advice how to solve it?
Hello, how does qor's admin supports null.String by https://github.com/guregu/null ?
When creating admin simply, edit panel shows "String" and "Valid" section for nullable columns.
But values of the section are empty even when it have some text
When creating admin simply, edit panel shows "String" and "Valid" section for nullable columns.
But values of the section are empty even when it have some text
How can I access login page for a provider. Accessing http://localhost:9000/auth/login results in following page:
I do see the login file under password/views/auth/login/providers/password/tmpl, but cannot find the url which would send this page. Could not find anything in PasswordProvider .ServeHttp method which sends this page - was expecting a handle in this file
Im getting this
someone knows why?
neil@neil-Inspiron-7577:~$ go get -u github.com/qor/qor-example
# github.com/qor/auth
go1: internal compiler error: in methods, at go/gofrontend/types.cc:8611
Please submit a full bug report,
with preprocessed source if appropriate.
See <file:///usr/share/doc/gcc-8/README.Bugs> for instructions.
# github.com/qor/exchange/backends/csv
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:41:3: error: range clause must have array, slice, string, map, or channel type
for i, cell := range row.Cells {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:2: error: range clause must have array, slice, string, map, or channel type
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:6: error: invalid type for range clause
for _, row := range sheet.Rows {
^
neil@neil-Inspiron-7577:~$
# github.com/qor/auth
go1: internal compiler error: in methods, at go/gofrontend/types.cc:8611
Please submit a full bug report,
with preprocessed source if appropriate.
See <file:///usr/share/doc/gcc-8/README.Bugs> for instructions.
# github.com/qor/exchange/backends/csv
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:41:3: error: range clause must have array, slice, string, map, or channel type
for i, cell := range row.Cells {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:2: error: range clause must have array, slice, string, map, or channel type
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:6: error: invalid type for range clause
for _, row := range sheet.Rows {
^
neil@neil-Inspiron-7577:~$
how can i contact?
how do i get the dropdown to show something other than blank spaces?
@glenfordwilliams Look at the select one Dcoumentation for a dropdown example https://doc.getqor.com/admin/metas/select-one.html
put public before system
