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:
None 
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:43] Basit A
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.
[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