Author |
Topic  |
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
i011877
Junior Member
 
Denmark
169 Posts |
Posted - 28 January 2004 : 19:15:56
|
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? |
 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 28 January 2004 : 19:30:25
|
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 |
 |
|
i011877
Junior Member
 
Denmark
169 Posts |
Posted - 28 January 2004 : 19:41:15
|
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! |
 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 28 January 2004 : 19:45:16
|
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 |
 |
|
i011877
Junior Member
 
Denmark
169 Posts |
Posted - 28 January 2004 : 19:54:37
|
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 |
 |
|
i011877
Junior Member
 
Denmark
169 Posts |
Posted - 28 January 2004 : 20:10:26
|
Sorry! Problem solved. High five to all at Snitz. |
 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
Topic  |
|