Contest System addon Error

[ruralcraftsman]

I keep getting this message when I run the sql code. The first time I installed this I entered text into one of the context fields without running the sql file.

Here's the message

Zen Cart Contest Version 1.6
Installing New Table and Admin Data
You have run INSTALL already if you need to re-run you must delete the contest table
Configuration Group `Contest` already exists SKIPPED
Contest Configuration_Group ID = 33
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', '33', 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.

Please help. Thank you.

[ruralcraftsman]

I keep getting this message when I run the sql code. The first time I installed this I entered text into one of the context fields without running the sql file.

thanks.

[stevesh]

Backup your database before any operations.

Someone who knows MySQL better than I do will probably be along with a statement that will drop the 'contest' table from your database, but you can also use phpMyAdmin in your hosting account's control panel to navigate to the 'contest' table and click 'Drop'. Then re-run the SQL for the mod.

[ruralcraftsman]

Thank you for helping out. I deleted the table through drop table in MyPhpAdmin. I ran it again. This time I got this message.

Zen Cart Contest Version 1.6
Installing New Table and Admin Data
tables_found = 0
New Contest Database Table Successfully Created.
Configuration Group `Contest` already exists SKIPPED
Contest Configuration_Group ID = 33
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', '33', 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.


I really think the words I have highlighted in Red are the problem. Thanks. David

[skipwater]

The sql errors that you are receiving is because the sql data is already in place.
Do you have under your admin the contest links? ie
Admin->Configuration->Contests
Admin->Reports->Contest Prize Entries
And you have configured your contest?

Could one of the forum admins move this thread to Contest System [support thread] Thanks

Skip

[ruralcraftsman]

Hi Skip, thanks for reaching out. I do see these two links
Admin->Configuration->Contests
Admin->Reports->Contest Prize Entries

but when I click on the Contest link under Configuration, it shows the header "contests" but then the rest is blank.

when I click on Contest Prize Entries under Reports, it brings up a page where it asks me if I want to setup a new contest. I go and set it up and when I hit confirm, it goes to a blank screen.

Any ideas?

Thanks for your help.

Regards, David

ps. Do you want me to enable the side box so you can check out the contest page live on my website?

Another thing I just realized. The very first time I did the install, I tried to set up the contest before installing the table. Do you think that messed everything up?

[skipwater]

As stevesh said BACKUP!! your sql data base.
Now using phpmyadmin or similar.
Under table configuration find these records (they should be the last records in this table and delete them.)
CONTEST_ALLOW_CUSTOMERS
CONTEST_ALLOW_GUESTS
CONTEST_ANSWER
CONTEST_CLOSE_DATE
CONTEST_CODE
CONTEST_DATE_DISPLAY_FORMAT
CONTEST_PRIZE_ID
CONTEST_QUALIFY
CONTEST_QUESTION
CONTEST_SHOW
CONTEST_START_DATE

Next
Under table configuration_group find the record.
Contests Contest Administraton and delete it.

Next find table contest and drop the table (Delete)

Now that is done run install-sql-contest-v1.6.php and you should get no errors.

Skip

[ruralcraftsman]

I went into the configuration table but i was not able to find any of these records

CONTEST_ALLOW_CUSTOMERS
CONTEST_ALLOW_GUESTS
CONTEST_ANSWER
CONTEST_CLOSE_DATE
CONTEST_CODE
CONTEST_DATE_DISPLAY_FORMAT
CONTEST_PRIZE_ID
CONTEST_QUALIFY
CONTEST_QUESTION
CONTEST_SHOW
CONTEST_START_DATE

so I did the other two steps

Next
Under table configuration_group find the record.
Contests Contest Administraton and delete it.

Next find table contest and drop the table (Delete)

and then I ran install-sql-contest-v1.6.php

Now I get this error

Zen Cart Contest Version 1.6
Installing New Table and Admin Data
tables_found = 0
New Contest Database Table Successfully Created.
Created New Configuration Group - Contest Administraton
Contest Configuration_Group ID = 35
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 your help. David

[skipwater]

What version of MYSQL are you running?

Skip

[ruralcraftsman]

MySQL 5.x