[eluser]ZeusChicago[/eluser]
Hum so I went in and added the following right after I do the $subModel->all();
$subModel->check_last_query();
and I get the following query which when run in phpmyadmin also returns 2 rows
Code:
SELECT `subscriptions`.*, `subscriptiontypes`.`ID` AS subscriptiontype_ID,
`subscriptiontypes`.`NAME` AS subscriptiontype_NAME, `subscriptiontypes`.`PRICE` AS
subscriptiontype_PRICE, `subscriptiontypes`.`displayname` AS subscriptiontype_displayname,
`subscriptiontypes`.`description` AS subscriptiontype_description
FROM (`subscriptions`)
LEFT OUTER
JOIN `subscriptiontypes` as subscriptiontypes ON `subscriptiontypes`.`id` =
`subscriptions`.`subscriptiontype_id`
WHERE `subscriptions`.`fa_user_id` =1
ORDER BY
`subscriptions`.`startdatetime` DESC
resultset (the ID's are differant)
Code:
ID fa_user_id subscriptiontype_id startdatetime enddatetime paypaldata subscriptiontype_ID subscriptiontype_NAME subscriptiontype_PRICE subscriptiontype_displayname subscriptiontype_description
33 1 3 2009-09-11 13:02:40 2009-10-11 13:02:40 mc_gross=4.99^|^protection_eligibility=Eligible^|^... 3 ONETIME 30|15.99 One Time Ad Select this package if you have just one ad you wo...
32 1 2 2009-08-04 10:59:19 2009-09-04 10:59:19 NA^|^NA 2 TRIAL 30|0|180|0|365|0 30 Day Free Trial We our offering, for a limited time a 30 day free ...
Maybe I botched the upgrade from datamapper to datamapper overzelous. Let me go down checking that route and will re-install the overzelous version from scratch.
Crosses fingers and hope this was an ID10T error on my part lol