This is what I know hopefully @davidefa will see this my server is as follows
Ubunto 22.04 Apache2
mysql Ver 8.0.31
php 8.1.13
modSetupUnofficial.php will not create the table in Mysql I had to create it manually, may or may not have it correct but it got rid of the mysqli error
These errors are after I created the table in mysql manually.
I tested mysql with a simple php code and my user was able to write to it stand alone and create a table
I TESTED MYsql with this code
Code: Select all
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$DB_HOST = 'localhost'; // Replace
$DB_USER = 'username'; // with
$DB_PASS = 'password'; // your
$DB_NAME = 'yur db'; // own
$db = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if($db->connect_errno > 0) {
die('Connection failed [' . $db->connect_error . ']');
}
$sql = "CREATE TABLE mt_mods
(id int(11) NOT NULL AUTO_INCREMENT,
`NAMESPACE` varchar(80) NOT NULL,
`VERSION` varchar(10) NOT NULL,
`STATUS` int(6) NOT NULL,
`DATE` date NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;");
$result = mysqli_query($db,$sql);
if(!$result) {
die('There was an error running the query [' . $db->error . ']');
}
else {
echo "Successful query.";
}
?>
IN modSetupUnofficial.php
Code: Select all
// check if table exixts...
$result = mysqli_query($con,"SHOW COLUMNS FROM `mt_mods`");
if (mysqli_errno($con))
{
// create table
mysqli_query($con,
"CREATE TABLE `$dbName`.`mt_mods` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAMESPACE` varchar(80) NOT NULL,
`VERSION` varchar(10) NOT NULL,
`STATUS` int(6) NOT NULL,
`DATE` date NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;");
Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /var/www/hurricanepub/template/admin/pluginSetupUnofficial.php:56 Stack trace: #0 {main} thrown in /var/www/hurricanepub/template/admin/pluginSetupUnofficial.php on line 56
IN modSetupUnofficial.php
Warning: Undefined array key "HTTP_X_FORWARDED_FOR" in /var/www/hurricanepub/template/admin/modSetupUnofficial.php on line 116
Warning: Undefined array key "HTTP_CLIENT_IP" in /var/www/hurricanepub/template/admin/modSetupUnofficial.php on line 117
Warning: Undefined array key "HTTP_CF_CONNECTING_IP" in /var/www/hurricanepub/template/admin/modSetupUnofficial.php on line 118
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'NAMESPACE' in 'order clause' in /var/www/hurricanepub/template/admin/modSetupUnofficial.php:51 Stack trace: #0 /var/www/hurricanepub/template/admin/modSetupUnofficial.php(51): mysqli_query() #1 {main} thrown in /var/www/hurricanepub/template/admin/modSetupUnofficial.php on line 51
IN blockSetupUnofficial.php
Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /var/www/hurricanepub/template/admin/blockSetupUnofficial.php:63 Stack trace: #0 {main} thrown in /var/www/hurricanepub/template/admin/blockSetupUnofficial.php on line 63
