| Author |
 Topic  |
|
i011877
Junior Member
Denmark
169 Posts |
 Posted - 19 November 2003 : 06:43:53
|
Hi there
I have a small problem with the edit reply function.
The editor opens, but the text I was suppose to edit is missing.
The same problem occours when I want to edit my profile. The profile is there but the 'signature'-field is blank, wich means that everytime I want to alter my profifle I have to retype my signature before pressing submit.
Very annoying.
The DB was originally running on an accesDB and then imported to SQL using DTS. Anything else seems to work but these 2 issues.
Any suggestions?
Thanx in advance. |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
i011877
Junior Member
Denmark
169 Posts |
Posted - 19 November 2003 : 07:26:02
|
Yes I have plenty of mods installed.
It is a serverhacker forum.
http://www.myforum.dk
user/pass:testuser |
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
i011877
Junior Member
Denmark
169 Posts |
Posted - 19 November 2003 : 07:44:43
|
Hahahaha..! True, sorry about that.
The move to SQL was done about a month ago.
Go to www.myforum.dk/default.asp and post a new subject called 'test', the try to edit it.
Thanx |
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 November 2003 : 09:45:29
|
| Ok, I've verified the issue. It seems to happen only with topics, replies are edited without problems. My guess is that this is a code issue, since the topic contents are ok. However, just to make sure it is indeed a code issue, can't you try the code with the Access DB again? Even in a test forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
rhagerma
Starting Member
USA
11 Posts |
Posted - 16 December 2003 : 00:47:38
|
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 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 December 2003 : 07:03:32
|
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.
Well, I have been helping someone with a similar issue and I have verified that with the same database, the SH code has this problem, but the base Snitz code does not. So this must be something in SH code.
Also this has never happened here, which confirms this is a code issue not a DB one. The table structure used at this forum is unchanged from a base snitz installation. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 16 December 2003 : 10:51:31
|
I two have had this problem with a customers site and have looked long and hard at the code to not find any answers. I installed a fresh serverhack forum and snitz forum to use on the existing database and snitz was able to edit the topic, but serverhack code was not. i might try today to just install a fresh version of server hack with a blank database to see what happens.
Do you think it would make a difference that the tables in MSSql are owned by dbo and are in lowercase instead of owned by the username and in caps? |
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets |
|
|
|
rhagerma
Starting Member
USA
11 Posts |
Posted - 16 December 2003 : 11:24:44
|
It could very well be the way SH SQL works. I had to do a lot of cusomization just to get things to work right. It appeared as though SH was written for MSAccess and not all the SQL was compatible with SQL Server 2000.
The code is relatively sloppy as well making it really hard to read through. Again though, the big difference is that when you create a forum from Snitz using the install script, it sets it up correctly. I'd be curious to see what your database looks like as far as dbo.forum_topic.t_message What is the data type you have? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 December 2003 : 11:31:55
|
quote:
Originally posted by redbrad0
Do you think it would make a difference that the tables in MSSql are owned by dbo and are in lowercase instead of owned by the username and in caps?
No, I don't think it would make any difference. If it would, Snitz would be affected too, since the database user is the same. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 December 2003 : 11:33:33
|
| Brad, I will have a look today, when I get home at differences between Snitz and SH in topic.asp. As I don't have SH code I will download the copy of topic.asp in that site of yours, if you don't mind, ok? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 16 December 2003 : 12:04:35
|
I actually started another topic on this HERE and also posted a topic at shnforums.com about this issue on his code.
Here is a picture of the SQL Server Database for topics of the ServerHack forum
I just noticed that with standard Snitz Forums the T_MESSAGE is set to ntext where server hack is just set to text. I will try this out and see if it works. |
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
jeepgen
New Member
Italy
73 Posts |
Posted - 16 December 2003 : 13:11:31
|
| by the way the my sql versione edit the topic correctly.. |
 |
|
|
|
Topic |
|
Topic Locked
