| Author |
 Topic  |
|
stwilson
Junior Member
USA
385 Posts |
 Posted - 26 September 2002 : 19:01:20
|
| strConnString = "driver={SQL Server};server=SERVER;uid=ID;pwd=PASS;database=DATABASE" |
Shannon
RidingArizona.com |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 26 September 2002 : 19:37:54
|
Still, the table is blank.
STW |
Shannon
RidingArizona.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 26 September 2002 : 20:08:26
|
No errors. In fact, it shows me the totals when it finishes and then goes back to the admin home page. All the other tables appear to be there and populated with data.
STW |
Shannon
RidingArizona.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 September 2002 : 20:28:37
|
I don't know why that happens. Any news on the having more than one FORUM_TOTALS table?
I don't if this will work, but try to add a row manually. Insert COUNT_ID as 1, and then just add some random values for the other columns. Then run update counts again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 27 September 2002 : 02:37:37
|
Ruirib,
That did it. It updated the counts to the accurate numbers.  On the top of the forum however the stat "There are 0 Posts in 0 Topics and 0 Users" is not updated. I keep digging. Thanks for your help.
STW |
Shannon
RidingArizona.com |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 27 September 2002 : 02:48:32
|
Ruirib,
I connected with EM and there are no duplicate tables. 
STW |
Shannon
RidingArizona.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 September 2002 : 08:03:39
|
Well,
Adding the record to the Topics table was the solution. The problem with this was that the SQL statements that update the counts are UPDATE statements and for these to work a record needs to be there before, so that it can be updated. It seems the most pressing issue has been solved now, right? Default.asp is working already, right?
I don't understand your reference to "on top of the forum (...)". What do you mean? Statistics are shown at the bottom, or do you have detailed statistics turned off? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
