Author |
Topic  |
|
thev8kid
Starting Member
United Kingdom
16 Posts |
Posted - 26 March 2005 : 23:00:31
|
This may be a simple fix, we had to move my forum to a new server etc, but now when you view active topics or any post the read count does not go up, does not even show a 0, any one any ideas???? http://www.v-8.org.uk/forum/active.asp you will see what i mean there |
Tony C, learning every day |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
thev8kid
Starting Member
United Kingdom
16 Posts |
Posted - 27 March 2005 : 08:17:16
|
yes ruirib. the read count goes up on old post before the move, its only new posts done since the move it is not working on, |
Tony C, learning every day |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 27 March 2005 : 10:23:01
|
That's caused by the way the move of the SQL DB was done. In any move, you need to create the tables first, using setup.asp, and only then use DTS to transfer the data. What you, or someone else for you, has done is to use DTS without running setup.asp first. Because of that, the tables were not correctly created. You can fix the current issue simply by setting the default value in the corresponding table column to 0. Anyway, since I believe you will experience other problems, if you can, I would advise creating a new set of tables and then transfering the data once again, using the guidelines set here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31144 |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
thev8kid
Starting Member
United Kingdom
16 Posts |
Posted - 27 March 2005 : 15:30:31
|
what would the corresponding table column be mate that needs changing,? sorry about this |
Tony C, learning every day |
 |
|
thev8kid
Starting Member
United Kingdom
16 Posts |
Posted - 29 March 2005 : 20:22:03
|
quote: Originally posted by thev8kid
what would the corresponding table column be mate that needs changing,? sorry about this
can you advise us please ruirib which table, |
Tony C, learning every day |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 29 March 2005 : 22:11:11
|
FORUM_TOPICS.T_VIEW_COUNT.
I still think it would be wise to recreate the tables and transfer the data again, according to the recommendation I posted earlier. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 29 March 2005 22:12:10 |
 |
|
thev8kid
Starting Member
United Kingdom
16 Posts |
Posted - 30 March 2005 : 05:33:35
|
cheers ruirib I understand what you are saying regarding the tables. |
Tony C, learning every day |
 |
|
|
Topic  |
|