Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

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

 
Reply
   X-Cart forums > X-Payments > X-Payments issues & questions
 
Thread Tools
  #21  
Old 01-14-2014, 04:28 AM
 
carpeperdiem carpeperdiem is offline
 

X-Guru
  
Join Date: Jul 2006
Location: New York City, USA
Posts: 5,399
 

Default 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
__________________
xcart 4.5.4 gold+ w/x-payments 1.0.6; xcart gold 4.4.4
Reply With Quote
  #22  
Old 01-14-2014, 05:11 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following 2 users thank aim for this useful post:
carpeperdiem (01-14-2014), Dougrun (04-07-2014)
  #23  
Old 01-14-2014, 05:23 AM
 
carpeperdiem carpeperdiem is offline
 

X-Guru
  
Join Date: Jul 2006
Location: New York City, USA
Posts: 5,399
 

Default 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
__________________
xcart 4.5.4 gold+ w/x-payments 1.0.6; xcart gold 4.4.4
Reply With Quote
  #24  
Old 01-14-2014, 09:17 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following user thanks aim for this useful post:
carpeperdiem (01-14-2014)
  #25  
Old 01-19-2014, 10:26 PM
 
Stizerg Stizerg is offline
 

Senior Member
  
Join Date: Apr 2008
Location: Sydney, Australia
Posts: 195
 

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

Thanks guys, I even didn't know about this problem, it fixed now.
__________________
X-Cart Gold Plus 4.6.6
A lot of custom mods
Reply With Quote
Reply
   X-Cart forums > X-Payments > X-Payments issues & questions


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:26 PM.

   

 
X-Cart forums © 2001-2020