Author Topic: The Secret Lives of Common Symbols--DATABASE ERROR!!!  (Read 297 times)

0 Members and 1 Guest are viewing this topic.

Bilgemaster

  • Just some guy
  • Grand Gearhead
  • *****
  • Posts: 899
  • Karma: 0
  • 2005 Bullet 500ES in "Mean Green" Military Trim
on: February 07, 2019, 01:30:08 am
Tried another reply and got the database error .  >:(

A.


Ahoy Adrian II!  I believe I may have just stumbled onto the cause of your "database errors" whilst trying to cut-n-paste the text of an email I received from a countrywoman of yours concerning Haynes Manuals shown here. It's your baroque British apostrophes. I'd figured it had something to do with your posh keyboards, all reeking of Marmite and Lemon Curd instead of orange Cheez-Doodle dust as the Good Lord intended. Seems I'm right.

Remember how I mentioned in some other threads like this one how the new Forum system's character handling defaults to the ultra-primitivo Windows US Character Set ca. 1999, and anything else will give it indigestion? Well, the apostrophe you're using is what they call a "Typographic" or "Curly" one, whilst we here in the Colonies and in basic ASCII typefaces use the "Typewriter" or "Straight" one, which combined both the apostrophe as such and the single closing quotation mark on the keyboard.  There's more than you ever wanted to know on the matter beginning here in the Wikipedia article on the Apostrophe, as if this Forum hasn't already had enough discussion about them.

Suffice it to say that if you try respond to this posting with a simple "It's...", and it chokes, then we've maybe found your database fouling culprit. If so, then look around on the keyboard and see if there isn't some other workaround option for you. Or, perhaps I should just cross-post this into the Forum Improvements  section, assuming anyone who can do anything about it is even paying attention there.


...maybe time the database manager joined the 21st Century!
So badass my Enfield's actually illegal  in India.


Adrian II

  • Grand Gearhead
  • *****
  • Posts: 1,480
  • Karma: 0
  • Sharing my ignorance with anyone who needs it
Reply #1 on: February 07, 2019, 07:23:10 am
Have attempted this under the exhausting topic thread, q.v.

A.
Grumpy Brit still seeking 500 AVL Bullet perfection! Will let you know if I get anywhere near...


Richard230

  • Grand Gearhead
  • *****
  • Posts: 2,526
  • Karma: 0
Reply #2 on: February 07, 2019, 08:03:53 am
I too also get the "database error" message, both when I try to start a new thread, or attempt to reply to an existing thread. My observation is that it seems to happen whenever I use the "cut and paste" feature, whether the text is cut from another forum or cut from something that I typed first on my word processor.  However, I do not get the "error" if I type my message or reply from "scratch".   ???
2011 Royal Enfield B5 500, 2018 16.6 kWh Zero S, 2016 BMW R1200RS, 2009 BMW F650GS, 2005 Triumph Bonneville T-100, 2002 Yamaha FZ1


Bilgemaster

  • Just some guy
  • Grand Gearhead
  • *****
  • Posts: 899
  • Karma: 0
  • 2005 Bullet 500ES in "Mean Green" Military Trim
Reply #3 on: February 07, 2019, 08:48:32 am
I too also get the "database error" message, both when I try to start a new thread, or attempt to reply to an existing thread. My observation is that it seems to happen whenever I use the "cut and paste" feature, whether the text is cut from another forum or cut from something that I typed first on my word processor.  However, I do not get the "error" if I type my message or reply from "scratch".   ???

I imagine there may be some other "indigestible" character, symbol or perhaps some non-visible formatting code like a variant of "Carriage Return" (similar but yet different to [Enter]) lurking in your copied text and shitting the bed.

I cut and pasted that British email from MS-Outlook (ver. 10.6x, Enterprise Edition) into Notepad (ver. 5.1) and then into the Forum's text editing window. When I tried to [Post], the database error occurred. Once I had replaced all its apostrophes manually with those on my keyboard (PS/2 101/102 key, U.S. English), it accepted and posted it. I only noticed the difference in apostrophes after I had changed the font to Times New Roman. In whatever default sans serif font the Forum uses, the two different "apostrophes", Curly and Straight (sounds like a description of Moe's conflicted sexual orientation...though the hair was always a clue to those who really knew him), have an identical appearance.

The fact remains that the Forum is using an unnecessarily outmoded and primitive character-handling configuration...Not that I necessarily have anything against the "outmoded and primitive". After all, I ride an "Iron Belly" Enfield. If it ain't broke, don't fix it, I always say. But it IS clearly broke when folks cannot post. My hunch is that re-configuring this Forum to accept some flavor of Unicode would repair its woes, and also give me back my umlauts, accents and cent symbols, so I don't have to type like a troglodyte. I'm willing to shoot them another 5 buck donation if they'll use it towards fixing this problem.


"Are you saying?..." 
(Moe comes to terms with his true feelings)
« Last Edit: February 07, 2019, 09:50:00 am by Bilgemaster »
So badass my Enfield's actually illegal  in India.


Stogierob

  • Neophyte
  • *
  • Posts: 47
  • Karma: 0
Reply #4 on: March 23, 2019, 11:38:22 am
sadly, this issue is also a bane to anyone using a mac or ipad to post to the forum.  i've resurrected an old IBM laptop running Win7 so I can reliably post without frustration.  that the old ibm laptop isn't a source of frustration is probably why i also enjoy WWII reenacting and riding an RE...

i doubt this will be addressed from the server side until the next upgrade is applied to the forum. 

Rob
1977 RE Bullet 350 that is slowly being converted to resemble a WWII era bike...