The sorting of the migrated old "Discussion Board" was – well, somewhat awkward. I found out it is sorted by the last-changed timestamp field of the thread-record – which – of course I didn’t fill…
The update with a single SELECT-Statement didn’t work since the MySQL-Version on my Webserver doesn’t support UPDATE with sub-SELECT 
Also the number of replies – field wasn’t set – don’t know if it makes any difference, just to make sure…
2 more little php-scripts which step through the threads-table, get the information (no of messages in that thread, timestamp of the newest message) and put into the corresponding field in the threads-table.
Viewing at all threads, deleting some more empty messages and some more spam took me almost the whole day… pew
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}
Comments RSS TrackBack Identifier URI
Leave a comment
No Comments