NOTE: This topic has a wiki article associated with it. You may view it here.
OP
Mon, 21 Jun 2021 16:32:09 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Mon, 21 Jun 2021 16:32:09 +0000 quote
Created article What are all the Forum Awards & How do I get them?

(This message was automatically generated)
OP
Mon, 21 Jun 2021 16:42:34 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Mon, 21 Jun 2021 16:42:34 +0000 quote
Uploading award images.
OP
Tue, 22 Jun 2021 13:29:42 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Tue, 22 Jun 2021 13:29:42 +0000 quote
adding judy's red toaster
A Small Award for Our Friend Judy
OP
Wed, 30 Jun 2021 15:28:07 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Wed, 30 Jun 2021 15:28:07 +0000 quote
adding MV Documentarista
the academy would like to recognize...
OP
Sun, 11 Jul 2021 02:23:58 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Sun, 11 Jul 2021 02:23:58 +0000 quote
Awards in the fields of Art and Photography
⬆️    About 1y elapsed between posts    ⬇️
Mon, 26 Dec 2022 02:46:38 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Mon, 26 Dec 2022 02:46:38 +0000 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.
Mon, 26 Dec 2022 02:47:38 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Mon, 26 Dec 2022 02:47:38 +0000 quote
Continued...
OP
Mon, 26 Dec 2022 02:51:25 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Mon, 26 Dec 2022 02:51:25 +0000 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
Tue, 27 Dec 2022 12:42:54 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Tue, 27 Dec 2022 12:42:54 +0000 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)
Tue, 27 Dec 2022 15:59:29 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 15:59:29 +0000 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).
Tue, 27 Dec 2022 18:03:32 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 18:03:32 +0000 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
Tue, 27 Dec 2022 22:01:30 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Tue, 27 Dec 2022 22:01:30 +0000 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.
Tue, 27 Dec 2022 22:15:36 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 22:15:36 +0000 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.
Tue, 27 Dec 2022 22:18:51 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 22:18:51 +0000 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.
Tue, 27 Dec 2022 22:19:19 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 22:19:19 +0000 quote
Oh, and you should be able to repost now. If you get another error, there's likely another apostrophe somewhere.
Tue, 27 Dec 2022 22:57:37 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 27 Dec 2022 22:57:37 +0000 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
Tue, 27 Dec 2022 23:40:11 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Tue, 27 Dec 2022 23:40:11 +0000 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!
...
Wed, 28 Dec 2022 00:38:41 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Wed, 28 Dec 2022 00:38:41 +0000 quote
berto wrote:
...
Excellent!
Tue, 03 Jan 2023 00:36:10 +0000

Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
 
Petty Tyrant
0:7 And counting
Joined: Wed, 12 Oct 2005 05:12:11 +0000
Posts: 34939
Location: Bay Area, California
Tue, 03 Jan 2023 00:36:10 +0000 quote
New award artwork. This is the "Broken Piston Award".
OP
Tue, 03 Jan 2023 02:14:58 +0000

Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
 
Molto Verboso
2006 LX150 (carbed) | 2007 GT200
Joined: Wed, 29 Jun 2016 14:22:10 +0000
Posts: 1841
Location: Toronto
Tue, 03 Jan 2023 02:14:58 +0000 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  

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.


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-2023 by Modern Vespa. All Rights Reserved.

[ Time: 0.0416s ][ Queries: 4 (0.0198s) ][ Debug on ][ 286 ][ Thing Two ]