error 127 from table handler

Discussion in 'Troubleshooting' started by underwing, May 7, 2007.

  1. underwing

    underwing New Member

    Joined:
    Feb 22, 2007
    Messages:
    1
    Sorry it's late and I'm just posting this before bed.

    I've just started to receive this error when accessing members details.


    Got error 127 from table handler
    in query:

    SELECT u.*, SUM(if(p.completed, 1, 0)) AS count_of_completed, SUM(if(p.completed, p.amount,0)) as summa_of_completed FROM membership_members u LEFT JOIN membership_payments p ON (p.member_id=u.member_id) WHERE 1 GROUP BY u.member_id HAVING 1 ORDER BY u.login LIMIT 0, 20

    I've had a quick look but cannot see it anywhere


    Regards

    John
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021

Share This Page