in `problems` column `src` NOT NULL, cause errors

[hih70]

CREATE TABLE problems (
pid int(11) NOT NULL AUTO_INCREMENT,
pub int(11) NOT NULL,
ts bigint(20) DEFAULT NULL,
src text COLLATE utf8_unicode_ci NOT NULL,
ttl text COLLATE utf8_unicode_ci NOT NULL,
level int(11) DEFAULT NULL,
porder int(11) DEFAULT NULL,
PRIMARY KEY (pid)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

When use website to create new problem. src will be NULL, which cause problem.

[sapphire4890]

great, thanks for your remind here.
I was stuck at adding a new problem after setup.

Here's my solution for ref.

mysql
use judgegirl;
ALTER TABLE problems MODIFY src text;
DESCRIBE problems; // check for the structure whether it is still NOT NULL(leads to the problem)

CHEERS~~~