osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 03-13-2006, 11:36 AM
Member
 
Join Date: May 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
dmiles
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 03-13-2006, 01:27 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,314
Thanks: 67
Thanked 321 Times in 304 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
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 Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 03-05-2007, 11:42 PM
Lurker
 
Join Date: Jan 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
dogdogscrew is on a distinguished road
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!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 02:34 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax