| Author |
 Topic  |
|
|
ian9001
Starting Member
22 Posts |
 Posted - 14 May 2006 : 11:36:44
|
I recently moved a forum over from MySql to MS Sql. All worked fine with one exception, the topic "Read" count is not working.
The database field F_TOPIC_VIEWS (in FORUM_TOPICS) is showing "null" for any topic started after the move and there is no entry in default value. Can I simply change the default value to "0" and what value should I have in the "nullable" column? My initial instinct is to go for "False" but not sure what effect this will have on the entries that current have "null" in this column.
Any advice appreciated.
Ian
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 May 2006 : 11:38:39
|
| yes, just set the default to 0 and change all the one that are null to a 0 that should sort out the counting |
 |
|
|
ian9001
Starting Member
22 Posts |
Posted - 14 May 2006 : 11:55:04
|
Thanks Huw, does that mean I don't need to worry about the "nullable" column as it will always have a default value? Sorry if this is a bit basic!
Ian |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 May 2006 : 11:57:40
|
| yes, that is correct |
|
|
|
ian9001
Starting Member
22 Posts |
Posted - 14 May 2006 : 12:00:06
|
Understood. Help appreciated.
Ian |
|
|
|
darkducke
Starting Member
Bhutan
12 Posts |
Posted - 15 May 2006 : 14:26:49
|
| I am with the same problem, as I make so that when a topic will be created this value already either 0 and nao either inserted a value null |
quote:
why did you not post this at Snitz?
The main reasons why this was not posted at Snitz and why I might not post the bugs I find
directly at Snitz anymore are the ways "ruirib and HuwR" take pleasure to criticize just about
anything I post and seem to resent the fact that I want to improve and correct Snitz which, I agree,
serve as the original base for my own Forum.
These are some of the actions I find unacceptable:
ruirib and HuwR take fun to Delete some of my topics, of my replies, locked or move my topic.
A topic posted last week from me to Davio in "Help: MOD Implementation" Forum as been deleted.
Two replies in my topic as been deleted about a bug on snitz topic page:
http://forum.snitz.com/forum/topic.asp?whichpage=5.96&TOPIC_ID=44136#372029
A Fix to texanman as been deleted (first reply to texanman subject):
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=66162
One of my Multi-Language Topic on Snitz has disappeared last night
Multi-Language and Multi-Language Skin3D
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=40765
etc...
3 times I changed my password and the day after the same game start.
Since I send to HuwR a donation of $200 on December 22, 2006
this guy HuwR has never stop to pick on every thing I post on the Snitz Forum.
I have even received from HuwR and ruirib an e-mail threatening to ban me from Snitz Forum :
Hello
You received the following message from: ruirib (ruirib@ruirib.net)
At: http://forum.snitz.com/forum/
It was a pleasure to have you there, hope you enjoyed the ride ;).
And don't try to sneak in...
Goodbye ;).
Hey as_shole, I know it’s Davio who is a member at your forums, gonna lock him out too |
|
|
| |
Topic |
|
Topic Locked
