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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Help with registering and logging in new users
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

UnderRated
Starting Member

Portugal
39 Posts

Posted - 07 July 2004 :  16:15:44  Show Profile  Visit UnderRated's Homepage
I just started using Snitz Forums and when I register a new user, if it is a normal user I get this error:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'cLng'

/talk/inc_func_common.asp, line 881

I I upgrade the user to Moderator, it logs in ok but I see no forum tables and above the forum header is this message:

Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cLng'

/talk/inc_func_secure.asp, line 99

Only if I upgrade the user to Administrator I have no errors at all.

Can someone help me solve this problem, please?

Tks

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 07 July 2004 :  16:41:35  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Any mods installed?
What version of snitz are you using?
Could it be that you upgraded from Access to MSSQL?

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 07 July 2004 :  16:53:26  Show Profile  Visit UnderRated's Homepage
My version is Snitz Forums 2000 Version 3.4.04 and I don't know if I have any MODs installed (how do I check?). My database was created with an SQL server not Access.
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 07 July 2004 :  17:10:17  Show Profile  Visit UnderRated's Homepage
Just playing with it and found out that the problem must be just with the registration cause if I log in as the forum admin and open the member profile, even without changing anything when I hit submit and then log in as the user I have no problem. Also at members page instead of error as the title it changes to Starting member. What could it be?
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 08 July 2004 :  05:22:58  Show Profile  Visit UnderRated's Homepage
I also noticed that after I creat a category in the forum when they log in they get this message:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'recForumCount'

/talk/default.asp, line 406

and cannot see the category.

Please someone help me solve this problem. TKS
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 July 2004 :  05:52:24  Show Profile  Send ruirib a Yahoo! Message
Do you have any forums created in your board?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 08 July 2004 :  06:34:14  Show Profile  Visit UnderRated's Homepage
No forums just a gategory. dose it make a diference?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 July 2004 :  14:20:05  Show Profile  Send ruirib a Yahoo! Message
It does. That's the problem. Create a forum and the problem will go away.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 08 July 2004 :  16:25:06  Show Profile  Visit UnderRated's Homepage
Now I get the message

Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cLng'

/talk/inc_func_secure.asp, line 99

I still get this message when a new registered user tries to log in

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'cLng'

/talk/inc_func_common.asp, line 881

And in the members list their title is error.

If I, as the forum administrator, edit their profile, even withoput changing anything, when I hit the submit button, the problem goes away. And in the members list, their title turns to Starting User.

Can you help me?

Here's the address for the forum
http://www.underratedteam.com/talk/login.asp
if you want to take a look. User name: test PWD: test

Tks
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 July 2004 :  18:18:23  Show Profile  Send ruirib a Yahoo! Message
Do you have any way to take a look at the F_PRIVATEFORUMS field in the FORUM_FORUM table? What value does it have?
If you can, take also a look at the definition of that field. Does it have 0 as a default value?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 09 July 2004 :  19:58:23  Show Profile  Visit UnderRated's Homepage
I just took a look at that field in the table. The value was empty and I changed it to 0 but nothing happened? Should I just delete the database and create a new one? How do I do that?
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts

Posted - 09 July 2004 :  20:43:18  Show Profile  Visit UnderRated's Homepage
Solved the problem! Forum work fine now. Just erased all the tables and created completly new ones. JOB DONE.
TKS for your help. VIVA PORTUGAL!
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 July 2004 :  21:34:19  Show Profile  Send ruirib a Yahoo! Message
Ok, glad to know that all is working now. Viva Portugal .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07