OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Be back in a few hours, I hope.
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
So, the database upgrade did not go quite as planned. I had to roll back to the original and then make a few of the lesser mods that I had planned, but not the big MySQL version upgrade.

Anyway, we're back.
@znomit avatar
UTC

Veni, Vidi, Posti
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
 
Veni, Vidi, Posti
@znomit avatar
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
UTC quote
Yay!
@attila avatar
UTC

Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
 
Veni, Vidi, Posti
@attila avatar
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
UTC quote
The best thing about this change is that Jess came back to us more often, I felt like someone whose closest relative had gone far and you saw him every now and then.
With gratitude
Attilio Ferrari aka Attila
@attila avatar
UTC

Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
 
Veni, Vidi, Posti
@attila avatar
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
UTC quote
Jess .... does not make me edit the posts after entering them, I need it for grammar corrections otherwise I write bullshit.
@birdsnest avatar
UTC

Not So Moderator
VNB VSC 09C VMA VSX - vbc vmb
Joined: UTC
Posts: 7953
Location: Hustletown, TX
 
Not So Moderator
@birdsnest avatar
VNB VSC 09C VMA VSX - vbc vmb
Joined: UTC
Posts: 7953
Location: Hustletown, TX
UTC quote
^^^
Agreed. I noticed the same.
(The edit feature isn't functional... not that you write bullshit.)
@mr_f avatar
UTC

Hooked
2013 BV350
Joined: UTC
Posts: 445
Location: Sacramento, California
 
Hooked
@mr_f avatar
2013 BV350
Joined: UTC
Posts: 445
Location: Sacramento, California
UTC quote
Hi Jess!

I'm glad to discover that you are still with us and keeping busy. I've used this site and owned three scoots since discovering MV. Thanks to this site, I've learned so much to drive safely and maintain (yup, I wrench.) scoots. Thanks for everything.

Mark
Mr F.
@fledermaus avatar
UTC

Veni, Vidi, Posti
2007 LX150 2015 GTS (on the bench) 2017 BV 350
Joined: UTC
Posts: 11929
Location: Fond du Lac, Wisconsin
 
Veni, Vidi, Posti
@fledermaus avatar
2007 LX150 2015 GTS (on the bench) 2017 BV 350
Joined: UTC
Posts: 11929
Location: Fond du Lac, Wisconsin
UTC quote
Birdsnest wrote:
^^^
Agreed. I noticed the same.
(The edit feature isn't functional... not that you write bullshit.)
Laughing emoticon Laughing emoticon
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Sorry, folks! I busted the Lambretta.

Trying to figure out what went wrong.
@attila avatar
UTC

Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
 
Veni, Vidi, Posti
@attila avatar
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
UTC quote
Indeed it seems that the expression on your avatar's face has changed ...
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
@syd avatar
UTC

Ossessionato
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: UTC
Posts: 4705
Location: Tempe, AZ
 
Ossessionato
@syd avatar
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: UTC
Posts: 4705
Location: Tempe, AZ
UTC quote
Nice picture of Patrick. Good to see him pop up too.
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
@syd avatar
UTC

Ossessionato
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: UTC
Posts: 4705
Location: Tempe, AZ
 
Ossessionato
@syd avatar
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: UTC
Posts: 4705
Location: Tempe, AZ
UTC quote
jess wrote:
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
Good one. I noticed the two-time Cannomball SYM in the background too. I'd bet Patrick could'a done it!
@old_as_dirt avatar
UTC

Veni, Vidi, Posti
2007 GTS
Joined: UTC
Posts: 22412
Location: Harriman, Tennessee, Tn
 
Veni, Vidi, Posti
@old_as_dirt avatar
2007 GTS
Joined: UTC
Posts: 22412
Location: Harriman, Tennessee, Tn
UTC quote
wow its slower now than before
@old_as_dirt avatar
UTC

Veni, Vidi, Posti
2007 GTS
Joined: UTC
Posts: 22412
Location: Harriman, Tennessee, Tn
 
Veni, Vidi, Posti
@old_as_dirt avatar
2007 GTS
Joined: UTC
Posts: 22412
Location: Harriman, Tennessee, Tn
UTC quote
speed has picked up ALOT. thank you
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
old as dirt wrote:
speed has picked up ALOT. thank you
Fingers crossed. I am not entirely sure this is going to continue to function.
@znomit avatar
UTC

Veni, Vidi, Posti
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
 
Veni, Vidi, Posti
@znomit avatar
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
UTC quote
jess wrote:
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
znomit wrote:
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
Which isn't even in the MP3 section. Errrm, this is awkward.
@znomit avatar
UTC

Veni, Vidi, Posti
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
 
Veni, Vidi, Posti
@znomit avatar
LX190 Friday afternoon special, Primavera, some pushbikes
Joined: UTC
Posts: 10016
Location: Hermit Kingdom
UTC quote
jess wrote:
znomit wrote:
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
Which isn't even in the MP3 section. Errrm, this is awkward.
Maybe consult MV-Bot for neutral advice?
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
znomit wrote:
Maybe consult MV-Bot for neutral advice?
MV-Bot is neutral in the same way that a hand grenade is neutral.
@madison_sully avatar
UTC

Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
 
Veni, Vidi, Posti
@madison_sully avatar
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
UTC quote
jess wrote:
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
Huh. Your post doesn't indicate that it was edited. I'd swear I saw that in the past.....

So here's me editing it to see if it says it was edited.. 3...2...1...

Nope, no indication it was edited. Commence chaos...

And, edit...
⚠️ Last edited by Madison Sully on UTC; edited 1 time
@madison_sully avatar
UTC

Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
 
Veni, Vidi, Posti
@madison_sully avatar
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
UTC quote
jess wrote:
znomit wrote:
Maybe consult MV-Bot for neutral advice?
MV-Bot is neutral in the same way that a hand grenade is neutral.
Um, so, who exactly "throws" MV-Bot then?
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Madison Sully wrote:
Nope, no indication it was edited. Commence chaos...
It only shows "edited" if it gets edited after someone replies to it. If it's the last reply in the topic, then the edited tag doesn't get applied.
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Madison Sully wrote:
Um, so, who exactly "throws" MV-Bot then?
It's a mystery. I mostly don't even know. I think the moderators change her password whenever they need her to post.
@madison_sully avatar
UTC

Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
 
Veni, Vidi, Posti
@madison_sully avatar
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7542
Location: Madison, Wisconsin
UTC quote
Madison Sully wrote:
jess wrote:
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
Huh. Your post doesn't indicate that it was edited. I'd swear I saw that in the past.....

So here's me editing it to see if it says it was edited.. 3...2...1...

Nope, no indication it was edited. Commence chaos...

And, edit...
Crap, chaos averted. Laughing emoticon
@attila avatar
UTC

Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
 
Veni, Vidi, Posti
@attila avatar
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: UTC
Posts: 8291
Location: Latina (Italy)
UTC quote
My IT experience is limited to the knowledge and use of CAD / CAM programs for mechanics and woodworking for furnishings. Ask me to disassemble and reassemble an engine and I will do it but with a PC more likely I washed it down with gasoline to set it on fire.
OP
@jess avatar
UTC

Petty Tyrant
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
 
Petty Tyrant
@jess avatar
0:7 And counting
Joined: UTC
Posts: 36808
Location: Bay Area, California
UTC quote
Attila wrote:
Ask me to disassemble and reassemble an engine and I will do it but with a PC more likely I washed it down with gasoline to set it on fire.
I am a professional software engineer, and if I'm honest there are days that I would do the same.
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.1347s ][ Queries: 34 (0.1012s) ][ Debug on ][ 313 ][ Thing One ]