WebStat analyser/src/sql.hpp, branch webstat-0.7 WebStat web site access analyser http://git.randomdan.homeip.net/repo/webstat/atom?h=webstat-0.7 2026-07-04T18:36:30Z Include extra details when storing unparsable and uninsertable lines. 2026-07-04T18:36:30Z Dan Goodliffe dan@randomdan.homeip.net 2026-07-04T11:11:38Z urn:sha1:61e106fe6a15f76b73125682e91d5c17ee875be2 Now includes the hostnameId, timestamp and optionally error message. Updates idx_entities_retryinsert to account for details not being NULL. Also fixes the issue where the entities inserted and rollback would still be recorded in the entity cache if the access log insert failed. This would have lead to PK violations later on. Add job to retry insertion of log lines which had previously failed 2026-05-18T19:43:51Z Dan Goodliffe dan@randomdan.homeip.net 2026-05-18T19:43:51Z urn:sha1:e1a6654bd5e284842ffbc3b93bd390f3bad7a187 Entities are reparsed and reinserted, removed on success. Failure to parse updates the entity type to UnparsableLine. Failure to insert again updates the detail with the reason. Add job for puring old access log entries from the database 2025-12-20T15:16:25Z Dan Goodliffe dan@randomdan.homeip.net 2025-12-20T15:16:25Z urn:sha1:30a9d45f5322a63c2adf1de7a248ba3a9a0c3903 Create and perform UA lookup curl op when new user agent is encountered 2025-09-13T12:24:23Z Dan Goodliffe dan@randomdan.homeip.net 2025-09-13T12:24:23Z urn:sha1:84bd17328a4dc027e689ca7b2a85744d6e2b7cf5 Store utsname details in the host's detail field 2025-09-02T15:13:22Z Dan Goodliffe dan.goodliffe@octal.co.uk 2025-09-02T15:13:22Z urn:sha1:ca9be55a98c094e8026a4003a099573dd4137050 Store log lines in full using entity ids 2025-08-25T15:02:41Z Dan Goodliffe dan@randomdan.homeip.net 2025-08-23T16:28:37Z urn:sha1:7ec58bf3f72fd7e0396a37f43ff023731697ff8a Add helpers and SQL for storing an entity 2025-08-25T15:02:31Z Dan Goodliffe dan@randomdan.homeip.net 2025-08-23T15:52:38Z urn:sha1:2db6c4f42a20c0c2a9b32545f4d6fab90be2c26d