Failed to Create Table

Sorry for my late reply.

Sorry to trouble you, please tell me the full statements of SQL which is displayed in a modal dialog for confirmation of when you will be creating a table.

Thank you,

Hello Ka2,

I’ve also encountered the same error and here is the info in my case:

CREATE TABLE wp_activities (
ID int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
activity_type varchar() ,
activity_order int(11) ,
activity_link varchar() ,
activity_done bool ,
done_date date ,
created datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘Created Date’,
updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘Updated Date’,
PRIMARY KEY (ID)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8
COMMENT=” ;

Thanks,
Ajmir

Thank you for your inquiry.

By column definition, the varchar type of column need the length of the string. So, varchar() instead, please put the number of the string length, such as varchar(255). Then, you are able to be table creation.

Please try it.