alexluft

Hey Hector — I installed the alpha and a few weeks after running it, got in trouble with the host again. Here’s their message as it relates to the query:

Problematic query:
SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL(v.pageviews, 0) AS 'pageviews' FROM wp_posts p LEFT JOIN (SELECT id, SUM(pageviews) AS 'pageviews', day FROM (SELECT id, pageviews, day FROM wp_popularpostsdatacache WHERE day > DATE_SUB('2012-06-26 13:18:26', INTERVAL 1 MONTH) ORDER BY day) sv GROUP BY id) v ON p.ID = v.id WHERE p.post_status = 'publish' AND p.post_password = '' AND v.pageviews > 0 GROUP BY p.ID ORDER BY v.pageviews DESC LIMIT 7

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY ALL 4342 Using where; Using temporary; Using filesort
1 PRIMARY p eq_ref PRIMARY PRIMARY 8 v.id 1 Using where
2 DERIVED ALL 112276 Using temporary; Using filesort
3 DERIVED wp_popularpostsdatacache ALL 112489 Using filesort

This query examines 54,838,656,573,688 rows, which is unacceptable in shared hosting.

Would really appreciate any and all help. Thanks so much!

Alex

Hi Hector — thanks for developing the plugin! We’ve been using it as part of our theme for the last two years and it’s been nothing but useful for our users! Unfortunately, it seems that our host has recently pulled down our database due to overloading the server.

According to them:

Problematic query:
SELECT wp_posts.ID, wp_posts.post_title , (SUM(wp_popularpostsdatacache.pageviews)) AS ‘pageviews’ FROM wp_posts RIGHT JOIN wp_popularpostsdatacache ON wp_posts.ID = wp_popularpostsdatacache.id WHERE wp_posts.post_status = ‘publish’ AND wp_posts.post_password = ” AND wp_popularpostsdatacache.day >= ‘2012-04-25’ – INTERVAL 30 DAY GROUP BY wp_posts.ID ORDER BY pageviews DESC LIMIT 7

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE wp_popularpostsdatacache ALL id 34841 Using where; Using temporary; Using filesort
1 SIMPLE wp_posts eq_ref PRIMARY PRIMARY 8 GMCweekly.wp_popularpostsdatacache.id 1 Using where

This query examines 34841 rows.

Since then, we’ve disabled the plugin so we could be put back up… but I was hoping there would be something you would recommend us do to work around the issue at hand.

Again, thanks for your hard work!

Alex

Any help? Bump.

Yea, same as internetgenius:

POP3 connect: Error [110] [Connection timed out]

Using ssl://pop.gmail.com
[email protected]
password

I have turned on POP access in Gmail settings.

Thanks for the reply!

That’s not what I’m trying to do.

I’m relocating from luftberg.com/technest to alexluft.com/blog.

Both domains are hosted on the same server (luftberg.com).

The problem is that when I export through WordPress export feature, it only exports some, not all, of my posts. I know this since when I import them into the new blog (at alexluft.com), only some of them get imported, ending a few months ago.

Thanks for any help.

Bump! Still need help please.

Hehe – I guess the tone in writing online comes out different than it does in person. Thanks for the heads up.

Here are the details:

Manage –> export feature on my current blog (luftberg.com/technest) only exports about 1/3 of my posts. I am going over to a new wordpress blog (alexluft.com/blog) and when I Manage–> import, only about 1/3 of my posts are imported.

I tried exporting out of technest using WordPress version 2, but have since then upgraded to the latest version as of this writing – 2.3.2. The new blog I tried importing on was version 2.0 and I tried importing to version 2.3.2 also, but with the same outcome.

Moreover, I have tried disabling all plugins and themes and exporting.

Also, I tried to export and then import through the SQL interface but all the posts were broken after import.

What else should I try?

Thanks everyone for your help and support, and sorry if the tone above was a rough; have been trying to figure it out for the last week! phew

I’m having the same problem. What is the deal here? Is there really no one who can help or even care to respond? I hear all these WordPress “developers” on so many podcasts I listen to talk about the latest plugin they’ve developed but what good is it when the blog software can’t even get something like “exporting” correct?!