search

duncanmcclean / simple-commerce

A simple, yet powerful e-commerce addon for Statamic.
https://statamic.com/simple-commerce
Other
143 stars 34 forks source link

Search via listing API: Unknown column 'status_log' in 'where clause' #1045

Closed Web10-Joris closed 2 months ago

Web10-Joris commented 2 months ago

Description

We are not able to search within the order table due to the following error: https://flareapp.io/share/LPdK24Ym (edit: changed link, added the wrong one)

Let me know if you need more info or if I have to help with debugging :)

Steps to reproduce

  1. Enable database orders using runway
  2. Search in the listing table or orders
  3. Error occurs

Environment

Environment Application Name: xxxxx Laravel Version: 10.47.0 PHP Version: 8.2.15 Composer Version: 2.7.2 Environment: production Debug Mode: OFF URL: xxxxx.nl Maintenance Mode: OFF

Cache Config: CACHED Events: NOT CACHED Routes: CACHED Views: CACHED

Drivers Broadcasting: log Cache: statamic Database: mysql Logs: stack / daily, flare Mail: smtp Queue: sync Session: file

Simple Commerce Currencies: EUR, EUR, EUR, EUR Gateways: Mollie Repository: Customer: DuncanMcClean\SimpleCommerce\Customers\EloquentCustomerRepository Repository: Order: DuncanMcClean\SimpleCommerce\Orders\EloquentOrderRepository Repository: Product: DuncanMcClean\SimpleCommerce\Products\EntryProductRepository Shipping Methods: MTC Pallet Zending, PostNL International Tax Engine: DuncanMcClean\SimpleCommerce\Tax\Standard\TaxEngine

Statamic Addons: 7 Antlers: runtime Sites: 4 (Nederlands, Duits, Engels, Pools) Stache Watcher: Enabled Static Caching: Disabled Version: 4.52.0 PRO

Statamic Addons aerni/advanced-seo: 2.4.4 duncanmcclean/simple-commerce: 6.0.10 heidkaemper/statamic-toolbar: 1.1.2 statamic-rad-pack/runway: 6.4.1 statamic/collaboration: 0.8.1 web10/back-in-stock-notifier: dev-main web10/language-switcher: dev-main

github-actions[bot] commented 2 months ago

Released as part of v6.1.0.