Author |
Topic |
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 30 May 2001 : 16:10:22
|
While testing out the beta version of the forums, I ran into a few errors.
1. I get these errors when clicking on the "Display IP" link on a Topic or a Reply respectively:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'TOPICS'. Make sure it exists and that its name is spelled correctly.
/beta/v33/topic.asp, line 662"
---------------------------------------------------------------
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'REPLY'. Make sure it exists and that its name is spelled correctly.
/beta/v33/topic.asp, line 673"
2. When clicking on the Questions sign link <img src="icon_smile_question.gif" border=0> in the Admin Options, I get this error:
"Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getMemberNumber'
/beta/v33/inc_top_short.asp, line 50"
3. When doing a search and the "Archived Posts" option is selected, I get this error after clicking the Search button:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
/beta/v33/search.asp, line 178"
That's most of what I have found so far. If it would be easier to post each individual bug in it's own topic, I'll just edit this post and do so.
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 30 May 2001 : 16:30:00
|
quote:
1. I get these errors when clicking on the "Display IP" link on a Topic or a Reply respectively:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'TOPICS'. Make sure it exists and that its name is spelled correctly.
/beta/v33/topic.asp, line 662"
Fixed in source code and on beta site,
strArchiveTablePrefix = strTablePrefix & "A_"
was only present in inc_top.asp and not in inc_top_short.asp
Pierre Join the Snitz WebRing |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 30 May 2001 : 16:36:32
|
quote:
2. When clicking on the Questions sign link in the Admin Options, I get this error:
"Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getMemberNumber'
/beta/v33/inc_top_short.asp, line 50"
Fixed in the source code and on the beta site. inc_functions.asp wasn't needed and thus not included in pop_config_help.asp Since this version the function getMemberNumber() in inc_functions.asp is called from within that page and so inc_functions.asp needed to be added as include file.
Pierre Join the Snitz WebRing |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 30 May 2001 : 16:50:36
|
quote:
3. When doing a search and the "Archived Posts" option is selected, I get this error after clicking the Search button:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
/beta/v33/search.asp, line 178"
Ehm..I think I fixed this one also, one strTablePrefix that needed to be replaced by a strActivePrefix..but I can't test that at the moment because it throws me a Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5c4 Thread 0x9b0 DBC 0x3070044 Jet'.
/beta/v33/inc_top.asp, line 51
That must be because I opened the database in FP to change the date of one of the topis (needed something archived to test the fix). I expect it to reset by itself in a while (minutes/hours ?), will check again tomorrow.
Pierre Join the Snitz WebRing |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 30 May 2001 : 19:51:06
|
So where is this beta?
====== Doug G ====== |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 30 May 2001 : 23:42:43
|
My pleaser Gor. I believe there is a bug with the Moderation, but since I'm still pretty new to it, i'm just testing it to make sure.
Doug, http://forum.snitz.com/beta/v33/
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 31 May 2001 : 00:57:00
|
It is back up again btw. Davio all members/posts were lost since I corrupted the database.
Pierre Join the Snitz WebRing |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 01 June 2001 : 09:33:44
|
quote:
quote:
2. When clicking on the Questions sign link in the Admin Options, I get this error:
"Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getMemberNumber'
/beta/v33/inc_top_short.asp, line 50"
Fixed in the source code and on the beta site. inc_functions.asp wasn't needed and thus not included in pop_config_help.asp Since this version the function getMemberNumber() in inc_functions.asp is called from within that page and so inc_functions.asp needed to be added as include file.
I changed the fix because getMemberNumber() was needed in more places and in those places it was the only function of inc_functions.asp needed. Instead of including the huge inc_functions.asp file I just added the getMemberNumber() function to inc_top.asp and in_top_short.asp
Pierre Join the Snitz WebRing |
|
|
|
Topic |
|