Code: Select all
"You have an error in your SQL syntax ... near 'SELECT id ...' at line 1.It happens on every table.
Do you have any ideas?
Thanks,
g.
error when editing from data grid
-
grahampcharles
- Posts: 2
- Joined: Sun 09 Jun 2013 21:27
error when editing from data grid
Every time I try to edit data in a MySql 5.0.27 table, I get an error:
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.
It happens on every table.
Do you have any ideas?
Thanks,
g.
-
alexa
Re: error when editing from data grid
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.
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.