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: General / Classic ASP versions(v3.4.XX)
 Problems setting up new forum
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

zakazn
New Member

58 Posts

Posted - 24 February 2010 :  16:31:12  Show Profile
Thank you
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 24 February 2010 :  16:34:22  Show Profile  Send ruirib a Yahoo! Message
Can't understand it. I am using MySQL 5.1.40 and all is working for me. Can you try and restart IIS and see if it fixes it?


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

zakazn
New Member

58 Posts

Posted - 24 February 2010 :  16:47:32  Show Profile
The IIS runs 100's of websites - I can get them to restart the specific website in IIS, but this will be tomorrow now when staff are back in the office. I will let you know what happens.
Go to Top of Page

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  04:23:14  Show Profile
The website server has been restarted and the errors are still showing. I have also found (even with the sigs turned off) that I cannot edit a current post. I get the error:-

Note: Only the poster of this message, and the Moderator can edit the message.

Microsoft VBScript runtime error '800a000d'

Type mismatch

/forum/inc_func_posting.asp, line 89

and this is the code from line 89

if fString = "" or IsNull(fstring) then
Go to Top of Page

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  04:42:50  Show Profile
OK, We have fixed the new edit error, but the original errors as yesterday (with sigs turned on) are still present.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 February 2010 :  06:28:51  Show Profile  Send ruirib a Yahoo! Message
I honestly don't know what could be causing that. Try and run this statement and see if it helps:

UPDATE FORUM_MEMBERS SET M_SIG=''


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

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  07:33:15  Show Profile
Sorry to be a bit dim, but how do I run the statement?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 February 2010 :  09:25:54  Show Profile  Send ruirib a Yahoo! Message
phpmyadmin or the tool you used to connect to the database.


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

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  09:53:23  Show Profile
I don't know what that did, but it seems to be working now. Thank you so much.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 February 2010 :  09:59:45  Show Profile  Send ruirib a Yahoo! Message
It just assigned an empty string value to all sigs. Not sure why the nulls should create issues. You'd better change the column to accept a null string as the default value.


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

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  10:29:28  Show Profile
I've done that.

Now whenever I edit a post it is just showing ????. And if I add a sig into the profile, that just shows as ???? too!?

Any ideas?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 February 2010 :  10:57:43  Show Profile  Send ruirib a Yahoo! Message
Sorry I meant you should set the column default value to an empty string, not a null one. Empty strings are defined just as I did before: ''.


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

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  11:04:37  Show Profile
I can't change the default value - this is the message I get when trying:-

BLOB/TEXT column 'M_SIG' can't have a default value
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 February 2010 :  11:35:47  Show Profile  Send ruirib a Yahoo! Message
Yeah, seems so.

Not sure if Snitz will add something as sig, when you create a new user. Want to create a new user and try to post as him, to see if the issue shows up again?


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

zakazn
New Member

58 Posts

Posted - 25 February 2010 :  11:43:18  Show Profile
OK, I tried to create a new user. And as I have set for administrator to authorise went to do this and on clicking 'activate account' I got this error:-
Microsoft VBScript runtime error '800a000e'

Out of string space: 'Trim'

/forum/inc_func_common.asp, line 287

The line 287 shows this code:-

fString = trim(pString)
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07