Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 No Post Count In Read Columb Of Forum
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

thev8kid
Starting Member

United Kingdom
16 Posts

Posted - 26 March 2005 :  23:00:31  Show Profile  Visit thev8kid's Homepage
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

Posted - 27 March 2005 :  07:37:08  Show Profile  Send ruirib a Yahoo! Message
Are you using SQL Server as the database?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thev8kid
Starting Member

United Kingdom
16 Posts

Posted - 27 March 2005 :  08:17:16  Show Profile  Visit thev8kid's Homepage
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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 March 2005 :  10:23:01  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

thev8kid
Starting Member

United Kingdom
16 Posts

Posted - 27 March 2005 :  15:30:31  Show Profile  Visit thev8kid's Homepage
what would the corresponding table column be mate that needs changing,?
sorry about this

Tony C,
learning every day
Go to Top of Page

thev8kid
Starting Member

United Kingdom
16 Posts

Posted - 29 March 2005 :  20:22:03  Show Profile  Visit thev8kid's Homepage
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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 March 2005 :  22:11:11  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

thev8kid
Starting Member

United Kingdom
16 Posts

Posted - 30 March 2005 :  05:33:35  Show Profile  Visit thev8kid's Homepage
cheers ruirib
I understand what you are saying regarding the tables.

Tony C,
learning every day
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.46 seconds. Powered By: Snitz Forums 2000 Version 3.4.07