Contest System [support thread]

Hi Skip,

Yes if the fields are left blank the errors occur. Also if I leave the email address blank and fill in the name field I get the email error.

The only mod I'm using is the manufacturer's image mod.

Is their a way I can enable debugging so I can trace the sql insert line? What is the page name that inserts the name and email address of the contestants?

Also the "contest end page" displays despite an active contest running. But this is a minor problem because I can simply edit the end page to reflect an ongoing contest.

Thanks for all your help Skip..

Hi Skip,

I got everything working. Problem was I had the contest start date set to 11/01/10 yet the contest page was still active but posting will not occur. Also since the side box was active yet contest was out of date range the contest page appears active and the "end of contest" page is displayed prior. Since the contest page loads it implys the contest is active when it is not.

Thanks for the great app and support...

One quick question. How do I edit the "Enter our Contest" text?

Thank you.....

Hi Skip,

Also to avoid spam entries I would like to enable only registered users which I see is possible. However I would like to display the prize as a teaser then once they try to post at that point they are flagged to register. Currently as soon as they hit the "contest link" they are flagged to register with no indication of what the prize is.

Thanks for your help...

Hi Skip,

One more request if possible:). I can send in a donation if necessary. Any way to include the picture of the contest item in the side box, that would be a great teaser...

Sorry for all the posts...

Skip How much to add the Contest picture to the sidebox?. If this is possible then no need to modify contest page to include contest picture when allow guest is set to false..

Jim21:

Skip How much to add the Contest picture to the sidebox?. If this is possible then no need to modify contest page to include contest picture when allow guest is set to false..

This sidebox file will show the prize image with a link if the contest is active.

Unzip this tpl_contest_sidebox.zip and replace your /includes/templates/YOUR_TEMPLATE/sideboxes/tpl_contest_sidebox.php with this new file.

Skip

Thank you. That us really a great little app..

Tagyourbaby:

I got another competition going but when it ends the same problem will happen again...with the entry form underneath the "Contest Closed" how can this be fixed?

I am having this same problem.... the contest ended yesterday, and today it displays "contest closed", but with the entry form underneath.

I uninstalled all the files, then re-installed them, and still no luck.

Any Ideas??

thanks

Tagyourbaby:

View my website you can see its still got the option to enter even when the competition is closed.

In the admin when i update for a new competition, its not updating the storefront because its stating the last time it was updated was mm/dd/2036 so its not updating the contest due to it thinking we are in year 2036 not 2010. Same thing happens on both my stores.

I have just noticed, I too am having this same problem.. it is displaying 2036.

I have tried removing the files, and re-installing them. And still no change. Any Ideas?

Thanks

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

skipwater:

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

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.

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.

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

skipwater:

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.

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

skipwater:

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.

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

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

It reads all the files were found OK except:

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

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

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

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?