Current Issues regarding new release
Closed this issue · 6 comments
These are the current issues I found when I pushed Marketplace to marketplace.davidtrushkov.com:
-
Spell error on about page.
-
Can't see the warning dialog when first time connecting to Stripe.
-
Limit number of files user can upload in dropzone JS
-
Fix badge notification icon to
padding 2px 6px -
User avatar image not working on notification pages
-
Update the config/mail.php to match real environment variables
-
Remove footer and body CSS positioning on mobile devices.
-
This issue happens when I click "Most Sales" in the filter bar on the files page:
SQLSTATE[42000]: Syntax error or access violation: 1055 'davidtru_marketplace.files.identifier' isn't in GROUP BY (SQL: select files.*, count(sales.id) AS count fromfilesleft joinsalesonsales.file_id=files.idwherefinished= 1 andlive= 1 andapproved= 1 andfiles.deleted_atis null group byfiles.idorder bycountdesc limit 15 offset 0)
hei @davidtrushkov i got an error go to admin dashboard like this
Illuminate \ Database \ QueryException (42703) SQLSTATE[42703]: Undefined column: 7 ERROR: column "%m/%d" does not exist LINE 1: select DATE_FORMAT(created_at, "%m/%d") as day, sum(sale_pri... ^ (SQL: select DATE_FORMAT(created_at, "%m/%d") as day, sum(sale_price) as sale_price from "sales" where "created_at" > 2018-03-01 00:00:00 and "sale_price" > 0 group by "day")
what can i do or can i contact your email ?
Did you clone this on your own computer, or are you having the error on my live website?
If you downloaded it to your computer, then are you by any chance using a database that is not MySQL, like sq-lite, or PostgreSQL? Because I had the same problem when I tried to upload to Heroku, I got the same error because the query im doing there can only work on MySQL database I believe. (Heroku doesn't use MySQL by default)
oh i see @davidtrushkov 👍 thank you. so i gotta use mysql ? okay i will try migrate again
I think that will fix the problem, yes.
one more @davidtrushkov where can i show all files ? updated files and new files ? or i can't see it ?