View Single Post
  #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