Wilde Times

Arts and Literature Newsletter

Archive for the ‘Tech Stuff’ Category

One more “fix” for the Shopp plugin

without comments

 

So this one isn’t really a Shopp issue. Those of you who’ve visited the store after I fixed it may have noticed that the main item image wasn’t lining up correctly. After a good long while of wracking my brain, a thought occurred to me. I changed the theme of the base blog, and, voilà, the misalignment was fixed.

Conclusion: Shopp does NOT work with the very cool Journalist theme. You’ll have to find a different very cool theme.

Written by Alex Kaulfuss

December 4th, 2013 at 4:03 pm

Posted in Tech Stuff

Some Excel Help

without comments

 

Checking column values against each other in Excel

Lo, what to do when faced with the question: How do I check to see if a value in one column shows up in another column in Excel?

There is an easy formula to check this.  Well, there are two, but they’re really the same thing; it’s just that one is pretty, and the other: not so much.

The first (pretty) formula is a little more complex, mainly because it’s backwards:

=IF(ISERROR(MATCH(A1,B:B,0)),” “,”WE HAVE A WINNAAHHH!!!”)

This formula says this: If there is an error when I try to match cell A1 to column B, do nothing; if, however, there is no error, say “We have a winnaahhh!!!”

The reason that I say it’s backwards is because the first set of quotes (the empty ones) says what to do if the value is true (i.e., there is an error because there is NOT a match), and the second set of quotes says what to do if the value is false (i.e., there is NOT an error because there is a match), and we generally think that if we’re looking for something, the fact that it’s there should make it true.

The second (easy) formula is a little uggo, mainly because it fills most of a column with this: #N/A.

=IF(MATCH(A1,B:B,0),”yes”,”no”)

This formula says this: If there is a match for cell A1 in column B, say “yes”; if there is not a match, say “no”.  NOTE: the “say no” part is irrelevant because if there is no match the formula will return an error (viz., #N/A). 

This formula seems more “forward” in that we’re looking for a match, and it will say “yes” if the match is true. 

FYI: you can replace what you want the formula to do when it finds a match with many things.  For example, if you want to make a list of repeats, you can replace the “we have a winnaahhh!!!” (or the “yes”) with A1 (no quotes).  This will copy the value in A1 into the new cell.

Counting up those bad boys.

Now you might be thinking: How do I determine the number of repeats in columns in Excel?

Now that you’ve identified duplicates, you may want to see how many there are.  This is pretty simple, too. 

=COUNTIF(C:C, “yes”)

This is assuming you’ve placed the formula in the above section in column C.  The equation says this: Include a cell in the counting if it says “yes”.

The last part can be changed to include variables, so let’s say it’s a list of emails; you can use this:

=COUNTIF(C:C, “*@*”)

This will count the number of times the at symbol shows up.  Use the * symbol to search for an unknown string and the ? symbol to search for one missing character.  For example, suppose you’re searching for a name beginning with “Pau”; “Pau*” will return names like Paul, Paula, Pauline, and Paunchy von Puncherson; whereas, “Pau?” would only return Paul. 

Written by Alex Kaulfuss

September 13th, 2013 at 5:56 pm

Posted in Tech Stuff

One liners and an &.

without comments

 

Hello, loyal readers (All three of you are very special to me.), I’m writing with another SHOPP for WordPress problem and fix to pass along to your friends.  After applying the fix I wrote about in my last post, users may have noticed an array of error messages preceding almost everything in the store.  All you have to do is change two tiny things, and the problem will be remedied.

First open the error.php file referenced in the error.  Follow the trail.  Then find lines 135 and 148-156.  Inert a new line 156 and write this: return $error;

Then go to line 236 which reads as follows:

call_user_func_array($callback,$args);

Now add an ampersand, like so:

call_user_func_array($callback,&$args);

Boom.  Fixed.  Hope that helps; pass it along!

Written by Alex Kaulfuss

January 29th, 2013 at 3:31 pm

Posted in Tech Stuff

What the deuce!?! It’s all because of an “E”?

without comments

 

If you’re running the WordPress SHOPP plugin and are getting error messages about JPEG support, you need to read this.  If neither of those conditions apply to you, you don’t need to read this, but you can if you want to see how ridiculously smart I can be sometimes.

Seeing the FATAL ERROR message can be terrifying to anyone trying to manage a web-based business without a crew of geeks on hand.  Recently, I tried to access my online store (SHOPP plugin through WordPress); I saw this message:

Shopp requires JPEG support in the GD image library. Your web hosting environment does not currently have a version of GD installed that has JPEG support.

While investigating this issue, which neither my host nor Shopp provided information about, I came across a site where someone suggested running a simple phpinfo script to take a look around.  Once I did, I noticed something amazingly simple and profoundly damaging: a missing letter.

Line 349 of Shopp’s function.php reads as follows:

if (!$gd['JPG Support']) $errors[] = __(“Shopp requires JPEG support in the GD image library.

When I ran the php info script, I noticed that the people at my host had decided to call the support for this image type “JPEG Support”, while the people at Shopp were calling it “JPG Support”.  Simply adding that missing “E” to line 349 fixed everything.  The line should read like this:

if (!$gd['JPEG Support']) $errors[] = __(“Shopp requires JPEG support in the GD image library.

Hope this helps someone.

Written by Alex Kaulfuss

January 28th, 2013 at 5:11 pm

Posted in Tech Stuff

If you don't see the WildeTimes menu to the left click here.