You are viewing page 3 of 203.

Good Friday

By Timothy R Butler | Posted at 12:23 PM

“For one will scarcely die for a righteous person—though perhaps for a good person one would dare even to die— but God shows his love for us in that while we were still sinners, Christ died for us.” (Rom. 5:7-8 ESV)

Journey through Jesus’s sacrifice with Little Hills.

Image

Resetting MySQL Primary Key in Chronological Order

By Timothy R Butler | Posted at 11:53 AM

As longtime readers of asisaid know, this blog — and my other sites — run a custom content management system called SAFARI that I started writing way back in 1999. For a long time, SAFARI evaded spam comments simply because most spammers targeted WordPress and other vastly more common CMSes. However, at some point in the mid-2010’s as I started serving as a pastor and professor, this blog went into something of a hibernation and the spammers went crazy with it. I later implemented more serious anti-spam measures, but there were already thousands of junk comments to deal with. I recently realized that my panicked hacking away at the comments back then wiped out nearly 4,000 early comments to the blog that were not spam.

I wanted to restore them from a backup I dug up, but since more comments have been posted since then, the unique id number given to each comment had been given away to other comments. The database table that stores the comments is set to auto-increment the ids, so I could remove the ids from the backed up comments before restoring them, but the result bugged me: older comments that were restored had higher id numbers than the newer comments. It didn’t ruin the function, but it bugged me.

So, I looked for a way to regenerate the unique ids and to do so in chronological order. I combined several of the answers on this Stack Overflow page to achieve the desired result:

SET @count = 0;
ALTER TABLE `uninet_comments` DROP `cid`;
ALTER TABLE `uninet_comments` ADD `cid` int UNSIGNED NOT NULL FIRST;
UPDATE `uninet_comments` SET `uninet_comments`.`cid` = @count:= @count + 1 ORDER BY `gmt` ASC;
ALTER TABLE `uninet_comments` ADD PRIMARY KEY(`cid`);

I figured I would share the queries I used in case anyone else needs to accomplish the same thing on a database.

Maundy Thursday

By Timothy R Butler | Posted at 10:58 PM

The last of the poisons in our series is “discord.” How do we know when we are causing discord and when we are standing up for what is good and righteous?

Steadfast

Overturning the Right Tables (March 29, 2021)

By Timothy R Butler | Posted at 9:41 PM

The last of the poisons in our series is “discord.” How do we know when we are causing discord and when we are standing up for what is good and righteous?

OFB

Are We Palm Sunday Followers of Jesus?

So Many Misunderstood Jesus Then and We Still Do Today

By Timothy R Butler | Posted at 3:27 PM

Palm Sunday was yesterday, marking the beginning of Holy Week. A week when Christians remember Jesus’s path toward crucifixion and His subsequent overcoming of death. While both Palm Sunday and Easter are filled with joy, the joy of Palm Sunday is striking in how the crowd was joyful – at least in part – for the wrong reasons.

Sunday Devotional

52 Verses, 52 Books, 52 Weeks (Week 13: 1 John)

By Timothy R Butler | Posted at 7:30 PM

Jim Krenning continues our adventure through Scripture with a special Palm Sunday edition of #ThisWeekAtLittleHills, looking at 1 John. Please join us!

Hailing Spring

By Timothy R Butler | Posted at 5:57 PM

Well, it is definitely spring here in Missouri. It just hailed for a very long time just now — and these hailstones are still relatively large after sitting in a downpour for about 10 minutes prior to when I went out to retrieve them. 😳 (The white stuff on the ground is more hail.)

Image

Steadfast

Are We Identity Thieves?

By Timothy R Butler | Posted at 7:00 PM

We would never steal… or would we? I continued the series “Six Poisons” this week as we turn to the topic of false witnesses and how we often steal something precious from those around us without even thinking about it.

Sunday Devotional

52 Verses, 52 Books, 52 Weeks (Week 12: 2 Thessalonians)

By Timothy R Butler | Posted at 8:08 PM

This week, I turned to Paul’s second letter to the Thessalonians as we continue our journey through 52 books of the Bible over the course of 2021!

TestyTim

Improving My Coffee Game

Testing the Miroco 1.7 Liter Electric Tea Kettle

By Timothy R Butler | Posted at 4:46 PM

I have slowly been trying to improve my home barista skills for years, using the delightfully clever Areopress to make coffee when I have time for more than my normal rush to Keurigland. Recently, I have added pour over coffee into my repertoire as well. Both methods have the “flaw” of being dependent on that old fashioned task of boiling water. Both are improved with an electric tea kettle like one Miroco provided for us to test.

You are viewing page 3 of 203.