[BUG] Table "counter" is empty (due to import?) #401
Description
Describe the bug
I have recently activated mail archiving (SMTP from Exchange), and afterwards started to use "pilerimport" to import EML files from our previous archiving solution. Import went really smooth, except from accidentally importing an XML file (see #400).
In between, the statistics looked fine, afair. When I had imported all ~120 GB however, "Message Disposition" didn't show any information. Checking the database, I found that the table "counter" didn't have any records. As I certainly didn't delete it manually, I assume there might be a bug somewhere. At the moment, I have no other explanation for the record missing.
To Reproduce
Sadly, no idea. Piler was in productive use, and I imported a lot of old emails. Importing the XML file might or might not have caused the issue.
Piler version:
piler 1.4.8-652f50a3, Build Date: Mon Jan 12 14:02:37 UTC 2026
ldd version: ldd (Ubuntu GLIBC 2.39-0ubuntu8.6) 2.39
gcc version: gcc version 13.3.0 (Ubuntu 13.3.0-6ubuntu2~24.04)
OS: Linux bbebad682a99 6.14.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.14.11-4 (2025-10-10T08:04Z) x86_64 x86_64 x86_64 GNU/Linux
Configure command: ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var --with-database=mariadb
MySQL client library version: 3.3.16
Extractors: /usr/bin/pdftotext /usr/bin/catdoc /usr/bin/catppt /usr/bin/xls2csv /usr/bin/unrtf /usr/bin/tnef libzip
Additional context
As a quick fix, I manually created a new record and entered some numbers. Of course, the numbers are not correct right now.
Is there a way to calculate the correct numbers as they should be right now?