WordPress DB/Statraq

  • RobertBruce

    (@robertbruce)


    19 years, 5 months ago

    I get this error displayed at the bottom of my blog’s page:

    WordPress database error: [Out of memory (Needed 1048548 bytes)]

    SELECT COUNT(DISTINCT ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-12-19 10:27:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment”

    Where and how do I go about fixing the problem?

    I have deactivated Statraq (yes I know it is now an unsupported Plugin).

    Is it related to Statraq? I just assumed it was as Statraq reoports were displaying error messages too.

    So if you can itemise what I need to do to fix the problem I will be very grateful. I am not a coder or programmer.

    Thanks

Viewing 10 replies - 1 through 10 (of 10 total)
  • Samuel B

    (@samboll)

    19 years, 5 months ago

    What is being called at the bottom of your page? Is it from a plugin or something you’ve hacked?

    Thread Starter RobertBruce

    (@robertbruce)

    19 years, 5 months ago

    I have not hacked anything. Where must I check on which page? Classic or the Equix template?

    Thread Starter RobertBruce

    (@robertbruce)

    19 years, 5 months ago

    Just checked the Page and Main Index templates in the Equix theme folder. In the main index template, the footer and sidebar are being called.

    In the page, only the footer is being called.

    Samuel B

    (@samboll)

    19 years, 5 months ago

    Whichever template you’re using. It looks like a php memory error in which case you or your host will need to increase the php memory.

    Moderator Samuel Wood (Otto)

    (@otto42)

    ww.wp.xz.cn Admin

    19 years, 5 months ago

    Add this to the top of your .htaccess file:
    php_value memory_limit 20M

    Doesn’t always work, but sometimes it will.

    Thread Starter RobertBruce

    (@robertbruce)

    19 years, 5 months ago

    Otto,

    Great I’ll try it! Will post here again if it fails.

    Err it failed! Nice try.

    Samuel B

    (@samboll)

    19 years, 5 months ago

    Ask your host to increase it – most will.

    Thread Starter RobertBruce

    (@robertbruce)

    19 years, 5 months ago

    OK will ask them.

    Here is what I pick up from my admin stats.Current space usage:

    Disk Usage Viewer

    Directory Space Used
    public_html/wp-content 10.42 Meg
    mail/iscatterlings.com 6.22 Meg
    mail/new 3.20 Meg
    tmp/webalizer 3.16 Meg
    public_html/wp-includes 1.13 Meg
    public_html/wp-admin 1.09 Meg
    tmp/webalizerftp 0.61 Meg
    public_html/smilies 0.13 Meg
    mail/cur 0.08 Meg
    public_html/cgi-bin 0.04 Meg
    mail/.Sent 0.02 Meg
    mail/.Trash 0.02 Meg
    mail/.Drafts 0.02 Meg
    mail/courierimapkeywords 0.02 Meg
    mail/.spam 0.02 Meg
    public_html/iscatterlings 0.01 Meg
    etc/iscatterlings.com 0.01 Meg
    tmp/cpbandwidth 0.01 Meg
    mail/tmp 0.00 Meg
    public_ftp/incoming 0.00 Meg
    tmp/analog 0.00 Meg
    tmp/awstats 0.00 Meg
    .htpasswds/wp-stattraq 0.00 Meg
    .cpaddons/moderation 0.00 Meg
    .fantasticodata/temporary 0.00 Meg
    .fantasticodata/Joomla 0.00 Meg
    .fantasticodata/PerlDesk 0.00 Meg

    –

    Samuel B

    (@samboll)

    19 years, 5 months ago

    None of that has to do with php memory. Increasing the memory will not affect your storage space.

    Thread Starter RobertBruce

    (@robertbruce)

    19 years, 5 months ago

    Cool! OK I’ll mail them. Will let you guys know the result. meanwhile – thanks for your help and have a brilliantly nice and happy Christmas!

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘WordPress DB/Statraq’ is closed to new replies.