[Bug 29413] New: Acronis True Image 11 Home installer: custom action returns with invalid SQL syntax error (empty column name in select expression)
http://bugs.winehq.org/show_bug.cgi?id=29413
Bug #: 29413 Summary: Acronis True Image 11 Home installer: custom action returns with invalid SQL syntax error (empty column name in select expression) Product: Wine Version: 1.3.35 Platform: x86 OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: msi AssignedTo: wine-bugs@winehq.org ReportedBy: focht@gmx.net Classification: Unclassified
Hello,
while investigating bug 17212 I found another issue - though seems non-critical to overall install process.
Actually I'm not sure if it's valid but here you go...
The console spits out:
--- snip --- err:msi:custom_get_thread_return Invalid Return Code 1615 --- snip ---
This happens in "IsAllUsersPageEnabledCA" custom action.
The first "select distinct" query is executed successfully:
--- snip --- ... 0025:trace:msi:ACTION_CustomAction Handling custom action L"IsAllUsersPageEnabledCA" (1 L"CustomActionDLL" L"IsAllUsersPageEnabled") 0025:trace:msi:HANDLE_CustomType1 Calling function L"IsAllUsersPageEnabled" from L"C:\users\focht\Temp\msi5572.tmp" ... 002d:trace:msi:ACTION_CallDllFunction calling L"IsAllUsersPageEnabled" ... 002d:trace:msi:MsiGetActiveDatabase (1) 002d:trace:msi:alloc_msihandle 0x18bb68 -> 3 002d:trace:msi:alloc_msi_remote_handle 0x1182848 -> 4 002d:Ret msi.MsiGetActiveDatabase() retval=00000004 ret=01c136c4 002d:Call msi.MsiDatabaseOpenViewW(00000004,01c55270 L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Component`, `Directory` where `Component`.`Directory_` = `Directory`.`Directory`",01bfe7f0) ret=01c147ed 002d:trace:msi:MsiDatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Component`, `Directory` where `Component`.`Directory_` = `Directory`.`Directory`" 0x1bfe7f0 002d:trace:msi:MsiDatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Component`, `Directory` where `Component`.`Directory_` = `Directory`.`Directory`" 0x1bfe7f0 002d:trace:msi:MSI_DatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Component`, `Directory` where `Component`.`Directory_` = `Directory`.`Directory`" 0x1bfe604 ... 002d:trace:msidb:DISTINCT_CreateView (nil) ... 002d:trace:msi:MSI_ParseSQL Parse returned 0 002d:trace:msi:alloc_msihandle 0x11fac30 -> 5 002d:Ret msi.MsiDatabaseOpenViewW() retval=00000000 ret=01c147ed ... 002d:trace:msidb:DISTINCT_execute 0x12108c0 (nil) ... 002d:trace:msidb:DISTINCT_execute Row 69 -> 329 ... 002d:Ret msi.MsiViewExecute() retval=00000000 ret=01c13c44 ... --- snip ---
shortly after, another SQL query is done:
--- snip --- 002d:Call msi.MsiDatabaseOpenViewW(00000004,01c54f78 L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? ",01bfe774) ret=01c147ed 002d:trace:msi:MsiDatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? " 0x1bfe774 002d:trace:msi:MsiDatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? " 0x1bfe774 002d:trace:msi:MSI_DatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? " 0x1bfe594 .. 002d:trace:msi:MSI_ParseSQL Parse returned 1 ... 002d:trace:msi:msiobj_release object 0x11fac30 destroyed 002d:Ret msi.MsiDatabaseOpenViewW() retval=0000064f ret=01c147ed 002d:Call ntdll.RtlAllocateHeap(01c72000,00000000,00000100) ret=01c40d7f 002d:Ret ntdll.RtlAllocateHeap() retval=01c76a28 ret=01c40d7f 002d:Call KERNEL32.RaiseException(e06d7363,00000001,00000003,01bfe6ac) ret=01c409c6 002d:trace:seh:raise_exception code=e06d7363 flags=1 addr=0x7b838b5b ip=7b838b5b tid=002d 002d:trace:seh:raise_exception info[0]=19930520 002d:trace:seh:raise_exception info[1]=01bfe714 002d:trace:seh:raise_exception info[2]=01c5f8fc 002d:trace:seh:raise_exception eax=7b826171 ebx=7b8a97a8 ecx=19930520 edx=01bfe5b4 esi=01bfe690 edi=01bfe610 002d:trace:seh:raise_exception ebp=01bfe5f8 esp=01bfe594 cs=0023 ds=002b es=002b fs=0063 gs=006b flags=00000203 ... 002d:trace:msi:DllThread custom action (2d) returned 1615 --- snip ---
-> invalid SQL syntax.
The SQL query is hard coded into msi package:
--- snip --- $ strings -e l AcronisTrueImage.msi | grep 'distinct' select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Shortcut`, `Directory`, `Component` where `Shortcut`.`Directory_` = `Directory`.`Directory` and `Component`.`Component` = `Shortcut`.`Component_` select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, `Component`.`Condition` from `Component`, `Directory` where `Component`.`Directory_` = `Directory`.`Directory` --- snip ---
It's probably the empty column name ", ''" in select expression. Maybe someone knowledgeable in SQL query language can shed a light on this if this is allowed or the failure is expected.
$ sha1sum TrueImage11.8053_s_en.exe 61e8ad32e4fc05ceeb6a125f2c026323a73db032 TrueImage11.8053_s_en.exe
$ wine --version wine-1.3.35-117-g27e3e1a
Regards
http://bugs.winehq.org/show_bug.cgi?id=29413
--- Comment #1 from Austin English austinenglish@gmail.com 2011-12-23 15:07:28 CST --- http://source.winehq.org/git/wine.git/commitdiff/ca49aae61ec31b8f26ce8b3e0b9...
http://bugs.winehq.org/show_bug.cgi?id=29413
Anastasius Focht focht@gmx.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Fixed by SHA1| |ca49aae61ec31b8f26ce8b3e0b9 | |317a312819940 Status|NEW |RESOLVED Resolution| |FIXED
--- Comment #2 from Anastasius Focht focht@gmx.net 2011-12-27 05:08:42 CST --- Hello,
thanks Hans for the quick response and fix.
--- snip --- 002f:trace:msi:MSI_DatabaseOpenViewW L"select distinct `Directory`.`Directory`, `Directory`.`Directory_Parent`, '' from `Directory` where `Directory`.`Directory` = ? " 0x148e610 002f:trace:msidb:WHERE_CreateView (L"Directory") 002f:trace:msidb:TABLE_CreateView 0x17bb38 L"Directory" 0x11c270c 002f:trace:msidb:TABLE_CreateView table 0x1ab600 found with 3 columns 002f:trace:msidb:TABLE_CreateView L"Directory" one row is 9 bytes 002f:trace:msidb:TABLE_get_dimensions 0x11a9738 (nil) 0x11c2710 002f:trace:msidb:TABLE_get_column_info 0x11a9738 1 (nil) (nil) 002f:trace:msidb:TABLE_get_column_info 0x11a9738 1 0x148db60 0x148db9c 002f:trace:msidb:SELECT_CreateView (nil) 002f:trace:msidb:SELECT_AddColumn 0x11a9788 adding L"Directory".L"Directory" 002f:trace:msidb:WHERE_get_dimensions 0x11a96e8 (nil) 0x148db74 002f:trace:msidb:WHERE_get_column_info 0x11a96e8 1 0x148db7c (nil) (nil) 0x148db78 002f:trace:msidb:TABLE_get_column_info 0x11a9738 1 0x148db7c (nil) 002f:trace:msidb:SELECT_AddColumn Translating column L"Directory" from 0 -> 1 002f:trace:msidb:SELECT_AddColumn 0x11a9788 adding L"Directory".L"Directory_Parent" 002f:trace:msidb:WHERE_get_dimensions 0x11a96e8 (nil) 0x148db74 002f:trace:msidb:WHERE_get_column_info 0x11a96e8 1 0x148db7c (nil) (nil) 0x148db78 002f:trace:msidb:TABLE_get_column_info 0x11a9738 1 0x148db7c (nil) 002f:trace:msidb:WHERE_get_column_info 0x11a96e8 2 0x148db7c (nil) (nil) 0x148db78 002f:trace:msidb:TABLE_get_column_info 0x11a9738 2 0x148db7c (nil) 002f:trace:msidb:SELECT_AddColumn Translating column L"Directory_Parent" from 1 -> 2 002f:trace:msidb:SELECT_AddColumn 0x11a9788 adding (null).L"" 002f:trace:msidb:SELECT_AddColumn Translating column L"" from 2 -> 0 002f:trace:msidb:DISTINCT_CreateView (nil) 002f:trace:msidb:SELECT_get_dimensions 0x11a9788 (nil) 0x148dc20 002f:trace:msidb:WHERE_get_dimensions 0x11a96e8 (nil) (nil) 002f:trace:msi:MSI_ParseSQL Parse returned 0 ... --- snip ---
$ wine --version wine-1.3.35-168-g5b93bb9
Regards
http://bugs.winehq.org/show_bug.cgi?id=29413
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #3 from Alexandre Julliard julliard@winehq.org 2011-12-30 12:57:48 CST --- Closing bugs fixed in 1.3.36.
http://bugs.winehq.org/show_bug.cgi?id=29413
Anastasius Focht focht@gmx.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |Installer
https://bugs.winehq.org/show_bug.cgi?id=29413
Anastasius Focht focht@gmx.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |download URL| |https://web.archive.org/web | |/20210320213415/http://pub. | |agrarix.net/Windows/Acronis | |TrueImage/TrueImage11_d_en. | |exe
-
wine-bugs＠winehq.org -
WineHQ Bugzilla