| Author |
 Topic  |
|
hondaxr
New Member
80 Posts |
 Posted - 11 July 2008 : 17:52:46
|
| One more question before I run the SQL statements; I don't see T_MESSAGE columns in my forum's FORUM_REPLY and FORUM_A_REPLY tables, only R_MESSAGE. Where do I find the T_MESSAGE columns?< |
 |
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
hondaxr
New Member
80 Posts |
Posted - 11 July 2008 : 18:02:01
|
Doh! Thanks bobby.
When I tried to change one of the table's parameters to nvarchar(max), I got this error:
'FORUM_A_REPLY' table
- Unable to modify table.
The transaction log for database 'Snitz_ForumDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases"
Does this look like something I can fix or will I need to notify my hosting company?
EDIT: The log_reuse_wait_desc column says nvarchar(60). Could this be why?< |
Edited by - hondaxr on 11 July 2008 18:07:15 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2008 : 18:35:38
|
Try the script like this, it won't require you to change the fields to nvarchar(max) prior to execution. Just execute it.
If the error about the log shows up, you need to contact the host:
UPDATE FORUM_REPLY SET R_MESSAGE=REPLACE(CONVERT(nvarchar(max),R_MESSAGE),'<hr height="1" noshade id="quote">','<hr height="2" noshade id="quote">')
UPDATE FORUM_A_REPLY SET R_MESSAGE=REPLACE(CONVERT(nvarchar(max),R_MESSAGE),'<hr height="1" noshade id="quote">','<hr height="2" noshade id="quote">');
UPDATE FORUM_TOPICS SET T_MESSAGE=REPLACE(CONVERT(nvarchar(max),T_MESSAGE),'<hr height="1" noshade id="quote">','<hr height="2" noshade id="quote">');
UPDATE FORUM_A_TOPICS SET T_MESSAGE=REPLACE(CONVERT(nvarchar(max),T_MESSAGE),'<hr height="1" noshade id="quote">','<hr height="2" noshade id="quote">');
< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
hondaxr
New Member
80 Posts |
Posted - 22 July 2008 : 17:12:20
|
| I'm still getting the same error with the script above. I've submitted a trouble ticket with my host to see if they can tell me what the problem is. Will post back.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
hondaxr
New Member
80 Posts |
Posted - 22 July 2008 : 18:09:55
|
They did, and it seems to work, but... I tried running a short test script on just some text that I posted and it did not change it but the SQL Query said "4775 row(s) affected."
I posted this in the forums: test123
And then ran this SQL Query:
UPDATE FORUM_REPLY SET R_MESSAGE=REPLACE(CONVERT(nvarchar(max),R_MESSAGE),'test123','test124')
UPDATE FORUM_A_REPLY SET R_MESSAGE=REPLACE(CONVERT(nvarchar(max),R_MESSAGE),'test123','test124');
UPDATE FORUM_TOPICS SET T_MESSAGE=REPLACE(CONVERT(nvarchar(max),T_MESSAGE),'test123','test124');
UPDATE FORUM_A_TOPICS SET T_MESSAGE=REPLACE(CONVERT(nvarchar(max),T_MESSAGE),'test123','test124'); What am I doing something wrong?< |
Edited by - hondaxr on 22 July 2008 18:11:03 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 July 2008 : 19:04:12
|
The statements work perfectly. The string to be replaced must be specified correctly, no leading or trailing spaces.
You will need to requery the data to see the effects of the statements.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 23 July 2008 : 13:28:40
|
I had this code for my quotes:
fString = doCode(fString, "[quote*]", "[/quote]", "<blockquote id=""quote""><font size=""" & strFooterFontSize & """ face=""" & strDefaultFontFace & """ id=""quote"">Quote:<hr size=""1"" noshade id=""quote"">", "<hr size=""1"" noshade id=""quote""></font id=""quote""></blockquote id=""quote"">")
Note: * added to [quote*] tag to parse code
and I have added an icon in front of the Quote: All works well and all nested quote replies work ok. I've used this code:
I had this code for my quotes:
fString = doCode(fString, "[quote*]", "[/quote]", "<blockquote id=""quote""><font size=""" & strFooterFontSize & """ face=""" & strDefaultFontFace & """ id=""quote""><img src=""icon_quote.gif"" align=""bottom"" style=""margin-bottom: -5px;""> Quote:<hr size=""1"" noshade id=""quote"">", "<hr size=""1"" noshade id=""quote""></font id=""quote""></blockquote id=""quote"">")
There is a problem when I reply quote to an older quote, ie when an old quote is nested in a new style with the icon.
This is the first quote:
This is the above quote reply in nesting old to new
This below is the new reply quotes new to new
Is there a quick way to remove the nesting incompatability?
< |
Edited by - Andy Humm on 23 July 2008 13:30:14 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
