Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter 040310b

    (@040310b)

    The “delete query” I was attempting in 1, above, worked, but, apparently, the entire category was deleted, instead of just tweets older than 400 days.

    What did I do wrong?

    delete a,b,c,d
    FROM wp_posts a
    LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )
    LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id )
    LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
    LEFT JOIN wp_terms e ON ( e.term_id = d.term_id )
    WHERE e.term_id =1772
    AND DATEDIFF(NOW(), <code>post_date</code>) > 400

    Separately, I tried the following phpMyAdmin query to merge my category 7 into my category 112731. Is the query correct, for that purpose?:

    UPDATE wp_term_relationships
    SET term_taxonomy_id = 112747
    WHERE term_taxonomy_id = 112748;
    Thread Starter 040310b

    (@040310b)

    I hear you, Joe.

    I understand. I am not really in a position to put a lot of time into posting to Twitter, “live”. Since I still have this particular website up, and the WP to Twitter plugin is active, on it, I was just thinking it would be “nice” if I could do something that would send Tweets in the “hourly limited” manner I initially described.

    I posted here, I guess, for the same reason most people post here; hoping someone might offer up a “solution” I could implement, myself.

    The website does not get any traffic, but I was just thinking that, potentially, the 1700, or so, Twitter followers I have might take to using my website; which, in turn, could have a very “outside chance” of creating a beneficial “opportunity” for me.

    Specifically, when those 7 tweets were inadvertently sent, linking back to posts on my website, 2 Twitter users actually marked one of the Tweets as a “favorite”. So, I thought about how many more “favorites”, on Tweets linking back to my website, I could get if I were able to set my website to automatically Tweet its FeedWordPress aggregated content 24 hours a day.

    Since, this is one of the fairly rare periods of time during which I am doing something with my website(s), I figured I would try to get a number of things going on it, including this.

    http://wordpress.org/support/topic/manipulating-categories-with-phpmyadmin

    Thread Starter 040310b

    (@040310b)

    Thanks for replying.

    I, very much, appreciate the functionality WP to Twitter provides.

    I actually lost my home of 17 years, however, and I am, more or less, living out of my 20 year old car trying, rather desperately, to get in a position where that is no longer necessary.

    You have no idea how much I am not in a position to get the PRO version.

    Thread Starter 040310b

    (@040310b)

    Yes, I found one of those plugins, after I posted in this thread, in response to your reply.

    Hopefully, I have successfully turned off all automatic updates on this particular site. Now, I must do the same on the others.

    // ** Turn off all automatic wordpress updates ** //
    /** all automatic updates disabled */
    define( ‘AUTOMATIC_UPDATER_DISABLED’, true );

    I read, very briefly, about using github with my wordpress sites, as recently as a couple days ago. I think that is a form of “source control”, but I lack “how to” knowledge, when it comes to using github in that manner, and about “source control”, in general.

    Hopefully, in the near future, I will have time to learn more about “source controlling” wordpress sites, to the extent that I can do so for my sites.

    Thread Starter 040310b

    (@040310b)

    Guess what. Earlier this week, a day or two after I successfully updated to 3.8.2, the LiteSpeed server, where my site is, started “throwing” 404 pages.

    I was, entirely, surprised by this, because I, typically, make “notes” for myself; however, none of my “notes”, or anything I could recollect, could explain these, apparent, server 404s.

    Even when I, finally, resolved the issue I was still perplexed as to how the problematic changes occurred, in the first place.

    Now I know. I believe this wordpress “auto-update” broke this particular site. I have been running wordpress blogs for a good number of years, and can not recall ever running into a situation like this.

    Indeed, a primary reason why I “manually” update is so that I can make notes for myself; especially, in order to quickly “reverse” changes, if I run into a problem.

    Thread Starter 040310b

    (@040310b)

    Thanks for replying.

    Based on the information you linked to, apparently, I can turn all auto-updates off; I will do so, right now, and add that to the list of things I do on new wordpress installs. Personally, one thing I detest, is auto-updates. I even turned “auto-updates” off for my cellphone, to the extent that is possible.

    I will turn “auto-updates” off on my other blogs running 3.7.x, or greater, as well

    Is there a plugin, yet, that makes it possible to turn off these “auto-updates” from the wordpress dashboard.

    Thread Starter 040310b

    (@040310b)

    Thankyou, again, for replying to my email. I am still kind of amazed at how quickly you replied.

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