Schema Sync Fails: Limit

[maxhugen]

I've had a problem a number of times now, where a Schema Sync fails, reporting:

Code:

Query : USE `cams` LIMIT 116, 0
Error Code : 1064
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 'LIMIT 116, 0' at line 1

The queries generated were:

Code:

USE `cams`;

/* Foreign Keys must be dropped in the target to ensure that requires changes can be done*/

ALTER TABLE `project` DROP FOREIGN KEY `FK_project` ;

/* Alter table in target */
ALTER TABLE `project`
ADD COLUMN `area_building` int(10) NULL after `sort_order`,
ADD COLUMN `area_shell` int(10) NULL after `area_building`,
ADD COLUMN `area_footprint` int(10) NULL after `area_shell`,
ADD COLUMN `beds` int(10) NULL after `area_footprint`,
ADD COLUMN `beds_shell` int(10) NULL after `beds`,
CHANGE `short_code` `short_code` varchar(50) COLLATE utf8_general_ci NULL after `beds_shell`,
CHANGE `ts` `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP after `short_code`,
DROP COLUMN `sqft`,
DROP COLUMN `shell_sqft`,
DROP COLUMN `no_beds`,
DROP COLUMN `no_beds_shell`, COMMENT='';

/* The foreign keys that were dropped are now re-created*/

ALTER TABLE `project`
ADD CONSTRAINT `FK_project`
FOREIGN KEY (`master_project_code`) REFERENCES `master_project` (`master_project_code`) ON UPDATE CASCADE;

I don't know what's wrong; I've used this tool many times without problem, until just the last couple of months. If I run the generated queries myself, all is OK.

Any thoughts? (version is 8.3)

MTIA

[Mahesh]

This issue has been fixed in latest v8.32.

http://www.webyog.com/en/downloads.php

Regards,

Mahesh

[maxhugen]

Thanks Mahesh!

[Author]

Posts