-<package id = "postbooks-upgrade-451"
- version = "4.5.1"
+<package id = "postbooks-upgrade-470"
+ version = "4.7.0"
developer = "xTuple"
descrip = "load PostBooks resources"
updater = "2.2.4" >
</prerequisite>
<prerequisite type = "query"
- name = "Checking xTuple ERP database version" >
+ name = "Checking for too-old xTuple ERP database version" >
<query>SELECT fetchMetricText('ServerVersion') > '4.4.';</query>
- <message>This package must be applied to a 4.4+ PostBooks database.
+ <message>This package must be applied to a 4.4+ database.
</message>
</prerequisite>
<prerequisite type = "query"
- name = "Checking for bad xTuple ERP database version" >
- <query>SELECT NOT fetchMetricText('ServerVersion') > '4.5.1' AND fetchMetricText('ServerVersion')!='4.5.0Beta' AND fetchMetricText('ServerVersion')!='4.5.0RC';</query>
- <message>This package may not be applied to a 4.5.1+ Postbooks database.
+ name = "Checking for too-new xTuple ERP database version" >
+ <query>SELECT NOT fetchMetricText('ServerVersion') >= '4.8.0';</query>
+ <message>This package may not be applied to a database newer than 4.7.0.
</message>
</prerequisite>
</message>
</prerequisite>
- <prerequisite type = "query"
+ <prerequisite type = "query"
name = "Checking for duplicate Credit Card payments on Sales Orders" >
<query>
WITH counter AS (SELECT COUNT(*) AS freq
FROM payco
GROUP BY payco_ccpay_id, payco_cohead_id
ORDER BY 1)
- SELECT COALESCE(MAX(freq), 1) <= 1
+ SELECT (COALESCE(MAX(freq), 1) = 0 OR COALESCE(MAX(freq), 1) = 1)
FROM counter;
</query>
<message>There are duplicate payco_ccpay_id and payco_cohead_id on the payco table. Please see your system administrator or contact xTuple.