Skip to main content

The Bandwidth section of the cPanel Statistics sidebar shows 'Data Unavailable'

Brian Dial
  • Updated

Symptoms

In cPanel in the Statistics sidebar, the 'Bandwidth' section shows 'Data Unavailable'

mceclip2.png

 

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.

 

Related articles