After moving my DB to another server (using DTS and no errors reported) I can not see how many times a topic is read. Older topics, from before the move are showing the counter fine +1 each time the topic is read, but new topics are 'blank'. Everything else seems to work splendid!
Looks like the default values have been lost during the move to the new server. Edit the database and make sure the default value for T_VIEW_COUNT in the FORUM_TOPICS table is 0. And you should run a query (can be done via Alternate MOD Setup) to change the current (wrong) values to 0.
That also means the data transfer process was not properly done. It is always recommended to run setup to create the database tables and only then use DTS to transfer the data. That would ensure situations like these do not occur.
I can not make a poll without one of the entries making a 0 (zero). When i vote (on either of the choices), it makes a vbscript error in topic.asp! Older polls works fine. This is a SQL-table problem for sure...or
Did you run the dbs file for your mods after running setup.asp? The principle is always to create the table structure and then, and only then, DTS the data.
Topic Locked
Posted - 07 April 2004 : 07:09:32
