Ich habe das Update mit gut pull gemacht. Die Werte erscheinen alle wie gewohnt. Wenn der erste live-Update erfolgt, verschwinden die Werte Zeile für Zeile und kommen auch nicht mehr wieder.

PHP 7.4 ist auf der Serverseite und da tauchen erneut irreführende Fehlermeldungen auf: für die Software aus 2018 die bisher lief und konfiguriert ist. und für die Software mit aktuellem Stand, die nicht konfiguriert ist. Mein Problem ist nun wie ich von diesen beiden Meldungen aus zu einem funktionierenden System komme.

Originally posted by @WolfgangFahl in https://github.com/volkszaehler/volkszaehler.org/issues/607#issuecomment-703222327

seit #560 sind Kanäle, die über Kanal hinzufügen > Öffentliche Kanäle abonniert werden, zunächst nicht aktiv. Ein Reload des Frontends behebt das. Hinzufügen via Private Kanäle mittels UUID abonniert den gleichen Kanal direkt aktiv.

Observered after two days. I have beside others three channels for Bezug, Einspeisung, and Erzeugung and are all three electric meters and with correct initial values and scale factor 1000 set for the electric power here. The first two channels are done with sml and the third with exec protocol.

Comparing the vzlogger log file with the last entries shows that the Gesamt/total consumptions are not in sync with those shown by the middleware server. Currently shown for Bezug/chn0 is 427 kWh, but actual value is 432769.20 W, for Einspeisung/chn1 it is 61.0 kWh, but value is 61140.30 W (that is beside the missing rounding for initial value OK ... not enough sun for Einspeisung only for Eigenverbrauch), and then for Erzeugung/chn4 it is 458 kWh, but actual value is 460057.00 W

The resulting curves seems to be correct and are perfect reflected by e.g. current Wirkleistung of both electric smartmeter and inverted rectifier

I have updated my Volkszähler installation following the instructions at:

http://wiki.volkszaehler.org/howto/git

The first issue I encountered was a http 500 and an entry in the apache 2 error log:

Mon Apr 17 07:58:05.353126 2017] [core:alert] [pid 13522] [client 2.0.0.102:56945] /var/www/volkszaehler.org.2017/.htaccess: Require not allowed here

to fix this I had to add Authconfig to the AllowOverride options in the vz configuration of apache:

Alias /vz2017/  "/var/www/volkszaehler.org.2017/htdocs/"
<Directory /var/www/volkszaehler.org.2017>
  Options Indexes FollowSymLinks MultiViews
  AllowOverride FileInfo Limit Options Indexes Authconfig
  Require all granted
</Directory>

you might want to add this info to the documentation.

The next issue is a display of "Network Error" - Internal Server Error dialog. If I ignore this I get Javascript Runtime Error "TypeError: vz.capabilities.definitions.entities is undefined"

I have cleared the vz_ cookie and the cache to no avail.

Please advise

Fix https://github.com/volkszaehler/volkszaehler.org/issues/495 and add some responsive UI elements for smaller screen sizes.

To hide UI elements add their CSS selectors:

?hide=#footer,#header,#accordion

To get rid of the options section only:

?hide=h3:not(:first-of-type)

To add UUIDS:

&uuid[]=abc&uuid[]=def

Fehlermeldung: pi@volkszaehler:~ $ sudo /usr/bin/php /var/www/volkszaehler.org/misc/tools/push-server.php Volkszaehler Push Server Listening for updates on 5582. Clients may connect at 8082. PHP Fatal error: Call to undefined function GuzzleHttp\Psr7\parse_request() in /var/www/volkszaehler.org/vendor/react/http/src/RequestParser.php on line 98

After I had successfully set up the frontend on my intranet server (using my Raspberry Pi to POST meter reading to it), I noticed that the frontend was using local times -- while my server runs on UTC.

I found a config item $config['timezone'] in volkszaehler.conf.php which I changed to $config['timezone'] = 'UTC'; but still the frontend continues to use local time.

This applies to the frontend code which I downloaded today from GitHub (can't easily find the build?!).

In general this project claims copyright. Good.

As far as i know one should add a time frame for the copyright notice indicating a range between first and last code change. For this project: 2011 to 2017.

This should be use on user interface (frontend footer), documentation (readme) and source code incl. unit tests. All these elements of a project should have a notice that each element (file) is part of the project incl. a project-level (global) copyright range. Do not put other copyright ranges at individual file-level.

This PR adds missing copyright notices to some files and normalizes copyright ranges (years) to a global project-level standard (developer-facing and user-facing). Applying this PR now makes sence even when 2018 is just a view days away (update to 2018 is a simple string operation after applying this PR)

This PR is a major rewrite of the basis Volkszaehler middleware request/response infrastructure.

Instead of using PHP global request variables and outputting results directly to the browser, all input/output is channeled through the defacto-standard Symfony HTTPFoundation Request and Response components (http://symfony.com/doc/current/components/http_foundation/introduction.html).

To structure this process, input/output follows the design paradigm of Symfony HTTPKernel (http://symfony.com/doc/current/components/http_kernel/introduction.html).

The main benefit of this rewrite is the greatly improved testability of middleware functionality (plus additional tests implemented). Future uses may include stackability of Volkszaehler middleware in other applications (https://igor.io/2013/02/02/http-kernel-middlewares.html).

To keep the overhead and especially implementation complexity and learning curve of the additional libraries used low, this require does NOT use a microframework. However, porting Volkszaehler to e.g. Silex can now be done with minor additional changes.

NOTE Though these changes have undergone testing they cannot be considered production quality yet.

Does fix https://github.com/volkszaehler/volkszaehler.org/issues/199

New behaviour: when on right boundary, zooming to hour/day/week etc will adjust left boundary to start of period. I zooming immediately again to same period, left boundary is adjusted so chart shows timestamp of period and is no longer fixed to period start.

Datensätze die ich in der Datenbank gelöscht habe werden im frontend noch angezeigt. Es muss irgendwo noch eine Art Cache geben. Kann man den löschen ?

When creating a virtual sensor channel with 2 inputs, and then emptying the second input value, the value is still visible in the web frontend - until the frontend is reloaded.

Steps to reproduce:

1. Create new channel of type "Verbrauchssensor (virt.)"
2. Fill values for "Eingang 1" and "Eingang 2" and save
3. Edit the channel and remove the value for "Eingang 2" and save
4. A PATCH request is sent, removing the value. The object data returned by the server do not contain "in2" anymore.
5. The edit window closes automatically
6. Click the channel's info button. "Eingang 2" is still shown and still has the value that was just deleted. <-- this is a bug
7. Click the edit button and remove the value again in the "Eingang 2" field. Save.
8. The PATCH request fails with status code 400: Object { message: "Entity has no property: 'in2'", type: "Exception", code: 0, … } <-- this is a bug
9. Reload the tab in the browser
10. Open the channel's info popup: The "Eingang 2" value is gone.

Somehow the web interface keeps the in2 field internally.

I started with a clean install of volkszaehler earlier this year and migrated the data from my old server using dbcopy.

Since then I did not get the vzcompress2 script to work. Here is the output

12/02/2021 04:51:45 PM - SQL:SELECT entities.*, properties.value AS name FROM entities INNER JOIN properties ON properties.entity_id = entities.id WHERE properties.pkey = ? AND class = ?
12/02/2021 04:51:45 PM - Processing channel 13df0000-097b-11eb-a092-174646e1882d (Bathroom)...
12/02/2021 04:51:45 PM - SQL:SELECT MIN(timestamp) AS min, MAX(timestamp) AS max FROM data WHERE channel_id = ? AND timestamp <= ? AND timestamp > ?
12/02/2021 04:51:45 PM - Skipping compression pass for data points between 11/02/2021 04:51:45 PM and 11/25/2021 04:51:45 PM using a 60 seconds window: No data points found
12/02/2021 04:51:45 PM - SQL:SELECT MIN(timestamp) AS min, MAX(timestamp) AS max FROM data WHERE channel_id = ? AND timestamp <= ? AND timestamp > ?
12/02/2021 04:51:45 PM - Processing: 06/05/2021 05:56:28 PM - 06/05/2021 06:01:28 PM (0%)... 08:46:07 PM using a 300 seconds window
12/02/2021 04:51:45 PM - SQL:SELECT AVG(value) AS newval, COUNT(value) AS datapoints, MAX(id) AS updateid FROM data WHERE channel_id = ? AND timestamp > ? AND timestamp <= ?PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list' in /home/scripts/volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112

I have added an additional debug output to see the actual SQL. And that leaves me puzzled: data table does not have an id field. The structure is

channel_id PrimaryIndex int(11) No None
timestamp Primary bigint(20) No None
value double No None

Which seems to be the intended structure. When executing

bin/doctrine orm:schema-tool:create --dump-sql > database.sql This is the create for data:

CREATE TABLE data (timestamp BIGINT NOT NULL, channel_id INT NOT NULL, value DOUBLE PRECISION NOT NULL, INDEX IDX_ADF3F36372F5A1AA (channel_id), PRIMARY KEY(channel_id, timestamp)) DEFAULT CHARACTER SET utf8 COLLATEutf8_unicode_ciENGINE = InnoDB;

Looking at an sql dump of my previous server it did seem to have an id field before.

Am I missing something? Was the table structure changed but vzcompress was not updated?

By default a uuid added by url is activated. When the uuid is a group this might me unwanted. The parameter active defines if the uuid is active or not. The default value is not changed. Deactivated when set active to FALSE, F, NO, or 0 (case insensitive) Example: https://demo.volkszaehler.org/?uuid=6836dd20-00d5-11e0-bab1-856ed5f959ae&active=0