Page 1 of 1
error when editing from data grid
Posted: Tue 25 Jun 2013 19:03
by grahampcharles
Every time I try to edit data in a MySql 5.0.27 table, I get an error:
Code: Select all
"You have an error in your SQL syntax ... near 'SELECT id ...' at line 1.
This wasn't happening until I installed 6.0.265 of dbForge. It also doesn't happen on MySQL 5.5.
It happens on every table.
Do you have any ideas?
Thanks,
g.
Re: error when editing from data grid
Posted: Wed 26 Jun 2013 10:23
by alexa
Please perform the following:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Log application errors' and 'Write queries sent by the program to the SQL Log' options.
4. Unselect the 'Delete application log after closing' option.
5. Generate the error message.
6. Navigate to the log file located in the directory with the application executable file (usually '%programfiles%\Devart\dbForge Studio for MySQL\') and send it to us for investigation.
7. Send us the CREATE definition of the table you are trying to edit (right-click the table in Database Explorer and select 'Generate Script As -> CREATE' from the popup menu).
You can send the reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via that system.