| Author |
 Topic  |
|
|
l2k man
New Member
United Kingdom
74 Posts |
 Posted - 22 March 2013 : 10:45:21
|
| I've got myself confused!! I have just created a new forum, then added a topic, but I get 0 Topics and Posts count. I manually changed the counts F_TOPICS and F_COUNT in FORUM_FORUM, then when I added another topic the counts incremented, and decremented when the new topic was deleted. Any suggestions as to where I should look will be gratefully received. I am using an SQL database. |
Edited by - l2k man on 23 March 2013 16:02:56 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
|
|
l2k man
New Member
United Kingdom
74 Posts |
Posted - 23 March 2013 : 17:34:27
|
Huw,
Many thanks but yes I did |
Edited by - l2k man on 24 March 2013 06:51:08 |
 |
|
|
l2k man
New Member
United Kingdom
74 Posts |
Posted - 24 March 2013 : 07:32:27
|
AH SORTED  When I changed from an Access database to SQL I found some parameters where not transferred. This is another one! I had to change the General/Default Value from nothing to 0. I guess it is better to make sure all numeric (integer) fields have a default value of 0. |
Edited by - l2k man on 24 March 2013 07:39:25 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
|
|
l2k man
New Member
United Kingdom
74 Posts |
Posted - 24 March 2013 : 09:14:23
|
Huw,
As a matter of interest, how are these parameters set when setting up a Snitz forum with a SQL database? When making the transfer I had to trawl through the tables setting the Identity Specification to autoincrement those fields that Autonumber in Access. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 24 March 2013 : 10:55:12
|
Snitz uses scripts to set up the tables with the correct defaults etc.
When transferring from acess to SQL we always recomend that you use the snitz setup to create all the tables and then transfer the data from the access db to the sql db, doing it any other way normally ends in the situation you describe. |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
l2k man
New Member
United Kingdom
74 Posts |
Posted - 24 March 2013 : 11:35:23
|
Huw,
Many thanks again. I didn't come across that recommendation when I was making the transition. Hopefully this topic will benefit someone else.
Having researched again, and I don't know why it didn't come up when I looked before, I found this in the Archives. Anyone else moving from Access to SQL should read it before doing anything.
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=63884 |
Edited by - l2k man on 25 March 2013 12:11:34 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
|
|
l2k man
New Member
United Kingdom
74 Posts |
|
| |
Topic |
|
