Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Centershop sql errors


Guest

Recommended Posts

Ok, I'm trying to install the centershop contribution again and I'm still getting errors.

 

Error

SQL-query :  

INSERT INTO configuration_group
VALUES ( 16, 'Center Shop', 'Center Shop Module Integration', 16, 1 ) 

MySQL said: 


Duplicate entry '16' for key 1

 

I was suggested that I try changing all the 200's into 400, but then I get a 400 error saying it already exist. So, I really don't get it.

 

This is the contribution in question. I'm hoping that someone can give me some idea what's going on....

 

Here are some of the other contributions that I have installed on my site....

 

Featured Sets

Quick Updates

 

Now, I think that one of these two could be interfering with the sql file... Not sure how, but that's the only thing that makes sense to me! the featured sets used to be "entry 16" but I changed it to 15 as suggested in the past. But apparently that didn't change anything.

 

So, I beg you all to please help me figure something out!

 

Thanks as always!

Link to comment
Share on other sites

SQL-query :  

INSERT INTO configuration
VALUES ( 200, 'Center Shop on/off', 'CENTER_SHOP_ON', 'on', 'Turn on/off CenterShop.', 16, 1, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL , 'tep_cfg_select_option(array(\'on\', \'off\'),' ) 

MySQL said: 


Duplicate entry '200' for key 1

 

Now I get this error when I remove the 16... I really don't get this....

Link to comment
Share on other sites

in place of the 16 i wanted you to put ''

 

some of the problems when people write contributions, they dont take into account that the other numbers may have been used by a different contribution, so things conflict. if the 200 is also a # trying to be inserted which is duplicate, then use '' for it too.

Link to comment
Share on other sites

Hey Mibble,

 

Thanks for the quick reply! I've made the changes and this is what the code looks like now!

 

INSERT INTO configuration_group VALUES ('', 'Center Shop', 'Center Shop Module Integration', '' 1);

INSERT INTO configuration VALUES ('', 'Center Shop on/off', 'CENTER_SHOP_ON', 'on', 'Turn on/off CenterShop.', '', 1, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, 'tep_cfg_select_option(array(\'on\', \'off\'),');
INSERT INTO configuration VALUES ('', 'Shop width', 'CENTER_SHOP_WIDTH', '760', 'Shop Width.', '', 2, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Padding outside of shop.', 'CENTER_SHOP_PADDING', '10', 'Table Cellpadding', '', 3, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Outer background color.', 'CENTER_SHOP_BACKGROUND_COLOR_OUT', 'DFDFDF', 'Outer background color.', '', 4, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Border thickness.', 'CENTER_SHOP_BORDER', '1', 'Border thickness.', '', 5, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Border Color.', 'CENTER_SHOP_BORDERCOLOR', '000000', 'Border Color.', '', 6, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Thickness of cell walls', 'CENTER_SHOP_CELLSPACING', '0', 'cellspacing', '', 7, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Padding inside of cells.', 'CENTER_SHOP_CELLPADDING', '5', 'cellpadding', '', 8, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Background color on/off', 'CENTER_SHOP_BACKGROUND_ON', 'on', 'Use Backgroundcolor?', '', 9, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, 'tep_cfg_select_option(array(\'on\', \'off\'),');
INSERT INTO configuration VALUES ('', 'Color between border & shop.', 'CENTER_SHOP_BACKGROUND_COLOR', 'FFFFFF', 'Cellpadding Color', '', 10, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);

 

Now, what I'm getting is this error.

Error

SQL-query :  

INSERT INTO configuration_group
VALUES (

'', 'Center Shop', 'Center Shop Module Integration', ''1
) 

MySQL said: 


You have an error in your SQL syntax near '1)' at line 1

 

Now, I have no idea what I should be looking to change to make this work.

 

Thanks again for any help that you can provide!

Link to comment
Share on other sites

AAAAAAAARRRRRRRRRRRRGGGGGGGGGHHHHHHHHHH

 

Now I'm getting this error! I really hate this contribution!!!!

 

SQL-query :  

INSERT INTO configuration_group
VALUES (

'', 'Center Shop', 'Center Shop Module Integration', '1'
) 

MySQL said: 


Column count doesn't match value count at row 1

 

Got another suggestion?

Link to comment
Share on other sites

when I do a search for the centershop, I only get three options. Should I be searching for something else?

 

I wish I could help but when its installed it is a real nice feature....Mark

 

Is there a way you could start over from scratch? you know get rid of the sql file you uploaded and and start over...mine went in fine.....

The Hobby Undergound..."For The Pure Hobbyist"

Link to comment
Share on other sites

Ok, I finally found the contribution which John was talking about, but now the only thing that I don't like is that there's no border. I'm not sure what I could do to add one in.

 

What else would you suggest that I do to make it look right?

 

Thanks again!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...