search

supergeorg / Grocy-SwiftUI

A client for Grocy for macOS and iOS, written with SwiftUI
GNU General Public License v3.0
177 stars 17 forks source link

Consume fails when using Grocy 4.0.3 #185

Open martinrosenauer opened 10 months ago

martinrosenauer commented 10 months ago

First of all, thanks for a great app!

After upgrading to Grocy (docker) 4.0.3 I'm no longer able to Quick-Scan Consume from the app, getting the following in the App-log:

Oct 17, 2023 at 9:01:00 AM: Consume failed: decodingError(error: Grocy_Mobile.APIError.errorString(description: "SQLSTATE[HY000]: General error: 1 no such table: uihelper_product_details"))

Downgrading to 4.0.2 resolves it and it works again. Bug or am I doing something wrong?

Thanks in advance!

supergeorg commented 10 months ago

The SQLSTATE errors are not related to the App but are produced by Grocy Server itself.

Usually you need to migrate the database, this is done by visiting the Grocy stock overview webpage.

A shortcut for this is in the App, go to Settings -> Information about Grocy Server -> Open in Browser (to migrate database)

martinrosenauer commented 10 months ago

Brilliant! - that helped, happy there was a simple solution..

Thanks!

SvenJachalke commented 9 months ago

Hi to all,

I have a very similar problem: Each time I consume a product (independent of quick-consume or regular consume) I got the red pop-up error "consume failed". But the number of products decreased by the previously consumed amount ... that's working as expected, but the message is misleading.

The AppLog provides the following:

09.12.2023, 20:07:42: Consume failed: decodingError(error: Grocy_Mobile.APIError.errorString(description: "Shopping list does not exist"))

For me a missing shopping list is not related to consumption?

About my Grocy Installation:

I hope you can help me. Thanks in advance!