X-Cart forums - Confirmed Bug - Customers Can't Pay partially with Gift Certificate

Page 3 of 3

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- X-Payments issues & questions (https://forum.x-cart.com/forumdisplay.php?f=50)

- - Confirmed Bug - Customers Can't Pay partially with Gift Certificate (https://forum.x-cart.com/showthread.php?t=68326)

carpeperdiem

01-14-2014 04:28 AM

Re: Confirmed Bug - Customers Can't Pay partially with Gift Certificate

Hi Alex,
Thanks for the vers 2 diff

I have not applied it yet -- but looking at the sql patch ---

Code:

Index: sql/xcart_tables.sql

--- sql/xcart_tables.sql

+++ sql/xcart_tables.sql

@@ -1582,7 +1582,8 @@ CREATE TABLE xcart_orders (

   KEY s_country (s_country),

   KEY b_country (b_country),

   KEY clickid (clickid),

-  KEY userid (userid),

+  KEY us (userid, `status`),

+  KEY es (email(64), `status`),

questions:

1. we are editing an installer file here. Do we also need to run an sql query to modify this table?
2. are we sure about KEY us and KEY es? Is this proper syntax?

Thx
J

aim	01-14-2014 05:11 AM

Re: Confirmed Bug - Customers Can't Pay partially with Gift Certificate

1) You can run this query

Code:

ALTER TABLE xcart_orders DROP INDEX userid, ADD INDEX us (userid, status), ADD INDEX es (email(64), status);

This change is optional.

2) This is the correct syntax
http://dev.mysql.com/doc/refman/5.1/en/create-table.html
us is the key name. It is formed as an acronym for the UseridStatus phrase.

carpeperdiem

01-14-2014 05:23 AM

Re: Confirmed Bug - Customers Can't Pay partially with Gift Certificate

Quote:

Originally Posted by aim

us is the key name. It is formed as an acronym for the UseridStatus phrase.

and es in the next line
+ KEY es (email(64), `status`),
? is that correct or should it be KEY us?

Thanks for clarifying this.
J

aim	01-14-2014 09:17 AM

Re: Confirmed Bug - Customers Can't Pay partially with Gift Certificate

Quote:

Originally Posted by carpeperdiem

and es in the next line
+ KEY es (email(64), `status`),
? is that correct or should it be KEY us?

Thanks for clarifying this.
J

And es is the other correct key for the email and status fields

Stizerg

01-19-2014 10:26 PM

Re: Confirmed Bug - Customers Can't Pay partially with Gift Certificate

Thanks guys, I even didn't know about this problem, it fixed now.

All times are GMT -8. The time now is 04:12 AM.

Page 3 of 3

Show 40 posts from this thread on one page