mysql> select id,foff from fud2_msg order by id asc limit 0,20; +-----+-------+ | id | foff | +-----+-------+ | 151 | 57381 | | 152 | 57069 | | 153 | 7931 | | 154 | 55070 | | 155 | 54286 | | 156 | 55111 | | 157 | 7398 | | 158 | 53404 | | 159 | 41364 | | 160 | 20306 | | 161 | 30313 | | 162 | 49720 | | 163 | 6627 | | 164 | 50459 | | 165 | 7290 | | 166 | 6907 | | 167 | 48498 | | 168 | 48607 | | 169 | 7049 | | 170 | 48328 | +-----+-------+ 20 rows in set (0.00 sec)
aerie# ls -l fcweb/fc-forum-data/messages/ total 1810 -rw-r--r-- 1 www www 14 Sep 3 20:45 .htaccess -rw-rw-rw- 1 www www 83375 Sep 3 20:52 msg_100000 -rw-rw-rw- 1 www www 42601 Sep 3 20:52 msg_110000 -rw-rw-rw- 1 www www 12762 Sep 3 20:52 msg_120000 -rw-rw-rw- 1 www www 953 Sep 3 20:52 msg_130000 -rw-rw-rw- 1 www www 56330 Sep 3 20:52 msg_140000 -rw-rw-rw- 1 www www 118043 Sep 3 20:52 msg_150000 -rw-rw-rw- 1 www www 103124 Sep 3 20:52 msg_160000 -rw-rw-rw- 1 www www 35288 Sep 3 20:52 msg_170000 -rw-rw-rw- 1 www www 87825 Sep 3 20:52 msg_180000 -rw-rw-rw- 1 www www 167250 Sep 3 20:52 msg_190000 -rw-rw-rw- 1 www www 120014 Sep 3 20:52 msg_20000 -rw-rw-rw- 1 www www 12123 Sep 3 20:52 msg_200000 -rw-rw-rw- 1 www www 1484 Sep 3 20:52 msg_210000 -rw-rw-rw- 1 www www 43293 Sep 3 20:52 msg_220000 -rw-rw-rw- 1 www www 36897 Sep 3 20:52 msg_230000 -rw-rw-rw- 1 www www 29978 Sep 3 20:52 msg_240000 -rw-rw-rw- 1 www www 29518 Sep 3 20:52 msg_250000 -rw-rw-rw- 1 www www 9796 Sep 3 20:52 msg_260000 -rw-rw-rw- 1 www www 922 Sep 3 20:52 msg_270000 -rw-rw-rw- 1 www www 3523 Sep 3 20:52 msg_280000 -rw-rw-rw- 1 www www 52470 Sep 3 20:52 msg_30000 -rw-rw-rw- 1 www www 18490 Sep 3 20:52 msg_40000 -rw-rw-rw- 1 www www 4026 Sep 3 20:52 msg_50000 -rw-rw-rw- 1 www www 88847 Sep 3 20:52 msg_60000 -rw-rw-rw- 1 www www 236994 Sep 3 20:52 msg_70000 -rw-rw-rw- 1 www www 93128 Sep 3 20:52 msg_80000 -rw-rw-rw- 1 www www 177285 Sep 3 20:52 msg_90000 -rw-rw-rw- 1 www www 133488 Sep 3 20:52 private]]>
Quote: |
Also, I see the private file is not empty, implying presence of private messages in the forum, do those messages appear correctly? |
mysql> select fud2_pmsg.id, fud2_pmsg.offset from fud2_pmsg order by fud2_pmsg.id asc limit 0,10; +----+--------+ | id | offset | +----+--------+ | 1 | 0 | | 2 | 283 | | 4 | 591 | | 5 | 874 | | 7 | 1115 | | 8 | 1115 | | 9 | 1447 | | 12 | 1907 | | 13 | 566 | | 14 | 566 | +----+--------+ 10 rows in set (0.12 sec)
mysql> select fud2_pmsg.id, fud2_pmsg.foff from fud2_pmsg order by fud2_pmsg.id asc limit 0,10; +----+------+ | id | foff | +----+------+ | 1 | 283 | | 2 | 283 | | 4 | 283 | | 5 | 283 | | 7 | 283 | | 8 | 283 | | 9 | 283 | | 12 | 283 | | 13 | 283 | | 14 | 283 | +----+------+ 10 rows in set (0.01 sec)
mysql> select fud2_msg.id, fud2_msg.offset from fud2_msg order by fud2_msg.id asc limit 0,10; +-----+--------+ | id | offset | +-----+--------+ | 151 | 0 | | 152 | 34 | | 153 | 387 | | 154 | 346 | | 155 | 1093 | | 156 | 1877 | | 157 | 9925 | | 158 | 3470 | | 159 | 38654 | | 160 | 41672 | +-----+--------+ 10 rows in set (0.04 sec)
mysql> select fud2_msg.id, fud2_msg.foff from fud2_msg order by fud2_msg.id asc limit 0,10; +-----+-------+ | id | foff | +-----+-------+ | 151 | 57381 | | 152 | 57069 | | 153 | 7931 | | 154 | 55070 | | 155 | 54286 | | 156 | 55111 | | 157 | 7398 | | 158 | 53404 | | 159 | 41364 | | 160 | 20306 | +-----+-------+ 10 rows in set (0.00 sec)