Upgrading from 1.1.21 to...

[ducpainter]

I have to say...if I lose images I'm not too concerned.

What's weird is I have had the forum set to not allow any uploads from the beginning.

All the images have to be linked from somewhere on the web. We did host some images from certain posts, but they're not online any longer.

Not sure if that's pertinent, or not.

[Sir Osis of Liver]

The 1.1.21 database had attachments disabled, I'd have to assume those 2400 attachments were from long ago, and you may have run maintenance task to remove them.  Embedded images loading from external links are different, some load, others don't.  There are a lot of Photobucket pics, those were made unavailable by Photobucket a few years ago, iirc. 

The 1.1.21 clone is running normally, everthing I've checked is working - posts, PMs, registration, attachments, etc..  No errors are being logged.  Cleaned up the database, it's now back to 41 core tables, and cleaned up settings table.  Will run 2.1.4 upgrade now and see what happens.

[ducpainter]

Go for it bro.

[Sir Osis of Liver]

Running now.  I'm inclined to think that for some reason you ran attachment maintenance tasks, which removed all existing attachments.  id_thumb and id_msg are just to neatly and thoroughly zeroed out for it to be a random glitch.

[ducpainter]

Running now.  I'm inclined to think that for some reason you ran attachment maintenance tasks, which removed all existing attachments.  id_thumb and id_msg are just to neatly and thoroughly zeroed out for it to be a random glitch.

I don't think I did that, but to be perfectly honest...

I have no clue what you just said.

[Sir Osis of Liver]

Upgrade is complete, I've installed GreyedOut theme.  Check if everything's working.

[ducpainter]

your server, or mine?

[Sir Osis of Liver]

That's the clone on my server.  Haven't done anything to your production install. Couldn't anyway, don't have access to database.

[Sir Osis of Liver]

You'll have to decide on a portal to replace SimplePortal.  These are available for 2.1 -

• EhPortal - Ported from SP, this will be most similar.  It's supported by Chen Zhen on his own support forum.
• ezPortal - supported here
• TinyPortal - supported here.
• Light Portal - supported here.

Can try them on clone, you have admin access.

[ducpainter]

Not so sure I want a portal.

We used Simple portal because it provided a better navigation than the breadcrumb system of SMF.

To be honest...I don't really want a 'front page' and I, personally, don't find the SMF breadcrumb system distasteful.

Can you make it say Ducati Monster Forum instead of Greyed Out?

[ducpainter]

That's the clone on my server.  Haven't done anything to your production install. Couldn't anyway, don't have access to database.

I will fix that when it's time.

Following along in the thread with shawn...what's his issue with mariadb? Is SMF limited?

[Sir Osis of Liver]

Can you make it say Ducati Monster Forum instead of Greyed Out?

The Greyed Out logo is an image (/Themes/GreyedOut/images/custom/logo.png) -

   You cannot view this attachment.

If you remove it forum title wll be displayed (Admin > Server Settings) as it is now, or you can replace it with a custom image you can create in a graphics editor.  You can play with the forum title formatting in index.css.  Look for .header_logo_area h1.forumtitle.

[Sir Osis of Liver]

Following along in the thread with shawn...what's his issue with mariadb? Is SMF limited?

The original upgrade on your GoDaddy vps running mysql failed with same errors, it was not because of mariadb.  Shawn was able to replicate the error in mariadb but not mysql. 

[ducpainter]

Following along in the thread with shawn...what's his issue with mariadb? Is SMF limited?

The original upgrade on your GoDaddy vps running mysql failed with same errors, it was not because of mariadb.  Shawn was able to replicate the error in mariadb but not mysql. 

Where does that put us...back to the db errors?

[Sir Osis of Liver]

The upgrade errors do not affect the forum and are easy to get around.  For reasons unknown the upgrader looks for two 1.0 tables that don't exist in 1.1, the correct tables are already in 1.1, so they don't need to be renamed.  Upgrade runs fine when the to RENAMEs are edited out.

[shawnb61]

For reasons unknown the upgrader looks for two 1.0 tables that don't exist in 1.1, the correct tables are already in 1.1, so they don't need to be renamed.  Upgrade runs fine when the to RENAMEs are edited out.

A clarification...  The reasons are known & are explained in the other thread.  That's the 1.0 to 1.1 script, that is normally rerun at that start of an upgrade from 1.1 to any subsequent release, to ensure you're starting from a valid 1.1 starting point.  This is normally not a problem, since the upgrader is designed to allow reruns; it traps the rename error that is produced by MySQL & ignores it.  The problem is that MariaDB is literally producing a different error; further, the error it produces is indistinguishable from a real error, so it cannot be ignored.

The issue cannot be independently reproduced in MySQL - I have run many 1.1 upgrades with the exact same scripts, with many versions of MySQL and PHP. 

It's a definite issue with MariaDB 1.1 upgrades.

In the past, we've seen lots of MariaDB upgrader errors, but normally, once you get past the upgrade, it generally works OK-ish. 

MariaDB has some syntax quirks we run across occasionally.  They are usually fixed when encountered, e.g.:
https://github.com/SimpleMachines/SMF/pull/8192
https://github.com/SimpleMachines/SMF/pull/7658
https://github.com/SimpleMachines/SMF/pull/6319
https://github.com/SimpleMachines/SMF/pull/6096

I.e., there is no guarantee you won't find some additional MariaDB errors. 

[ducpainter]

Have we figured out why the ezportal 'controls' don't show in the admin cp?

I also installed the curve color changer and can't figure out how to access it.

[Sir Osis of Liver]

I've installed ezportal on clone, it installs correctly, there's an ezportal link in ACP to access portal config.  Curve color changer is intended for use with Curve2, may or may not work in custom themes.  You can change colors by editing css manually.

[Sir Osis of Liver]

Curve color changer does not work in Greyed Out theme.

[ducpainter]

Can you make it say Ducati Monster Forum instead of Greyed Out?

If you remove it forum title wll be displayed (Admin > Server Settings) as it is now, or you can replace it with a custom image you can create in a graphics editor. 

Removing it from httpdocs/themes/greyed out/images/custom doesn't work. Still says Greyed out.

I can't find it anywhere else.

Curve color changer does not work in Greyed Out theme.

I understand that, but it's more likely I don't know how. Maybe I was expecting something not code based.