| ||||||||||
![]() |
Shopping cart software Solutions for online shops and malls | |||||||||
![]() |
![]() |
|
X-Cart Home | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Confirmed Bug - Customers Can't Pay partially with Gift Certificate | ||||
![]() |
|
|
Thread Tools |
#21
|
|||||||
|
|||||||
![]() Hi Alex,
Thanks for the vers 2 diff I have not applied it yet -- but looking at the sql patch --- Code:
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 |
|||||||
#22
|
|||||||
|
|||||||
![]() 1) You can run this query
Code:
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 |
|||||||
|
#23
|
|||||||
|
|||||||
![]() Quote:
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 |
|||||||
#24
|
|||||||
|
|||||||
![]() Quote:
And es is the other correct key for the email and status fields
__________________
Sincerely yours, Ildar Amankulov Head of Maintenance group |
|||||||
|
#25
|
|||||||
|
|||||||
![]() 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 |
|||||||
|
|||
X-Cart forums © 2001-2020
|