| Author |
 Topic  |
|
|
moeman96
Starting Member
7 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 17 July 2008 : 07:30:09
|
If you want us to take a look, you should provide a testuser account for us to log in.
On a different note, your background pattern makes it very difficult to read your menu< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 July 2008 : 07:48:57
|
| I would be interested to know why an upgrade would zero counts though, since there is nothing in setup.asp that would do that.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 July 2008 : 08:15:30
|
quote:
Originally posted by HuwR
I would be interested to know why an upgrade would zero counts though, since there is nothing in setup.asp that would do that.
I agree, but I've seen it happening and the update counts fixing it.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
moeman96
Starting Member
7 Posts |
Posted - 17 July 2008 : 09:35:29
|
Hi HuwR, sure username and password are both test@test.com
I agree with background, I'm in the middle of changing the whole site after been hacked
Hi ruirb
I have tried the Update Counts, but this gives me the following error
Updating Counts Step 5 of 5
Totals: error '80020009'
/forum/admin_count.asp, line 494
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 July 2008 : 11:31:32
|
To fix the error, and make Update Counts work with MySQL 5.0, you will need to change the columns F_TOPICS, F_COUNT, F_A_TOPICS, F_A_COUNT in FORUM_FORUM to double data type.
Once you do that, just run the Update Counts again.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
moeman96
Starting Member
7 Posts |
Posted - 20 August 2008 : 12:16:23
|
Hi Guys
Sorry for the late reply, I ran into some issues, anyways, I tried changing the ASP code as this seemed to be the easiest, as per http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63480 but it did not work I still had the same error (I changed the code back to it's original state). I then changed the column data types and now the count is working in the sense I do not get an error, but the count is wrong, I get
Updating Counts Step 5 of 5
Totals: Total Topics: 0
Archived Topics: 0
Total Posts: 0
Total Archived Posts: 0
Registered Users: 1739
The figures are wrong, as drilling into the Forum reveals Topics and so on, any ideas?
Regards Moeman96< |
Edited by - moeman96 on 20 August 2008 12:29:46 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
moeman96
Starting Member
7 Posts |
Posted - 22 August 2008 : 09:38:54
|
Thanks ruirib, but I seem to have hit another issue while running the script, my database name takes the form of letters and numbers with a dash in the middle, for example qwerty-12345 (I do not want to supply the real database name)
When I use the script I get a syntax error for USE qwerty-12345, I have tried qwerty\-12345 and 'qwerty-12345' with no success, any ideas?
Regards Moeman96< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
moeman96
Starting Member
7 Posts |
Posted - 22 August 2008 : 12:03:09
|
Yes, Yes, Yes, you have made me a happy man, thanks very much guys now it works, 
Regards Moeman96< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.<