| Bug #70246 | workbench synchronize and reverse engineer is not working | ||
|---|---|---|---|
| Submitted: | 5 Sep 2013 3:43 | Modified: | 13 Nov 2013 5:15 |
| Reporter: | Basit A | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 6.0.7 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | reverse engineer, synchronize, syntax error | ||
[5 Sep 2013 3:44]
Basit A
reverse engineer log file with error on it
Attachment: wb.log (application/octet-stream, text), 1.18 KiB.
[5 Sep 2013 11:36]
Alfredo Kojima
Can you provide a dump of the problematic schema?
[5 Sep 2013 11:39]
Basit A
schema dump file
Attachment: sajjad-teamwork.sql (application/octet-stream, text), 3.08 KiB.
[7 Sep 2013 4:22]
Basit A
anyone know what is causing this? or how can i fix this?
[13 Nov 2013 5:14]
Basit A
updating database will fix this issue.
[13 Nov 2013 5:15]
Basit A
solved by updating mysql database
Description: I was working fine on 5.2 CE. as soon as i updated to 6.0.7 i cannot synchronize or do any reverse engineer on any database or even on new model. i even tried installing back to 5.2 CE, now even that is giving the same issue. following is the log file for reverse engineering and its error: 08:35:31 [INF][ grt]: Fetching schema list. 08:35:31 [INF][ grt]: OK 08:35:34 [INF][ grt]: Fetching table list. 08:35:34 [INF][ grt]: 3 items from sajjad-teamwork 08:35:34 [INF][ grt]: OK 08:35:34 [INF][ grt]: Fetching view list. 08:35:34 [INF][ grt]: 0 items from sajjad-teamwork 08:35:34 [INF][ grt]: OK 08:35:34 [INF][ grt]: Fetching routine list. 08:35:34 [INF][ grt]: 0 items from sajjad-teamwork 08:35:34 [INF][ grt]: OK 08:35:34 [INF][ grt]: Fetching trigger list. 08:35:36 [INF][ grt]: 0 items from sajjad-teamwork 08:35:36 [INF][ grt]: OK 08:35:39 [WRN][ grt]: Previously created MySQL Schema `sajjad-teamwork` was found. Statement ignored. Line 11: syntax error, unexpected TYPE_SYM, expecting SELECT_SYM or '('. Statement skipped. 08:35:39 [ERR][ grt]: Line 19: syntax error, unexpected TYPE_SYM, expecting SELECT_SYM or '('. Statement skipped. 08:35:39 [ERR][ grt]: Line 28: syntax error, unexpected TYPE_SYM, expecting SELECT_SYM or '('. Statement skipped. How to repeat: after installing 6.0.7 on window 7.