Thread

I am trying to install NSM Better Meta into Expression Engine and while I can install the Fieldtype and the Module, I get the following error when enabling the Extension. Installed ExpressionEngine is v2.1.0 Build 20101020

A Database Error Occurred
Error Number: 1064

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 ‘default tinyint(1) DEFAULT ‘0’, title varchar(255), keywords varchar(255), ke’ at line 7

CREATE TABLE IF NOT EXISTS `exp_nsm_better_meta` ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, entry_id int(10) UNSIGNED, site_id int(5) UNSIGNED DEFAULT ‘1’ NOT NULL, channel_id int(6) UNSIGNED, language_id varchar(255), default tinyint(1) DEFAULT ‘0’, title varchar(255), keywords varchar(255), keywords_append_default tinyint(1) DEFAULT ‘0’, description varchar(255), publisher varchar(255), rights varchar(255), author varchar(255), canonical_url varchar(255), robots_index tinyint(1) DEFAULT ‘0’, robots_follow tinyint(1) DEFAULT ‘0’, robots_archive tinyint(1) DEFAULT ‘0’, sitemap_priority double(2,1) DEFAULT ‘0.5’, sitemap_change_frequency varchar(20), sitemap_include tinyint(1) DEFAULT ‘0’, geo_region varchar(255), geo_placename varchar(255), geo_latitude double(8,5), geo_longitude double(8,5), PRIMARY KEY id (id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Filename: third_party/nsm_better_meta/ext.nsm_better_meta.php

Line Number: 243

I’ve made sure I have the most up to date versions of my Add-ons. Any ideas what is causing this?

Moved to CodeShare Corner by Moderator

Hi, jon. Unfortunately we are unable to help with support issues for third party add-ons. You’ll need to contact Leevi directly. In the mean time, moving to CodeShare Corner for additional community support.