Contest System [support thread]

[skipwater]

With that many mods running I am unable to build a test site to debug the cause.
Maybe in time I will come across why this is happening to your site.
Or someone else has seen this before?

Skip

[divaboutiques]

Well thank you!

At least I tried to see how I can fix this problem for the contest section. I will just have to probably uninstall some of the module to test and see which one's are giving me this problem, and go from there.

But thank you again

[divaboutiques]

Well thank you skipwater-

At least I tried to see how I can fix this problem for the contest section. I will just have to probably uninstall some of the module to test and see which one's are giving me this problem, and go from there.

I'm going to start with these for right now and see what happens, and post something up if there was a change with me uninstalling the following. But deep down I'm thinking it's my wordpress for zencart that's causing the problem, but I will see once I uninstall

AskCost Automated Store Feed System API v1.0 for Zen Cart
Auction Lister Pro for Zen Cart
Better Together
Better Together Promotional Page
Ebay Exporter
eBay Exporter Configuration
FAQ module
Links Manager
News and Article Manager & Optional Sideboxes
Sitewide Mark Up
Ty Package Tracker
Yahoo! Product Submit Feeder

But thank you again

[skipwater]

That sounds great be sure to let us know the out come.

Skip

[divaboutiques]

Skipwater-

I made a discovery just now by turning my SEO url to false and my contest entry worked see screen print


Now I don't know what made me check that out, but now my contest entry is work properly, but as soon as I turn my SEO url on to true I get the error again?????

So I guess now we can go forward and try to resolve this issue, so I found the problem

Also if I try to re-enter I get this error

ERROR FALSE
iamtheultimatediva######################
test submission

1062 Duplicate entry 'iamtheultimatediva######################-August Con' for key 2
in:
[insert into zen_contest (contestant_name, contestant_email, contestant_ip_address, date_entered, validated, contest_code) values ('test submission', 'iamtheultimatediva######################', '63.80.205.5', now(), 'Y', 'August Contest 2009')]

[divaboutiques]

Skipwater-

I made a discovery just now by turning my SEO url to false and my contest entry worked see screen print


Now I don't know what made me check that out, but now my contest entry is working properly, but as soon as I turn my SEO url on to true I get the error again?????

Update:

Skip I got it working with the SEO url Now set to true....I noticed under "Enter pages to allow re-write I had the following entered

index, product_info, products_new, products_all, featured_products, specials, contact_us, conditions, privacy, reviews, shippinginfo, faqs_all, site_map, gv_faq, discount_coupon, page, page_2, page_3, page_4, ez_pages, about_us, unsubscribe, main_page, login, how_to_checkout, create_account, account, logoff, add_product, shopping_cart, checkout_shipping, links, links_submit, contest

Once I deleted the contest and went back to the contest page and enter the contest again with another email address it worked


Butttttt if I try to re-enter the contest again I get this error

ERROR FALSE
iamtheultimatediva######################
test submission

1062 Duplicate entry 'iamtheultimatediva######################-August Con' for key 2
in:
[insert into zen_contest (contestant_name, contestant_email, contestant_ip_address, date_entered, validated, contest_code) values ('test submission', 'iamtheultimatediva######################', '63.80.205.5', now(), 'Y', 'August Contest 2009')]

[divaboutiques]

Also when I go to the contest prize entries, I can't see any name or emails, this is how it looks, but there or entries setting there that i can't see

[skipwater]

I am glad you found the issue

You should have not gotten that error but this one "You are already entered in to this prize drawing."

Most likely trying to get it all to work the contest data is bad.

You might want to clear the contest data if you only have test records.
or
Use phpmyadmin and open the contest table.
When you look at the last field OMIT should have a '1' or 'W' or blank.

blank = active contest
1 = closed contest
W = winner of contest

If you replace all the blank fields with a 1 the contest will close and you will need to setup a new contest.

Skip

[bear1728]

hello, i love this mod, it works perfectly

one question:
what do i change the start and end date format to dd/mm/yyyy

or 09 SEPTEMBER_LANGUAGE 2009 will be better
(define SEPTEMBER_LANGUAGE of english file to September)

thanks

[skipwater]

hello, i love this mod, it works perfectly

one question:
what do i change the start and end date format to dd/mm/yyyy

or 09 SEPTEMBER_LANGUAGE 2009 will be better
(define SEPTEMBER_LANGUAGE of english file to September)

thanks

Edit file includes/templates/YOUR_TEMPLATE/templates/tpl_contest_default.php

Find anound line 18:

  $show_invite = false;
  $prossed_complete = 0;

Place this added code above it so it looks like this:

  $disp_start_date = date('d F Y', strtotime(CONTEST_START_DATE)); 
  $disp_close_date = date('d F Y', strtotime(CONTEST_CLOSE_DATE));

  $show_invite = false;
  $prossed_complete = 0;

Next find around line 180:

<!-- Display Prize -->
<hr>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="infoNotice" width=75% align="left" valign="top">
<?php
echo '<strong>Contest Starts: </strong>'.CONTEST_START_DATE.' 12:00am <strong>Ends: </strong>'.CONTEST_CLOSE_DATE.' 11:59pm<br/><br/>';
echo '<hr>';

Change CONTEST_START_DATE to $disp_start_date and CONTEST_CLOSE_DATE to $disp_close_date so it looks like this.

<!-- Display Prize -->
<hr>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="infoNotice" width=75% align="left" valign="top">
<?php
echo '<strong>Contest Starts: </strong>'.$disp_start_date.' 12:00am <strong>Ends: </strong>'.$disp_close_date.' 11:59pm<br/><br/>';
echo '<hr>';

Skip