We just upgraded MariaDB from Version: 5.5.5-10.2.44 to Version: 5.5.5-10.3.37

This message is for the PHP-Nuke Titanium admins that have cPanel access. 

The revision number links will take you to the revision's page on GitHub. On GitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Includes all fixes from MariaDB 10.2.44
• Revision #3303748fd1 2022-11-02 12:49:24 +0100
  • MDEV-29926: ASAN heap-use-after-free in Explain_query::Explain_query
• Revision #278fbe61d8 2022-10-26 10:14:34 +0200
  • Add skipped changes to oracle mode parser.
• Revision #fa5f26b422 2022-09-22 15:13:22 +0100
  • MDEV-29578 Fix CONNECT build warnings
• Revision #055cb3fcd1 2022-10-22 23:08:06 -0400
  • Rocksdb: Add initial OpenBSD support
• Revision #77951dd710 2022-10-25 23:48:54 +0400
  • MDEV-26161 crash in Gis_point::calculate_haversine
• Revision #e910dff81e 2022-10-25 21:21:19 +0200
  • MDEV-26161 crash in Gis_point::calculate_haversine
• Revision #72e79eaaf3 2022-10-25 20:24:11 +0200
  • cleanup: put casts in a separate statement
• Revision #1ff476b415 2022-09-12 14:39:12 +0200
  • MDEV-29490 Renaming internally used client API to avoid name conflicts
• Revision #32158be720 2022-10-21 19:50:07 +0200
  • MDEV-29811 server advertises ssl even if it's unusable.
• Revision #34ff5ca895 2022-10-24 15:52:29 +0200
  • MDEV-28701 Update 10.3 HELP tables
• Revision #4fd6dd2d3b 2022-10-12 15:59:46 +0200
  • MDEV-29748 ASAN errors or server crash in File_parser::parse upon concurrent view operations
• Revision #e00ea301ef 2022-10-21 13:47:17 +0200
  • MDEV-16549 Server crashes in Item_field::fix_fields on query with view and subquery, Assertion `context' failed, Assertion `field' failed
• Revision #28d6f6a514 2022-10-24 13:58:14 +0400
  • MDEV-14983 Wrong error message with SET sql_mode=sha2(ucs2_value)
• Revision #68fb05c360 2022-10-22 17:11:04 +0200
  • MDEV-29851 Cached role privileges are not invalidated when needed
• Revision #7a2f995649 2022-10-22 17:06:50 +0200
  • cleanup: rename test file
• Revision #741c14cbdd 2022-10-22 12:33:09 +0200
  • remove two acl_cache->clear()
• Revision #16d4431ab6 2022-10-22 11:45:38 +0200
  • CONNECT: compile with libxml2 2.10.x
• Revision #0609b34555 2022-10-21 20:37:09 +0200
  • disable LTO in debian builds
• Revision #3e377fd35b 2022-10-21 19:40:08 +0200
  • MDEV-15795 Stack exceeded if pthread_attr_setstacksize(&thr_attr,8196) succeeds
• Revision #68391acef2 2022-10-22 10:22:56 +0200
  • fix for x86 and other 32-bit little engian arch
• Revision #45755c4e1b 2022-09-13 00:41:43 +0000
  • Use OPENSSL_free instead of free to avoid instance crash
• Revision #e46217182f 2022-10-12 10:42:54 +1100
  • MDEV-29678 Valgrind/MSAN uninitialised value errors upon PS with ALTER under ONLY_FULL_GROUP_BY
• Revision #6bc2e93381 2022-10-21 12:04:00 +0300
  • MDEV-23160: SIGSEGV in Explain_node::print_explain_for_children on UNION SELECT
• Revision #0c06320ae9 2022-10-21 14:26:06 +0200
  • MDEV-29687:ODBC tables do not quote identifier names correctly (#2295)
• Revision #e1414fc7e3 2022-10-20 08:29:56 +0530
  • MDEV-29778 Having Unique index interference with MATCH from a FULLTEXT
• Revision #e11661a4a2 2022-09-21 11:29:07 +0800
  • MDEV-25343 Error log message not helpful when filekey is too long
• Revision #9de37e07de 2022-10-18 00:01:58 +0400
  • MDEV-19569 Assertion `table_list->table' failed in find_field_in_table_ref.
• Revision #3a62ff7e89 2022-10-19 19:25:48 +1100
  • Revert "MDEV-25343 add read secret size in file key plugin"
• Revision #cee7175b79 2022-09-21 11:29:07 +0800
  • MDEV-25343 add read secret size in file key plugin
• Revision #64d85c369b 2022-09-22 14:57:57 +0800
  • MDEV-28720 add log message if flush log failure
• Revision #8c38939369 2022-09-16 11:20:41 +1000
  • MDEV-29540 Incorrect sequence values in INSERT SELECT
• Revision #d6707ab11f 2022-10-18 10:29:15 +0300
  • MDEV-29753 fixup: Silence bogus GCC -Og -Wmaybe-uninitialized

Data Scientist / Programmer   name: Ernest Allen Buffington   email: ernest.buffington[at]gmail.com   www: https://theghost.86it.us   github: https://github.com/ernestbuffington

We just upgraded cPanel again from v96.0.7 to v106.7

This message is for the PHP-Nuke Titanium admins that have cPanel access. Again we did not want you logging in a freaking out because of all the changes that took place today. If you are an admin you probably have compiler access already but if you do not and would like to have compiler access enabled on your personal 86it portal just use the chat plugin by clicking on the blue circle in the bottom left-hand corner. You can request compiler access anytime you like. Compilers are accessible 24/7 now so you will no ;longer have just 24 hours from the time of request before your compiler goes back offline. Your compiler will stay online forever!

CentOS v7.0 to CentOS v7.9.2009 STANDARD

Data Scientist / Programmer   name: Ernest Allen Buffington   email: ernest.buffington[at]gmail.com   www: https://theghost.86it.us   github: https://github.com/ernestbuffington

We dumped MySQL

We have gone back to MariaDB and I guess we owe Monty an apology as it is obvious that we made a horrible decision going to MySQL 

As time goes on, MySQL develops more extensive features (not created by Monty) or changes to its internal architecture. They have more developers on staff than MariaDB, so they are making changes at a faster pace. However, it turns out that MySQL sucks and is slower than dog shit! I guess Oracle deserves it though. I can see some bullshit was pulled during the sale and somebody messed up when they lost the lead developer (Monty) for MySQL.

Who's Currently Behind The Databases?

In 2010, MySQL was acquired by the Oracle Corporation. At that time, one of the original lead developers, Michael “Monty” Widenius, felt that the Oracle Corporation had a conflict of interest between MySQL and their Oracle database.

In response to this, he decided to create a fork of the project and he named it MariaDB. Since then, there's been a lot of healthy competition between MySQL and MariaDB that has led to some really great innovation. Since Oracle is backing MySQL and has a pretty solid foundation, it continues to be the leader and not because it should be. However, MariaDB offers some compelling reasons why developers may want to switch databases.

MySQL was originally started by MySQL AB in 1994 by a Swedish company that was created by a nerd named David Axmark, Allan Larsson, and another developer named Michael “Monty” Widenius. The first version of MySQL was released in 1995. In 2008, Sun Microsystems purchased MySQL AB. In 2010, Sun Microsystems was acquired by Oracle.

MySQL is currently maintained by the Oracle Corporation.

MariaDB on the day Oracle announced they had purchased MySQL, Michael “Monty” Widenius shit a shiny nerd cape and took several MySQL developers, and started MariaDB, a fork of MySQL and from that point, they have become #1.

Hats off to Michael “Monty” Widenius he is truly the shit and we thank you for what you have done, You did us proud! MariaDB is lightning fast!

Data Scientist / Programmer   name: Ernest Allen Buffington   email: ernest.buffington[at]gmail.com   www: https://theghost.86it.us   github: https://github.com/ernestbuffington

Current Developer Support:

FROM:
PHP 5.4 for porting only.
PHP 5.5 for porting only.
PHP 5.6 for porting only.
PHP 7.0 for porting only.
PHP 7.1 for porting only.
PHP 7.2 for porting only.
PHP 7.3 for porting only
 

TO:
PHP 7.4 for current development.
OR
PHP 8.0 for advanced current development.
OR
PHP 8.1 for advanced current development.

PHP 8 has been here for a little while now. It was released on November 26, 2020. This will introduce some breaking changes, as well as lots of new features and performance improvements.

Because of the breaking changes, there's a higher chance you'll need to make some changes in your code to get it running on PHP 8. If you've kept up to date with the latest releases though, the upgrade shouldn't be too hard, since most breaking changes were deprecated in the PHP 7. x versions.

Besides breaking changes, PHP 8 also brings a nice set of new features such as the JIT compiler, union types, attributes, and more.

PHP-Nuke Titanium Dev Administrator   name: Winston Terrance Wolfe   email: webmaster[at]php-nuke-titanium.86it.us   www: https://php-nuke-titanium.86it.us   github: https://github.com/TerranceWolfe