cannot link image using HTML tag.

[jkp*74]

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)

[Beth]

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

[jkp*74]

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

[Beth]

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.

[jkp*74]

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...

[Beth]

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.

[jkp*74]

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)

[lbauer]

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.

[jkp*74]

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.

[Beth]

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.

[jkp*74]

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.

[Beth]

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.

[jkp*74]

Ok. Just send the email.

[Beth]

Got it. Thanks.
HS: 228748