Contest System addon Error

[skipwater]

In your ZC admin->Tools ->Install SQL Patch insert this code.

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 ('', 'Display a qualifing question to enter contest', 'CONTEST_QUALIFY', 'true', 'Displays the qualifing question and only allows entry upon its completion', '35', 8, '2008-11-06 22:01:43', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

Let me know if this works let me know.

Skip

[ruralcraftsman]

I inserted this patch and ran it. Here's the error I got:

1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[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 ('', 'Display a qualifing question to enter contest', 'CONTEST_QUALIFY', 'true', 'Displays the qualifing question and only allows entry upon its completion', '35', 8, '2008-11-06 22:01:43', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');]
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.

Thanks for working with me on this.

[skipwater]

OK I have no idea why your system is throwing this error.

The configuration_id field is auto_incremented which seems to be the issue.

Again a new try:
Us phpMyAdmin and find the value of the configuration_id in the last record of configuration table. Take that number and add one (1) to it.
Now with your new number replace my example number with yours and run the patch again.


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 ('535', 'Display a qualifing question to enter contest', 'CONTEST_QUALIFY', 'true', 'Displays the qualifing question and only allows entry upon its completion', '35', 8, '2008-11-06 22:01:43', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

Skip

[ruralcraftsman]

Awesome. It worked. So now do I go and run the sql install for the rest? Thank you for your help. David

[ruralcraftsman]

Hi Skip, Could you help me out with the SQL syntax for the remaining?

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 ('1122', 'Contest Answer', 'CONTEST_ANSWER', 'B', 'Set the correct answer to your question', '" . $categoryid['configuration_group_id'] . "', 10, '2008-11-06 19:59:45', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''A'', ''B'',''C''),'); ";

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 ('1123', 'Contest Question', 'CONTEST_QUESTION', 'How Many Days in a week. A=5 B=7 C=8', 'Enter in the question text that will be displayed', '" . $categoryid['configuration_group_id'] . "', 9, '2008-11-06 21:50:50', '0000-00-00 00:00:00', NULL, NULL); ";

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 ('1124', 'Contest Reference Code', 'CONTEST_CODE', '001', 'Enter a unique code for this contest. Change this code each time you run a different contest.', '" . $categoryid['configuration_group_id'] . "', 7, NULL, '0000-00-00 00:00:00', NULL, ''); ";

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 ('1125', 'Allow customers to enter contest', 'CONTEST_ALLOW_CUSTOMERS', 'true', 'Allow registered customers to enter the contest', '" . $categoryid['configuration_group_id'] . "', 6, '2008-11-06 01:10:42', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); ";

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 ('1126', 'Allow guest to enter contest', 'CONTEST_ALLOW_GUESTS', 'true', 'Allow guest visitors to enter the contest', '" . $categoryid['configuration_group_id'] . "', 5, '2008-11-06 21:50:08', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); ";

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 ('1127', 'Contest Close Date', 'CONTEST_CLOSE_DATE', '11/30/2008', 'The close date of the contest (mm/dd/yyyy)', '" . $categoryid['configuration_group_id'] . "', 4, '2008-11-06 14:38:39', '0000-00-00 00:00:00', NULL, NULL); ";

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 ('1128', 'Contest Start Date', 'CONTEST_START_DATE', '11/01/2008', 'The start date of the competiton (mm/dd/yyyy)', '" . $categoryid['configuration_group_id'] . "', 3, '2008-11-06 14:37:39', '0000-00-00 00:00:00', NULL, NULL); ";

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 ('1129', 'Contest Date Display Format', 'CONTEST_DATE_DISPLAY_FORMAT', 'F d Y', 'Use normal date formatting code. Default is Long month - day leading zero - 4 digit year', '" . $categoryid['configuration_group_id'] . "', 3, '2009-09-09 14:37:39', '0000-00-00 00:00:00', NULL, NULL); ";

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 ('1130', 'Prize', 'CONTEST_PRIZE_ID', '2', 'The ID of the product that is being offered as a prize', '" . $categoryid['configuration_group_id'] . "', 2, NULL, '0000-00-00 00:00:00', NULL, NULL); ";

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 ('1131', 'Show contest invitation', 'CONTEST_SHOW', 'true', 'Displays the contest invitation box', '" . $categoryid['configuration_group_id'] . "', 1, '2008-11-06 22:15:35', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); ";

Thanks for your help. You're awesome.

David

[skipwater]

Awesome. It worked. So now do I go and run the sql install for the rest? Thank you for your help. David

Again you must change my example numbers you should notice that with each insert the number is plus one.

If you did not delete this one just skip this insert.
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 ('535', 'Display a qualifing question to enter contest', 'CONTEST_QUALIFY', 'true', 'Displays the qualifing question and only allows entry upon its completion', '33', 8, '2008-11-06 22:01:43', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
and start with this one below.
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 ('536', 'Contest Answer', 'CONTEST_ANSWER', 'B', 'Set the correct answer to your question', '35', 10, '2008-11-06 19:59:45', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''A'', ''B'',''C''),');
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 ('537', 'Contest Question', 'CONTEST_QUESTION', 'How Many Days in a week. A=5 B=7 C=8', 'Enter in the question text that will be displayed', '35', 9, '2008-11-06 21:50:50', '0000-00-00 00:00:00', NULL, NULL);
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 ('538', 'Contest Reference Code', 'CONTEST_CODE', '001', 'Enter a unique code for this contest. Change this code each time you run a different contest.', '35', 7, NULL, '0000-00-00 00:00:00', NULL, '');
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 ('539', 'Allow customers to enter contest', 'CONTEST_ALLOW_CUSTOMERS', 'true', 'Allow registered customers to enter the contest', '35', 6, '2008-11-06 01:10:42', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
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 ('540', 'Allow guest to enter contest', 'CONTEST_ALLOW_GUESTS', 'true', 'Allow guest visitors to enter the contest', '35', 5, '2008-11-06 21:50:08', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
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 ('541', 'Contest Close Date', 'CONTEST_CLOSE_DATE', '11/30/2008', 'The close date of the contest (mm/dd/yyyy)', '35', 4, '2008-11-06 14:38:39', '0000-00-00 00:00:00', NULL, NULL);
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 ('542', 'Contest Start Date', 'CONTEST_START_DATE', '11/01/2008', 'The start date of the competiton (mm/dd/yyyy)', '35', 3, '2008-11-06 14:37:39', '0000-00-00 00:00:00', NULL, NULL);
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 ('543', 'Contest Date Display Format', 'CONTEST_DATE_DISPLAY_FORMAT', 'F d Y', 'Use normal date formatting code. Default is Long month - day leading zero - 4 digit year', '35', 3, '2009-09-09 14:37:39', '0000-00-00 00:00:00', NULL, NULL);
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 ('544', 'Prize', 'CONTEST_PRIZE_ID', '2', 'The ID of the product that is being offered as a prize', '35', 2, NULL, '0000-00-00 00:00:00', NULL, NULL);
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 ('545', 'Show contest invitation', 'CONTEST_SHOW', 'true', 'Displays the contest invitation box', '35', 1, '2008-11-06 22:15:35', '0000-00-00 00:00:00', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

Remember you are Backing UP your database before these updates.

Skip

[ruralcraftsman]

Skip, It worked perfectly. Thanks a ton for working with me on this. I owe you. Regards, David

[ruralcraftsman]

Hi Skip,
I want assistance in transferring my web hosting to a new host. Could you tell me if you might be interested in doing this for a fee and if you are then how much do you want for the work. Thanks for your help.

Regards,

David

[skipwater]

David

Thanks for the offer but I must decline at this time.
As for transferring you site from one host to another is not that hard if you do your homework.
I can only suggest that the server that you get has the following software versions.

PHP == 5.2.9
MySQL => 5.0.51a

These seem to be the best version's for running ZC.

Maybe someone else will jump in and add to that list?

Skip