MYSQL Error

Discussion in 'Troubleshooting' started by endortrails, Sep 7, 2009.

  1. endortrails

    endortrails Guest

    Joined:
    Feb 2, 2009
    Messages:
    14
    Hi

    I'm getting this error on the default CPanel page:

    MYSQL ERROR:
    Out of memory (Needed 2091024 bytes)
    in query:
    SELECT FROM_DAYS(TO_DAYS(tm_added)) as date, count(payment_id) as added_count, sum(amount) as added_amount FROM amember_payments p WHERE tm_added BETWEEN '2009-08-31 00:00:00' AND '2009-09-07 23:59:59' GROUP BY date

    Kinda urgent. Thoughts?
  2. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    sounds like you have depleted the available memory set aside for php.

    You can try to create a file called php.ini in your need to do 1 of 2 things:

    1) create a file called php.ini in your \amember folder with:

    2) Let your host know what you are seeing (the "out of memory" error) and have them modify your allocated resources for your account.

Share This Page