This is a discussion on SQl Query error within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; I am installing the Minimum Product Quantity with Admin found at: http://www.oscommerce.com/community/...ns,2953/page,2 . When I try to run this query: ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| I am installing the Minimum Product Quantity with Admin found at: http://www.oscommerce.com/community/...ns,2953/page,2. When I try to run this 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 ('500', 'Minimum Orders', 'MINIMUM_ORDERS', 'true', 'Whether or not to enforce minimum orders', '1', '19', NOW( ) , NOW( ) , NULL , NULL); I get this error: #1062 - Duplicate entry '500' for key 1 I ran another query from the contribution successfully so, I think that I am using the correct procedures. Can anyone help me with the syntax of the query causing the error? Thanks for your help!
__________________ Learning osCommerce - a lifelong project? |
|
#2
| ||||
| ||||
| VALUES ('500' 500 is already used. Change it to another higher number and try again. Try 800. Should work..
__________________ Michael Sasek osCMax Developer
|
|
#3
| |||
| |||
| Ask for help when install this mod, after run sql in phpmyadmin 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 ('', 'Minimum Orders', 'MINIMUM_ORDERS', 'true', 'Whether or not to enforce minimum orders', '1', '19', NOW( ) , NOW( ) , NULL , NULL); **then returns** Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\phpMyAdmin\libraries\header_meta_st yle.inc.php:27) in C:\AppServ\www\phpMyAdmin\libraries\common.lib.php on line 1154 thank you!! |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ssl query | Lara Croft | osCMax v2 Installation issues | 2 | 12-30-2006 12:22 PM |
| General Support Query | jarb | osCMax v2 Features Discussion | 3 | 11-24-2006 05:59 AM |
| Shooping Cart Query | kama_k | osCommerce 2.2 Modification Help | 3 | 12-19-2004 08:06 AM |
| Mdb -> Insert Query -> mySQL -> I Happy ! | damnedpig | osCMax v1.7 Discussion | 1 | 07-29-2004 09:11 AM |