Tom Spielvogel Posted May 22, 2023 Posted May 22, 2023 I have tried to auto-update to the latest version. I had to update php to 7.4.0, which I accomplished php -v results in: PHP 7.4.30 (cli) (built: Jun 27 2022 08:14:52) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.30, Copyright (c), by Zend Technologies Now I am getting the "We are sorry, but a MySQL - error occurred. The administrator may find more information in the syslog" error. Any advice is appreciated. (e.g. where to read the syslog without web interface - maybe I can proceed from there, but if anyone has more insights, any help is welcome)
0 d00p Posted May 22, 2023 Posted May 22, 2023 The syslog is not read via the webinterface. Check your log files in /var/log/ folder via ssh. Also, please provide information about your OS, and from what version you are upgrading.
0 Tom Spielvogel Posted May 22, 2023 Author Posted May 22, 2023 Thank you for your reply. I believe it was bc. the php-mysql module was missing in the new php installation. I have added it and now getting a new error (in admin_updates.php?page=overview): Uncaught exception 0 Call to undefined function Froxlor\Config\simplexml_load_file() #0 /var/www/froxlor/install/updates/preconfig/preconfig_2.x.inc.php(61): Froxlor\Config\ConfigParser->__construct() #1 /var/www/froxlor/lib/Froxlor/Install/Preconfig.php(83): include('/var/www/froxlo...') #2 /var/www/froxlor/lib/Froxlor/Install/Preconfig.php(98): Froxlor\Install\Preconfig->__construct() #3 /var/www/froxlor/admin_updates.php(101): Froxlor\Install\Preconfig::getPreConfig() #4 {main}
0 d00p Posted May 22, 2023 Posted May 22, 2023 then you are also missing the xml extension...maybe it would be a better idea to use the apt-package which installs all these requirements
0 Tom Spielvogel Posted May 22, 2023 Author Posted May 22, 2023 Yes. you're right. But my dist isn't supporting php7.4x ootb. I really have to update to something past Stretch at some point. But with so many customers running live, who has the time, ey? Anyway, I am trying to get through somehow, now with xml extension working, getting: A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes Last time the update went so smooth. But I believe it was from version 0.10...something, now updating to 2.x.. which I think is natural to meet some challenges
0 d00p Posted May 22, 2023 Posted May 22, 2023 Just now, Tom Spielvogel said: I really have to update to something past Stretch at some point. But with so many customers running live, who has the time, ey? It really just takes a few minues tbh,,...done that a million times. We gladly offer you to do that for you The database error also originates from too old distro, try:
0 Tom Spielvogel Posted May 22, 2023 Author Posted May 22, 2023 Ok, thank you. Additionally I had to add innodb_default_row_format=dynamic to fix also the indexing size of utf8 vs. utf8mb4 All seems to be working now. Cheers!
Question
Tom Spielvogel
I have tried to auto-update to the latest version.
I had to update php to 7.4.0, which I accomplished
php -v results in:
PHP 7.4.30 (cli) (built: Jun 27 2022 08:14:52) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.30, Copyright (c), by Zend Technologies
Now I am getting the "We are sorry, but a MySQL - error occurred. The administrator may find more information in the syslog" error.
Any advice is appreciated.
(e.g. where to read the syslog without web interface - maybe I can proceed from there, but if anyone has more insights, any help is welcome)
6 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now