Differences

This shows you the differences between two versions of the page.

Link to this comparison view

cloudlinux:no-such-table-error-log [2016-07-13 10:45:07] (current)
rory.blanchard created
Line 1: Line 1:
 +====== LVEstats Error Message "no such table" ======
 +
 +LVEstats is a service the controls the updates of usage statistics within LVE. Sometimes however you will notice your stats not updating or see an error message in **/​var/​log/​messages** like the following:
 +
 +<​code>​
 +lvestats-server[2648]:​ <class '​sqlite3.OperationalError'>:​ no such table:
 +</​code>​
 +
 +This error can be fixed by reinitializing the sqlite database.
 +
 +Run the following commands to reinitialize the database:
 +
 +<​code>​
 +service lvestats stop
 +mv /​var/​lve/​lveinfo.db /​var/​lve/​lveinfo.db_backup
 +service lvestats start
 +</​code>​
 +
 +Once you have run that, lvestats should restart and you shouldn'​t see the message any more unless the database gets corrupted again.
 +\\
 +\\