3253 replies to this topic

[kgt]

Libido, on Jun 8 2006, 02:18 PM, said:

I've just installed this coupon contribution and it's calling this error, when I go to>Products>Discount Coupon (to create the coupon/set parameters):
Discount Coupons  
1146 - Table 'libidolondon_com_-_store.discount_coupons' doesn't exist

select count(*) as total from discount_coupons cd

[TEP STOP]

Looks like you didn't run the SQL statements in the install instructions, or there was an error when you ran it.

[kgt]

tschreier, on Jun 9 2006, 03:57 AM, said:

And in the admin part I can't add new coupon discounts in the menu over sql it works !!

Do you get an error?  What happens?

[Cubez]

kgt, on Jun 9 2006, 03:40 PM, said:

Try adding this code:

if (!tep_session_is_registered('coupon')) tep_session_register('coupon');
  if (tep_not_null($HTTP_POST_VARS['coupon'])) {
	$coupon = tep_db_prepare_input($HTTP_POST_VARS['coupon']);
  }

BEFORE these lines:

require(DIR_WS_CLASSES . 'order.php');
  $order = new order;

Thanks! That worked like a charm.

I may have some answers too. When I first installed this contribution I couldn't create coupons either. It had something to do with the field values not being received. I changed all insert and update values in coupons.php to $_POST[""] values and then everything worked.

example

tep_db_input($coupons_description) . "', '" .
tep_db_input($coupons_discount_percent) ."', " .

to

tep_db_input($_POST["coupons_description"]) . "', '" .
tep_db_input($_POST["coupons_discount_percent"]) ."', " .

[kgt]

Cubez, on Jun 9 2006, 09:55 AM, said:

I may have some answers too. When I first installed this contribution I couldn't create coupons either. It had something to do with the field values not being received. I changed all insert and update values in coupons.php to $_POST[""] values and then everything worked.

Great, I'll make some changes to the checkout_confirmation that will hopefully solve this problem for everyone.  And I will make changes to the admin page while I'm at it.

[Libido]

kgt, on Jun 9 2006, 01:41 PM, said:

Looks like you didn't run the SQL statements in the install instructions, or there was an error when you ran it.

I did a manual install..since I'm not fluent in sql. (wouldn't know where to begin)

I've made the suggested mods :

tep_db_input($_POST["coupons_description"]) . "', '" .
tep_db_input($_POST["coupons_discount_percent"]) ."', " .

Still no ability to create a coupon. I'm getting this error:

1146 - Table 'libidolondon_com_-_store.discount_coupons' doesn't exist

select count(*) as total from discount_coupons cd

I've asked my server to checkout this string ie: libidolondon_com_store....since that seems to be what the error keeps calling. Any other suggestions greatly appreciated.

Kelly

[kgt]

Libido, on Jun 9 2006, 11:08 AM, said:

I did a manual install..since I'm not fluent in sql. (wouldn't know where to begin)

I've made the suggested mods :

tep_db_input($_POST["coupons_description"]) . "', '" .
tep_db_input($_POST["coupons_discount_percent"]) ."', " .

Still no ability to create a coupon. I'm getting this error:

1146 - Table 'libidolondon_com_-_store.discount_coupons' doesn't exist

select count(*) as total from discount_coupons cd

Step 3 of the instructions tells you that you need to run two statements via phpMyAdmin (generally available via your host's control panel).  You need to select your OSC database, then click the SQL tab along the top.  Copy and paste the following two statements into the text area provided and click Go.

Quote

**************** STEP 2 ****************
Create the database tables

Run these statements via the SQL tab in phpMyAdmin.


CREATE TABLE discount_coupons (
  coupons_id varchar(32) NOT NULL default '',
  coupons_description varchar(64) NOT NULL default '',
  coupons_discount_percent decimal(7,4) default NULL,
  date_start datetime default NULL,
  date_end datetime default NULL,
  max_use int(3) NOT NULL default 0,
  min_order decimal(15,4) NOT NULL default '0.0000',
  PRIMARY KEY  (coupons_id)
);

CREATE TABLE discount_coupons_to_orders (
  discount_coupons_to_orders_id int(11) NOT NULL auto_increment,
  coupons_id varchar(32) default NULL,
  orders_id int(11) default '0',
  PRIMARY KEY  (discount_coupons_to_orders_id),
  KEY coupons_id (coupons_id)
);

[Sigel]

Great contrib, thinking about installing it after the next update is released... one question I have is, I run the SPPC mod... will that conflict/affect it in any way?

thanks!

[Robomonkey3000]

Here's one I haven't seen mentioned. Thanks for this Contribution first of all. It looks like exactly what I need. Here's the problem...

Everything seems to Install fine, but when I go to Catalog> there isn't a tab for Discount Coupons. I know this must be something simple I'm overlooking. Help   . Thanks.

[Sigel]

maybe you missed the boxes/catalog.php edit....

[Libido]

kgt, on Jun 9 2006, 03:32 PM, said:

Step 3 of the instructions tells you that you need to run two statements via phpMyAdmin (generally available via your host's control panel).  You need to select your OSC database, then click the SQL tab along the top.  Copy and paste the following two statements into the text area provided and click Go.

Thanks so much KGT!!! Works like a dream now. (Just needed that SQL rock dropped on my head.

Kelly

[tschreier]

kgt, on Jun 9 2006, 01:44 PM, said:

Do you get an error?  What happens?

Over SQL it works very good but, in the admin section I have just the title stay in the DB all other fields are empty in the DB.

[kgt]

Sigel, on Jun 9 2006, 11:56 AM, said:

Great contrib, thinking about installing it after the next update is released... one question I have is, I run the SPPC mod... will that conflict/affect it in any way?

I cannot say for sure, but I strongly suspect it won't interfere at all.  When you insert the code, just double check that the code specified to be replaced is exactly the same in your file as it is in the text file.  Most of the code for coupon codes is purely added and doesn't replace existing code.

[kgt]

tschreier, on Jun 9 2006, 04:07 PM, said:

Over SQL it works very good but, in the admin section I have just the title stay in the DB all other fields are empty in the DB.

Install the latest version which was uploaded today and see if that fixes it.

[teleute]

Hi!  I'm so happy to see this contribution - I've been working on something similar, but kept getting sidetracked.  One odd bit of behaviour I'm noticing, though...

I've put the first coupon in and everything seems to work fine.  However, if I put in an invalid code, it returns to the payment page, shows the error message as part of the URL, but does not actually display it anywhere on the screen.  Any ideas?  Thank you!

[m_ring2003]

Hi,

this is a good contribution. I need a quick help though.

In Admin -> coupons.php, when I create a new Discount Coupon, the date shows is in MM/DD/YYYY.

How do I change to DD/MM/YYYY? My entire site is DD/MM/YYY. If i can mod this discount code contribution to be DD/MM/YYYY, that would be perfect.

Can someone please help n advise?

Many thanks.

[acastro2]

I had isntall this great contribution.... and seems to be working very good but some problem

the display text for "warnig" apper only on the browser address and no in the box down??? anything else it's just perfect.

besides I would like to know if there is the posibility to create coupons with fixed amount this will be nice.

thank you

[acastro2]

I had isntall this great contribution.... and seems to be working very good but with some problem

the display text for "warnig" apper only on the browser address and no in the box down??? anything else it's just perfect.

besides I would like to know if there is the posibility to create coupons with fixed amount this will be nice.

thank you

[acastro2]

I had isntall this great contribution.... and seems to be working very good but with some problem

the display text for "warnig" apper only on the browser address and no in the box down??? anything else it's just perfect.

besides I would like to know if there is the posibility to create coupons with fixed amount this will be nice.

thank you

[m_ring2003]

m_ring2003, on Jun 10 2006, 02:28 PM, said:

Hi,

this is a good contribution. I need a quick help though.

In Admin -> coupons.php, when I create a new Discount Coupon, the date shows is in MM/DD/YYYY.

How do I change to DD/MM/YYYY? My entire site is DD/MM/YYY. If i can mod this discount code contribution to be DD/MM/YYYY, that would be perfect.

Can someone please help n advise?

Many thanks.

Hi, even if u uninstall Discount Coupon from Order total modules,.. "Do you have a promotional code or discount coupon?" still appear in checkout_payment.php?

Anyone has any ideas how to change the date format for this contribution?

many thanks

[mpower]

I have installed the Coupons add-on which I really love only there is a small problem; everything works fine until the shopping cart is being passed through to PayPal. There I see the price without the discount.

Do you have any idea what I'm doing wrong ?