Page 1 of 1

HM10044: Error while executing SQL Statement

Posted: 2015-04-03 09:17
by funcoolio
Hello,
i am trying to upgrade from HMS 5.5.2-B2129 to 5.6.2-B2234 (but the error comes out whenever i try to upgrade from 5.5.2-B2129 to 5.6.x) when the installer starts to upgrade the database it fires up the following error:

update hm_settings set settingstring = '..........' where settingname = 'sslcipherlist' and settingstring='';
microsoft ole db provider for sql server
invalid column name 'settingname'

'........' contains a string which is too hard to rport here.

i've checked the database; there is the hm_settings table and there is the column settingname.
any idea?

HMS is running on a w2k8 box 64 bit
DB is MSSQL 2005 on a different box w2k8 64bit
both of them are virtual

Re: HM10044: Error while executing SQL Statement

Posted: 2015-04-03 13:10
by martin
That sounds really odd. Can you check if the case is the same - is the column name in lowercase as well?

You can run the script manually using SQL Server Management Studio as well, but it should not be any issue running it as a part of the upgrade.

Re: HM10044: Error while executing SQL Statement

Posted: 2015-04-03 13:43
by funcoolio
i am sorry i didn't write all the senteces in their proper case

this is the table definition:

USE [hmailsrv]
GO
/****** Object: Table [dbo].[hm_settings]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[hm_settings](
[settingid] [int] IDENTITY(1,1) NOT NULL,
[settingname] [nvarchar](30) NOT NULL,
[settingstring] [nvarchar](4000) NOT NULL,
[settinginteger] [int] NOT NULL,
CONSTRAINT [hm_settings_pk] PRIMARY KEY NONCLUSTERED
(
[settingid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [u_settingname] UNIQUE NONCLUSTERED
(
[settingname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

this is the error:
Image

the error reports filed names with capital letters but afaik sql do not have problem on fields name written in different cases

Re: HM10044: Error while executing SQL Statement

Posted: 2015-04-03 14:04
by SorenR
From what I can see then case sensitivity depend on the collate used...

MySQL is different from MSSQL, here it depends on the OS :roll:

Anyways... Try this: "SELECT CASE WHEN 'A' = 'a' THEN 'NOT CASE SENSITIVE' ELSE 'CASE SENSITIVE' END" :|

Re: HM10044: Error while executing SQL Statement

Posted: 2015-04-07 12:45
by funcoolio
SorenR wrote:From what I can see then case sensitivity depend on the collate used...

MySQL is different from MSSQL, here it depends on the OS :roll:

Anyways... Try this: "SELECT CASE WHEN 'A' = 'a' THEN 'NOT CASE SENSITIVE' ELSE 'CASE SENSITIVE' END" :|
Thank you SorenR, you opened my mind, i solved the problem by changing the database collation.