The Official Status Thread
-
@ben_lubar I'm getting the error on this piece of code:
$stmt = $this->database->prepare("Select * FROM completionreport WHERE assignment_id = ? ORDER BY completed_on"); //snip error handling $stmt->bind_param("s", $assignmentID); $result = $stmt->execute();
$this
is a repository class which has adatabase
member holding a reference to amysqli
instance. The database connection works fine--I can query anything else. The only thing I can find is thatcompletionreport
is a view.Directly querying
SELECT * FROM completionreport
works but the one above with parameters gives the error on the first call. It's only ever called once and from one place.
-
Status: saw this ad in my newsfeed.
Probably just me, but when I heard "50% off swimwear" I wasn't thinking of its price...
-
@anotherusername buy a woman, get a girl for free? What?
-
Nyaa~
-
@Benjamin-Hall I don't know mysqli's syntax for this, but it doesn't look like
s
is defined anywhere in the query.
-
@anotherusername said in The Official Status Thread:
Status: saw this ad in my newsfeed.
Probably just me, but when I heard "50% off swimwear" I wasn't thinking of its price...
Mmmmm
-
@ben_lubar said in The Official Status Thread:
@Benjamin-Hall I don't know mysqli's syntax for this, but it doesn't look like
s
is defined anywhere in the query.No, the s means string.
-
@Tsaukpaetra said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
@Benjamin-Hall I don't know mysqli's syntax for this, but it doesn't look like
s
is defined anywhere in the query.No, the s means string.
Right. As I understand it, that "s" means "the first parameter is a string." A perfectly obtuse way of doing things (the syntax for two strings followed by an int would be "ssi", but not the problem. I can use a prepared statement elsewhere calling a stored procedure, just not on a view it seems. Which makes the view less useful than it should be.
-
status: my bitch has a weird blood-blister thing on her breast area...
-
@Tsaukpaetra you mean like a hickey?
-
@Benjamin-Hall said in The Official Status Thread:
@ben_lubar I'm getting the error on this piece of code:
$stmt = $this->database->prepare("Select * FROM completionreport WHERE assignment_id = ? ORDER BY completed_on"); //snip error handling $stmt->bind_param("s", $assignmentID); $result = $stmt->execute();
$this
is a repository class which has adatabase
member holding a reference to amysqli
instance. The database connection works fine--I can query anything else. The only thing I can find is thatcompletionreport
is a view.Directly querying
SELECT * FROM completionreport
works but the one above with parameters gives the error on the first call. It's only ever called once and from one place.
Maybe I'm misreading, but you're calling "prepare" before "bind param"???
-
@Lorne-Kates
That's the correct way to do it in PHP -- you prepare the statement with its parameters, bind values to the parameters, and then execute the statement.
-
@izzion Same with JDBC
-
@Benjamin-Hall
Is this PHP PDO, a wrapper around PHP mysqli(), or something else?If it's PHP PDO, it looks like there's an option flag that should be used for MySQL (see the answer from ErickCarvalho - my guess is the name of the flag might vary based on your system language):
'options' => [ \PDO::ATTR_EMULATE_PREPARES => true ]
-
@anotherusername said in The Official Status Thread:
@Tsaukpaetra you mean like a hickey?
Unless the hickey was done by a mouse, probably not.
Would take a picture, but I'm not at home anymore and can't find the NSFL thread...
-
@dcon said in The Official Status Thread:
status Call back at 5p. (I'm on jury-duty-wait-and-see)
Update 1: Call back at 11a.
Update 2 (after 11): Call back at 5p. (whew, don't have to be there by 1p)edit: Hopefully the status will be the same tomorrow - I have to interview a candidate in the afternoon...
-
@izzion said in The Official Status Thread:
@Benjamin-Hall
Is this PHP PDO, a wrapper around PHP mysqli(), or something else?If it's PHP PDO, it looks like there's an option flag that should be used for MySQL (see the answer from ErickCarvalho - my guess is the name of the flag might vary based on your system language):
'options' => [ \PDO::ATTR_EMULATE_PREPARES => true ]
It was just using mysqli directly. I switched it to pdo and ended up having to enable that option. Seems there's a seriously long-standing "bug" in MySQL that makes prepared statements barf when someone using that server (which is a problem on shared hosting) is running a mysql_dump (backup process). The solution then is to tell PDO to just send raw SQL with the parameters properly inserted (and escaped). I guess that's my entry into the world of hating Oracle!
-
Status: Uh huh...
-
@Tsaukpaetra Results:
...
joined.
?
Hello and Welcome to our LiveChat! My name is Man and I'll be happy to assist you today.
Unfortunately, in a Shared hosting account details or logs of one particular account cannot be provided, @Tsaukpaetra. If you had a VPS/Dedicated hosting account, retrieving logs would be possible.
So details on who changed email forwarding or who reset such and such password is not available?
Unfortunately, no.
I'm speechless.
That's frankly horrifying to the seventh degree, actually.
I'm not talking about the hosted website, by the way.
I'm asking about the email forwards set up though https://my.bluehost.com/hosting/email_manager/forwarders
You don't keep records of that at all?
A forwarder once created can be deleted or edited anytime. There will be no track of it and it is just like a file in your computer, once deleted, it is deleted from the server so you will have to create it once again.
Did you have any other queries or concerns I can assist you with, today?
On the contrary to a file on my computer, there's certainly possibility to recover it.
I suppose my only other question is, can you forward this chat to the primary account holder?
The system froze on me. Well, you can let the account owner informed that due to the type of hosting account, the service they are requesting isn't available @Tsaukpaetra.
That's not really what I asked, I want this conversation forwarded to my@email.address.com .
...
? Hello?
Disconnected from the chat sessionSo: Anyone have good recommendations for a hosting provider that doesn't suck ass?
We really only need the site itself, dns, and email.
-
@Tsaukpaetra I use siteground.com and so far they haven't sucked. I don't use it heavily, so....
-
@Tsaukpaetra said in The Official Status Thread:
So: Anyone have good recommendations for a hosting provider that doesn't suck ass?
arvixe?
-
@Tsaukpaetra said in The Official Status Thread:
So: Anyone have good recommendations for a hosting provider that doesn't suck ass?
I just moved to GreenGeeks. They were very helpful at getting things set up. It's only been a month, so can't tell you about long-term... (they did have some good reviews)
-
@Lorne-Kates said in The Official Status Thread:
arvixe
Hmm...
Arvixe was founded by Arvand Sabetian in 2003, before later being acquired by EIG (who owns a TON of other hosting companies including Bluehost and even HostGator) in 2014.
Maybe it's just a face change?
@Benjamin-Hall said in The Official Status Thread:
@Tsaukpaetra I use siteground.com and so far they haven't sucked. I don't use it heavily, so....
Sounds promising, apparently $10/mo for the basic plan...
-
@Tsaukpaetra yeah, I'm on the even more basic plan (or got it on sale). I think I pay like $4/month. I think there's a discount if you pay for a year at a time.
-
@Tsaukpaetra said in The Official Status Thread:
Maybe it's just a face change?
Could be. I've been doing dev for a site that's been using arvixe since-- hmm-- 2014? Customer support has always been very fast to turn around. Maybe not as fast as before, but I have no experience with what "before" was like.
Site is running on a VPS. It gets a lot of traffic. Chugs along just fine. There's been maybe an outage or two, but still 99.99% uptime as far as anyone is concerned.
-
@Lorne-Kates said in The Official Status Thread:
Chugs along just fine
Yeah, it's not like the main site is really heavy either. I think the biggest problem is how terrible email is. For the half part, it seems to work ok for not so urgent things. But for anything more than basic "I followed a tutorial online to set up my own email server" tasks it's broken as fuck.
Like, I can't even use the myemail+category@domain.com trick, because apparently bluehost just drops those. That combined with lack of anything more than the most basic filtering controls or whatever, and I'm basically working out how to convince the boss to just move us into Google Apps (or, heck, even Exchange) just so I don't have to jank around with passwords and stuff to view other user's content.
It's just, the combination of web 0.9 technologies, lack of features introduced since the 90s, and overall user un-friendliness every time I have to deal with anything bluehost related...
I should be worrying about how I'm going to be implementing new features in our product, damnit, not trying to figure out if it's possible to audit-trail the fucking email provider!
-
Status: Testing the robustness of Amazon Cloud Drive's web uploader.
-
@Tsaukpaetra that's a really huge second floppy drive you have there.
-
status Internet Down at work
Backup link is prioritized for customer traffic ...
Stuff is generally not working. Except for people who have a 4G stick for work. Guess what I found ...
-
@Luhmann said in The Official Status Thread:
a 4G stick for work. Guess what I found ...
You found terminal zero where the worm was introduced? And it was on a 4G flash drive?
-
@Arantor said in The Official Status Thread:
@Tsaukpaetra that's a really huge second floppy drive you have there.
For now there's still about 2.2 TB left too!
-
@Tsaukpaetra
No, there was one ice cream cone left in the freezer
-
Status: WOOHOO!!! :D
-
Status: Getting to the end of a checkout process:
The process actually worked: the booking was successful. But still, poor form Silverstone, poor form.
-
Status: Got the official green light to move forward with the heretofore theoretical follow-up consolidation of an SQL 2014 server to the new SQL 2016 server that we just installed.
Less than 30 minutes into the prep research, have already found one show stopper with a third party application's databases and their lack of support for SQL 2016.
-
Status: Death to very long filenames! DEATH!
-
@dkf said in The Official Status Thread:
Status: Death to very long filenames! DEATH!
C:\Company Name Source Control\Company Name Git Provider\Company Name Department Name\Company Name Super Sekret You No Peak On Pain Of Being Fired Out Of A Cannon Into The Sun We Really Mean It Project Name\Company Name Super Sekret You No Peak On Pain Of Being Fired Out Of A Cannon Into The Sun We Really Mean It Project Name Root Solution\Company Name Super Sekret You No Peak On Pain Of Being Fired Out Of A Cannon Into The Sun We Really Mean It Project Name.sln
-
So close.
-
@RaceProUK said in The Official Status Thread:
Status: WOOHOO!!! :D
Huh. Who would have thought someone named RaceProUK would be excited for professional racing in and around the UK.
-
Well that was a weird guess.
caput (plural caputs or capita)
- (anatomy) The head.
- (anatomy) A knob-like protuberance or capitulum.
- The top or superior part of a thing.
- (Britain) The council or ruling body of the University of Cambridge prior to the constitution of 1856.
Yeah, none these "super cool" machine vision algorithms look at the "general shape" of the image the way humans do. That's why they are completely useless on line art.
-
@anonymous234 said in The Official Status Thread:
Yeah, none these "super cool" machine vision algorithms look at the "general shape" of the image the way humans do. That's why they are completely useless on line art.
???
But it's only trained on like, 100 different things...
-
-
@Tsaukpaetra said in The Official Status Thread:
But it's only trained on like, 100 different things...
"Not Hotdog"
-
Status: Looked at statistics for viewers of my audio-free Dwarf Fortress YouTube channel:
Status: Here, have some completely representative and not cherry-picked examples of Wolfram's image recognition AI:
-
@Atazhaia said in The Official Status Thread:
I would definitely not be fine to get back an inferior product to what I paid for.
Considering you bought an Apple product, isn't it already the case ?
-
STATUS
Tomorrow morning I'll test another job candidate. But since this guy is intern/junior, and I am super busy, it's gonna be an offline test. I'll send him the fruits link and he'll send in the solution in an hour or two.
If there's something interesting to see, I might post a quick post-mortum thread.
-
Tried to write a quick-and-dirty tar file extractor for an environment in which a library can't be used (no Internet access on the machine, no files in or out).
Hit a tar file entry in which the stated size is four bytes too long (the four extra bytes are NUL bytes) and thus remaining offsets to be wrong and the rest of the file breaks for me.
Opened the tar file in 7-Zip on another computer and it sees the same stated size (wondered if there was an edge case to deal with). But 7-Zip extracts it just fine, nonetheless. WTF is going on?! I can't just assume NUL bytes indicate end of file; that would break binary files! How did this happen, how the fuck do I deal with it, and how the fuck does other software deal with it?! Stupid fucking GNU bullshit.
-
@heterodox can you run any program on there? I suggest writing something in a language with a tar library and statically linking it.
-
@ben_lubar said in The Official Status Thread:
@heterodox can you run any program on there? I suggest writing something in a language with a tar library and statically linking it.
It's Windows. There's no built-in tar library that I know of to link against.
-
@heterodox said in The Official Status Thread:
Opened the tar file in 7-Zip on another computer and it sees the same stated size (wondered if there was an edge case to deal with). But 7-Zip extracts it just fine, nonetheless.
7 zip is open source, so in theory you could look at their code to see how they deal with it...