Reply to thread

Message

<blockquote data-quote="martin43103" data-source="post: 469013" data-attributes="member: 101142">i got this error when import the db can you help pleaseCREATE TABLE [ICODE]ip_cache[/ICODE] (&nbsp; [ICODE]ip[/ICODE] varchar(16) NOT NULL,&nbsp; [ICODE]country[/ICODE] varchar(75) NOT NULL DEFAULT 'UNKNOWN',&nbsp; [ICODE]isSafe[/ICODE] enum('false','true') DEFAULT 'true',&nbsp; PRIMARY KEY ([ICODE]ip[/ICODE]),&nbsp; UNIQUE KEY [ICODE]ip[/ICODE] ([ICODE]ip[/ICODE])) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXEDMySQL said: <a href="http://localhost/phpmyadmin/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Fserver-error-reference.html" target="_blank"><img src="http://localhost/phpmyadmin/themes/dot.gif" alt="Documentation" class="fr-fic fr-dii fr-draggable " style="" /></a>#1031 - Table storage engine for 'ip_cache' doesn't have this option</blockquote>

[QUOTE="martin43103, post: 469013, member: 101142"] i got this error when import the db can you help please CREATE TABLE [ICODE]ip_cache[/ICODE] ( [ICODE]ip[/ICODE] varchar(16) NOT NULL, [ICODE]country[/ICODE] varchar(75) NOT NULL DEFAULT 'UNKNOWN', [ICODE]isSafe[/ICODE] enum('false','true') DEFAULT 'true', PRIMARY KEY ([ICODE]ip[/ICODE]), UNIQUE KEY [ICODE]ip[/ICODE] ([ICODE]ip[/ICODE]) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED [B]MySQL said: [/B][URL='http://localhost/phpmyadmin/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.7%2Fen%2Fserver-error-reference.html'][IMG alt="Documentation"]http://localhost/phpmyadmin/themes/dot.gif[/IMG][/URL] #1031 - Table storage engine for 'ip_cache' doesn't have this option [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members