SQL File Error - URGENT HELP NEEDED PLEASE

[Adds]

Hi All,

Can anyone help me to resolve this error at all. I'm trying to put the following sql database file in via admin for a new site design:

DELETE FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Tabbed Products Config' LIMIT 1;
DELETE FROM `configuration` WHERE `configuration_description` LIKE 'Set this to 1%' LIMIT 11;
INSERT INTO configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id FROM `configuration_group` where `configuration_group_title` LIKE 'Tabbed Products Config';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO configuration VALUES ('', 'Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Main Image On Tab', 'GLOBAL_MAIN_IMAGE_ON_TAB', '0', 'Set this to 1 if you want the product main image on the first tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Add To Cart Tab', 'GLOBAL_ADD_TO_CART_ON_TAB', '0', 'Set this to 1 if you want the add to cart button on a tab. Note this includes Add To Cart, Qty Discounts, and Option Attributes. The add to cart option will add itself to the first tab if using any custom tabs, otherwise it will make its own tab, which will be the first tab. This keeps the Add to cart button in view at all times no matter the configuration', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Additional Images Tab', 'GLOBAL_ADDL_IMAGES_ON_TAB', '1', 'Set this to 1 if you want the additional images for a product on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Customers Also Purchased Tab', 'GLOBAL_CUST_ALSO_PURCH_ON_TAB', '1', 'Set this to 1 if you want the Customers Also Purchased module on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Media Collection Tab', 'GLOBAL_MEDIA_COLLECTION_ON_TAB', '0', 'Set this to 1 if you want the Media Collection module on its own tab. (MUSIC PRODUCT TYPE ONLY)', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Cross Sell Is Installed', 'CROSS_SELL_IS_INSTALLED', '0', 'Set this to 1 ONLY if you have the Cross Sell contrib installed as per the Cross Sell contribs instructions. This will give an error if you enable this to true without already having it installed', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Cross Sell Tab', 'GLOBAL_CROSS_SELL_ON_TAB', '0', 'Set this to 1 if you want the Cross Sell module on its own tab. This will only work if the setting \"Cross Sell Is Installed\" above is set to 1', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers', 'SHOW_TAB_HEADERS', '1', 'Set this to 1 if you want a header bar to appear under the tabs, above the tab content', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers when Javascript is Off', 'SHOW_TAB_HEADERS_NO_JSCRIPT', '1', 'Set this to 1 if you want the header to appear under the tabs when javascript is off. This makes it look nicer and more organized if the customer has javascript off and separates each section with a header bar. Can be used even if the normal Show Tab Header is set to false.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Reviews Tab', 'GLOBAL_REVIEWS_ON_TAB', '1', 'Set this to 1 if you want the Product Reviews to show up on its own tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Use Sub Tags', 'GLOBAL_USE_SUB_TAGS', '1', 'Set this to 1 to allow the use of sub tags to allow more than one core module to appear on the same tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");

But when I copy and paste it then submit it I get the following error message:

1048 Column 'configuration_group_id' cannot be null
in:
[INSERT INTO zen_configuration VALUES ('', 'Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, '11', now(), now(), 1, "zen_cfg_select_option(array('0', '1'),");]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


What does this mean and how do I fix this?

Hope you can help.
Thanks,
Adam.

[Vger]

It means what it says - you have to give the configuration_group_id an id, or number e.g.

INSERT INTO configuration_group VALUES ('1', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');

Vger

[Adds]

It means what it says - you have to give the configuration_group_id an id, or number e.g.

INSERT INTO configuration_group VALUES ('1', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');

Vger

I get this error message then:

1062 Duplicate entry '1' for key 1
in:
[INSERT INTO zen_configuration_group VALUES ('1', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[DrByte]

You're trying to insert a '1' value when one already exists.
Try NULL instead of '1' if you want it to auto-select a group number.
Or, choose an unused one, and implement it consistently.

[Vger]

Obviously you have to give it a id (number) which does not already exist in the configuration_group table.

Working with SQL queries is something where you really need to know what you are doing. You can seriously mess up your website if you don't.

Vger

[Adds]

You're trying to insert a '1' value when one already exists.
Try NULL instead of '1' if you want it to auto-select a group number.
Or, choose an unused one, and implement it consistently.

NULL will not work just get the same error message, how do I know what number to use?

[DrByte]

NULL will not work just get the same error message, how do I know what number to use?

If the field is auto_increment, then NULL should work fine. If it's not auto_increment, you probably have several things broken in your database.

If you have to pick one, just pick one not already used !!

[Adds]

If the field is auto_increment, then NULL should work fine. If it's not auto_increment, you probably have several things broken in your database.

If you have to pick one, just pick one not already used !!

How will I know if there is an issue with my database? I have had no issues before just with the upload of this new template design???

Is there away of resolving this?

[Adds]

If you also take a look at the site www.electronic-web.co.uk you see that the images are missing at the top it should look like this http://www.zen4me.com/projects/newadam/

Whats gone wrong there?

[DrByte]

Sounds like you need to talk to whoever did the design and get them to assist you with installing it.