Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 BUGS (v3.3 beta): 3 bugs noted
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 May 2001 :  16:10:22  Show Profile
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  Show Profile  Visit gor's Homepage
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
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 30 May 2001 :  16:36:32  Show Profile  Visit gor's Homepage
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
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 30 May 2001 :  16:50:36  Show Profile  Visit gor's Homepage
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
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 30 May 2001 :  16:51:23  Show Profile  Visit gor's Homepage
Davio, thank you for these bugs

Pierre
Join the Snitz WebRing
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 30 May 2001 :  19:51:06  Show Profile
So where is this beta?

======
Doug G
======
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 May 2001 :  23:42:43  Show Profile
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/

Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 31 May 2001 :  00:57:00  Show Profile  Visit gor's Homepage
It is back up again btw.
Davio all members/posts were lost since I corrupted the database.

Pierre
Join the Snitz WebRing
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 01 June 2001 :  09:33:44  Show Profile  Visit gor's Homepage
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07