Contest System [support thread]

[skipwater]

This was the fix that I gave Tagyourbaby but he never came back.

Picture is worth 1000 words

See if this fixes your issue.

First thing backup your zencart database.
Use phpmyadmin open your zencart database locate the configuration table. Browse and find in the field configuration_key CONTEST_SHOW edit the date_added to at least the day before your contest started.

Let us know if that fixes it.

Skip

[TinMan780]

Hello Skip,

Thanks for the reply... Yes I did see that post, I just wasn't sure what it meant. I am not familiar with phpMyAdmin, and not sure how to implement it.

[skipwater]

Hello Skip,

Thanks for the reply... Yes I did see that post, I just wasn't sure what it meant. I am not familiar with phpMyAdmin, and not sure how to implement it.

OK no phpMyAdmin use ZC
Under ZC Admin go to tools->Install SQL Patches
And paste this into the window.

UPDATE `configuration` SET `date_added` = '2010-10-01 00:00:00' WHERE `configuration`.`date_added` !='2010-12-01 00:00:00';

That will set the date to 10.01.2010.

I you are going to use this fix this query will not work if it is run on 12.01.2010 00:00:00 The way today has gone someone will try.

Skip

[TinMan780]

OK no phpMyAdmin use ZC
Under ZC Admin go to tools->Install SQL Patches
And paste this into the window.

UPDATE `configuration` SET `date_added` = '2010-10-01 00:00:00' WHERE `configuration`.`date_added` !='2010-12-01 00:00:00';

That will set the date to 10.01.2010.

I you are going to use this fix this query will not work if it is run on 12.01.2010 00:00:00 The way today has gone someone will try.

Skip

Hey Skip, a page comes up reading...

1054 Unknown column 'configuration.date_added' in 'where clause'
in:
[UPDATE zen_configuration SET date_added = '2010-10-01 00:00:00' WHERE configuration.date_added !='2010-12-01 00:00:00';]
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.

[skipwater]

1054 Unknown column 'configuration.date_added' in 'where clause'
in:
[UPDATE zen_configuration SET date_added = '2010-10-01 00:00:00' WHERE configuration.date_added !='2010-12-01 00:00:00';]
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.

It looks like you are using a prefix of zen_ so try this.

UPDATE `configuration` SET `date_added` = '2010-10-01 00:00:00' WHERE `zen_configuration`.`date_added` !='2010-12-01 00:00:00';

Skip

[TinMan780]

It looks like you are using a prefix of zen_ so try this.

UPDATE `configuration` SET `date_added` = '2010-10-01 00:00:00' WHERE `zen_configuration`.`date_added` !='2010-12-01 00:00:00';

Skip

Yes Skip, that has resolved the date issue. It no longer reads 2036. However the "contest has ended" is still displaying over top of the contest that just ended and entry form.

[skipwater]

I have attached this zip file check_contest_files.zip.

Unzip the file and then upload it to your web sites admin folder.
To run log in to your ZC admin and then change the index.php to check_contest_files.php this will check that all the mod's files have been loaded into the correct locations.

Let me know what the out come is.

Skip

[TinMan780]

I have attached this zip file check_contest_files.zip.

Unzip the file and then upload it to your web sites admin folder.
To run log in to your ZC admin and then change the index.php to check_contest_files.php this will check that all the mod's files have been loaded into the correct locations.

Let me know what the out come is.

Skip

It reads all the files were found OK except:

........./myadmin/install-sql-contest-v1.6.php

[skipwater]

Question I see start date as October 01 2010 and ending date November 01 2010 is this true?

So if you go to admin->Configuration->Contests

Show contest invitation = true (If you turn this to false the contest page only shows CONTEST HAS ENDED?)

Prize 1 (product #)

Contest Start Date = 10/01/2010 (This is what you have set?)
Contest Close Date = 11/01/2010 (This is what you have set?)
Allow guest to enter contest = true
Allow customers to enter contest = true
Contest Reference Code = 0xx (Every new contest you are changing this value?)

Skip

[TinMan780]

Question I see start date as October 01 2010 and ending date November 01 2010 is this true?

So if you go to admin->Configuration->Contests

Show contest invitation = true (If you turn this to false the contest page only shows CONTEST HAS ENDED?)

Prize 1 (product #)

Contest Start Date = 10/01/2010 (This is what you have set?)
Contest Close Date = 11/01/2010 (This is what you have set?)
Allow guest to enter contest = true
Allow customers to enter contest = true
Contest Reference Code = 0xx (Every new contest you are changing this value?)

Skip

Those values are all correct, except when :

Show contest invitation = false (the page has no change, it is still displaying the contest that just past.

odd huh?