Avatar

Web server of the project site buggy or is it the forum? (General)

by Auge ⌂, Thursday, February 07, 2019, 12:39 (1877 days ago) @ Magma

Hello

PHP Fatal error: Call to undefined function mysqli_fetch_all

includes/admin.inc.php on line 1188

Please replace the following code, beginning with line 1188:

   $rGetSettingsEdit = mysqli_fetch_all(mysqli_query($connid, "SELECT name, value FROM " . $db_settings['settings_table']), MYSQLI_ASSOC);
   foreach ($rGetSettingsEdit as $line) {
    $settings_array[$line['name']] = $line['value'];
   }

with:

   $rGetSettingsEdit = mysqli_query($connid, "SELECT name, value FROM " . $db_settings['settings_table']);
   while ($line = mysqli_fetch_assoc($rGetSettingsEdit)) {
    $settings_array[$line['name']] = $line['value'];
   }

and in the next block for the advanced settings, beginning with line 1217 (I would like to point to the different database query):

   $rGetSettingsEdit = mysqli_fetch_all(mysqli_query($connid, "SELECT name, value FROM " . $db_settings['settings_table'] ." ORDER BY name ASC"), MYSQLI_ASSOC);
   foreach ($rGetSettingsEdit as $line) {
    $settings_array[$line['name']] = $line['value'];
   }

with:

   $rGetSettingsEdit = mysqli_query($connid, "SELECT name, value FROM " . $db_settings['settings_table'] ." ORDER BY name ASC");
   while ($line = mysqli_fetch_assoc($rGetSettingsEdit)) {
    $settings_array[$line['name']] = $line['value'];
   }

This will not solve the problem(s) completely! I still get here an status 500 every when and then, not in the settings but on the main page. Have to dig further.

Tschö, Auge

[edit]Updated the posting to correct an error. Changed mysqli_fetch_assoc($connid, $rGetSettingsEdit) to the correct mysqli_fetch_assoc($rGetSettingsEdit).

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread