Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unknown column 'discounts.orderConditionFormula' in 'field list' #1351

Closed
malinky opened this issue Apr 2, 2020 · 2 comments
Closed

Unknown column 'discounts.orderConditionFormula' in 'field list' #1351

malinky opened this issue Apr 2, 2020 · 2 comments

Comments

@malinky
Copy link

malinky commented Apr 2, 2020

Description

I've installed craftcms and commerce and in the admin section I try and click on the one of the default products that have been added to the database and I get a Database Exception. There isn't an orderConditionFormula in my database.

Column not found: 1054 Unknown column 'discounts.orderConditionFormula' in 'field list'

Steps to reproduce

  1. composer create-project craftcms/craft
  2. ./craft setup
  3. composer require craftcms/commerce
  4. ./craft install/plugin commerce
  5. Open admin, click commerce -> products and try and view one of the default products (The Last Knee-High for example) and the Database Exception is shown.

Additional info

  • Craft version: 3.4.13
  • PHP version: 7.35
  • Database driver & version: mysql 8.0.12
  • Plugins & versions: Commerce 3.10
@nfourtythree
Copy link
Contributor

Hi @malinky

Thank you for bringing this to our attention. We have pushed up a fix that will be included in the next release (that we look to get out asap).

To get this early, change your craftcms/commerce requirement in composer.json to:

"require": {
  "craftcms/commerce": "dev-develop#6217bc5f7b1c75e27b4c8ce94f45bdbd56ba8d10 as 3.1.0",
  "...": "..."
}

Then run composer update.

Thanks.

@malinky
Copy link
Author

malinky commented Apr 3, 2020

No problem. Thanks for the quick fix.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants