MySQL Bugs: #30339: Workbench Database Synchronisation

Bug #30339	Workbench Database Synchronisation
Submitted:	9 Aug 2007 17:07	Modified:	6 Dec 2009 17:14
Reporter:	Pablo Vega	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	1.0.6 Beta	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	SQL script errors!!

Description:
file c:\dokumente und einstellungen\mike\eigene dateien\work\mysql-gui-common\library_grt\source\myx_grt_value.c: line 3295: assertion `dict != NULL' failed
file c:\dokumente und einstellungen\mike\eigene dateien\work\mysql-gui-common\library_grt\source\myx_grt_value.c: line 3295: assertion `dict != NULL' failed

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 'COLLATE  NOT NULL,
  `apellido` VARCHAR(40) CHARACTER SET  COLLATE  NOT NULL,
' at line 3
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 'COLLATE  NULL,
  `clave` VARCHAR(16) CHARACTER SET  COLLATE  NULL
)
ENGINE=In' at line 5
Unknown table engine 'Inno'
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 'COLLATE  NULL,
  `descripcion` VARCHAR(255) CHARACTER SET  COLLATE  NULL,
  `a' at line 2
Unknown table engine 'Inno'
Unknown table engine 'Inno'
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 'COLLATE  NOT NULL,
  `empresa` VARCHAR(40) CHARACTER SET  COLLATE  NULL,
  `co' at line 2
Unknown table engine 'Inno'
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 'COLLATE  NOT NULL,
  `idprenda` INT NOT NULL,
  `idcodigocolor` INT NOT NULL,
' at line 3
Unknown table engine 'Inno'
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 'COLLATE  NOT NULL,
  `idprenda` INT NOT NULL,
  `idcabo` INT NOT NULL,
  `idc' at line 4
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
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 'COLLATE  NOT NULL,
  `tara` INT NOT NULL,
  `costototal` INT NOT NULL,
  `pag' at line 5
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 'COLLATE  NOT NULL,
  `idcompralana` INT NOT NULL,
  `unidades` INT NOT NULL,
' at line 2
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 'COLLATE  NOT NULL,
  `cabo` INT NOT NULL,
  `calidad` INT NOT NULL,
  `conos`' at line 3
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 'COLLATE  NULL,
  `contacto` VARCHAR(40) CHARACTER SET  COLLATE  NULL,
  `direc' at line 3
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 'COLLATE  NOT NULL,
  `aleman` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  `esp' at line 2
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 'COLLATE  NOT NULL,
  `aleman` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  `esp' at line 2
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 'COLLATE  NOT NULL,
  `aleman` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  `esp' at line 2
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 'COLLATE  NOT NULL,
  `aleman` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  `esp' at line 2
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 'COLLATE  NOT NULL,
  `aleman` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  `esp' at line 2
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 'COLLATE  NOT NULL,
  `idtallasmedidas` INT NOT NULL
)
ENGINE=Inno' at line 2
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 'COLLATE  NOT NULL,
  `combinacion` TINYINT(1) NOT NULL,
  `descripcion` VARCHA' at line 3
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
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 'COLLATE  NULL,
  `descripcion` VARCHAR(30) CHARACTER SET  COLLATE  NULL,
  PRI' at line 4
Unknown table engine 'Inno'

ENGINE=Inno' at line 3
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 'COLLATE  NULL,
  PRIMARY KEY (`idcondicionpago`)
)
ENGINE=Inno' at line 3
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 'COLLATE  NULL,
  PRIMARY KEY (`idformaenvio`)
)
ENGINE=Inno' at line 3
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 'COLLATE  NULL,
  PRIMARY KEY (`idlugarenvio`)
)
ENGINE=Inno' at line 3
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 'COLLATE  NULL,
  PRIMARY KEY (`idtallasmedidas`)
)
ENGINE=Inno' at line 3
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 'COLLATE  NULL,
  PRIMARY KEY (`idtejido`)
)
ENGINE=Inno' at line 3
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 'COLLATE  NOT NULL,
  `nombre` VARCHAR(60) CHARACTER SET  COLLATE  NOT NULL,
  ' at line 3
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
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 'COLLATE  NOT NULL,
  `idprenda` INT NOT NULL,
  `cabo` INT NULL,
  `color` IN' at line 3
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'
Unknown table engine 'Inno'

How to repeat:
Unknown table engine 'Inno'   <----     ????

file c:\dokumente und einstellungen\mike\eigene dateien\work\mysql-gui-common\library_grt\source\myx_grt_value.c: line 3295: assertion `dict != NULL' failed
????

Suggested fix:
the correct is 'InnoDB' not 'Inno'

Thank you for a bug report. Please, wait for a new version of Workbench, as this older one is not supported any more.

Hello,
I have an account to BUX and I have this error, I can't and i don't know fix it.
Can you help me?
I don't know much about computers.
This is my error:

$ 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 '' at line 1

Please, check if newer versions of MySQL Workbench, 5.1.18 or 5.2.6, solves the problem for you.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".