search

JasonBaier / ci3-fire-starter

NOW THAT CODEIGNITER 4 HAS BEEN RELEASED, THIS PROJECT WILL NOT BE UPDATED ANYMORE. CI3 Fire Starter is a CodeIgniter3 skeleton application that includes jQuery and Twitter Bootstrap. It is intended to be light weight, minimalistic and not get in your way of building great CodeIgniter 3 applications.
MIT License
153 stars 152 forks source link

Error importing database #5

Closed dink closed 9 years ago

dink commented 9 years ago

Hello, I'm getting the following error when trying to import the 'ci3-fire-starter.sql' databse. 

SQL query:

CREATE TABLE IF NOT EXISTS `emails` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 64 ) NOT NULL ,
`email` varchar( 256 ) NOT NULL ,
`title` varchar( 128 ) NOT NULL ,
`message` text NOT NULL ,
`created` datetime NOT NULL ,
`read` datetime DEFAULT NULL ,
`read_by` int( 11 ) unsigned DEFAULT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `name` ( `name` , `email` ( 255 ) , `title` , `created` , `read` , `read_by` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

Any ides what is going on?

JasonBaier commented 9 years ago

Do a pull and try again. Looks like the indexes in the email table were too big. Let me know what happens.

dink commented 9 years ago

Thank you, it's working now.