Sql hata kodunu nasıl düzenlememiz gerekiyor

14-06-2021, 11:30:58

CREATE TABLE IF NOT EXISTS userlog (
`userlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`script` varchar(50) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`extrainfo` varchar(200) NOT NULL default '',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`userlogid`),
KEY `script_action` (`script`,`action`)
) TYPE=MyISAM;

Sql 1064 hatasını almaktayım

14-06-2021, 11:38:10

#2

TekLanDC

CREATE TABLE IF NOT EXISTS `userlog` (
`userlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`script` varchar(50) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`extrainfo` varchar(200) NOT NULL default '',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`userlogid`),
KEY `script_action` (`script`,`action`)
) TYPE=MyISAM;
);

yani en üstteki userlog u tırnak içerisine alıp ve son kısıma ); ekleyip denermisiniz

14-06-2021, 11:42:43

#3

aim_fakiri

TekLanDC adlı üyeden alıntı: mesajı görüntüle

CREATE TABLE IF NOT EXISTS `userlog` (
`userlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`script` varchar(50) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`extrainfo` varchar(200) NOT NULL default '',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`userlogid`),
KEY `script_action` (`script`,`action`)
) TYPE=MyISAM;
);

yani en üstteki userlog u tırnak içerisine alıp ve son kısıma ); ekleyip denermisiniz

hocam tablo şu şekilde;

<codes>
        <code version="1.0.0">
            <installcode><![CDATA[$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "userlog");
$db->query("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "userlog (
  `userlogid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `extrainfo` varchar(200) NOT NULL default '',
  `ipaddress` char(15) NOT NULL default '',
  PRIMARY KEY  (`userlogid`),
  KEY `script_action` (`script`,`action`)
) TYPE=MyISAM");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN logging_thread int(10) DEFAULT '0' NOT NULL");]]></installcode>
            <uninstallcode><![CDATA[$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "userlog");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP COLUMN logging_thread");]]></uninstallcode>
        </code>
        <code version="1.0.3">
            <installcode><![CDATA[$db->query_write("UPDATE " . TABLE_PREFIX . "user SET logging_thread = 0");]]></installcode>
            <uninstallcode />
        </code>
    </codes>