chrometweaks.org

I need the best iPage web host (& domain) ever?

Click Here To View All Answers...


Got a quick question: I need the best iPage web host (& domain) ever? Hoping for any answer or 2. Another question... 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!..

Comments (34)

Good question... I dunno what is the answer. I'll do some research in Google and get back to you if I discover an decent answer. You should email the people at iPage as they probably could give you help..

Comment #1

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

Comment #2

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

Comment #3

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

Comment #4

I tried it again & I'm still getting the same error!.

Please help!.

Thanks a lot!!!..

Comment #5

'', 'Center Shop', 'Center Shop Module Integration', ''1.

Needs to be:.

'', 'Center Shop', 'Center Shop Module Integration', '1'..

Comment #6

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

Comment #7

What is it you are wanting to do, center sthe shop? there is a center shop css in the contributions which works..

Comment #8

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

Comment #9

I wish I could help but when it's 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.......

Comment #10

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

Comment #11

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

Comment #12

Remove the 16, just leave it as '' on the insert as something is already there...

Comment #13


This question was taken from a support group/message board and re-posted here so others can learn from it.