Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[SOLVED] Installing database gives error
PHP 8.2
Textpattern 4.8.8
What’s wrong?
[Edit]
PHP mysqli extension wasn’t running … :o
Last edited by RedFox (2023-03-29 11:43:36)
Offline
Re: [SOLVED] Installing database gives error
We have issue 1309 which covers this partially, but that’s aimed at existing installations and a preflight check for an intended version upgrade. It makes sense to me to have some automated checking in the installer that the required components are available, and a report on the optional components (I know of some other PHP apps that check during install), rather than just for existing installations.
Offline
Re: [SOLVED] Installing database gives error
Y’know, we should probably revisit that issue and just blitz it, adding any checks in core. We do rudimentary checks (e.g. is PHP version high enough) but beyond that, nothing much.
Since we list the system requirements and direct people there prior to upgrades, it would make sense to at least list what the server environment has available so admins can check diagnostics to see what’s supported and cross ref it with the published list.
I think checking compatibility of extensions for incoming version upgrades is probably a step too far, logic wise. I.e. if you want to install 4.9.0, it somehow lists incompatible issues near the “upgrade available” message. That would be hard to pull off. But a manual cross check with what’s there vs what we publish as required would make sense.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Online
Re: [SOLVED] Installing database gives error
Bloke wrote #335201:
Since we list the system requirements and direct people there prior to upgrades, it would make sense to at least list what the server environment has available so admins can check diagnostics to see what’s supported and cross ref it with the published list.
I remember Magento had a preflight .php checker that we could perhaps crib, let me see if I can find it…
Edit: voila–
<?php
extension_check(array(
'curl',
'dom',
'gd',
'hash',
'iconv',
'mcrypt',
'pcre',
'pdo',
'pdo_mysql',
'simplexml'
));
function extension_check($extensions) {
$fail = '';
$pass = '';
if(version_compare(phpversion(), '5.2.0', '<')) {
$fail .= '<li>You need<strong> PHP 5.2.0</strong> (or greater)</li>';
}
else {
$pass .='<li>You have<strong> PHP 5.2.0</strong> (or greater)</li>';
}
if(!ini_get('safe_mode')) {
$pass .='<li>Safe Mode is <strong>off</strong></li>';
preg_match('/[0-9]\.[0-9]+\.[0-9]+/', shell_exec('mysql -V'), $version);
if ($version) {
if(version_compare($version[0], '4.1.20', '<')) {
$fail .= '<li>You need<strong> MySQL 4.1.20</strong> (or greater)</li>';
}
else {
$pass .='<li>You have<strong> MySQL 4.1.20</strong> (or greater)</li>';
}
} else {
$pass .='<li>You probably have<strong> MySQL 4.1.20</strong> (or greater)</li>';
}
}
else { $fail .= '<li>Safe Mode is <strong>on</strong></li>'; }
foreach($extensions as $extension) {
if(!extension_loaded($extension)) {
$fail .= '<li> You are missing the <strong>'.$extension.'</strong> extension</li>';
}
else{ $pass .= '<li>You have the <strong>'.$extension.'</strong> extension</li>';
}
}
if($fail) {
echo '<p><strong>Your server does not meet the following requirements in order to install Magento.</strong>';
echo '<br>The following requirements failed, please contact your hosting provider in order to receive assistance with meeting the system requirements for Magento:';
echo '<ul>'.$fail.'</ul></p>';
echo 'The following requirements were successfully met:';
echo '<ul>'.$pass.'</ul>';
} else {
echo '<p><strong>Congratulations!</strong> Your server meets the requirements for Magento.</p>';
echo '<ul>'.$pass.'</ul>';
}
}Last edited by gaekwad (2023-03-31 11:01:18)
Offline
Re: [SOLVED] Installing database gives error
Lovely, thank you. I’ll, uhhh, pay homage to that in our pre-flight check.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Online
Re: [SOLVED] Installing database gives error
Interestingly, we already list all loaded extensions in diagnostics, it’s just that (for whatever reason) it was never displayed. I’ve enabled that first, then I’ll look at comparing that to the list of required extensions and pull those out separately to highlight them.
Last edited by Bloke (2023-03-31 11:41:05)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Online
Re: [SOLVED] Installing database gives error
Bloke wrote #335218:
I’ll, uhhh, pay homage to that in our pre-flight check.
It’s Magento v1 era stuff, it sort of worked…but caveat emptor and don’t shoot the messenger!
Offline
Re: [SOLVED] Installing database gives error
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Online
Offline
Offline