Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

DineshM

Pioneers
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • Real Name
    Dinesh Mahbubani

DineshM's Achievements

  1. Hi Jim, There was a field missing in your script, I have highlighted below. However it appears that this issue arises all through the script. I have decided to roll-back and wait for the updated module to be posted because it is disrupting my setup. tep_db_query( "insert into " . TABLE_CONFIGURATION . " ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) values ( 'Version: " . $this->version . "', 'MODULE_HEADER_TAGS_THEME_SWITCHER_VERSION', '','', '6', '0', '', 'tep_cfg_do_nothing(', now() ) "); 1364 - Field 'configuration_title' doesn't have a default value insert into configuration ( configuration_key, configuration_group_id, sort_order, use_function, set_function ) values ('MODULE_HEADER_TAGS_THEME_SWITCHER_JQUERY_TEST', '6', '7', 'tep_jquery_check', 'tep_cfg_do_nothing(' ) [TEP STOP]
  2. Hi Jim A Similar error followed. (MySQL 5.1.39-community) I used Workbench6 to pull the create script and I see that NOT Null is specified on a lot of the fields. The DB creation was done by the current OScommerce automatic creation script. I thought about entering '' for configuration_description but then I don't know what would be the appropriate variable to use for date_added 1364 - Field 'configuration_description' doesn't have a default value insert into configuration ( configuration_title, configuration_key, configuration_value, configuration_group_id, sort_order, use_function, set_function ) values ( 'Version: 1.4.2', 'MODULE_HEADER_TAGS_THEME_SWITCHER_VERSION', '', '6', '0', '', 'tep_cfg_do_nothing(' ) [TEP STOP] CREATE TABLE `configuration` ( `configuration_id` int(11) NOT NULL AUTO_INCREMENT, `configuration_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `configuration_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `configuration_value` text COLLATE utf8_unicode_ci NOT NULL, `configuration_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `configuration_group_id` int(11) NOT NULL, `sort_order` int(5) DEFAULT NULL, `last_modified` datetime DEFAULT NULL, `date_added` datetime NOT NULL, `use_function` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `set_function` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`configuration_id`) ) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Thanks, Dinesh
  3. Hello, I have pushed up the three files: catalog/includes/languages/english/modules/header_tags/ht_theme_switcher.php catalog/includes/modules/header_tags/ht_theme_switcher.php catalog/includes/template_top.php Installed Version: osCommerce Online Merchant v2.3.3.4 When I click the install button I get: 1364 - Field 'configuration_value' doesn't have a default value insert into configuration ( configuration_title, configuration_key, configuration_group_id, sort_order, use_function, set_function ) values ( 'Version: 1.4.2', 'MODULE_HEADER_TAGS_THEME_SWITCHER_VERSION', '6', '0', '', 'tep_cfg_do_nothing(' ) [TEP STOP] Look forward t any help. Tanks
×
×
  • Create New...