Results 1 to 3 of 3

SQl Query error

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: ...

      
  1. #1
    Member
    Join Date
    May 2004
    Posts
    31
    Rep Power
    0


    Default SQl Query error

    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. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,500
    Rep Power
    567


    Default RE: SQl Query error

    VALUES ('500'

    500 is already used. Change it to another higher number and try again. Try 800. Should work..
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Lurker
    Join Date
    Jan 2007
    Posts
    2
    Rep Power
    0


    Default Re: SQl Query error

    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!!

Similar Threads

  1. ssl query
    By Lara Croft in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 12-30-2006, 12:22 PM
  2. General Support Query
    By jarb in forum osCMax v2 Features Discussion
    Replies: 3
    Last Post: 11-24-2006, 05:59 AM
  3. Shooping Cart Query
    By kama_k in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 12-19-2004, 08:06 AM
  4. Mdb -> Insert Query -> mySQL -> I Happy !
    By damnedpig in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 07-29-2004, 10:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •