[SCHWERER FEHLER] PHP: 8.2.14 | MySQL Client: 8.2.14 | MySQL Server: 8.0.36

[blaloc]

Hallo,

auf der Suche nach einem Gästebuch für die Homepage eines Freundes bin ich auf dieses Projekt hier gestoßen.
Bei meinem Test bin ich allerdings sehr schnell auf das eine oder andere Problem gestoßen.
Wie es scheint, ist mein PHP und / oder MySQL wohl etwas zu neu, um noch mit dem Script hier kompatibel zu sein.

Es fängt schon bei der Installation an:

abgesehen davon, daß ich nach der Dateneingabe für die MySQL-Verbindung und die Admin-Userdaten gleich mal eine PHP-Ausgabe sehe, die meines Erachtens nicht sichtbar sein sollte:

Code:

Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_banlist_domains' doesn't exist in /..../mgb/install/install.php on line 287
Warning: Undefined variable $prefix_already_used in /..../mgb/install/install.php on line 290
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_banlist_emails' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_banlist_ips' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_entries' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_settings' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_smilies' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_spam' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_spam_log' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_sys_log' doesn't exist in /..../mgb/install/install.php on line 287
Warning: mysqli::query(): (42S02/1146): Table '3384827db1.mgb_user' doesn't exist in /..../mgb/install/install.php on line 287

muß ich dann also ein 2. Mal auf abschicken klicken und erhalte wieder eine Fehlermeldung:

Code:

Fatal error: Uncaught mysqli_sql_exception: BLOB, TEXT, GEOMETRY or JSON column 'message' can't have a default value in /..../mgb/install/mysql.php:653
Stack trace: #0 /..../mgb/install/mysql.php(653): mysqli_query(Object(mysqli), 'CREATE TABLE IF...')
    #1 /..../mgb/install/install.php(366): require_once('/....')
    #2 {main} thrown in /..../mgb/install/mysql.php on line 653

das läßt sich ja noch recht leicht beheben - einfach in der mysql.php die Zeilen 66 und 67 ändern:

Code:

original:
        `message` MEDIUMTEXT NOT NULL DEFAULT '',
        `comment` MEDIUMTEXT NOT NULL DEFAULT '',

neu:
        `message` MEDIUMTEXT NOT NULL,
        `comment` MEDIUMTEXT NOT NULL,

fertig ist die Installation, allerdings auch mit einer Fehler-Ausgabe:

Code:

Warning: Undefined variable $success in /..../mgb/install/mysql.php on line 654
Warning: Undefined array key "import" in /..../mgb/install/install.php on line 398
Deprecated: preg_replace(): Passing null to parameter #2 ($replacement) of type array|string is deprecated in /..../mgb/install/includes/functions.inc.php on line 91

Doch dann beginnen leider gleich die nächsten Schwierigkeiten beim ersten Test-Eintrag, ohne daß ich an der Original-Config noch etwas verstellt hätte:

Code:

Warning: Undefined array key "msn" in /..../mgb/newentry.php on line 448
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "user_accept_akismet_service" in /..../mgb/newentry.php on line 454
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Fatal error: Uncaught mysqli_sql_exception: Field 'comment' doesn't have a default value in /..../mgb/includes/functions.inc.php:36
Stack trace: #0 /..../mgb/includes/functions.inc.php(36): mysqli_query(Object(mysqli), 'INSERT INTO mgb...')
             #1 /..../mgb/newentry.php(556): mgb_sql_connect('INSERT INTO mgb...', 'Error while sav...', 0)
             #2 {main} thrown in /..../mgb/includes/functions.inc.php on line 36

wenn ich dann (für mich) unerwünschte/unnötige Felder ( ICQ / AIM / Facebook / Twitter ) ausblende:

Code:

Warning: Undefined array key "2RsdE2srq2z81ZLk" in /..../mgb/newentry.php on line 1026
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "yJH9KjW8wRLBb5j4" in /..../mgb/newentry.php on line 1027
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "9GlODpzxtat7R4QW" in /..../mgb/newentry.php on line 1028
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "4amP1W17XNiS7Q8x" in /..../mgb/newentry.php on line 1029
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107

und ganz lustig wird es, wenn ich reCaptcha aktiviere:

Code:

Warning: Undefined array key "1wI2natqpCRCZjZ8" in /..../mgb/newentry.php on line 167
Warning: Undefined array key "Q7wbL9GTYVsLSMOL" in /..../mgb/newentry.php on line 168
Warning: Undefined array key "eyzbe26W4kHiGzs1" in /..../mgb/newentry.php on line 170
Warning: Undefined variable $blocked in /..../mgb/includes/functions.inc.php on line 1213
Warning: Trying to access array offset on value of type null in /..../mgb/includes/functions.inc.php on line 1216
Warning: Undefined variable $blocked in /..../mgb/includes/functions.inc.php on line 1246
Warning: Trying to access array offset on value of type null in /..../mgb/includes/functions.inc.php on line 1250
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "msn" in /..../mgb/newentry.php on line 448
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Warning: Undefined array key "user_accept_akismet_service" in /..../mgb/newentry.php on line 454
Deprecated: strip_tags(): Passing null to parameter #1 ($string) of type string is deprecated in /..../mgb/includes/functions.inc.php on line 1107
Fatal error: Uncaught mysqli_sql_exception: Field 'comment' doesn't have a default value in /..../mgb/includes/functions.inc.php:36
Stack trace: #0 /..../mgb/includes/functions.inc.php(36): mysqli_query(Object(mysqli), 'INSERT INTO mgb...')
             #1 /..../mgb/newentry.php(556): mgb_sql_connect('INSERT INTO mgb...', 'Error while sav...', 0)
             #2 {main} thrown in /..../mgb/includes/functions.inc.php on line 36

Ich werde mal versuchen, das eine oder andere Problem in den Griff zu bekommen , soferne ich Zeit finde, allerdings sieht mit das nach etwas mehr Arbeit aus.

lg blaloc