| Author |
 Topic  |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 12 July 2004 : 18:40:28
|
I've just started to use Speedball 2 on one of my forums, and I've noticed since changing over, it's not counting how many people have read the new topics.
For example:
http://www.mortioli.co.uk/forums/forum.asp?forum_id=2
The top 3 topics have no reads next to them, but the others (before changing) do, and they update once read.
I'm now using a MySQL DB, so would this be the cause? |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 13 July 2004 : 04:04:09
|
| Structurally speaking, Speedball a duplicate of the original Snitz, so it shouldn't be a code problem. Can't think why its not counting the reads in those forums as, as far as I am aware, it isn't a configurable option. |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 13 July 2004 : 04:08:37
|
quote:
Originally posted by mortioli
I'm now using a MySQL DB, so would this be the cause?
Yep, most likely. How did you do the conversion?
Easy way to fix this is to go in and set a default value of 0 for the T_VIEW_COUNT field in the FORUM_TOPICS table. |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 13 July 2004 : 14:43:51
|
I converted using the hosts control panel, so not sure how exactly.
I've attempted to set the value to 0, but it won't save for some reason, so I've contacted the host.
I noticed this at the bottom of the page, and just thought I'd post it to see if I should have these or not:
Indices
Index Name Indexed column Primary Key Unique Action
aaaaaFORUM_TOPICS_PK CAT_ID True True delete
aaaaaFORUM_TOPICS_PK FORUM_ID True True delete
aaaaaFORUM_TOPICS_PK TOPIC_ID True True delete
Topic_ID TOPIC_ID False True delete
{5DB0DADA-07CD-4557-A125-F8E7E7892D5E} T_AUTHOR False False delete
{83D30317-27DF-4001-8144-74F3D12C59BF} CAT_ID False False delete
{83D30317-27DF-4001-8144-74F3D12C59BF} FORUM_ID False False delete
CAT_ID CAT_ID False False delete
Forum_id FORUM_ID False False delete
EDIT - Sorry, it's MS SQL ...not sure if that's much different, I'm not clued up on the whole SQL thing
Would this be causing anything? |
Edited by - mortioli on 04 October 2004 17:17:03 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 04 October 2004 : 19:15:34
|
| The preferred method of conversion is to let Snitz create all the tables in your new MS SQL DB and then simply import the database, I think it would be fairly safe to say that becuase you've used another method to upgrade your DB that this is whats causing your issues now. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
