NOTE: This topic has a wiki article associated with it. You may view it here.
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
Created article What are all the Forum Awards & How do I get them?

(This message was automatically generated)
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
Uploading award images.
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
adding judy's red toaster
A Small Award for Our Friend Judy
Forum member supplied image with no explanatory text
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
adding MV Documentarista
the academy would like to recognize...
Forum member supplied image with no explanatory text
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
⬆️    About 1 year elapsed    ⬇️
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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.
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
Continued...
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
jess wrote:
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.
Awesome! Will do (traveling at the moment, but in a day or so when I return).
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
jess wrote:
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.
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)
Forum member supplied image with no explanatory text
Forum member supplied image with no explanatory text
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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).
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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.
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
jess wrote:
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.
Forum member supplied image with no explanatory text
txt
522kb
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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.
External inline image provided by member with no explanatory text
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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.
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
Oh, and you should be able to repost now. If you get another error, there's likely another apostrophe somewhere.
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
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!
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
jess wrote:
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!
Clap emoticon ...
Forum member supplied image with no explanatory text
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
berto wrote:
Clap emoticon ...
Excellent!
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36364
Location: Bay Area, California
UTC quote
New award artwork. This is the "Broken Piston Award".
Forum member supplied image with no explanatory text
OP
@berto avatar
UTC

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
 
Molto Verboso
@berto avatar
2006 LX150 (carbed) | 2007 GT200
Joined: UTC
Posts: 1894
Location: Toronto
UTC quote
jess wrote:
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.)
NOTE: This topic has a wiki article associated with it. You may view it here.
DoubleGood Design banner

Modern Vespa is the premier site for modern Vespa and Piaggio scooters. Vespa GTS300, GTS250, GTV, GT200, LX150, LXS, ET4, ET2, MP3, Fuoco, Elettrica and more.

Buy Me A Coffee
 

Shop on Amazon with Modern Vespa

Modern Vespa is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com


All Content Copyright 2005-2024 by Modern Vespa.
All Rights Reserved.


[ Time: 0.0377s ][ Queries: 9 (0.0092s) ][ Debug on ][ 309 ][ Thing One ]