Hi New Zeal,

I wanted to try out your Adv. Tax Menu but on install/activate I get the following error:

user warning: Column length too big for column 'vocab_order' (max = 255); use BLOB or TEXT instead query: CREATE TABLE adv_taxonomy_menu ( `tmid` INT unsigned NOT NULL auto_increment, `mid` INT unsigned NOT NULL DEFAULT 0, `name` VARCHAR(32) NOT NULL DEFAULT '', `display_page` VARCHAR(32) NOT NULL DEFAULT '', `display_num` INT unsigned NOT NULL DEFAULT 0, `hide_empty` INT unsigned NOT NULL DEFAULT 0, `show_normal` VARCHAR(32) NOT NULL DEFAULT '', `show_views` VARCHAR(32) NOT NULL DEFAULT '', `vocab_order` VARCHAR(2048) NOT NULL DEFAULT '', `module_alter` VARCHAR(256) NOT NULL DEFAULT '', PRIMARY KEY (tmid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /includes/database.inc on line 555.
user warning: Table 'riccardo_onamap01.adv_taxonomy_menu' doesn't exist query: SELECT * FROM adv_taxonomy_menu in /sites/all/modules/adv_taxonomy_menu/adv_taxonomy_menu.module on line 27.

I haven't seen anybody mention it so it seems I am the first/only one who ran into this. Any idea why and how to solve?
I guess I'll go and try Listing in the meantime.

Cheers!

Comments

mleynse’s picture

mleynse commented

same thing here ..

user warning: Table 'db.adv_taxonomy_menu' doesn't exist query: SELECT * FROM adv_taxonomy_menu in httpdocs/sites/all/modules/adv_taxonomy_menu/adv_taxonomy_menu.module on line 27.

NewZeal’s picture

NewZeal commented

This is your error:

Column length too big for column 'vocab_order' (max = 255);

Your mysql is set to only allow a varchar of length 255 which is too short for many drupal modules. Pass this by your webhost or do some searching on google to find out the solution to this problem but I guess you need to change some mysql settings.