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
 No text when editing a subject
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 December 2003 :  16:55:32  Show Profile  Send ruirib a Yahoo! Message
The fix for this is to move the T_MESSAGE field so that it becomes the last field in the SELECT clause of the SQL statement that retrieves the topic info.


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

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  19:15:56  Show Profile  Visit i011877's Homepage
quote:
Originally posted by rhagerma

Greetings all

The problem with topics and SQL Server is that the field in forum_topics (t_message) is ntext. ADODB does not work well with text or ntext. I converted the field on my Server Hacker forum to varchar(8000) and all works well.
Regards,

Ron Hagerman
http://www.rons-sandbox.com

The above seems to work quite well! Thanx a million!
I still have a problem with the 'disappearing signature' when editing my (or others) profile.
Short : The signature is gone, and you have to type your signature all over if you wish to alter anything in the profile.

There, I spelled it out

Any suggestions?


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  19:30:25  Show Profile  Send ruirib a Yahoo! Message
If you want to use unicode characters in your database, I wouldn't recommend the change. In fact, this fix does not solve the issue, it merely avoids it. Changing the order of the fields in the SQL statement does fix it without changes to the Db.


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

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  19:41:15  Show Profile  Visit i011877's Homepage
Eeeeh this is the signature-problem I am dealing with..!!
Which column in what table are we talking about, to solve the 'missing signature' -problem?

Thanx for the support!


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  19:45:16  Show Profile  Send ruirib a Yahoo! Message
I would guess that it is the same problem, the solution should be the same, but I don't run SH forum and I don't know the code.


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 28 January 2004 19:46:51
Go to Top of Page

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  19:54:37  Show Profile  Visit i011877's Homepage
Sorry! I'm a little lost here.

The T_MESSAGE problem was solved in the FORUM_TOPICS table, but what about the signature?
It must be another statement in another table.

Could you spell it out please?



Edited by - i011877 on 28 January 2004 20:10:45
Go to Top of Page

i011877
Junior Member

Denmark
169 Posts

Posted - 28 January 2004 :  20:10:26  Show Profile  Visit i011877's Homepage
Sorry! Problem solved.
High five to all at Snitz.


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 January 2004 :  20:21:33  Show Profile  Send ruirib a Yahoo! Message
Glad that we can be of help.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous 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.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07