cannot link image using HTML tag.

If you are having a problem using Vault, post a message here.
Post Reply
jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

cannot link image using HTML tag.

Post by jkp*74 » Wed Mar 23, 2011 6:33 pm

I am trying to link an image by entering this in the comment field:
<img src="images\Projects\RND-023 - SOT\3-22-bin6full.jpg"/>
I have check on the use HTML check box.

The following error message appear after clicking the submit button:
"The following database error has occured: Procedure 'spaddmessage' expects parameter '@xmlkeywords', which was not supplied."

I am using Vault Pro 5.1.1 on Windows Server 2003, SQL Server 8.00.2039 - SP4 (Standard Edition)

Here is the log file:

Helpers::AddItemComment Procedure 'spaddmessage' expects parameter '@xmlkeywords', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at MantisSQLService.MantisSQLService.AddMessage(MantisSqlConn conn, Int32 nAuthUID, MantisItemComment mic, String strXmlKeywords, Int32 nAttDBBufSize, AddItemCommentNotifyParam& aicnParam) at MantisServiceAPI.MantisServiceAPI.AddItemComment(Int32 nAuthUID, MantisItemComment mic, Int32 nAttDBBufSize) at MantisServiceLib.Helpers.AddItemComment(HttpSessionState session, MantisItemComment mic)
Last edited by jkp*74 on Wed Mar 30, 2011 12:40 am, edited 1 time in total.
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot upload image using HTML tag.

Post by Beth » Thu Mar 24, 2011 10:27 am

The current version of Vault doesn't allow using comments for uploading attachments. If you creating a new work item, then there is a separate field for uploading an attachment. If the work item already exists, then there is an attachments tab towards the bottom of the page, by the comments tab, where you can add an attachment.

F: 14973
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot upload image using HTML tag.

Post by jkp*74 » Mon Mar 28, 2011 7:25 pm

I don't mean to 'upload' the image, just trying to show the image in the comment field by using the HTML tag. I stored the images somewhere else. This has been working fine when i am using Fortress 1.1
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot upload image using HTML tag.

Post by Beth » Tue Mar 29, 2011 12:55 pm

We ran a quick test here with just linking to an image, and we can make the link work, but we tested with an image from a website.

Try using either a full path or try a test using an image from the web. Then let me know your results.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot link image using HTML tag.

Post by jkp*74 » Wed Mar 30, 2011 12:49 am

It works when i update existing comment (using the same relative path). But when i put the same HTML tag in new comment, the error appear.
One more observation is that when i open other comments which already contain <img /> HTML tag, the image does not appear, only the HTML tag text. I have to click the Update button (the comment appear in editable form), and resubmit (click the update button), then only the image appear.
Could this due to the migration from Fortress 1.1 to Vault Pro 5.1.1?
Try using either a full path or try a test using an image from the web.
Not sure how to link image from other web site into the comment field... :|
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot link image using HTML tag.

Post by Beth » Wed Mar 30, 2011 7:38 am

Trying from the web would just have a web address such as http://some website/some path/some more path/myimage.jpg.

I don't know at this point if what you are seeing is due to the upgrade or not. I'll try a few more tests to reproduce what you are seeing. So that I use the same environment, could you open a Vault GUI client, login, then go to Help - Technical Support and copy the information from there to me? You don't need to include the license details at the bottom, just the client and server information.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot link image using HTML tag.

Post by jkp*74 » Fri Apr 08, 2011 1:09 am

Here goes:

Client Information
Vault Professional Client Version: 5.1.1.19216
.NET Framework Version: 2.0.50727.4005
Operating System: Microsoft Windows XP Professional
Service Pack: 2.0
OS Version: 5.1.2600
Total Physical Memory: 1.5 GB
Time Zone:

Server Information
Server Version: 5.1.1.19216
.NET Framework Version: 2.0.50727.3053
Operating System: Microsoft(R) Windows(R) Server 2003 for Small Business Server
Service Pack: 2.0
OS Version: 5.2.3790
Timezone: (GMT+08:00) Kuala Lumpur, Singapore
SQL Version: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Joel
Micro Modular System
http://www.mmsis.com

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: cannot link image using HTML tag.

Post by lbauer » Fri Apr 08, 2011 1:01 pm

I was able to reproduce this. The "Procedure 'spaddmessage' expects parameter '@xmlkeywords', which was not supplied" error was the same in Fortress 1.1.4 and VaultPro 5.1.1.

However in Fortress 1.1.4, clicking the "Edit Comment" icon and Update" made the image appear in the comment, but in VaultPro 5.1.1, the link was accepted, but the comment just displayed an image icon, not the image. I used an image path on the Vault Server machine, like

Code: Select all

<img src="C:\Vault\Myimage.jpg"/>
I've logged bug 15927 and we'll investigate this further.
Linda Bauer
SourceGear
Technical Support Manager

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot link image using HTML tag.

Post by jkp*74 » Mon Sep 02, 2013 8:49 pm

I just wonder is there any hot fix for this?
I am still using the same version as my company did not allocate budget to upgrade to new version. :roll:
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot link image using HTML tag.

Post by Beth » Tue Sep 03, 2013 4:13 pm

I tested this with Vault 5.1.2.

What I found is if I do one of the following the comment with image is added.
1) Add text in the subject and some text before the image, and make sure to click the link Use HTML.
2) Add the URL in without using the link Use HTML and submit the comment. Then go back and edit the comment and turn on the Use HTML.
3) Add the tags <html></html> around the <img scr=""/>


Scratch that idea. Bad idea and I was wrong about it.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot link image using HTML tag.

Post by jkp*74 » Wed Sep 25, 2013 12:56 am

One more observation is that when i open other comments which already contain <img /> HTML tag, the image does not appear, only the HTML tag text. I have to click the Update button (the comment appear in editable form), and resubmit (click the update button), then only the image appear.
It is this behavior that is causing some confusion when users do not see the images when they first browse to the item.

Steps to reproduce:
1. Login to Item Tracking.
2. Search an existing Item No in the search field.
3. Comments shows <img src="Images\Projects\NT-001 - Lens AVI\Production Counter Not Refresh.jpg"/>
4. Click Add a Comment tab
5. Click Comments tab
6. Image re-appear in the comments.
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot link image using HTML tag.

Post by Beth » Wed Sep 25, 2013 2:13 pm

This appears to be fixed in Vault 7, but don't currently have a fix for Vault 5 or 6.

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread? Then we can see about a few other options.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: cannot link image using HTML tag.

Post by jkp*74 » Thu Sep 26, 2013 6:12 am

Ok. Just send the email.
Joel
Micro Modular System
http://www.mmsis.com

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: cannot link image using HTML tag.

Post by Beth » Thu Sep 26, 2013 7:37 am

Got it. Thanks.
HS: 228748
Beth Kieler
SourceGear Technical Support

Post Reply