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