Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

#1170 - BLOB/TEXT column 'configuration_value' used in key specification without a key length


julio1

Recommended Posts

CREATE TABLE ebox_configuration(

 

configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_title text NOT NULL ,

configuration_key varchar( 255 ) NOT NULL ,

configuration_value text NOT NULL ,

configuration_description text NOT NULL ,

configuration_group_id int( 11 ) NOT NULL ,

sort_order int( 5 ) ,

last_modified datetime,

date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,

use_function text,

set_function text,

PRIMARY KEY ( configuration_id ) ,

KEY unq_config_key_zen( configuration_key ) ,

KEY idx_key_value_zen( configuration_key, configuration_value ) ,

KEY idx_cfg_grp_id_zen( configuration_group_id )

 

#1170 - BLOB/TEXT column 'configuration_value' used in key specification without a key length

 

 

I would like to know the problem of the sql database, can't install it,thanks very much for you help

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...