dhtml-coolmenu integration issue

[thecustomshop]

I attempted to install the dhtml and coolmenu combo contribution fount at http://www.oscommerce.com/community/contri...ns,1494/page,20. Everything loaded up fine as best as I can tell. The very last step calls for...

 

INSERT INTO configuration VALUES (231, 'Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', 1, 19, '2003-03-13 01:23:23', '2003-03-07 20:37:02', NULL, 'tep_cfg_select_option(array(\'Default\', \'Dhtml\',\'CoolMenu\'),');

 

When I log in to phpMyAdmin and run the string in SQL within the database, it returns...

 

MySQL said:

 

#1062 - Duplicate entry '231' for key 1

 

Do I need to use UPDATE instead of INSERT? Or will that throw off all my codes?

[thecustomshop]

Anyone? Help?

[Guest]

its a bug with the contribution. They hard-coded the configuration_id. Backup your dbase and use this one:

 

insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('', 'Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', '1', '19', NULL, now(), NULL, 'tep_cfg_select_option(array(\'Dhtml\', \'CoolMenu\'), ');

 

see if it works haven't tested it here, if so update the contribution instructions so others don't get the same problem.

[thecustomshop]

SQL query:

 

INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )

VALUES (

 

'', 'Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', '1', '19', NULL , now( ) , NULL , 'tep_cfg_select_option(array(\'Dhtml\', \'CoolMenu\'), '

)

 

MySQL said:

 

#1264 - Out of range value adjusted for column 'configuration_id' at row 1

[Guest]

SQL query:

 

INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )

VALUES (

 

'', 'Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', '1', '19', NULL , now( ) , NULL , 'tep_cfg_select_option(array(\'Dhtml\', \'CoolMenu\'), '

)

 

MySQL said:

 

#1264 - Out of range value adjusted for column 'configuration_id' at row 1

 

ok try:

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', '1', '19', now(), now(), NULL, 'tep_cfg_select_option(array(\'Dhtml\', \'CoolMenu\'), ')

[thecustomshop]

Wow, something new happened this time other then an error!!

 

Inserted rows: 1

Inserted row id: 1137 (Query took 0.0015 sec)

 

SQL query:

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )

VALUES (

'Enable Display a Dhtml menu', 'DISPLAY_DHTML_MENU', 'Default', 'Do you want to display a DHTML menu instead of the default text based?', '1', '19', now( ) , now( ) , NULL , 'tep_cfg_select_option(array(\'Dhtml\', \'CoolMenu\'), '

)

[Guest]

right so it's in. I tried both codes I posted and work here. In your case the 2nd one worked. Anyways that should be it.

[thecustomshop]

right so it's in. I tried both codes I posted and work here. In your case the 2nd one worked. Anyways that should be it.

 

I will update the contribution as soon as I can test.

 

Unfortunatly right now, the server is experiencing problems, so I cant test it.

 

Thanks for all your support though.

[thecustomshop]

The issue now is, there is no option to return to default... only DHTML and coolMenu.

[thecustomshop]

The issue now is, there is no option to return to default... only DHTML and coolMenu.

 

Anyone have any ideas how to alter the code to have the default settings as an option in thise feature?

[thecustomshop]

Still looking for input!