Using Affiliates table during installation before it's created (v 5.1.3-RC1)

4 views
Skip to first unread message

Alexander Obuhovich

unread,
Jul 15, 2011, 10:29:56 AM7/15/11
to In-Portal Bugs
I've noticed, that since 5.1.3 version we've got 1 more error during installation:

SELECT wbf_Affiliates.* ,(u.PortalUserId) AS `UserId`,(IF( LENGTH(u.Login), u.Login'')) AS `UserName`,(ap.Name) AS `PlanName`,(wbf_Affiliates.LastPaymentDate) AS `LastPaymentDate_date`,(wbf_Affiliates.LastPaymentDate) AS `LastPaymentDate_time`,(wbf_Affiliates.LastOrderDate) AS `LastOrderDate_date`,(wbf_Affiliates.LastOrderDate) AS `LastOrderDate_time`,(wbf_Affiliates.CreatedOn) AS `CreatedOn_date`,(wbf_Affiliates.CreatedOn) AS `CreatedOn_time`
    
FROM wbf_Affiliates
    LEFT JOIN wbf_PortalUser u ON wbf_Affiliates
.PortalUserId u.PortalUserId
    LEFT JOIN wbf_AffiliatePlans ap ON wbf_Affiliates
.AffiliatePlanId ap.AffiliatePlanId
    WHERE 
(`wbf_Affiliates`.PortalUserId '-1')
    
LIMIT 0,1


happening from OrdersEventHandler->isAffiliate method on "Modules to Install" step.


This is because installation wizard now uses the same method for logging user in as Front-End code. That's why I propose to skip affiliate checks during installation.


Dmitry A.

unread,
Jul 15, 2011, 10:38:50 AM7/15/11
to in-port...@googlegroups.com
Hi Alex,


Yes, this is a good idea to do that.

Please create a task/patch for it. This should be simple.


Cheers!

DA

Alexander Obuhovich

unread,
Oct 17, 2011, 8:49:45 AM10/17/11
to in-port...@googlegroups.com
Here is the task: http://tracker.in-portal.org/view.php?id=1144


--
You received this message because you are subscribed to the Google Groups "In-Portal Bugs Team" group.
To view this discussion on the web visit https://groups.google.com/d/msg/in-portal-bugs/-/mhJ4kdgys2UJ.
To post to this group, send email to in-port...@googlegroups.com.
To unsubscribe from this group, send email to in-portal-bug...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/in-portal-bugs?hl=en.
Reply all
Reply to author
Forward
0 new messages