2012/01/11

Cannot create `tag` table in Magento installation with sample data

彈出的ERROR
Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘USING BTREE,
KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first’ at line 7

原來是MYSQL 5.0 和5.1 的SYNTAX問題, 升級到5.1可以解決問題, 或是用以下方法

solved this problem by changing:

PRIMARY KEY (`tag_id`) USING BTREE,
changed into
PRIMARY KEY USING BTREE (`tag_id`),

PRIMARY KEY (`tag_relation_id`) USING BTREE ,
changed into
PRIMARY KEY USING BTREE (`tag_relation_id`),

2012/01/10

改變sandbox testuser feedback score

原來可以出cheat 自行調教feedback score... 當然是在sandbox
api 名為 ValidateTestUserRegistration

<?xml version="1.0" encoding="utf-8"?>
<ValidateTestUserRegistrationRequest xmlns="urn:ebay:apis:eBLBaseComponents">
  <!-- Standard Input Fields -->
  <FeedbackScore>500</FeedbackScore>
  <RequesterCredentials>
    <eBayAuthToken>token</eBayAuthToken>
  </RequesterCredentials>
</ValidateTestUserRegistrationRequest>