Sign in

Microsoft.com

Microsoft

Remove From My Forums

T-SQL Forum Editor is Broken

Question
0

Sign in to vote
It does all kind of weird things. Like posts appearing in html.

Tool bar missing when editing. Stays in html.

Urgent.

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
- Edited by Kalman Toth Saturday, October 6, 2012 9:06 PM
Tuesday, February 7, 2012 12:13 AM

Reply

|

Quote

Answers

Sign in to vote

Sign in to vote

We had an update today which included new editor bits. It's probable that there is a time frame where there was indeed some issues.

select dg.[Name] urlname, dg.DiscussiongroupTypeID, dg.searchdefaultbrandid, dg.archived, dg.islocked, count (ur.roleid) ModeratorsAdmins 
from ForumsUsers.dbo.UserRole ur right  JOIN
ForumsShard.dbo.DiscussionGroup dg
ON ur.entityid  = dg.discussiongroupid
--where ur.roleid = '3'
where dg.Archived = 0
group by dg.[Name], dg.searchdefaultbrandid, dg.archived, dg.islocked, dg.DiscussiongroupTypeID, ur.roleid
order by ModeratorsAdmins

Community Forums Program Manager

Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, February 7, 2012 7:06 PM
Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, February 16, 2012 7:57 PM

Tuesday, February 7, 2012 1:29 AM

Answerer

1

Sign in to vote
Try dumping your cache Heslacher. The icons for html and code are in fact different. They are different actions that have different icons.
Community Forums Program Manager
- Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, February 16, 2012 7:56 PM
Tuesday, February 7, 2012 5:24 PM

Reply

|

Quote

Answerer

All replies

Sign in to vote

Sign in to vote

We had an update today which included new editor bits. It's probable that there is a time frame where there was indeed some issues.

select dg.[Name] urlname, dg.DiscussiongroupTypeID, dg.searchdefaultbrandid, dg.archived, dg.islocked, count (ur.roleid) ModeratorsAdmins 
from ForumsUsers.dbo.UserRole ur right  JOIN
ForumsShard.dbo.DiscussionGroup dg
ON ur.entityid  = dg.discussiongroupid
--where ur.roleid = '3'
where dg.Archived = 0
group by dg.[Name], dg.searchdefaultbrandid, dg.archived, dg.islocked, dg.DiscussiongroupTypeID, ur.roleid
order by ModeratorsAdmins

Community Forums Program Manager

Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, February 7, 2012 7:06 PM
Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, February 16, 2012 7:57 PM

Tuesday, February 7, 2012 1:29 AM

Answerer

1

Sign in to vote

Seems to be working ok for me. Is this still a problem? What browser are you using? Can you dump cache see if that helps?
Community Forums Program Manager

Tuesday, February 7, 2012 1:29 AM

Reply

|

Quote

Answerer
1

Sign in to vote

It is badly broken. Colors are incorrect, line breaks are removed, etc. See the sample

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e96eccc3-e651-41fa-8145-4c5c70456310
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

Tuesday, February 7, 2012 4:07 AM

Reply

|

Quote
1

Sign in to vote
I looked at that example, it has line breaks. Where did you intend the line breaks to be? Can you mark it up in html and post it to the sample I just made at http://social.msdn.microsoft.com/Forums/en-US/msdnsandbox/thread/6c67ea03-e108-4643-ab93-f4bb41be8088 ? I purposely took the sql above and removed line breaks and that's what I used.

THe colors will be different, we are using the prettify colorizer now.

I do see the line breaks are removed in 'preview' window...is that what you are talking about?

Community Forums Program Manager
- Edited by Brent SerbusEditor Tuesday, February 7, 2012 5:04 AM edit
Tuesday, February 7, 2012 5:03 AM

Reply

|

Quote

Answerer
1

Sign in to vote
At this time it works OK for me to post and edit.
Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, February 7, 2012 7:06 PM
Tuesday, February 7, 2012 5:52 AM

Reply

|

Quote
1

Sign in to vote

I should also mention that this is really the v.1 of this thing. The good news is that we have a lot more control over the code and editor, able to update to current versions etc. So Things should only get better going forward. Thanks for the note Kalman.
Community Forums Program Manager

Tuesday, February 7, 2012 6:45 AM

Reply

|

Quote

Answerer
0

Sign in to vote
Brent,

I noticed the following: it is showing a question mark and check mark on a thread with multiple answers "How to add trailing....":

http://social.msdn.microsoft.com/Forums/en/transactsql/threads?page=12

The following is answered and shows a question mark:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/1c784da3-887b-4ee7-b4fe-3b01c1df71dc

Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES
- Edited by Kalman Toth Tuesday, February 7, 2012 2:12 PM
Tuesday, February 7, 2012 7:08 AM

Reply

|

Quote
0

Sign in to vote

Brent,

at least you need to change the icon either for Insert Html or Insert Code Block. The usability of same icons for different action is bad.
Hannes

If you have got questions about this, just ask.

In a perfect world,
users would never enter data in the wrong form,
files they choose to open would always exist
and code would never have bugs.

C# to VB.NET: http://www.developerfusion.com/tools/convert/csharp-to-vb/

Tuesday, February 7, 2012 7:42 AM

Reply

|

Quote
0

Sign in to vote

I just tried updating it by removing the code block and re-posting, but the colors are still messed up

<p>Try</p><pre class="prettyprint lang-sql">TanggalBerubah>=dateadd(day, datediff(day,'19000101',CURRENT_TIMESTAMP), '19000101')

and TanggalBerubah < dateadd(day, 1+ datediff(day,'19000101',CURRENT_TIMESTAMP), '19000101') </pre><hr /><span style="color:blue;">For every expert, there is an equal and opposite expert. - Becker's Law
<br />
<br />
<br />
<strong><a href="http://blogs.lessthandot.com/index.php/All/?disp=authdir&author=218">My blog</a></strong></span>
<p></p><p></p><p></p><br /><br />

------------------------

The line break I had to manually insert two times, because otherwise it was posted as one long line.

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

Tuesday, February 7, 2012 2:23 PM

Reply

|

Quote
1

Sign in to vote

Kalman,

This problem was reported yesterday in another thread. Perhaps you identified the reason correctly - as soon as the thread has more than 1 answer it now loses the green mark.
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

Tuesday, February 7, 2012 2:25 PM

Reply

|

Quote
0

Sign in to vote
This is an oldie. It was fixed once, it is back.

When I edit a quote, I am stuck in it.

I have to go in to html, add "<p> </p>" as last row to bail myself out into the white area of the edit space.

I figured out what is bug. It inserts <p></p>before </blockquote> instead of after.

</blockquote><p></p>

Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES
- Edited by Kalman Toth Wednesday, February 8, 2012 1:27 PM
Tuesday, February 7, 2012 2:34 PM

Reply

|

Quote
0

Sign in to vote

Another sample of bad coloring

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/bfae097b-e1de-429b-8b22-f6db226feda8

In this thread, it's hard to follow the code because of the bad colors.

Also, another problem I noticed - if I post a link, I don't have ability to continue typing, it looks like the Editor stops and I had to either add <p> in HTML mode or somehow force a new line.
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

Tuesday, February 7, 2012 3:16 PM

Reply

|

Quote
0

Sign in to vote

Also, another problem I noticed - if I post a link, I don't have ability to continue typing, it looks like the Editor stops and I had to either add <p> in HTML mode or somehow force a new line.

It happened to me also a few times.
Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES

Tuesday, February 7, 2012 3:39 PM

Reply

|

Quote
0

Sign in to vote
Another sample of bad colors

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/5fb0c669-4f50-4dc0-8e4a-23c0cdacb2ec

I think it may have something to do with my usual way of writing code. I usually start to write code in the plain answer mode, then I switch to insert code mode. Using this algorithm seems to mess the colors.

For every expert, there is an equal and opposite expert. - Becker's Law

My blog
- Edited by Naomi N Tuesday, February 7, 2012 3:42 PM
Tuesday, February 7, 2012 3:42 PM

Reply

|

Quote
0

Sign in to vote
And yet another sample of the code all in one line (not to mention bad colors)

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c9b565af-abf6-4e0c-b210-f812cb9b7eb3

and another one

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/8e654d9d-561a-4e0c-9975-ea7560d044a7

For every expert, there is an equal and opposite expert. - Becker's Law

My blog
- Edited by Naomi N Tuesday, February 7, 2012 4:41 PM
Tuesday, February 7, 2012 4:03 PM

Reply

|

Quote
1

Sign in to vote
Try dumping your cache Heslacher. The icons for html and code are in fact different. They are different actions that have different icons.
Community Forums Program Manager
- Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, February 16, 2012 7:56 PM
Tuesday, February 7, 2012 5:24 PM

Reply

|

Quote

Answerer
0

Sign in to vote

Just did and you are absolutely right.

Thanks
Hannes

If you have got questions about this, just ask.

In a perfect world,
users would never enter data in the wrong form,
files they choose to open would always exist
and code would never have bugs.

C# to VB.NET: http://www.developerfusion.com/tools/convert/csharp-to-vb/

Tuesday, February 7, 2012 5:37 PM

Reply

|

Quote