Knowledge Base support case for AllWebMenus, abstracted and stripped of all user’s private info.
Initial Email From: User
Initial Email Subject: Could not create table. Please check your privileges
Support Case Month: November 2012
Hi
I got this error when using the plugin in wordpress
"Could not create table. Please check your privileges"
have any solution for me?
Here my Information
AllWebMenus Pro 5.3-Build #900
AllWebMenus WordPress Menu Plugin v1.1.14
*** also the web form cannot send out the message so i send you email
Thanks
Reply From: Likno Customer Support
Hello,
According to the error message, it seems that your WordPress does not have the access rights required to create new tables into the database!
This means that you blocked this access *after* the WordPress installation. Does this make sense?
Would you be able to create the table manually through your SQL admin? If so, then you could use the following query:
CREATE TABLE wp_awm (
id mediumint(9) NOT NULL AUTO_INCREMENT,
name tinytext NOT NULL,
active BOOLEAN NOT NULL DEFAULT '0',
custom_menu BOOLEAN NOT NULL DEFAULT '0',
custom_menu_id mediumint(9) NOT NULL DEFAULT '0',
position tinytext NOT NULL,
type tinytext NOT NULL,
include_home BOOLEAN NOT NULL DEFAULT '1',
pages BOOLEAN NOT NULL DEFAULT '1',
pages_ms tinytext NOT NULL DEFAULT '',
pages_name tinytext NOT NULL DEFAULT '',
excluded_pages tinytext,
posts BOOLEAN NOT NULL DEFAULT '0',
posts_ms tinytext NOT NULL DEFAULT '',
posts_name tinytext NOT NULL DEFAULT '',
posts_ids tinytext,
categories BOOLEAN NOT NULL DEFAULT '0',
categories_ms tinytext NOT NULL DEFAULT '',
categories_name tinytext NOT NULL DEFAULT '',
categories_subitems BOOLEAN NOT NULL DEFAULT '1',
categories_subitems_no tinyint NOT NULL DEFAULT 5,
excluded_cats tinytext,
hide_future BOOLEAN NOT NULL DEFAULT '1',
hide_protected BOOLEAN NOT NULL DEFAULT '1',
hide_private BOOLEAN NOT NULL DEFAULT '1',
related BOOLEAN NOT NULL DEFAULT '0',
related_name tinytext NOT NULL DEFAULT '',
UNIQUE KEY id (id)
);
Note here that the table name “wp_awm” is assuming that all your WordPress tables have the “wp_” prefix. If they have another prefix you have to use the same for this new table.
Best Regards,
Kostas
Likno Customer Support
www.likno.com
Create any type of javascript menu (CSS menu, drop-down menu, sliding menu), button, html tree, modal window, tooltip, accordion, tab, scroller, jQuery slider or design for your websites!
Like us on Facebook – Follow us on Twitter
Reply From: User
Hi
I got this Sql Error
#1101 - BLOB/TEXT column 'pages_ms' can't have a default value
Thanks
Reply From: Likno Customer Support
Hello again,
Did you check if you can give the proper permissions to the WordPress installation? This would be the proper solution.
If you want to continue with the manual way, please try with this:
CREATE TABLE wp_awm (
id mediumint(9) NOT NULL AUTO_INCREMENT,
name tinytext NOT NULL,
active BOOLEAN NOT NULL DEFAULT '0',
custom_menu BOOLEAN NOT NULL DEFAULT '0',
custom_menu_id mediumint(9) NOT NULL DEFAULT '0',
position tinytext NOT NULL,
type tinytext NOT NULL,
include_home BOOLEAN NOT NULL DEFAULT '1',
pages BOOLEAN NOT NULL DEFAULT '1',
pages_ms tinytext NOT NULL,
pages_name tinytext NOT NULL,
excluded_pages tinytext,
posts BOOLEAN NOT NULL DEFAULT '0',
posts_ms tinytext NOT NULL,
posts_name tinytext NOT NULL,
posts_ids tinytext,
categories BOOLEAN NOT NULL DEFAULT '0',
categories_ms tinytext NOT NULL,
categories_name tinytext NOT NULL,
categories_subitems BOOLEAN NOT NULL DEFAULT '1',
categories_subitems_no tinyint NOT NULL DEFAULT 5,
excluded_cats tinytext,
hide_future BOOLEAN NOT NULL DEFAULT '1',
hide_protected BOOLEAN NOT NULL DEFAULT '1',
hide_private BOOLEAN NOT NULL DEFAULT '1',
related BOOLEAN NOT NULL DEFAULT '0',
related_name tinytext NOT NULL,
UNIQUE KEY id (id)
);
Again, note here that the table name “wp_awm” is assuming that all your WordPress tables have the “wp_” prefix. If they have another prefix you have to use the same for this new table.
Best Regards,
Kostas
Likno Customer Support
www.likno.com
Create any type of javascript menu (CSS menu, drop-down menu, sliding menu), button, html tree, modal window, tooltip, accordion, tab, scroller, jQuery slider or design for your websites!
Like us on Facebook – Follow us on Twitter