Mysql Error Code 1628
Impact on me: None Category:MySQL Workbench: Modeling Severity:S3 (Non-critical) Version:5.2.26CE Revision 6432 OS:Any Assigned to: Tags: Sitcoms_Comedy` INT(11) NOT NULL AUTO_INCREMENT View Add Comment Files Developer Edit Submission View Progress Log Contributions [7 Sep 2010 10:10] Tebs Seabs Description: I had created a EER model and was trying to edit the SQL script from my EER model. I also selected execute file after opening,But I get the following msg. (Error Code: 1628 - Comment for table 'sitcoms_comedy' is too long (max = 60) Actions taken while executing the file after opening -- ----------------------------------------------------- -- Table `dvd_collections`.`sitcoms_comedy` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `dvd_collections`.`sitcoms_comedy` ( `Sitcoms_Comedy` INT(11) NOT NULL AUTO_INCREMENT , `Actors` VARCHAR(45) NOT NULL , `Produced_date` DATE NULL DEFAULT NULL , `Tax_status` TEXT NOT NULL , `series_Series` INT(11) NOT NULL , PRIMARY KEY (`Sitcoms_Comedy`, `series_Series`) , INDEX `fk_sitcoms_comedy_series1` (`series_Series` ASC) , CONSTRAINT `fk_sitcoms_comedy_series1` FOREIGN KEY (`series_Series` ) REFERENCES `dvd_collections`.`series` (`Series` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARACTER SET = latin1 COMMENT = 'Tables created for thr Sitcoms and Comedy which intertain us on our screens.' How to repeat: Sitcoms_Comedy` INT(11) NOT NULL AUTO_INCREMENT , Suggested fix: None [7 Sep 2010 10:13] Valerii Kravchuk Had you tried to make table comment shorter, as suggested by the error message? [7 Oct 2010 23:00] Bugs System 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". Legal Policies Your Privacy Rights Terms of Use Contact Us Portions of this website are copyright © 2001, 2002 The PHP Group Pa
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.6 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.6 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of https://bugs.mysql.com/bug.php?id=56607 Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has https://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.6 Release Notes Download this Manual PDF (US Ltr) - 31.1Mb PDF (A4) - 31.1Mb PDF (RPM) - 30.3Mb EPUB - 7.7Mb HTML Download (TGZ) - 7.5Mb HTML Download (Zip) - 7.6Mb HTML Download (RPM) - 6.5Mb Eclipse Doc Plugin (TGZ) - 8.3Mb Eclipse Doc Plugin (Zip) - 10.1Mb Man Pages (TGZ) - 182.
unknown table specified. FileMaker Error Codes Lasso Error Codes MySQL Error Codes Windows System Errors About this database This is a mysql error free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful! There are not yet any user contributed notes for mysql error code this error.Add the first note! [ Close Window ] The class that teaches you how to successfully sell your FileMaker Pro solution as a professional shrinkwrapped software application. Let's Meet in Person Sunday, August 13 2006, Orlando FL Courtyard Orlando International Drive Don't miss this most important day of the Developer Conference. Please click here for complete details and online registration.