More problems with articles

[IchBin]

I didn't mean engine type. I meant column type. It should say text, or longtext.

[GhostRider2110]

Sorry Ich, I am confused, are you talking about the Row_format? which is Dynamic.  If not, I'm not sure where to find that.  I have looked in phpmyadmin and with the "show table status"  --Mitch

[GhostRider2110]

OK, maybe I found how, show create table? 

Code Select Expand


smf_tp_articles | CREATE TABLE `smf_tp_articles` (
  `id` int(11) NOT NULL auto_increment,
  `date` int(11) NOT NULL default '0',
  `body` text,
  `intro` text,
  `useintro` tinyint(4) NOT NULL default '1',
  `category` smallint(6) NOT NULL default '0',
  `frontpage` tinyint(4) NOT NULL default '1',
  `subject` text,
  `authorID` int(11) NOT NULL default '0',
  `author` text character set latin1 collate latin1_general_ci,
  `frame` tinytext character set latin1 collate latin1_general_ci,
  `approved` tinyint(4) NOT NULL default '1',
  `off` tinyint(4) NOT NULL default '0',
  `options` text character set latin1 collate latin1_general_ci,
  `parse` tinyint(4) NOT NULL default '0',
  `comments` tinyint(4) NOT NULL default '0',
  `comments_var` text character set latin1 collate latin1_general_ci,
  `views` int(11) NOT NULL default '0',
  `rating` text character set latin1 collate latin1_general_ci,
  `voters` text character set latin1 collate latin1_general_ci,
  `ID_THEME` smallint(6) NOT NULL default '0',
  `shortname` tinytext character set latin1 collate latin1_general_ci,
  `sticky` tinyint(4) NOT NULL default '0',
  `fileimport` text character set latin1 collate latin1_general_ci,
  `topic` int(11) NOT NULL default '0',
  `locked` tinyint(4) NOT NULL default '0',
  `illustration` text character set latin1 collate latin1_general_ci,
  `headers` text character set latin1 collate latin1_general_ci,
  `type` tinytext character set latin1 collate latin1_general_ci,
  `global_tag` text character set latin1 collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 |


That what you are looking for?

--Mitch

[IchBin]

Yes! ok, so you need to actually click on the articles table to view that info. Next you need to edit the "body" column of this table. Change its "type" to longtext instead of text.

A "text" column can only hold 65,535 characters, where as a "longtext" 4,294,967,295 characters.