Modern Vespa

Created article What are all the Forum Awards & How do I get them?

(This message was automatically generated)

Uploading award images.

adding judy's red toaster
A Small Award for Our Friend Judy

adding MV Documentarista
the academy would like to recognize...

Awards in the fields of Art and Photography

Here are some reasonably-sized versions of the award artwork. I'll leave it up to berto as to whether to include it in the article or not.

Continued...

Awesome! Will do (traveling at the moment, but in a day or so when I return).

Hey Jess - I attempted to edit this article, and a couple of issues came up:

• No toilet paper award image - intentional, or did you just miss it?
• Upload error when I "submitted" the changes (screenshot below - I also saved full text of message, if needed)
  

Hmmm. Might have broken something. When was the last time an article got successfully edited?

(There is no large artwork for the TP award. Plus, we don't talk about it).

I was able to edit the existing article, and added the word "test" at the bottom. No issues. If you do have the text you tried to post, can you stick it in a post here on the discussion side? If it doesn't post here, there's definitely something wrong with it, though not sure what yet.

Similar errors here But the error message is more verbose, and specifically complains about the "--" part. So I guess it's something with SQL parameterization, and the internal slashes are being seen as comments and messing with the insert statement. I removed those characters, and other errors come about - this time I think it has to do with quote characters like in "Judy's", but I didn't quite pin it down.

I've attached the html and SQL, if it helps.

Testing 6:

(Judy's) Red Toaster -- Posthumously awarded to our very own Judy Rossman in remembrance of her contributions here. An homage to her long-standing red toaster avatar.

Okay, the problem is with the name of the attachment that's already been uploaded. It gets converted to an attachment tag (instead of a url) along with the original filename, which included an apostrophe. The apostrophe isn't getting escaped properly, leading it to barf on the SQL.

So a temporary fix is that I've taken the apostrophe out of the name of the original file upload -- if you quote my post above, you'll see an attachment tag, along with the name of the file, sans an apostrophe.

The correct fix is to figure out at what point that apostrophe needs escaping. It obviously made it into the attachment database with no problem -- my guess is that the conversion of an URL to an attachment tag needs some attention.

Oh, and you should be able to repost now. If you get another error, there's likely another apostrophe somewhere.

Okay, the correct fix is now also in place. Apostrophes in the filenames of attachment tags are now correctly escaped, and shouldn't produce any more errors.

Thanks much for pointing out this problem!

...

Excellent!

New award artwork. This is the "Broken Piston Award".

Thanks! I'll add it when I'm at my desk. (I see the related threads describing its purpose/ origin too.)