bat out of database hell, sideways

in a new twist, the web designer that i worked with prior to the current web designer i work with — the one who blew a gasket for some still-unknown reason — was, as a part of what i was paying her to be a web designer, to delete the old web site files, once i had successfully been migrated to my new site.

unfortunately, apparently she blew a gasket before she actually did that.

and i didn’t know until… well… today.

my current web site is running PHP5, but there was an error which showed up in the log which was an uncaught variable that doesn’t exist in PHP5… in fact, it doesn’t exist until PHP7.4… and, upon further investigation, we discovered that it came from a document that is from osCommerce, which lead to other osCommerce documents, which lead, basically, to the entire osCommerce web site, which has been trying, and failing, to run PHP7.4, and generating WEIRD errors.

it had been beheaded — i.e. it didn’t have an internet-facing interface — but it is all still there.

it should be deleted. 😠

database hell updated

quoth the web developer: I’m going to guess, they’re going to come back and tell us they see nothing wrong. However, they will modify the server and then when I get back in there to test it again, it’s going to work. They just have a problem admitting when they’re wrong so they’ll fix it but tell us that it works fine.

quoth i: i don’t care how it’s fixed, i just want it to be fixed.

they have access to the dashboard, but they’re in a different time zone, so i have to be patient. 😒

ETA: i just got an email notification that says: A user with username “webhost-python” who has administrator access signed in to your WordPress site.

and then a note from YET ANOTHER technician who i HAVEN’T TALKED TO BEFORE (😠), who, apparently, tried the login, looked through the ticket history and decided that they don’t know enough to do anything about it, saying “I will assign this to our developers and they will get back to you.”

so, it begins…

tomorrow… 😒

database hell, okay?

i gave the web developer my login to the open support ticket at the host provider. there hasn’t been any obvious action yet, but i’ve emailed with the web developer, who worked out a temporary solution which may work out if his attempts to communicate with the host provider don’t work out… but, as i said, he hasn’t even logged in, much less done what the host provider asked of me, which was to “clearly lay out the issues you’re facing and the solution you need done to resolve this issue”.

210606 screenshot SQL error
210606 screenshot SQL error
the issues are that i can’t add new content (the “not HTML” difficulty and its results), and i get weird SQL errors, which only appear once, and then go away. i don’t get them on a regular basis: sometimes i get them the first time i hit the site, when i boot my computer in the morning, and sometimes i get them in the middle of the afternoon. frequently i get them when i’m hitting the base URI, but i’ve also seen them when i’m hitting deeper content.

i don’t know what the solution is, because i don’t know what is causing it. my web developer seems to think it’s the database engine at my host provider, because he has some sort of advanced tool that tells him when things aren’t working correctly. my host provider says he’s full of shit, that his proposed “upgrades” will break things for everybody else, and won’t even talk to the him unless he logs in as me. unfortunately, i know little enough about database engines that any input i can offer would be totally meaningless.

i feel a little bit better, because, now, instead of "doing this as a courtesy as this is not included as part of your Web Maintenance", they have now, actually charged me money, so i am, actually, paying them to fix my shit, and the temporary work around that he proposed, while not ideal, would certainly fix the problem for at least a year.

but i seem to recall going through another database fiasco last year around this time, and, if this is going to become a regular occurrance, i think i’ll pass, thanks. 😒

ETA: the web developer has logged in as me, and given a detailed description of exactly what is wrong, exactly why he thinks it’s wrong, examples of identical installations that follow his guidelines that don’t experience the problems i’m having, and a variety of different solutions to the problems he’s found. the host provider has yet to reply. because of the fact that they’re on eastern time, there’s a good chance we won’t hear anything until tomorrow.

blargh! 🤬

i’ve noticed a couple of things that are… screwy… about my web sites.

intermittently, i get random SQL errors. they only appear once, and when i reload the page, they disappear, but it’s sort of alarming.

and then there’s the “not HTML” FUMTU, which usually works, but has decided not to for a few days now.

so, i contacted my web developer, who said that my database needed “upgrading” to prevent these, and future problems.

not knowing that much about databases, i contacted my host provider, who said that the “upgrades” he proposed are actually DOWNgrades, and implementing them would break the databases for EVERYONE who shares the server i’m on.

so, i got back to the developer, who said that the reason he stopped using this host provider two years ago (which was about the same time i started using this host provider) was because “their policy” was to avoid communication with “third parties” (i.e. i’m a customer of the host provider, and the guy who i pay to know more about the web than me is a “third party”).

while they didn’t actually deny that this was “their policy”, the host provider went out of their way to emphasise that i am their customer, and if i wanted to include my web designer, i would have to give him my login, because they weren’t going to create a special login for him.

so i did that.

i figure, whatever happens, i can change my password once this whole thing is resolved. it is also A LOT easier than trying to convince the host provider to create a login for someone who is not a customer of theirs…

then they switched their tactics, and had a different technician chime in (one with whom i have not talked about this particular problem), who stated “let your developer know that it is already upgraded and using a stable version. If he is unable to diagnose this issue then another developer may be needed…”

this was AFTER i gave my web developer my login, so that he could participate in the “conversation”…

i wanted to say “HE’S RIGHT HERE! TALK TO HIM, NOT TO ME!!” 😠🤬😠🤬

but i didn’t…

but i wanted to… 😒

the web developer was busy yesterday, and (like most “businesses”) he doesn’t work on the weekend, so i’ve pushed back the impending storm until monday…

but…

the web developer has already said “we’re doing this as a courtesy as this is not included as part of your Web Maintenance” and “if they can’t do what we’re asking them to do our hands are tied.” AND the host provider has already said “we do not have a way to resolve something like this as the server itself is not causing the issue and the database server is already up to date.”, which gives me the very strong impression that, when monday comes around, the web developer is going to show up and make demands, the host provider is going to say no, and we’ll be right back where we started.

and all of this is IN SPITE of the fact that i am paying BOTH of these entities to make sure that my shit is kept up to date! 🤬🤬🤬🤬🤬🤬

🤬

this morning is the second in a row that i have woken up at 4:00 in the morning, and can’t get back to sleep. 😒

it is THIS EXACT PHENOMENON that makes me want to give up internet forever and go live in the woods, like a hermit, not interacting with anyone! 😠

when HTML is not HTML

i’m REALLY glad someone else is maintaining my business web site these days. 😒

seriously, if it had been left up to me, i would have given up a LONG time ago, and would probably be out of business, because the web design business has gotten REALLY confusing.

example: the places in WordPress where HTML code is not, actually, HTML code…

210603 not html
210603 not html

there are places which display HTML code, and where that code occurs on the back end, it is actually rendered as HTML code in the browser, but if you want to edit the HTML, you have to copy the ENTIRE page, go to another location (or use an actual text-based code editing tool) and paste the ENTIRE page into that location, make the edits, save them in that other location, copy them from that location, go BACK to the original location where you copied the original code from and paste the new code in, and THEN save the original location…? 😕

210603 not html rendered
210603 not html rendered
and, oddly enough, if you try to edit the HTML code without jumping through the copy/paste hoops multiple times, you end up screwing up the page entirely. 😠

and, to make matters even worse, as far as i can tell, there’s no way to tell which locations are HTML, and which locations only LOOK LIKE HTML… you’re just expected to know. 😠

as far as i can tell, backed up by a professional web designer who does this for a living, that’s the routine that works, and it has actually worked for me, in the past… but not this morning… which is frustrating beyond belief…

in my day, if something LOOKED LIKE HTML code, it WAS HTML code, and could be edited as such, wherever it occurred. 😠✊

failed login record:

the following login failures were counted on my server last month:

1167 from admin
938 from [login]
25 from przxqgl
11 from user
10 from root
6 from test

to reiterate what is now on my sidebar, my login is NOT “[login]”, “login”, “admin” or “przxqgl” — or “user”, or “root”, or “test” — and i automatically block the IP ranges of anyone who tries to guess my login, so you might as well try to break into someone else’s shit, ’cause it’s not happening here. 😒

woo hoo?

the first HPOI that i bought, way back in april of 2018, included 26 kg of MSD 7 “Africanas” Powers.

i bought it because, at the time, i thought it was a requirement to order more than one scent, when you’re ordering in bulk from the manufacturer. i now know this to be false. i made a number of assumptions about the first HPOI that i, now, know are false.

nevertheless, today, 3 years and a few weeks later, someone actually BOUGHT ONE POUCH of 7 “Africanas” Powers…

and, oddly enough, i still have pretty close to 26 kg left. my guess is that it’s going to last me a while. 😉

woo… and hoo… 😒

they’re starting the process of “permitting” buskers at the pike place market (i.e. they’re starting the process by which one applies for a “permit” to be a busker). 😒

because of COVID, they’re not actually allowing buskers at the pike place market… yet… but they’re starting the process of permitting them, so that when they get the okay from the health department, buskers can, officially, “return” to the market. 😒

but, if my memory serves, they’re only allowing tubas on a case-by-case basis, they’re not allowing any other cup-mouthpiece brass instruments of any kind, regardless of how quitely they’re played (but loud, obnoxious, reed-mouthpiece, brass saxophones are perfectly fine), and they’re not allowing ANY electronic amplification of any kind, for any reason. 😒

oh yeah, i forgot… technically, the “official rules” say “MUTED” tubas… i don’t actually own a tuba mute. very few tuba players i know own a tuba mute. tuba mutes can cost $300. i don’t know of a NON-tuba-player who can even describe what a tuba mute looks like… i’m not going to buy a tuba mute just to play at the pike place market. i’ve said it before, and i’ll say it again. tuba mutes are ridiculous! 🤬

not only that, but i no longer have a busking partner. 👎😒

so, do i apply for a permit, or not? 😒

😲

so, for some time now, i have wanted to make a reproduction of The Stele Of Revealing, and i got started the other day. but very quickly, i realised that, if i want to make it a “good enough” reproduction rather than a reproduction that would only look good if you didn’t look too closely, i would need to know the original dimensions, and have a reasonably accurate idea of what the heiroglyphs look like, and what the other artwork looks like, and i would, then, need to reduce them from their original size to the size that i ended up deciding i was going to make it — approximately a 40% reduction.

because i’m an artist, i know that, usually (in the absence of photocopiers, or proportional cameras), the tool used to make miniature reproductions is a proportional divider. i have used them before, know what they look like, and know that they can be very expensive. i didn’t want a really expensive one, but i also did not want something that somebody (most likely me) made out of plywood, because it wouldn’t be accurate enough, so i went to ebay, and discovered the exact tool i needed — from the picture, i deduced that it was, largely, the same tool i used in high school, when i was first learning about proportional dividers.

210515 proportional dividers
210515 proportional dividers

they arrived in the mail today. they are… um… not what i expected.

what arrived in the mail was a finely machined set of proportional dividers with sharpened tool steel points, and an engraved scale for both circles and lines. it is stamped “J.H.Weil & Co.” and it came in a velvet-lined case with antique gold writing on the outside that says U.S.C.E., which i take to mean U.S. Army Corps of Engineers… my impression is that, under normal circumstances, this could be as much as a $200 tool, but, because of the fact that it appears to be a vintage, military tool, it could be worth a lot more… this is a tool that is, pretty much GUARANTEED to be accurate to at least one thousandth of an inch… and it cost me less than $50!

so, i just wanted to give a shout out to Next Stage Vintage… they suprised the hell out of me! thank you! 😉👍

and i am going to use it to reduce The Stele Of Revealing… 😲

þe olde hear ȝe… ƿhat are ȝe talking about??

i’ve griped about this before, but it has surfaced again, so here’s another…

“ye olde” stuff, and people who yell “hear ye” are NOT using the same word, and it all has to do with three, but primarily two obsolete letters; ƿ which is called “wynn”, þ which is called “thorn”, and ȝ which is called “yogh”.

ƿ is pronounced like “w”. þ is pronounced as a voiceless “th”. ȝ is pronounced like “y”.

it also has to do with the fact that the letter “y”, itself, is a relatively recent innovation, and it wasn’t really decided exactly what the letter “y” was going to “do” until the late 1800s or early 1900s. prior to that time, the letters ƿ, þ, and ȝ were in reasonably common use, and people used “y” for wildly different reasons, depending on what flavour of proto-modern-english they were speaking.

“þe olde” is pronounced “the old”. when we were in the process of figuring out what “y” did, some enterprising printers got it into their heads that “y” could be used as a substitute for þ, and then things got out of hand.

again, while we were in the process of figuring out what “y” was supposed to do, the letter ȝ was falling out of fashion. “ye” — which was originally spelled “ȝe” — is the nominative case of the second person plural pronoun, which, in modern times, is “you”, and some other enterprising printers figured that they could use this new fangled “y” thingy as a substitute for ȝ, and, thus, instead of “hear ȝe”, we now have “hear ye”, even though the letter ȝ is actually more closely related to the modern letter “g”.

and then there’s ƿ, which sort of looks like “y”, if you squint — and, considering that corrective lenses were still a curiosity, there must have been A LOT of printers who couldn’t see very well. but the fact that it is pronounced like “w” means that it can only come down to stupid printers who didn’t know, or couldn’t see the difference, and mistakenly set ƿ as “y” as a typographical error.

and the fact that people don’t just KNOW this stuff is something i find very frustrating. 😒

bounded chaotic mixing produces what?

this is an example of bounded chaotic mixing producing strange stability:

210504 Carrey Creek, Taylor Mountain – Hobart, WAalthough it’s not as high resolution as i would have liked… however, at almost 500mb, i couldn’t be too choosy.

this exact phenomenon is what people are talking about when they’re talking about God, in whatever form. 😉👍

okay, there is a mathematical theory (which is NOT what most people THINK is a theory) which says “bounded chaotic mixing produces strange stability”.

i have gotten in trouble with mathematicians for “taking this too liberally”, but it works, regardless of what they think.

the theory is that if you have an instance of bounded chaotic mixing — in this case, the “chaotic mixing” of H2O molecules, “bounded” by the banks of the stream, that if you take away that boundary, temporarily — say, for example, a waterfall — that the boundaries will, more or less, hold, until that chaotic mixing is forced into another boundary. in the case of a waterfall, “bounded chaotic mixing produces strange stability” is the reason why you can stand fairly close to the base of a waterfall, without getting wet, but eventually — and nobody can tell exactly when, but the probability increases the closer you get — you WILL get wet.

men will be familiar with this phenomenon when they pee… 😉

in the case of this video, the bounded chaotic mixing is violently changing course, and the strange stability is, just before it does so, there’s a place where, even when the video is slowed down, you can see a roundish, perfectly clear patch of water, that stays more or less in the same place… strange stability: nothing is keeping it there, no bubbles go through it, even though, everywhere around it, are bubbles and ripples…

and it is exactly the same phenomenon that people are talking about, when they talk about God.

somebody else says “god” did it. i say, bounded chaotic mixing produces strange stability.

when i say i believe that God both exists, and doesn’t exist, at the same time, creating no contradiction, this is what i am talking about.

Evolution Control Committee

“What Would You Think If I Sang Autotune” by Evolution Control Committee.

“Whole Lotta Royalty Payments” by Evolution Control Committee.

i found this book in a “little free library” today… i’m having a lot of fun imagining what it COULD BE about… 😉

The Complete Book Of Meat
The Complete Book Of Meat

whoah!

i learned something about our neighbours down the street… 😲

i’m not going to say who or what, but it explains some things, and i feel REALLY sorry for some of the members of their family. 😟

i hope they get what they need, soon, although, at this point, it doesn’t seem very likely.

another one

i now have four people on the Incense Of The Month list, one of whom is a person i gifted a membership to… so, three “random” people, and one “deliberate” person.

it’s a REALLY good thing i decided to keep records, because, otherwise, i would already be completely hosed. i’m still not sure what to do at the end of this year, when my original two have run their course… of course, i will send 12 months worth of incense to everybody, regardless of when they signed up, but how to deal with the ones who chose to sign up after two, three or four months is something i didn’t think about when i was first starting this… i suppose i’ve got the rest of the year to figure it out, but that doesn’t mean leaving it until the middle of december before deciding, as tempting as that sounds…

it also means that there are only 21 slots left before i close the IOTM club to new entries… 😉

210423 trillia, elk ridge trail

trillium — picking parts off a trillium plant can kill it even if the rhizome is left undisturbed… so don’t. around here, they are T. albidum, T. ovatum, and T. petiolatum. all the ones pictured here are ovatum. 😉

210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail
210423 trillium, elk ridge trail

harvest

today i harvested 19.5 grams of bud from my two small, stressed plants. i planted them in 2020, shortly after we moved. one of our neighbours gave me a couple of clones from the plants that he had, which had already started to bud. i put them under lights, and, basically, forced them back into vegetative mode by changing the lights and lengthening the cycle, which made them start sprouting malformed leaves. then they got even more stressed because i had them under lights in the uninsulated garage, where the temperature regularly got down into the upper 30s for a few months, and the plants started turning purple… which is something i have read about, but never actually seen before. i didn’t expect much, but 19.5 grams is nothing to sneeze at. and, if the state of my fingers after harvesting them is any indication, i’ve got some sticky bud here… 😉

post-inaugural smoke-test, indicators are high! 😉👍👍

oh, and it’s legal, AND i have a permit to grow up to 15 plants! 😎

also, the 5 button head screws referred to here, FINALLY showed up… they left pacific NINE DAYS ago… i could LIMP there faster! honestly! i could DRIVE from my house to pacific and back at least 500 times in nine days! do better, UPS. 😒

victory is mine!

210421 repaired magnifying loupe
210421 repaired magnifying loupe
210421 repaired magnifying loupe
210421 repaired magnifying loupe
210421 repaired magnifying loupe
210421 repaired magnifying loupe

i got the nuts that fit the screws, i took the loupe part off the old, broken frames, and mounted it on the new, unbroken frames, with entirely new screws and nuts, and washers from the repair kit the denmat/perioptix people sent me. the new screws are TINY alan-key drive… mcmaster-carr doesn’t have philips-head screws that are 2-64… 😒 i don’t actually have an alan-key small enough to tighten them, but i’m pretty sure i got it tight enough with a wrench on the nut side. 🔧

ETA: it turns out i do have an alan-key that is small enough, and i did get it tight enough with a wrench… HOWEVER in my final look-over before i put it back in the box, i noticed something i hadn’t before, which is that the hinge is completely broken, and, while the repair kit they sent me has a replacement hinge, it’s actually the part of the hinge that is a molded part of the magnifier, itself, which means that i cannot fix it, because it is an integral part of the actual optical piece… replacement parts for which, i already know they no longer make. 😒

210421 eyebrow hole
210421 eyebrow hole

at this point, it’s still in one piece, and functional, so long as you don’t move the hinge around too much, but the hinge has already failed and cannot be repaired. it’s just a matter of time before the whole thing falls apart. 🤬

i also burned a hole in my eyebrow, when i was grinding down the screw so that it wouldn’t poke the wearer in the eye, and i put the frames on to test them too quickly after grinding… 😉

the enlightened rantings of a brain damaged freak