Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Peepo

Pioneers
  • Posts

    25
  • Joined

  • Last visited

Profile Information

  • Real Name
    Peepo

Peepo's Achievements

  1. Hello, I receive this error when trying to run the database query 'Error SQL query: Documentation CREATE TABLE extra_product_fields( epf_id int unsigned NOT NULL AUTO_INCREMENT , epf_order int NOT NULL default 0, epf_status tinyint( 1 ) NOT NULL default 1, epf_uses_value_list tinyint( 1 ) NOT NULL default 0, epf_advanced_search tinyint( 1 ) NOT NULL default 1, epf_show_in_listing tinyint( 1 ) NOT NULL default 0, epf_size tinyint unsigned NOT NULL default 64, epf_use_as_meta_keyword tinyint( 1 ) NOT NULL default 0, epf_use_to_restrict_listings tinyint( 1 ) NOT NULL default 0, epf_show_parent_chain tinyint( 1 ) NOT NULL default 0, epf_quick_search tinyint( 1 ) NOT NULL default 0, epf_multi_select tinyint( 1 ) NOT NULL default 0, epf_checked_entry tinyint( 1 ) NOT NULL default 0, epf_value_display_type tinyint( 1 ) NOT NULL default 0, epf_num_columns tinyint unsigned NOT NULL default 1, epf_has_linked_field tinyint( 1 ) NOT NULL default 0, epf_links_to int unsigned NOT NULL default 0, epf_textarea tinyint( 1 ) NOT NULL default 0, epf_show_in_admin tinyint( 1 ) NOT NULL default 1, epf_all_categories tinyint( 1 ) NOT NULL default 1, epf_category_ids text default NULL ); MySQL said: Documentation #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key ' Does anyone know what is going wrong?
×
×
  • Create New...