Hi! It seems there is a bit of a misunderstanding regarding SQL files and Collations.
utf8mb4_0900_ai_ci is not a file you can import; it is a Collation (a set of rules for comparing characters) specific to MySQL 8.0+. You don't need to 'find' it, your MySQL server handles it automatically if it’s the correct version.
Regarding the SQL files:
Full Installation: The SQL structure is included, but you should not import it manually via phpMyAdmin. The standard install/ script handles the entire database creation for you.
Update Version: This package does not include a full SQL file because it uses your existing database. The ow_updates/ script is responsible for modifying your current tables to the new version.
My advice: Please avoid manual database manipulations if you are not experienced with Collations. If you are performing an update, the most important step is to create a full backup of your files and database before running the update script. Let the automated tools do the work!Hi! It seems there is a bit of a misunderstanding regarding SQL files and Collations.
utf8mb4_0900_ai_ci is not a file you can import; it is a Collation (a set of rules for comparing ch...See more
Hi! Don't let the collation settings stop you from upgrading. While utf8mb4_0900_ai_ci is indeed a MySQL 8.0 specific standard, Oxwall is perfectly capable of running on MariaDB.
The software doesn't 'require' that specific sorting rule to function. If your hosting provider uses MariaDB, you can simply adjust your database or table settings to use a more universal standard:
Recommended: Use COLLATE utf8mb4_general_ci. This is the most compatible version and works flawlessly on both MariaDB and older MySQL versions.
Fallback: If you want to keep it even simpler, just use utf8mb4.
Since Oxwall mainly uses alphanumeric characters for core functions (like usernames and URLs), you won't notice any difference in performance or stability. Just make sure to set your collation before running the installation or update, and you’ll be good to go!Hi! Don't let the collation settings stop you from upgrading. While utf8mb4_0900_ai_ci is indeed a MySQL 8.0 specific standard, Oxwall is perfectly capable of running on MariaDB.
I'll give it a try this weekend and let you know how the installation goes.
I think it's fantastic that you're continuing with the software, and that the software has a more or less different name.
? Big Update! Version 12 is now officially available. We have completely overhauled the code to ensure full compatibility with PHP 8.1+ and OxWall 1.9.1. This new build fixes legacy bugs and improves financial precision. We highly recommend upgrading to the latest version for a stable and error-free experience. Check it out in our store!? Big Update! Version 12 is now officially available. We have completely overhauled the code to ensure full compatibility with PHP 8.1+ and OxWall 1.9.1. This new build fixes legacy bugs and improves ...See more
In my experience, the installations haven't gone smoothly for me.I believe this is normal under PHP 8.3, but I also had the same installation problems...
Today I installed the latest version 1.9.1 on my company website. The installation went absolutely wrong, but it eventually finished after going back about four times in the browser.
During installation, I received a fatal PHP error, which was recorded four times in the error log.
Could it be that the 1.9.1 version doesn't work with PHP 8.3, but does work with an earlier version.?Today I installed the latest version 1.9.1 on my company website. The installation went absolutely wrong, but it eventually finished after going back about four times in the browser.
During ins...See more
Thank you for sharing the details of your experience. To answer your question: Yes, that is exactly the issue.
The current version of OWSpain (1.9.1) was specifically developed for and tested on PHP 8.1. It has not yet been optimized or verified for later versions like PHP 8.2 or 8.3.
The "Fatal Errors" and the need to refresh the installation process are likely caused by deprecated functions or strict type changes introduced in PHP 8.3 that are not compatible with the current core. For a stable and smooth installation, I strongly recommend using PHP 8.1.
I am working on updating the code to support newer PHP versions in future releases, but for now, 8.1 is the required environment.Thank you for sharing the details of your experience. To answer your question: Yes, that is exactly the issue.
The current version of OWSpain (1.9.1) was specifically developed for and ...See more
Is it difficult to modify a plugin so it also works under Oxwall version 1.9 and under php version 8.3Could I do this myself, or is that just too much...
How do I get through to the support team of the website www.developers.oxwall.comWe have tried to change the email address of our account there, but n...
utf8mb4_0900_ai_ci is not a file you can import; it is a Collation (a set of rules for comparing characters) specific to MySQL 8.0+. You don't need to 'find' it, your MySQL server handles it automatically if it’s the correct version.
Regarding the SQL files:
Full Installation: The SQL structure is included, but you should not import it manually via phpMyAdmin. The standard install/ script handles the entire database creation for you.
Update Version: This package does not include a full SQL file because it uses your existing database. The ow_updates/ script is responsible for modifying your current tables to the new version.
My advice: Please avoid manual database manipulations if you are not experienced with Collations. If you are performing an update, the most important step is to create a full backup of your files and database before running the update script. Let the automated tools do the work!Hi! It seems there is a bit of a misunderstanding regarding SQL files and Collations.
utf8mb4_0900_ai_ci is not a file you can import; it is a Collation (a set of rules for comparing ch...See more
The software doesn't 'require' that specific sorting rule to function. If your hosting provider uses MariaDB, you can simply adjust your database or table settings to use a more universal standard:
Recommended: Use COLLATE utf8mb4_general_ci. This is the most compatible version and works flawlessly on both MariaDB and older MySQL versions.
Fallback: If you want to keep it even simpler, just use utf8mb4.
Since Oxwall mainly uses alphanumeric characters for core functions (like usernames and URLs), you won't notice any difference in performance or stability. Just make sure to set your collation before running the installation or update, and you’ll be good to go!Hi! Don't let the collation settings stop you from upgrading. While utf8mb4_0900_ai_ci is indeed a MySQL 8.0 specific standard, Oxwall is perfectly capable of running on MariaDB.
T...See more
I think it's fantastic that you're continuing with the software, and that the software has a more or less different name.