Hi, did this ever get resolved? I appear to have the same problem. I'm on 2.8.1 although following a failed upgrade to 3.0.0
SELECT file_id, count(*) FROM fud26_msg GROUP BY file_id;
gives...
file_id count(*)
-20000 85291
20000 29908
50000 250
60000 975
70000 20
5 row(s) returned.
and I have this in the forum's message directory.
total 93692
-rw------- 1 54825067 2009-11-21 05:31 msg_20000
-rw------- 1 0 2009-07-04 17:13 msg_30000
-rw------- 1 289502 2009-08-23 10:45 msg_50000
-rw------- 1 345616 2009-11-18 09:00 msg_60000
-rw------- 1 230973 2009-08-16 13:37 msg_70000
-rw------- 1 621205 2009-11-21 05:54 private
-rw-r--r-- 1 39499386 2009-11-21 04:46 tmp_msg_20000