Some forum troubles
Posted by Paul Beuk on 30 June 2008 10:04:51
Yesterday we had some troubles with the forum and, I am partly pleased to say, this was due to the popularity of the site. The other part of me is slightly embarrassed, because I knew the problem would arise at one point but a logical error prevented me from anticipating it now. The content management system (CMS), by default, has a database structure that allows 65536 posts. As we are 'only just' 64000 I though I did not need to take action yet, hoping that it would not be needed before the CMS is upgraded later this year. I overlooked that the database numbers each post individually and the maximum ID number would be reached earlier. SO yesterday evening I changed the setting for the posts table in the database and we should not have any problems anymor in this century. I did not realise that the attachments table carried the same setting for post ID and no attachments were allowed. I changed the setting in that table, too. W should not have problems anymore.
I apologise for not anticipating this issue in the proper way and for any posts/images that may have been lost in this way.
Paul