It does not appear that the table was correctly installed. I get this when I go to the statistics page:

* user warning: Table 'kscape.webfm_statistics' doesn't exist query: INSERT INTO webfm_statistics (uid, fid, dl_time) VALUES (1, 3, NOW()) in /home/users/k/kscape/public_html/sites/all/modules/webfm_statistics/webfm_statistics.module on line 52.
* user warning: Table 'kscape.webfm_statistics' doesn't exist query: SELECT count(*) AS count FROM webfm_statistics in /home/users/k/kscape/public_html/sites/all/modules/webfm_statistics/webfm_statistics.module on line 90.
* user warning: Table 'kscape.webfm_statistics' doesn't exist query: SELECT count(*) FROM webfm_statistics in /home/users/k/kscape/public_html/sites/all/modules/webfm_statistics/webfm_statistics.module on line 102.
* user warning: Table 'kscape.webfm_statistics' doesn't exist query: SELECT a.sid, a.uid, a.fid, a.dl_time, b.name, b.mail, c.fmime, c.fpath, d.nid, e.title FROM webfm_statistics a LEFT OUTER JOIN users b ON a.uid = b.uid LEFT OUTER JOIN webfm_file c ON a.fid = c.fid LEFT OUTER JOIN webfm_attach d ON a.fid = c.fid AND c.fid = d.fid LEFT OUTER JOIN node e ON d.nid = e.nid ORDER BY nid DESC LIMIT 0, 10 in /home/users/k/kscape/public_html/sites/all/modules/webfm_statistics/webfm_statistics.module on line 102.

Comments

rich_lang’s picture

rich_lang commented

I have received the same error. Did you manage to get this module working? At the moment, my statistics for WebFM downloads is empty.

clarkburbidge’s picture

clarkburbidge commented

I was able to get this module to work by manually installing the database. I looked in the webfm_statistics.install file. I used the info in there to build the table in my DB. Now it seems to be working.

I used phpMyAdmin. I had two snags.

1. Type serial in mysql is BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE http://www.allinterview.com/showanswers/19512.html
2. I didn't quite get the PRIMARY sid configuration correct. I think that phpMyAdmin sets the first row as the primary automatically, so when I clicked the primary icon I got an error of a duplicate primary. I just clicked around a bit until I didn't get an error anymore.

jadowd’s picture

jadowd commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.