After 2 months, my application stopped working correctly

[gruntaroman (Roman G)]

Hello,

I have an application that has been working without any problems for over two months, until yesterday. It’s designed to sum up values from several other fields into a single field. However, today, the summing field has shown a negative value, which is an error and means the application is not working as it should. It’s also strange that when I load an older version of the app, the same problem appears there as well. The negative value is present in a field where the value should be positive, since the field only sums up other individual fields. Could the problem be related to the recent major Kodular update?

Thank you for your help.

[RaYzZz (Gianluca Franco)]

Hi gruntaroman,

Could you show the blocks related to that value?

@gruntaroman

Could the problem be related to the recent major Kodular update?

I don’t think so but let’s take a look at the blocks before saying that.

[gruntaroman (Roman G)]

There’s no point in showing the blocks because I have a lot of them. But the problem won’t be in the blocks, because I haven’t changed these specific blocks that do the summation. It’s also really strange that when I updated the app with a version from a month ago, it’s making the same mistake there too. Yet, until yesterday, it worked perfectly for over 2 months. And I didn’t touch the blocks. Could the problem be that I’m using the TinyDB component and I already have over 1000 stored fields that are recalled when the app starts to sum all these items? Is there a limit for this? Otherwise, I really can’t explain why it stopped working today. The app was even working without any issues yesterday.

[RaYzZz (Gianluca Franco)]

@gruntaroman

There’s no point in showing the blocks because I have a lot of them.

If you’re not looking for help, then just open a bug report directly.

@gruntaroman

Could the problem be that I’m using the TinyDB component and I already have over 1000 stored fields that are recalled when the app starts to sum all these items? Is there a limit for this? Otherwise, I really can’t explain why it stopped working today.

It shouldn’t be a problem, but it would make more sense to manage all this data in a dictionary or an SQL database rather than saving each piece of data in a tag and then having to recall them all when the app opens.

[Ibrahim_Jamar]

@gruntaroman

There’s no point in showing the blocks

So how could we help?

It’s like saying there’s no point in going to the hospital — but then when you get there, you say no to getting injected. The blocks are part of the treatment, without them the solution won’t really work. Even a screenshot?

[gruntaroman (Roman G)]

So, when I saved the app under a different name, it works without any problems. The problem is probably that there is already so much data stored in TinyDB that the app has to retrieve and load, and then it stops calculating correctly. I don’t have any other explanation for it. Because the same app under a different name with less data runs completely fine. Unfortunately, I don’t know how to work with an SQL database.

[Taifun]

@gruntaroman

Could the problem be that I’m using the TinyDB component and I already have over 1000 stored fields that are recalled when the app starts to sum all these items?

Probably
Your approach looks cumbersome

What about working with lists and storing lists in TinyDB instead of 1000 single values?

Imagnity.com List Tutorial, Mirrored - @Saj

Taifun

[Taifun]

@gruntaroman

Unfortunately, I don’t know how to work with an SQL database

Also the local Sqlite database is an option… probably the better one because you also can easily calculate there

SQLite Tutorial - An Easy Way to Master SQLite Fast

Taifun

[gruntaroman (Roman G)]

Thank you for the advice. I’ll look into it and try using lists. Is it then possible to save the entire list to TinyDB instead of saving individual items? And how can I make sure that items from newly entered values are automatically added to the list? Thank you so much for the advice.

[RaYzZz (Gianluca Franco)]

Since you were saving the data with a tag, I suggested using a dictionary, this way you can keep the key:value structure.

@gruntaroman

Is it then possible to save the entire list to TinyDB instead of saving individual items?

sure

To add item to tinyDBList use this function

[solomon_zerihun (:kodular: koder)]

Anyways in my opinion using tinyDB to store data is risky, I don’t recommand anyone to store data using tinyDB(because he don’t know what you gave him) rather try to use SQlite( he know what you gave him).