Done, DX.
'Potential'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Okay. Here are the goals:
- MARCIE -- implement according to previous specs, or revise specs if needed
- Database -- resolve MySQL fake connection pileup. Preliminary options are: restructure MySQL queries or change database back end (PostgreSQL suggested). A change of back end might have other benefits. Rob -- can you share with tommyrot what you gathered back when we were on Hostrocket/Kristen's server? Tommyrot, I've finished setting up a SQL test environment for you. A replica of this MySQL implementation is up and running, with the code dated as of today. PostgresSQL is running, but absolutely nothing is set up for it yet. I'll e-mail you the details.
ita, DX, insent.
Got it, Tom.
It works.
I took a look at that bad URL sitch with Jilli's post. See: DXMachina "Buffistas Building a Better Board" Mar 31, 2004 8:15:06 pm PST
The good news is that a post only becomes uneditable if the href URL opens with a single quote and ends with a double quote. If the reverse error is made, it can be edited and corrected by the user. Also, the problem *mostly* self-corrects after another post is made. The original post is still messed up, and part of the user/date stamp of the following post is messed up, but posts after that are perfectly normal and the rest of the page isn't affected.
The bad news is that I have no idea how to fix the problem by redesigning the page. I think we need a code fix, like a regex, to fix any badly formed href URLs that are entered.
One interesting thing about having a ton of newbies around is that they find lots of new and fascinating ways to break the board. In this post,
MFNlaw "The Minearverse: YExpirationDateMV" Apr 4, 2004 1:29:23 pm PDT
The line, "<I am REALLY upset by this. Anything I know about sentence structure seems to have flown out the window.>" was interpreted by the system as an italics tag.
I fixed the post. (edit: And then she did as well, deleting the line. Oh well.)
New Minearverse thread, please. (As I say this, I'm sure it's being created. Because ya'll are fly like that.)
When the Minearverse 'turned over' I was seeing three different post #10,000s (different users and text).
edit: still true. And FWIW, I had post 10,001, and now it's one of the post 10,000s.
And they were separated by 2 seconds each, even. Hmm.
AND they took the place of 9998 and 9999 instead of 10001 and 10002. Hmm again.
Sorry DX... :( I didn't mean to break the board.
ETA: Does this count as a trip into the guac?
-Maria