View Issue Details

IDProjectCategoryView StatusLast Update
0031928mantisbtdb mysqlpublic2023-01-25 05:24
ReporterRosek93 Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
Product Version2.25.5 
Summary0031928: Error on installation MantisBT 2.25.5
Description

Stack:

  • PHP 8.2
  • MySQL 8.0

I try downgrade MySQL to 5.7

Error:

[Tue Jan 24 18:52:08.972733 2023] [php:error] [pid 22] [client 35.191.17.199:42306] PHP Fatal error:  Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'schema()schema()' at line 5 in /var/www/html/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php:808
Stack trace:
#0 /var/www/html/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php(808): mysqli_query()
0000001 /var/www/html/vendor/adodb/adodb-php/adodb.inc.php(1282): ADODB_mysqli->_query()
0000002 /var/www/html/vendor/adodb/adodb-php/adodb.inc.php(1260): ADOConnection->_Execute()
0000003 /var/www/html/vendor/adodb/adodb-php/adodb.inc.php(2599): ADOConnection->Execute()
0000004 /var/www/html/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php(569): ADOConnection->MetaTables()
0000005 /var/www/html/core/database_api.php(868): ADODB_mysqli->MetaTables()
#6 /var/www/html/core/database_api.php(506): db_get_table_list()
0000007 /var/www/html/core/config_api.php(82): db_table_exists()
#8 /var/www/html/core/lang_api.php(159): config_get()
0000009 /var/www/html/core/lang_api.php(124): lang_map_auto()
#10 /var/www/html/core/error_api.php(164): lang_get_default()
#11 [internal function]: error_handler()
0000012 /var/www/html/core/error_api.php(92): trigger_error()
#13 [internal function]: error_exception_handler()
#14 {main}
  thrown in /var/www/html/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php on line 808, referer: xxx

EDIT (dregad): reformatted error stack trace with line breaks

TagsNo tags attached.

Activities

Rosek93

Rosek93

2023-01-24 14:54

reporter   ~0067315

Start working on stack:
PHP 7.2
MySQL 5.6

dregad

dregad

2023-01-25 05:24

developer   ~0067317

For the record, MantisBT does not officially support PHP 8.1 or later yet. This is due to the cross-dependency between ADOdb library and our minimum supported PHP version.

MySQL 8 should be no problem though, I've been using it for many months.

We're aware that an update of our minimum requirements is long overdue, but unfortunately the team has not had time to finalize the required work. Please bear with us.

If you can reproduce the problem on PHP 8.0 / MySQL 8.0 or earlier, please let us know.