MySQL Bugs: #48156: Unable to export result set to CSV

Bug #48156	Unable to export result set to CSV
Submitted:	19 Oct 2009 16:40	Modified:	30 Oct 2009 17:24
Reporter:	philip antoniades	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.4	OS:	Linux (Fedora 11 amd64)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	csv, export, TTREV

Description:
Attempting to export result of SQL query to CSV gives the error:

Failed to open template file: `/usr/share/mysql-workbench/modules/data/sqlide/CSV.tpl`

This is on Fedora 11 AMD64 install, from RPM. 

The requested file was found in a different directory (/usr/share/mysql-workbench/sqlide/), and moving it to the required location solved the problem. 

How to repeat:
Execute a SQL query. 

Select Query->Export Results from the menu. 

Select CSV file type, current resultset (Results(1), in my case) and a file name. 

Suggested fix:
sudo cp -rp /usr/share/mysql-workbench/sqlide /usr/share/mysql-workbench/modules/data/

Not repeatable on Mac OS X. Looks Linux-specific.

On Ubuntu 9.10 64-bit I got a crash:

** (mysql-workbench-bin:3043): WARNING **: /home/miguel/.mysql/workbench/wb_options.xml:306: link 'ed6cd436-bcd0-11de-a820-001cbf6f5ea2' <object GrtObject> key=owner could not be resolved                                                     
_view_impl has NULL ptr at 15                                                                                           
** Message: item_activated: 0x272a320 -> 'plugin:wb.form.showQueryConnectDialog'                                        
** Message: unhandled message 4: wb.form.showQueryConnectDialog finished in 0.00s                                       

** Message: item_activated: 0x2743310 -> 'plugin:wb.form.showQueryConnectDialog'
** Message: unhandled message 4: wb.form.showQueryConnectDialog finished in 0.00s

Segmentation fault (core dumped)
*** Segmentation fault          
Register dump:

Verified as described by using WB 5.2.6

fixed in repository. fix will be included in 5.2.7

An entry was added to the 5.2.7 changelog:

Attempting to export the result of an SQL query to CSV using Query, Export Results... gave the error:

Failed to open template file: `/usr/share/mysql-workbench/modules/data/sqlide/CSV.tpl`

This occurred on a Fedora 11 AMD64 install, from RPM. The requested file was found in a different directory, /usr/share/mysql-workbench/sqlide/. The error did not occur after the file was moved to the required location.