| Author |
 Topic  |
|
|
Mutz
Starting Member
4 Posts |
 Posted - 15 December 2008 : 12:00:40
|
Snitz™ 2000 Foums Version Number: 3.4.06
Exact errors: for a couple of days i have not been able to read any replies to threads anymore, they have simply vanished. If i run the Update Forum Counts i get an error on step 4 that says:
Updating Counts Step 4 of 5
Forum Replies: Microsoft VBScript runtime error '800a000d'
Type mismatch
/admin_count.asp, line 407
I have read something about this mismatch and tried using some of the fixes mentioned in this forum but it simply does not work for me.
List Of MODS Installed (if any): none
How Long The Error Has Been There For: about 3-4 dayes
Forum link: www.plastfyldning.dk
Member name: test Password: test
DB Type In Use: MysQl
I really hope you can help me
niels
< |
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 15 December 2008 : 12:16:46
|
| Your problem is worse than you think. I made a test reply to one of the messages and it duplicated 7 times. Also, it will not allow me (as the poster) to delete any of the 7 replies - it refuses to authenticate. You have something very corrupt in your database.< |
Edited by - Carefree on 15 December 2008 12:18:01 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Etymon
Advanced Member
United States
2395 Posts |
Posted - 15 December 2008 : 15:33:33
|
For the input to the database, it appears to be either recreating the REPLY_ID 1 for every post or the table is not "auto numbering" the REPLY_IDs as they are created.
In that sense, if true, the table is acting like FORUM_A_REPLY and not FORUM_REPLY.
For the output to the browser, it seems that the amount of replies may be equal to the strPageSize value which appears to be 10.
Perhaps REPLY_ID 1 is either getting recreated but only once or the table is not "auto numbering" each time, and perhaps the strPageSize value is looping the output to the browser until it reaches the value of strPageSize.
How, I don't know ... just some thoughts.
Rui, would running Check Installation rectify the table if it does not have the IDENTITY set correctly?< |
Edited by - Etymon on 15 December 2008 15:40:14 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Etymon
Advanced Member
United States
2395 Posts |
Posted - 15 December 2008 : 16:09:08
|
| If you are able, then create a new database, change the connection string in your config.asp file to point to that database, and then run setup.asp ... after this try posting topics and replies and see what happens.< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 15 December 2008 : 16:50:57
|
| Just out of curiosity, did you upgrade from Access to MySQL or have you been running on MySQL all the time?< |
|
|
|
Mutz
Starting Member
4 Posts |
Posted - 15 December 2008 : 17:02:28
|
No the forum worked perfectly until about a couple of days ago when i could see someone posted a reply but i could not read it. I have been using MySQL all the time. I am not that good with this forum things but our class uses it to share notes end old exam questions so i dont know ift it means anything but there are a lot of forums that the test user cannot see (on the hidden list only for allowed members).
What do you think i can do about it. Would like to have a stepwise guide since i am not that good with databases bit still am trying to getting it to work so the rest of my school can enjoy it.
niels< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Mutz
Starting Member
4 Posts |
Posted - 16 December 2008 : 11:56:58
|
I have just written to them to hear if they have changed anything.
Ruirib: what do you mean by "find out what actially is the db" do you mean the path to my database?< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Mutz
Starting Member
4 Posts |
Posted - 17 December 2008 : 05:42:38
|
My hosting company uses phpmyadmin so tried using its repair function and got the following (however, it did not solve the problem)
SQL-resultat
Vært: 195.128.174.37
Database: web181827
Genereringstid: 17. 12 2008 kl. 11:40:24
Genereret af: phpMyAdmin 2.11.7.1 / MySQL 5.0.51a-log
SQL-forespørgsel: REPAIR TABLE `FORUM_ALLOWED_MEMBERS`, `FORUM_A_REPLY`, `FORUM_A_TOPICS`, `FORUM_BADWORDS`, `FORUM_CATEGORY`, `FORUM_CONFIG_EXTENSION`, `FORUM_CONFIG_NEW`, `FORUM_FORUM`, `FORUM_GROUPS`, `FORUM_GROUP_NAMES`, `FORUM_MEMBERS`, `FORUM_MEMBERS_PENDING`, `FORUM_MODERATOR`, `FORUM_NAMEFILTER`, `FORUM_REPLY`, `FORUM_SUBSCRIPTIONS`, `FORUM_TOPICS`, `FORUM_TOTALS`;
Rækker: 18
Table Op Msg_type Msg_text
web181827.FORUM_ALLOWED_MEMBERS repair status OK
web181827.FORUM_A_REPLY repair status OK
web181827.FORUM_A_TOPICS repair status OK
web181827.FORUM_BADWORDS repair status OK
web181827.FORUM_CATEGORY repair status OK
web181827.FORUM_CONFIG_EXTENSION repair status OK
web181827.FORUM_CONFIG_NEW repair status OK
web181827.FORUM_FORUM repair status OK
web181827.FORUM_GROUPS repair status OK
web181827.FORUM_GROUP_NAMES repair status OK
web181827.FORUM_MEMBERS repair status OK
web181827.FORUM_MEMBERS_PENDING repair status OK
web181827.FORUM_MODERATOR repair status OK
web181827.FORUM_NAMEFILTER repair status OK
web181827.FORUM_REPLY repair status OK
web181827.FORUM_SUBSCRIPTIONS repair status OK
web181827.FORUM_TOPICS repair status OK
web181827.FORUM_TOTALS repair status OK
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
