Maximum version of mySQL?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.

7/25/2022 9:39:47 AM

Magnetic_dud

Total Posts 251

View Posts

Maximum version of mySQL?

Hello, since my ubuntu server upgraded to mysql 8.0.29, mojoportal on IIS wouldn't run anymore and would give this exception:

Error: The given key was not present in the dictionary

Last time when it happened (https://www.mojoportal.com/Forums/Thread.aspx?pageid=5&t=14092~1) my solution was to wipe and restore the latest version, but this time it did not work. I guess it's some kind of collation problem, because before the upgrade i see the mysql dumps had the db collation in utf8_unicode_ci, while now it is utf8mb4_0900_ai_ci. (something like that, did not take note)

I tried to edit the mysql dump by replacing every mention of utf8mb4_0900_ai_ci with utf8_unicode_ci but mysql would output an alert to say that "utf8" is no more an alias of utf8mb3 but it's an alias of utf8mb4.

My "fix" has been to run mysql 5.7 in docker and restore an old backup (can't restore the new dump due to the unsupported collation).

(more details for others who got this problem: i run it on a different port, added ";Port=33306" in the MySqlConnectionString key in user.config)

I wonder which is the last mysql supported version then, as mojoPortal 2.7.0.0 should work fine with mysql 8

7/25/2022 5:31:52 PM

Adobe Wan Kenobi

Total Posts 22

View Posts

Re: Maximum version of mySQL?

I have the same issue.

I've installed dozens of MojoPortal sites, but nothing in the last 5 or 6 years.

I wanted to return to the old MojoPortal because of the file upload and simple granular permissions methodology.

What should have been a "set up DB, install Mojo, create user.config, input DB string, connect, done" process, has (so far) been a 30-hour-plus troubleshooting purgatory with the error you list being among the most common. The other errors I get are when it states the credentials are invalid despite quadruple-checking that they are correct and verifying by successfully connecting through both MySQL workbench and HeidiSQL.

Seems there IS a maximum version of MySQL that is supported... but fat chance trying to find anything in the incomplete and internally contradictory "documentation" on this site.

This whole product/project of MojoPortal has, in fact, been COMPLETELY ABANDONED, with not one fix/patch/upgrade happening in the last half-decade! (The just-downloaded MojoPortal v2.7.0.0 zip archive has March 16, 2017 as the most recent file date!)

At this point, you're MUCH BETTER OFF using WordPress and being careful to harden that install than to try to get this old rusty jalopy up and running again.

I mean, with MojoPortal you have to PURCHASE a "make your website work with mobile devices" add-on?!? ...AND on the bright side it will make your website work with a phone operating system that was abandoned EIGHT YEARS AGO!!!

Sadly, it's clearly time to abandon MojoPortal to history and place it on the trash pile of obsolete tech, where it belongs.

7/26/2022 11:54:49 AM

Joe Davis

Total Posts 2253

View Posts

Re: Maximum version of mySQL?

Magnetic_dud, we are using mojoPortal on mysql 8, but locally. I will try it remotely and see if I can replicate your issue. If you would like to send me your database that did not work, I will see if I can find a solution that doesn't involve completely destroying your data. You can get that conversation started by submitting a contact request here.

Adobe Wan Kenobi, I am sorry you feel this way but your attitude is completely uncalled for. Your response is nasty and mostly inaccurate. I have seen exactly zero posts from you since November 2017. If you're having issues, why not ask for help instead of blasting us like this? Also, the project is not abandoned. Take a look at the github repository. Admittedly, we haven't made a public "official" release since 2018. There is a myriad of reasons for this but the biggest is the time commitment to build and test for the various DB platforms. Indeed, we are building new sites on mojoPortal all the time and we know many others that are doing so as well. Regarding the Mobile Kit Pro product, it is there because we removed it as it is no longer necessary and we got a lot of requests to bring it back. There are a lot of people using Artisteer (to our chagrin) and they also like using Mobile Kit Pro in conjunction with their Artisteer skins. All of the free skins we make available are mobile friendly without the plugin.

For all those reading this, please post on the forums if you are having issues with mojoPortal. We will help. We provide a lot of free support and we are continuing to develop mojoPortal. We have hired more developers in the past couple of months as we are a growing company. We have a feature complete release of the MSSQL version of mojo ready to make public but we don't want to do so until we get the MySQL, SQLite, and pgSQL versions ready. If anyone has .net experience and experience with one of those db platforms, we would be ecstatic to have your help.

Thank you,
Joe Davis

7/26/2022 12:16:07 PM

Magnetic_dud

Total Posts 251

View Posts

Re: Maximum version of mySQL?

Hi Joe, for now my "workaround" (use an ancient dedicated version of mysql) is ok. I don't have the data that gave the error because i'm one of those crazy admins that work directly live in production without backups, YOLO LOL

I'm not sure the cause of the problem. I use mysql on a separate linux server with much more cores and much more ram, the iis vps is basically untouched since 2015 (except security updates) and is underpowered.

Maybe the reason is that on the mysql server i enabled 4-byte support using this guide guide https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html

Also: i love that mojoportal is SO snappy, even if it's still hosted on a VPS based on a 2015 AMD ATHLON with just 1 core 512mb ram on an old 2tb wd green hdd, it beats wordpress in speed on similar websites hosted on a 16 core amd cpu from 6 months ago + 32gb ram and all the data on nvme fast storage

But indeed... the 5 themes that i made 10 years ago with artisteer don't play nice with 4k screens and mobile OSes, i'm too lazy to change one of the new themes...

7/26/2022 2:19:01 PM

microquiz

Total Posts 46

View Posts

Microquiz

Re: Maximum version of mySQL?

Mojoportal is still outstanding. I, and my staff, use this CMS every day, over and above any other CMS. We have built well over 1000 websites on our Windows Servers. We appreciate the ease of use, the ability to edit the site (within a browser), and the easy use of "many functions" in the background, like CSS/html-include, image uploading, document downloading, page layouts, multi user log-in and a almost endless list of positives. All this has made our lives (and business) very good indeed. Many thanks to the team at 7Media (who has been very helpful)..... need I go on?

You must sign in to post in the forums. This thread is closed to new posts.