Contest System [support thread]

[divaboutiques]

Thank you
Thank you
Thank you
It worked!

[sonjamichelle]

Using:

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2009-03-10 15:49:55] (Fresh Installation)
Server OS: Linux 2.6.18-92.1.10.el5PAE
Database: MySQL 5.0.67.d7-ourdelta-log
Server Date: 03/15/2009 00:04:42
Database Date: 03/15/2009 00:04:42
Server Up Time: 00:04:42 up 10 days, 8:01, 0 users, load average: 2.35, 3.07, 2.52
HTTP Server: Apache
PHP Version: 5.2.8 (Zend: 2.2.0)
PHP Memory Limit: 64M
PHP Safe Mode: Off
PHP File Uploads: On
Max Size: 8M
POST Max Size: 8M
Database Data Size: 1,590 kB
Database Index Size: 909 kB


http://www.hillcountrytactical.com/catalog

When I try to enter the contest I get the following error.

1054 Unknown column 'contest_code' in 'where clause'
in:
[select count(*) as total from customers where customers_email_address = 'sonjamichelle######################' and customers_id = '0' AND contest_code = '25']

The "contest" table exists with columns:

id
contestant_name
contestant_email
contestant_ip_address
date_entered
validated
contest_code
OMIT


Searching the net, this error seems to stem from changes with "join" from ver 4 to ver 5.

I am NOT a SQL person so I don't even know where to begin to deug this.


One other problem I noticed is that when I goto the contest report screen and choose to add customers who purchased during the contest period, I see no customers to add.

[skipwater]

sonjamichelle

Open this file /includes/templates/YOUR_TEMPLATE/templates/tpl_contest_default.php
and find around line 96

$check_members_email_query = "select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . zen_db_input($entry_email_address) . "' and customers_id = '" . (int)$customer_id . "' AND contest_code = '" . CONTEST_CODE . "'"; 

Replace with this

$check_members_email_query = "select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . zen_db_input($entry_email_address) . "' and customers_id = '" . (int)$customer_id . "'"; 

Add Customers Button
There is no list created prior to the adding of customers to a contest.
If you wish to pick customers from a list, this can only happen after adding them to the contest. Then you can go through the list and delete the unwanted ones.

This patch and others will be added to the version 1.4 update.

[sonjamichelle]

Re: Patch

Worked like a charm!! Thank you very much!!

RE: Add Customers Button

On the adding of customers, when you goto the admin section from reports/contest prize entries, there's a add customers button. Clicking that button yields;

Contest Prize Entries
Add Entries for Existing Customers

Add entries for customers who have brought products during the contest period.

Contest Dates 03/10/2009 - 03/17/2009 Entrants Name Email Address

By the text of this page it makes me think that it will pull data on customers who made purchases and list them. I can then add them to the current contest from here based on the fact they made a purchase during the contest dates.

Did I misunderstand the purpose of this particular page?

The word in red; is that a typo?

Oh, just a possible bug heads up, nothing major. But if you choose not to use a qualifying question, the submit button disappears.

Again, thanks for the quick patch!!!!

[skipwater]

By the text of this page it makes me think that it will pull data on customers who made purchases and list them. I can then add them to the current contest from here based on the fact they made a purchase during the contest dates.

Yes it will pull data on customers who made purchases. By clicking the confirm button it will add them to the contest.

Thanks for the typo info 'brought' should be "bought".

Oh, just a possible bug heads up, nothing major. But if you choose not to use a qualifying question, the submit button disappears.

This was a known bug it has been fixed in version 1.4 I uploaded v1.4 today so give it a day or two and it will show up in the software add on section.

Skip

[ibparn]

Skip, I've been running it and it's been great. We are getting lots of "real" traffic and it's generating sales...

Thanks...
Ibparn

[skipwater]

Skip, I've been running it and it's been great. We are getting lots of "real" traffic and it's generating sales...

Thanks...
Ibparn

I am glad to here that in these hard times it is good to hear positive feed back.

Skip