Forums > MySql error

Forums > Resource Center > Webmasters' Corner > Webmasters' Corner Resolved Topics

talcumpowder

Jan 4 2006, 10:31 PM

QUOTE

#1074 - Too big column length for column 'entry' (max = 255). Use BLOB instead

What'sa BLOB? &how do I fix it? In simple terms because my brain is a little... Eh at the moment.
Oh, and this is what I was trying to do....

<!-- begin code provided by createblog.com --><br />CREATE TABLE `entries` (<br />  `id` varchar(10) default NULL,<br />  `title` varchar(250) default NULL,<br />  `date` varchar(50) default NULL,<br />  `entry` varchar(50000) default NULL,<br />  `commentstatus` varchar(1) default NULL,<br />  `entrystatus` varchar(1) default NULL<br />) ENGINE=MyISAM;<br /><br />INSERT INTO `entries` VALUES ('1', 'Testing Installation', 'July 19th 2005', 'Default entry, if you are seeing this, then your installation was successful. You can use admin/form_edit.php to modify this.', '1', '1');<br /><br />CREATE TABLE `global` (<br />  `blog_title` varchar(100) default NULL,<br />  `entry_offline` varchar(10000) default NULL,<br />  `comments_online` varchar(10000) default NULL,<br />  `comments_offline` varchar(10000) default NULL,<br />  `entry_offline_title` varchar(100) default NULL<br />) ENGINE=MyISAM;<br /><br />INSERT INTO `global` VALUES ('TheMaser Blog', 'The status of the entry that you are viewing has been setted to offline and is currently unavailable. Please check back later.', 'Please enter your name, email or comments. Entering an email is not compulsary.', 'Comments for this entry has been turned offline and no new comments are allowed to be posted. Please check back later.', 'Entry Offline!');<br /><br />CREATE TABLE `comments` (<br />  `id` varchar(10) default NULL,<br />  `comment_id` varchar(10) default NULL,<br />  `name` varchar(100) default NULL,<br />  `email` varchar(100) default NULL,<br />  `comments` varchar(10000) default NULL<br />) ENGINE=MyISAM;<br /><!-- end code provided by createblog.com -->

mipadi

Jan 4 2006, 10:37 PM

varchar columns can only be up to 255 characters in length. You should use the type BLOB instead.

talcumpowder

Jan 4 2006, 10:52 PM

Okay, new errors now! Yay... -.-U Proves I've got zero idea what I'm doing.

QUOTE

#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 '(50000) default NULL,
`commentstatus` varchar(1) default NUL

<!-- begin code provided by createblog.com --><br />CREATE TABLE `entries` (<br />  `id` varchar(10) default NULL,<br />  `title` varchar(250) default NULL,<br />  `date` varchar(50) default NULL,<br />  `entry` BLOB(50000) default NULL,<br />  `commentstatus` varchar(1) default NULL,<br />  `entrystatus` varchar(1) default NULL<br />) ENGINE=MyISAM;<br /><br />INSERT INTO `entries` VALUES ('1', 'Testing Installation', 'July 19th 2005', 'Default entry, if you are seeing this, then your installation was successful. You can use admin/form_edit.php to modify this.', '1', '1');<br /><br />CREATE TABLE `global` (<br />  `blog_title` varchar(100) default NULL,<br />  `entry_offline` BLOB(10000) default NULL,<br />  `comments_online` BLOB(10000) default NULL,<br />  `comments_offline` BLOB(10000) default NULL,<br />  `entry_offline_title` varchar(100) default NULL<br />) ENGINE=MyISAM;<br /><br />INSERT INTO `global` VALUES ('TheMaser Blog', 'The status of the entry that you are viewing has been setted to offline and is currently unavailable. Please check back later.', 'Please enter your name, email or comments. Entering an email is not compulsary.', 'Comments for this entry has been turned offline and no new comments are allowed to be posted. Please check back later.', 'Entry Offline!');<br /><br />CREATE TABLE `comments` (<br />  `id` varchar(10) default NULL,<br />  `comment_id` varchar(10) default NULL,<br />  `name` varchar(100) default NULL,<br />  `email` varchar(100) default NULL,<br />  `comments` BLOB(10000) default NULL<br />) ENGINE=MyISAM;<br /><!-- end code provided by createblog.com -->

mipadi

Jan 4 2006, 11:14 PM

Don't pass a size along with BLOB--just do "'entry' BLOB default NULL".

talcumpowder

Jan 5 2006, 03:37 PM

Thank you. =3
-> Topic Closed.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.