Bug #1329 Can't find file syntax.txt
Submitted: 18 Sep 2003 2:22 Modified: 1 Jun 2004 0:31
Reporter: Ronan O'Connor Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.3 OS:Linux (Redhat 8)
Assigned to: Bugs System CPU Architecture:Any

[18 Sep 2003 2:22] Ronan O'Connor 
Description:
When opening a query window for a table in MySQLCC, the Messages tab reports "Could not Load Syntax file: '/usr/local/syntax.txt'".
MySQLCC appears to be looking for the syntax.txt file in the directory where the MySQLCC program was called from. In the above case, I ran the command "/usr/local/mysqlcc/mysqcc" from the directory /usr/local. If I run mysqlcc from say the root directory (/), The error message from the query window would instead be: "Could not Load Syntax file: '//syntax.txt'"

How to repeat:
Install MySQLCC as per installation instructions. Run /usr/local/mysqlcc/mysqlcc from any directory except /usr/local/mysqlcc. Make a connection to a mysql server. Open a query window for a table. Message tab reports "Could not Load Syntax file..."
[18 Sep 2003 2:43] Ronan O'Connor 
Slightly further investigation shows that in the options>General menu item, The path values, for the files in the General tab and the Syntax File path in the SQL Editor tab, will take the path of the directory from which you started MySQLCC, *until* you manually modify and apply the value.

E.G. 
New installation, run MySQLCC from /usr/local with command /usr/local/mysqlcc/mysqlcc, open the options>General menu item, the values for "Translations Path" on the General tab will be /usr/local/translations/ and the value for "Syntax File" on the Sql Editor tab will be /usr/local/syntax.txt.
If you then close and run MySQLCC from another path, say /home/user the above paths will become /home/user/translations/ and /home/user/syntax.txt respectively. 
 
Once you modify a file path manually and apply it, the value will "stay".
[22 Sep 2003 9:56] MySQL Verification Team 
Thank you for the bug report. I was able to repeat.
[24 Jan 2004 13:16] MySQL Verification Team 
Verified also with 0.9.4.
[1 Jun 2004 0:31] Jorge del Conde 
Hi!

MySQLCC will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.