- This topic has 3 replies, 2 voices, and was last updated 6 years, 2 months ago by
.
-
Posts
-
Version myeclipse CI 2018.9.0 Build id: 16.0.0-2018090
MySQL server version: 5.7.20Cannot insert / select: get an error:
<quote>
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=DEFAULT’ at line 1.
</quote>
I presume that the faulty syntax is an element of the db explorer. Regret I do not know how to fix that issue.
Note the graphic of the screen: schema ‘logon’ TABLE appears empty. In reality the tables are in the ‘logon’ db (seen in MySQL Workbench) . They just do not appear in the browser window.
Thanks and regards
Bruce Prior
[email protected]greybeard,
Sorry that you are seeing this problem.
While I investigate further, can you please try removing the
use logonstatement from the editor and try running the query? Does it work?About the missing tables in the Explorer view, do you see the problem only with logon catalog or for all the catalogs?
Please share with us the workspace log file by clicking on the icon for ‘Export Log’ in the Error Log view (change the extension to .txt) and attach it here to help us check for any errors/exceptions logged.
Apologies for inconvenience caused.
–Swapna
Genuitec SupportHi
1. closed the connection.
2. opened a connection specified schema “logon” via the select list on the edit wndow
3. checked the db browser tree. Tables now showing OK.
4. ran: select * from APP_USER
5 All OK
6. ran: insert into app_role (ROLE_ID, ROLE_NAME) values (3, ‘ROLE_FOO’);
7. ran select * from APP_ROLE
8 All OK.I will carry on from here and let u know if the symptoms show themselves again.
sorry for bother
Log is attached as requestedcheerz
bruce
