I am doing a clean install of latest embed_widgets and I get the following error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned NOT NULL, `status` INT(1) unsigned NOT NULL DEFAULT 1, `title` VARCHA' at line 3 query: CREATE TABLE embed_widgets ( `wid` INT unsigned NOT NULL auto_increment, `uid` unsigned NOT NULL, `status` INT(1) unsigned NOT NULL DEFAULT 1, `title` VARCHAR(128) NOT NULL DEFAULT '', `description` VARCHAR(255) NOT NULL DEFAULT '', `sources` MEDIUMTEXT NOT NULL, `settings` MEDIUMTEXT NOT NULL, `footer` VARCHAR(128) NOT NULL DEFAULT '', PRIMARY KEY (wid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Looks like there's a problem with the embed_widgets schema.

Any ideas?
Paul

Comments

freshaspect’s picture

freshaspect commented

Changing the 'unt' to 'int' in embed_widgets.install seems to have fixed the problem.

jtsnow’s picture

jtsnow commented
Status: Active » Fixed

Thanks! Typo :)

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.