"[color=000066]Impossibile installare oledrion. Errore(i):
Installazione in corso eCommerce
Index column size too large. The maximum column size is 767 bytes[/color]."
This the Query; There are new messages!:
0.000240 - SET SQL_BIG_SELECTS = 1
0.000428 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
[color=0066CC]0.011727 - CREATE TABLE oledrion_products ( `product_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `product_cid` INT(5) UNSIGNED NOT NULL DEFAULT '0', `product_title` VARCHAR(255) NOT NULL DEFAULT '', `product_vendor_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `product_sku` VARCHAR(60) NOT NULL DEFAULT '', `product_extraid` VARCHAR(50) NOT NULL DEFAULT '', `product_width` VARCHAR(50) NOT NULL DEFAULT '', `product_length` VARCHAR(50) NOT NULL DEFAULT '', `product_unitmeasure1` VARCHAR(20) NOT NULL DEFAULT '', `product_url` VARCHAR(255) NOT NULL DEFAULT '', `product_url2` VARCHAR(255) NOT NULL DEFAULT '', `product_url3` VARCHAR(255) NOT NULL DEFAULT '', `product_image_url` VARCHAR(255) NOT NULL DEFAULT '', `product_thumb_url` VARCHAR(255) NOT NULL DEFAULT '', `product_submitter` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_online` TINYINT(1) NOT NULL DEFAULT '0', `skip_packing` TINYINT(1) NOT NULL DEFAULT '0', `skip_location` TINYINT(1) NOT NULL DEFAULT '0', `skip_delivery` TINYINT(1) NOT NULL DEFAULT '0', `product_date` VARCHAR(255) NOT NULL DEFAULT '', `product_submitted` INT(10) UNSIGNED NOT NULL DEFAULT '0', `product_hits` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_rating` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_votes` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_comments` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_shipping_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_discount_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_stock` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_alert_stock` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_summary` TEXT, `product_description` TEXT, `product_attachment` VARCHAR(255) NOT NULL DEFAULT '', `product_weight` VARCHAR(20) NOT NULL DEFAULT '', `product_unitmeasure2` VARCHAR(20) NOT NULL DEFAULT '', `product_vat_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_download_url` VARCHAR(255) NOT NULL DEFAULT '', `product_recommended` DATE NOT NULL, `product_metakeywords` VARCHAR(255) NOT NULL DEFAULT '', `product_metadescription` VARCHAR(255) NOT NULL DEFAULT '', `product_metatitle` VARCHAR(255) NOT NULL DEFAULT '', `product_delivery_time` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_ecotaxe` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_property1` VARCHAR(255) NOT NULL DEFAULT '', `product_property2` VARCHAR(255) NOT NULL DEFAULT '', `product_property3` VARCHAR(255) NOT NULL DEFAULT '', `product_property4` VARCHAR(255) NOT NULL DEFAULT '', `product_property5` VARCHAR(255) NOT NULL DEFAULT '', `product_property6` VARCHAR(255) NOT NULL DEFAULT '', `product_property7` VARCHAR(255) NOT NULL DEFAULT '', `product_property8` VARCHAR(255) NOT NULL DEFAULT '', `product_property9` VARCHAR(255) NOT NULL DEFAULT '', `product_property10` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`product_id`), KEY `product_cid` (`product_cid`), KEY `product_online` (`product_online`), KEY `product_title` (`product_title`), KEY `product_unitmeasure1` (`product_unitmeasure1`), KEY `product_weight` (`product_weight`), KEY `product_vendor_id` (`product_vendor_id`), KEY `product_extraid` (`product_extraid`), KEY `product_width` (`product_width`), KEY `recent_online` (`product_online`, `product_submitted`), KEY `product_recommended` (`product_recommended`), KEY `product_summary` (`product_summary` (1000)), KEY `product_description` (`product_description` (1000)) ) ENGINE = InnoDB
Error number: 1709
Error message: Index column size too large. The maximum column size is 767 bytes.[/color]
.000288 - SET SQL_BIG_SELECTS = 1
0.000397 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000375 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'b17f805aab9e0778c8d8568dfd4fc7e2'
0.000291 - SELECT * FROM users WHERE uid = '1'
0.000273 - SELECT * FROM modules WHERE dirname = 'system'
0.000337 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0.000395 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000399 - SELECT COUNT(*) FROM protector_access WHERE ip='xxxxxxx' AND request_uri='/site/modules/system/admin.php?fct=modulesadmin&op=install&module=oledrion'
0.000392 - SELECT COUNT(*) FROM protector_access WHERE ip='xxxxxx'
0.000439 - INSERT INTO protector_access SET ip='xxxxxxx', request_uri='/site/modules/system/admin.php?fct=modulesadmin&op=install&module=oledrion', expire=UNIX_TIMESTAMP()+'60'
0.000325 - SELECT * FROM modules WHERE dirname = 'oledrion'
0.000271 - SELECT * FROM groups WHERE (group_type = 'Admin')
0.000275 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC
0.000291 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000424 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
0.003741 - SELECT * FROM `xcenter_xcenter` WHERE (submenu = '1' AND parent_id = '0' AND visible = '1' AND (publish < '1535744121' OR publish = '0') AND (expire > '1535744121' OR expire = '0'))
0.000272 - SELECT * FROM modules WHERE dirname = 'xcenter'
0.000328 - SELECT * FROM `xcenter_text` WHERE (storyid = '60' AND language = 'italian')
0.000306 - SELECT * FROM `xcenter_text` WHERE (storyid = '6' AND language = 'italian')
0.000298 - SELECT * FROM `xcenter_text` WHERE (storyid = '52' AND language = 'italian')
0.000302 - SELECT * FROM `xcenter_text` WHERE (storyid = '65' AND language = 'italian')
0.000336 - SELECT * FROM `xcenter_text` WHERE (storyid = '62' AND language = 'italian')
0.000306 - SELECT * FROM `xcenter_text` WHERE (storyid = '63' AND language = 'italian')
0.000316 - SELECT * FROM `xcenter_text` WHERE (storyid = '61' AND language = 'italian')
0.000345 - SELECT * FROM `xcenter_text` WHERE (storyid = '59' AND language = 'italian')
0.000294 - SELECT * FROM `xcenter_text` WHERE (storyid = '54' AND language = 'italian')
0.000292 - SELECT * FROM `xcenter_text` WHERE (storyid = '55' AND language = 'italian')
0.000299 - SELECT * FROM `xcenter_text` WHERE (storyid = '56' AND language = 'italian')
0.000546 - SELECT * FROM `xcenter_text` WHERE (storyid = '57' AND language = 'italian')
0.000292 - SELECT * FROM `xcenter_text` WHERE (storyid = '58' AND language = 'italian')
0.000301 - SELECT * FROM `xcenter_text` WHERE (storyid = '64' AND language = 'italian')
0.000261 - SELECT * FROM modules WHERE dirname = 'tag'
0.000299 - SELECT * FROM modules WHERE mid = 36
0.000335 - SELECT * FROM modules WHERE dirname = 'xnewsletter'
0.000218 - SELECT groupid FROM groups_users_link WHERE uid=1
0.000259 - SELECT * FROM `xnewsletter_cat` ORDER BY cat_id ASC
0.000350 - SELECT * FROM config WHERE (conf_modid = '89') ORDER BY conf_order ASC
0.000271 - SELECT * FROM groups WHERE group_type = 'Broker'
0.000224 - SELECT * FROM groups WHERE group_type = 'Accounts'
0.000226 - SELECT * FROM groups WHERE group_type = 'Officer'
0.000252 - SELECT * FROM modules WHERE dirname = 'xpayment'
0.000303 - SELECT * FROM config WHERE (conf_modid = '91' AND conf_catid = '0') ORDER BY conf_order ASC
0.000262 - SELECT * FROM modules WHERE mid = 91
0.000257 - SELECT * FROM modules WHERE dirname = 'profile'
0.000283 - SELECT * FROM modules WHERE dirname = 'protector'
0.000256 - SELECT * FROM modules WHERE mid = 4
0.000317 - SELECT * FROM modules WHERE dirname = 'adslight'
0.000259 - SELECT * FROM modules WHERE dirname = 'contact'
0.000265 - SELECT * FROM modules WHERE dirname = 'pm'
0.000278 - SELECT * FROM modules WHERE dirname = 'news'
0.000341 - SELECT * FROM config WHERE (conf_modid = '78') ORDER BY conf_order ASC
0.000260 - SELECT * FROM modules WHERE dirname = 'mylinks'
0.000316 - SELECT * FROM config WHERE (conf_modid = '67') ORDER BY conf_order ASC