View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0019515||phpList 3 application||Statistics||public||02-11-18 10:22||02-11-18 10:22|
|Target Version||Fixed in Version|
|Summary||0019515: Stats for certain messages can get completely blanked out|
|Description||I've wanted to see my Statistics overview and instead encountered error messages (in plural, although it's just the same message twice) about a malfunction table:|
Table "usermessage" is marked as crashed and should be repaired
The same error was shown in other stats as well, except clicks (the result of which was a negative percent).
The only solution I've found was entering my database and running a REPAIR TABLE command. The result produced the following info:
Wrong bytesec: 0- 0- 0 at 3061232; Skipped
Obviously users without database access or SQL knowledge have no way to fix this and are seemingly stuck forever with this error and its lack of stats.
I probably can't stress enough the importance of stats. phpList can do amazing things but they can't be evaluated without stats.
When your clients ask you for stats, and you can't deliver such, they won't care how smart phpList is in other aspects.
|Steps To Reproduce||It was probably caused because the affected message for some reason crashed in the middle of sending (maybe due to a connection drop) and I've had to relaunch the queue.|
|Tags||No tags attached.|