• Hi friends,

    Am facing an issue on my site, my site has been blocked by godaddy due to Problematic query, This query examines 532,215,396 rows, which is unacceptable in shared hosting.

    Problematic query:
    SELECT t.postcount AS total, d.postcount AS today FROM wp_cp_ad_pop_total AS t
    INNER JOIN wp_cp_ad_pop_daily AS d ON t.postnum = d.postnum
    WHERE t.postnum = 2689 AND d.time = ‘2012-06-05’

    EXPLAIN:
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE t ALL 1713 Using where
    1 SIMPLE d ALL 310692 Using where

    Am not a expert programmer, I guess this problem has come after i uploded one plugin, later i clicked one option to delete some data from that plugin. after that i lost connection with my site.

    just for more information i had added plugin transposh to convert content in different language, but later this plugin staterd giveing 404 error those error still going up and reached till 1,50,000 errors so i went and clicked auto deleted data.

    then my site got blocked. now above mentioned query and generated 532,215,396 rows hence my database is been blocked.

    if any one has any idea above this issue, plz help

    Kindly help me to solve this issue.

    http://wordpress.org/extend/plugins/transposh-translation-filter-for-wordpress/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author oferwald

    (@oferwald)

    Hi there,

    I don’t see how this query actually relates to Transposh, I have never seen Transposh generates half a billion rows anywhere,

    Please explain why this is an issue for us to handle?

    Thread Starter getliveads.com

    (@getliveadscom)

    Hi there,

    Thanks for replying.

    Am asking help from sources from were and how this issue generated. please dont take my wrong, am here just to take help. I will explain how this issue came up.

    firstly, my issue started when i uploded transposh plugin, it stated giving me 404 error, those link went up to 1,50,000 in 20 days.

    404 error links looks like this, it changed permalink like below and those all were giving error.

    http://www.Domain.com/da/ads/malaysia-day-tour-frim-rainforest-tour-kuala-lumpur-malaysia/
    http://www.Domain.com/vi/ads/manufactures-of-brass-copper-stainless-steel-strips-foils-in-sahibabad-ghaziabad-up/
    http://www.Domain.com/zh/ad-category/services/health-care/
    http://www.Domain.com/az/social-networking/

    To solve 404 error, I clicked on option “Delete all automated translation”, under database maintenance section.

    The movement i clicked my site got blocked and stated showing error and not able to connect to database.

    Now, I dont know were to get help from, is it wordpress or classipress theme which am using or from transposh plugin.

    please let me know if you can think of any solution to resolve my issue. I will really appreciate your help.

    Thanks

    Plugin Author oferwald

    (@oferwald)

    Hello,

    The 404 issue is something I can understand, assuming you had a url not translated, eg something like es/hello, enabling url translation would change this to es/hola

    What you did was not very good because you probably caused the new urls to generate 404s.

    This still does not explain the rest of the issues, unless you have some logging that freaks out with 404s…

    If you’ll provide more info I will see if I am able to help.

    Good luck,

    I’m stumped on trying to resolve the 404 errors when viewed in french. Enabling or disabling the “Change URL’s” feature makes no difference. Scratching head and searching the web, hopefully come across a fix. I absolutely love this plugin.

    oh,
    https://urbanassaultcellular.com is the url

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Transposh WordPress Translation] issue after i used transposh plugin – need help’ is closed to new replies.