Discussion:
Need Help with SQL Syntax: Getting Msi API Error 80004005:
(too old to reply)
Vinay Agarwal
2005-10-11 15:42:09 UTC
Permalink
Hello,

I am trying to modify msi file to correct version numbers in the Upgrade
table. I tried "UPDATE" command but that doesn't work here. So, I deleted the
records in Upgrade table and trying to insert new records with the following
command but I get error.

Cscript WiRunSQL.vbs myprog.msi "INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')"

Msi API Error 80004005: OpenView,Sql
1: 2235 2: myprog.msi 3: UpgardeCode 4: INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')

I have tries many combinations but none seems to work. Please help.

Regards,
Vinay Agarwal
Adrian Accinelli
2005-10-11 16:48:09 UTC
Permalink
You spelt UpgradeCode wrong in your statement
`Upgrade`.`UpgardeCode` --->> `Upgrade`.`UpgradeCode`

Sincerely,
Adrian Accinelli
Post by Vinay Agarwal
Hello,
I am trying to modify msi file to correct version numbers in the Upgrade
table. I tried "UPDATE" command but that doesn't work here. So, I deleted the
records in Upgrade table and trying to insert new records with the following
command but I get error.
Cscript WiRunSQL.vbs myprog.msi "INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')"
Msi API Error 80004005: OpenView,Sql
1: 2235 2: myprog.msi 3: UpgardeCode 4: INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')
I have tries many combinations but none seems to work. Please help.
Regards,
Vinay Agarwal
Vinay Agarwal
2005-10-11 16:45:05 UTC
Permalink
Never mind--misspelled UpgradeCode to UpgardeCode
Regards,
Vinay Agarwal
Post by Vinay Agarwal
Hello,
I am trying to modify msi file to correct version numbers in the Upgrade
table. I tried "UPDATE" command but that doesn't work here. So, I deleted the
records in Upgrade table and trying to insert new records with the following
command but I get error.
Cscript WiRunSQL.vbs myprog.msi "INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')"
Msi API Error 80004005: OpenView,Sql
1: 2235 2: myprog.msi 3: UpgardeCode 4: INSERT INTO `Upgrade`
(`Upgrade`.`VersionMin`,`Upgrade`.`VersionMax`,`Upgrade`.`UpgardeCode`,`Upgrade`.`Attributes`,`Upgrade`.`ActionProperty`)
VALUES
('0.0.1','0.4.0','{544FD38F-3ECA-448F-A69A-F5BE64B037C1}',256,'PREVIOUSVERSIONSINSTALLED')
I have tries many combinations but none seems to work. Please help.
Regards,
Vinay Agarwal
Loading...