http://bugs.winehq.org/show_bug.cgi?id=11480
Summary: db: Parsing select * _ForceCodepage fails Product: Wine Version: CVS/GIT Platform: Other OS/Version: other Status: UNCONFIRMED Severity: enhancement Priority: P2 Component: msi AssignedTo: wine-bugs@winehq.org ReportedBy: jdahlin@async.com.br
This might be related to not using quotes around identifiers. Trace:
trace:msi:MSI_DatabaseOpenViewW L"select * from _ForceCodepage" 0x33f878 trace:msi:MSI_ParseSQL Parse returned 1
To reproduce, do the following: cd /tmp wget http://ufpr.dl.sourceforge.net/sourceforge/msi2xml/msi2xml-2.2.1.957-bin.zip unzip msi2xml-2.2.1.957-bin.zip wget http://ufpr.dl.sourceforge.net/sourceforge/msi2xml/msi2xml-2.2.1.957.msi wine msi2xml.exe msi2xml-2.2.1.957.msi
msi2xml.exe also requires msixml6, which can be downloaded from http://download.microsoft.com/download/2/e/0/2e01308a-e17f-4bf9-bf48-161356c... It can be installed using msiexec /i.
http://bugs.winehq.org/show_bug.cgi?id=11480
James Hawkins truiken@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever Confirmed|0 |1 Keywords| |download Summary|db: Parsing select * |msi2xml fails to convert an |_ForceCodepage fails |msi file to xml
--- Comment #1 from James Hawkins truiken@gmail.com 2008-02-08 22:53:25 --- Please stop guessing at what the bug is. The problem is in MsiDatabaseExport, not the handling or SQL queries. "select * from table" (lack of back quotes) is not valid in Windows either.
http://bugs.winehq.org/show_bug.cgi?id=11480
Johan Dahlin jdahlin@async.com.br changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED
--- Comment #2 from Johan Dahlin jdahlin@async.com.br 2008-02-11 16:01:40 --- This is fixed in latest git. Thanks James!
http://bugs.winehq.org/show_bug.cgi?id=11480
Johan Dahlin jdahlin@async.com.br changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED |
--- Comment #3 from Johan Dahlin jdahlin@async.com.br 2008-02-11 16:06:30 --- Sorry, the problem in comment 1 is now fixed, but the bug still fails. Let me know if I should file a new bug for each issue I can find.
The next problem encountered is the following:
trace:msi:MsiDatabaseOpenViewW L"SELECT * FROM `_Streams`" 0x33fa6c trace:msi:MSI_DatabaseOpenViewW L"SELECT * FROM `_Streams`" 0x33fa00 trace:msi:MSI_ParseSQL Parse returned 0 trace:msi:alloc_msihandle 0x18fe20 -> 3 trace:msi:MsiViewExecute 3 0 trace:msi:MSI_ViewExecute 0x18fe20 (nil) trace:msi:MsiViewGetColumnInfo 3 1 0x33faac trace:msi:msi_set_record_type_string type 083e -> L"s62" trace:msi:msi_set_record_type_string type 1900 -> L"V0" trace:msi:alloc_msihandle 0x14fdc8 -> 4 trace:msi:MsiViewFetch 3 0x33fa60 trace:msi:MSI_ViewFetch 0x18fe20 0x33fa04 trace:msi:msi_view_get_row 0x13dd88 0x191b68 0 0x33fa04 err:msi:msi_view_get_row Invalid type!
http://bugs.winehq.org/show_bug.cgi?id=11480
James Hawkins truiken@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |FIXED
--- Comment #4 from James Hawkins truiken@gmail.com 2008-02-12 20:24:00 --- err's and fixme's are not bugs. This bug is fixed.
http://bugs.winehq.org/show_bug.cgi?id=11480
--- Comment #5 from Austin English austinenglish@gmail.com 2008-02-16 20:04:43 --- (In reply to comment #3)
Sorry, the problem in comment 1 is now fixed, but the bug still fails. Let me know if I should file a new bug for each issue I can find.
The next problem encountered is the following:
trace:msi:MsiDatabaseOpenViewW L"SELECT * FROM `_Streams`" 0x33fa6c trace:msi:MSI_DatabaseOpenViewW L"SELECT * FROM `_Streams`" 0x33fa00 trace:msi:MSI_ParseSQL Parse returned 0 trace:msi:alloc_msihandle 0x18fe20 -> 3 trace:msi:MsiViewExecute 3 0 trace:msi:MSI_ViewExecute 0x18fe20 (nil) trace:msi:MsiViewGetColumnInfo 3 1 0x33faac trace:msi:msi_set_record_type_string type 083e -> L"s62" trace:msi:msi_set_record_type_string type 1900 -> L"V0" trace:msi:alloc_msihandle 0x14fdc8 -> 4 trace:msi:MsiViewFetch 3 0x33fa60 trace:msi:MSI_ViewFetch 0x18fe20 0x33fa04 trace:msi:msi_view_get_row 0x13dd88 0x191b68 0 0x33fa04 err:msi:msi_view_get_row Invalid type!
If you have an actual bug (not just warnings/fixme's) please file a separate bug for each issue.
http://bugs.winehq.org/show_bug.cgi?id=11480
Dan Kegel dank@kegel.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #6 from Dan Kegel dank@kegel.com 2008-02-22 11:40:14 --- 0.9.56 released, so closing all bugs marked as RESOLVED FIXED.
http://bugs.winehq.org/show_bug.cgi?id=11480
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Version|CVS/GIT |unspecified