Acil db sorunu Dumping data in `smf_ban_groups

14-09-2009, 00:13:17

#1

Kadir TUTAK

php my adminden db yukledigimizde bu hatayı alıyoruz.

Alıntı

<H1>Hata

Alıntı

SQL sorgusu:

#
# Dumping data in `smf_ban_groups`
#
/*!40000 ALTER TABLE `smf_ban_groups` DISABLE KEYS */;

INSERT INTO `smf_ban_groups` ( `ID_BAN_GROUP` ,
`name` ,
`ban_time` ,
`expire_time` ,
`cannot_access` ,
`cannot_register` ,
`cannot_post` ,
`cannot_login` ,
`reason` ,
`notes`
)
VALUES ( 1, 'drigmamak', 1243364657, NULL , 1, 0, 0, 0, NULL , NULL ) ;

MySQL çıktısı:
#1048 - Column 'reason' cannot be null

</H1>
sorun nedir acaba :S
14-09-2009, 00:14:11

#2

Kadir TUTAK

Başka php my admine attıgımdada

Hata

SQL sorgusu:

CREATE TABLE `smf_attachments` ( `ID_ATTACH` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_THUMB` int( 10 ) unsigned NOT NULL default 0,
`ID_MSG` int( 10 ) unsigned NOT NULL default 0,
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL default 0,
`attachmentType` tinyint( 3 ) unsigned NOT NULL default 0,
`filename` tinytext NOT NULL default '',
`size` int( 10 ) unsigned NOT NULL default 0,
`downloads` mediumint( 8 ) unsigned NOT NULL default 0,
`width` mediumint( 8 ) unsigned NOT NULL default 0,
`height` mediumint( 8 ) unsigned NOT NULL default 0,
`file_hash` varchar( 40 ) NOT NULL default '',
PRIMARY KEY ( `ID_ATTACH` ) ,
UNIQUE `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,
KEY `ID_MSG` ( `ID_MSG` )
) TYPE = MYISAM ;

MySQL çıktısı:
#1101 - BLOB/TEXT column 'filename' can't have a default value