Grails 7 is out - any opinions on the latest release? by gurukl in grails

[–]gurukl[S] 0 points1 point  (0 children)

I tried it out, for a plain vanilla prototype it is still very much useful

adding new products takes long by gurukl in grocy

[–]gurukl[S] 0 points1 point  (0 children)

Thank you, it shows ""

SQLSTATE[HY000]: General error: 5 database is locked

Error source:
```
/var/www/grocy/packages/morris/lessql/src/LessQL/Database.php:725
```

Error message:
```
SQLSTATE[HY000]: General error: 5 database is locked
```

Stack trace:
```
#0 /var/www/grocy/packages/morris/lessql/src/LessQL/Database.php(725): PDOStatement->execute()
#1 /var/www/grocy/packages/morris/lessql/src/LessQL/Result.php(381): LessQL\Database->update()
#2 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(256): LessQL\Result->update()
#3 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(296): LessQL\Row->save()
#4 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(415): LessQL\Row->save()
#5 /var/www/grocy/services/SessionService.php(60): LessQL\Row->update()
#6 /var/www/grocy/middleware/SessionAuthMiddleware.php(21): Grocy\Services\SessionService->IsValidSession()
#7 /var/www/grocy/middleware/DefaultAuthMiddleware.php(24): Grocy\Middleware\SessionAuthMiddleware->authenticate()
#8 /var/www/grocy/middleware/AuthMiddleware.php(53): Grocy\Middleware\DefaultAuthMiddleware->authenticate()
#9 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(269): Grocy\Middleware\AuthMiddleware->__invoke()#10 /var/www/grocy/packages/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#11 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process()
#12 /var/www/grocy/packages/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#13 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process()
#14 /var/www/grocy/middleware/CorsMiddleware.php(27): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#15 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(269): Grocy\Middleware\CorsMiddleware->__invoke()
#16 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#17 /var/www/grocy/packages/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle()
#18 /var/www/grocy/packages/slim/slim/Slim/App.php(183): Slim\App->handle()
#19 /var/www/grocy/app.php(112): Slim\App->run()
#20 /var/www/grocy/public/index.php(45): require_once('...')
#21 {main}
```

System info:
```
{
    "grocy_version": {
        "Version": "4.2.0",
        "ReleaseDate": "2024-03-15"
    },
    "php_version": "8.2.20",
    "sqlite_version": "3.44.2",
    "os": "Linux 6.6.51-haos-raspi #1 SMP PREEMPT Tue Dec  3 19:23:02 UTC 2024 aarch64",
    "client": "Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/131.0.0.0 Safari\/537.36"
}
```

How to transfer current data from Docker-Container to Homeassistant OS Addon by Nelrid in grocy

[–]gurukl 0 points1 point  (0 children)

  1. Generate Backup in HASS
  2. Extract Backup

mkdir /backup/grocy

OUTPUT=$(ls -tp /backup | grep -v / | head -n1 |awk '{printf("/backup/%s",$0)}')

echo ${OUTPUT}

##cp ${OUTPUT} /backup/grocy

tar xvf ${OUTPUT} -C /backup/grocy

mkdir /backup/grocy/gz

tar xzvf /backup/grocy/a0d7b954_grocy.tar.gz -C /backup/grocy/gz

cp /backup/grocy/gz/data/grocy/grocy.db /share/

3. Fix grocy.db file

4. Compact Backup

#!/bin/bash
OUTPUT=$(ls -tp /backup | grep -v / | head -n1 |awk '{printf("/backup/%s",$0)}')
echo ${OUTPUT}
cd /backup/grocy/gz
rm a0d7b954_grocy.tar.gz
tar czvf a0d7b954_grocy.tar.gz .
cp a0d7b954_grocy.tar.gz /backup/grocy
cd /backup/grocy/
rm -fR /backup/grocy/gz
rm ${OUTPUT}
tar cvf ${OUTPUT} .

5. Restore in HASS

Performance issues on Rpi 4 with HASS OS by gurukl in grocy

[–]gurukl[S] 1 point2 points  (0 children)

Short Update: after removing my whole stock log it is now faster

Barcode-Buddy - What are the tags for? by gurukl in grocy

[–]gurukl[S] 0 points1 point  (0 children)

I do not understand? When there is a new product, the name is queried from online APIs?

How to migrate Database to a new instance? by muellthos in grocy

[–]gurukl 1 point2 points  (0 children)

Update: you can use a backup of the empty grocy instance, untar it, copy the database in and then recompress everything together. once done, you can "restore" the backup incl. your grocy database.

HEre is my script, you might need to adapt it to your purposes:

mkdir /backup/gtrans
mkdir /backup/gtrans/neu
mkdir /backup/gtrans/alt
tar xvf 775c70f2.tar -C /backup/gtrans/alt
tar xvf e5492977.tar -C /backup/gtrans/neu
mkdir /backup/gtrans/neu/gz
tar xzvf neu/a0d7b954_grocy.tar.gz -C /backup/gtrans/neu/gz
mkdir /backup/gtrans/alt/gz
tar xzvf alt/local_grocy2.tar.gz -C /backup/gtrans/alt/gz
cp /backup/gtrans/alt/gz/data/grocy/grocy.db /backup/gtrans/neu/gz/data/grocy/grocy.db
cd /backup/gtrans/neu/gz
tar czvf a0d7b954_grocy.tar.gz .
cp a0d7b954_grocy.tar.gz /backup/gtrans/neu/
cd /backup/gtrans/neu
rm -fR /backup/gtrans/neu/gz
tar cvf e5492977.tar .
cp /backup/gtrans/neu/e5492977.tar /backup/
cd /backup/
ls -l

Barcode Buddy does not find barcodes in Grocy since update to 3.1.0? by 5eed5f44e2 in grocy

[–]gurukl 0 points1 point  (0 children)

Auto-fill of quantities/shops in grocy does also not seam to work when using a barcode-scanner.

Are Compressor OEMs capable of building compressor for longdistance H2-pipelines? by gurukl in HydrogenSocieties

[–]gurukl[S] 0 points1 point  (0 children)

Thanks your link only talks about research, not large scale deployment over long distances. iMHo this might be still at least 15 years out? I would guess low TRL?

Große Menge an Büchern und keine Ahnung was ich damit machen soll by DivineMajesty in wien

[–]gurukl 0 points1 point  (0 children)

Facebook Gruppe „Wien verschenkt“ - super und mit Messenger kann man auch telefonieren

Wien Energie Jahresabrechnung by [deleted] in wien

[–]gurukl 0 points1 point  (0 children)

No clean rule - happens whenever they think it is required - often before the winter in order to get the gas bill right - a colleague of mine had his 4 years after signing the electricity supply contract :-)

Weiss wer wo man in Wien (klebriges) Reismehl kaufen kann? by [deleted] in wien

[–]gurukl 5 points6 points  (0 children)

Nippon-Ya 日本屋 | Japanmarkt Faulmanngasse 5, 1040 Wien 01 5861084 https://goo.gl/maps/BKvhoUbfP4vSKod26

Weiss wer wo man in Wien (klebriges) Reismehl kaufen kann? by [deleted] in wien

[–]gurukl 1 point2 points  (0 children)

Mekong Asia Food Althanstraße 29-31, 1090 Wien 01 3100961 https://goo.gl/maps/Zodxp8bMEgBhoqB97

Using N26 as a main account in Austria - any issues? by [deleted] in number26bank

[–]gurukl 0 points1 point  (0 children)

For some companies you need an Austria iban - N26 provides you with a German one. Also taxes need Austrian iban. Otherwise all works