Symptoms
In cPanel in the Statistics sidebar, the 'Bandwidth' section shows 'Data Unavailable'
The cPanel error log at /usr/local/cpanel/log/error_log
shows the following when loading the affected user's cPanel interface:
Cpanel::Exception::Database::Error/(XID abcdefg) The system received an error from the
“SQLite” database “/var/cpanel/bandwidth/user.sqlite”: SQLITE_ERROR
(no such table: version)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.
[stack trace]
Description
This issue can be caused by an empty SQLite bandwidth database.
Workaround
Check the size of the bandwidth database from the command line to ensure that it has no data:
ls -l /var/cpanel/bandwidth/user.sqlite
After confirming that the bandwidth database is 0 bytes, move it aside:
mv -v /var/cpanel/bandwidth/user.sqlite{,-backup.`date +%m%d%y`}
Next, refresh the user's cPanel interface to have the bandwidth database regenerated with the proper table structure.
Comments
0 comments
Article is closed for comments.