I reinstalled SC8 and still get the same error…
Could somebody create a table (MySQL) and test “Batch Express Creation” to make GRID and FORM apps of this table and see if running it would generate the same error.
I would really appreciate. If it works on another computer then I have a problem with my installation, if not the this is SC bug.
MySQL creation script
CREATE TABLE IF NOT EXISTS `edb_mLEADS` (
`UID` int(11) NOT NULL,
`UserID` int(11) DEFAULT NULL,
`FirstName` char(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`LastName` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Photo` char(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Street` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Town` char(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Region` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ZIP` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Country` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`HomePhone` char(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`WorkPhone` char(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`CellPhone` char(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Fax` char(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Email` char(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Skype` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`GooglePlus` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Website` char(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`LeadType` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`LastContactDate` date DEFAULT NULL,
`NextContactDate` date DEFAULT NULL,
`Cooperation` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Rank` int(2) DEFAULT NULL,
`Registered` char(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`YLC_member` char(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`YLID` int(8) DEFAULT NULL,
`Status` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Active` char(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`Lang` int(2) DEFAULT NULL,
`OperatorID` int(77) DEFAULT NULL,
`LastUpdate` datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `edb_mLEADS`
--
ALTER TABLE `edb_mLEADS`
ADD PRIMARY KEY (`UID`), ADD UNIQUE KEY `LastName_FirstName` (`LastName`,`FirstName`), ADD UNIQUE KEY `Email` (`Email`), ADD UNIQUE KEY `Website` (`Website`), ADD KEY `Country_Region_Town_Street` (`Country`,`Region`,`Town`,`Street`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `edb_mLEADS`
--
ALTER TABLE `edb_mLEADS`
MODIFY `UID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
====================================================================================