Errors payment search with Free Signup filter

Discussion in 'aMember Pro v.4' started by rrddzzz, Feb 13, 2014.

  1. rrddzzz

    rrddzzz New Member

    Joined:
    Apr 15, 2011
    Messages:
    1
    We receive an error message when trying to search free signups in the payment section.

    The errors appear only for free signups that signed up after we upgraded to aMember Pr0 4.3.5.
    Free signups that were purchased before the upgrade do not produce the error.

    Anyone have a fix?

    ERROR MESSAGE:
    Not unique table/alias: 'ii' at /xxx/club/library/Am/Query.php line 53(1066) in query: SELECT SQL_CALC_FOUND_ROWS t.*,(SELECT GROUP_CONCAT(item_title SEPARATOR ', ') FROM am_invoice_item WHERE invoice_id=t.invoice_id) AS `items`,m.login AS `login`,m.email AS `email`,m.street AS `street`,m.city AS `city`,m.state AS `state`,m.country AS `country`,m.phone AS `phone`,m.zip AS `zip`,concat(m.name_f,' ',m.name_l) AS `name`,ii.item_title AS `item_title` FROM am_invoice t LEFT JOIN am_user m ON m.user_id=t.user_id LEFT JOIN am_invoice_item ii ON t.invoice_id=ii.invoice_id LEFT JOIN am_invoice_item ii ON ii.invoice_id=t.invoice_id WHERE ii.item_type='product' AND ii.item_id in ('69') AND paysys_id in ('free') GROUP BY t.invoice_id ORDER BY `invoice_id` DESC LIMIT 0,1


    TRACE:

    Exception Am_Exception_Db
    Am_Db::defaultDatabaseErrorHandler
    call_user_func [ library/DbSimple/Generic.php : 1244 ]
    DbSimple_Generic_LastError->_setLastError [ library/DbSimple/Generic.php : 861 ]
    DbSimple_Generic_Database->_setLastError [ library/DbSimple/Generic.php : 1481 ]
    DbSimple_Mypdo->_setDbError [ library/DbSimple/Generic.php : 1441 ]
    DbSimple_Mypdo->_performQuery [ library/DbSimple/Generic.php : 1505 ]
    DbSimple_Mypdo->queryResultOnly [ library/Am/Query.php : 53 ]
    Am_Query->query [ library/Am/Query.php : 76 ]
    Am_Query->getFoundRows [ library/Am/Grid/Action/Export.php : 73 ]
    Am_Grid_Export_CSV->run [ library/Am/Grid/Action/Export.php : 236 ]
    Am_Grid_Action_Export->run [ library/Am/Grid/Editable.php : 238 ]
    Am_Grid_Editable->actionRun [ library/Am/Grid/ReadOnly.php : 423 ]
    Am_Grid_ReadOnly->run [ library/Am/Controller/Pages.php : 126 ]
    Am_Controller_Pages->renderPage [ library/Am/Controller/Pages.php : 73 ]
    Am_Controller_Pages->__call [ library/Am/Controller.php : 118 ]
    Am_Controller->dispatch [ library/Zend/Controller/Dispatcher/Standard.php : 295 ]
    Zend_Controller_Dispatcher_Standard->dispatch [ library/Zend/Controller/Front.php : 954 ]
    Zend_Controller_Front->dispatch [ library/Am/App.php : 1916 ]
    Am_App->run [ index.php : 43 ]



    URL:
    /xxx/club/default/admin-payments/p/invoices/index?_invoice_filter%5Bproduct_id%5D%5B0%5D=69&_invoice_filter%5Bpaysys_id%5D%5B0%5D=free&_invoice_filter%5Bdatf%5D=tm_added&_invoice_filter%5Bdat1%5D=&_invoice_filter%5Bdat2%5D=&_invoice_

Share This Page