View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000685 | XMB1 | Bugs | public | 2024-04-01 15:50 | 2024-04-15 04:35 |
Reporter | flushedpancake | Assigned To | miqrogroove | ||
Priority | high | Severity | crash | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.9.12.04 | ||||
Target Version | 1.9.12.06 | Fixed in Version | 1.9.12.06 | ||
Summary | 0000685: Installer Throws MySQL Exception in PHP 8.1+ | ||||
Description | Because the install script attempts to try a database connection to the example parameters stored in the example config.php file (the one when you download XMB from the website, XMB-1.9.12.05.zip), and doesn't check whether the values are unchanged from the placeholder ones before doing so, there's a MySQL error upon trying to open the installer. | ||||
Steps To Reproduce | 1) Throw xmb onto a server, using the release version from the website, don't touch anything except do enable php errors 2) Navigate to /install 3) Notice the first screenshot. | ||||
Additional Information | https://www.php.net/manual/en/mysqli-driver.report-mode.php | ||||
Tags | No tags attached. | ||||
MySQL Version | |||||
PHP Version | 8.1 | ||||
Web Server | Apache | ||||
Browser | Chrome | ||||
Flags | |||||
Original Reporter | |||||
SVN Revision | 3031 | ||||
related to | 0000681 | closed | miqrogroove | Installer Version Number is Stale and Doesn't Match header.php |
|
|
|
Version issue has a bug report here: https://bugs.xmbforum2.com/view.php?id=681 |
|
flushedpancake asked 'Why is the svn trunk returning a 404 btw' I'm not getting a 404 on the https://sourceforge.net/p/xmb-forum/code/HEAD/tree/ svn. Perhaps it was a transient error or accessing an old linked svn? |
|
Yup, I was trying to access the one mentioned in the sourceforge page for copying to a terminal window: svn checkout svn://svn.code.sf.net/p/xmb-forum/code/trunk xmb-forum-code I've never used subversion before so I just assumed I was doing something wrong or the mentioned thing in the sourceforge page was old. |
|
Thanks for the report. The installer hasn't been revised or tested much over the years. Attempting to connect to the DB 'upon trying to open the installer' would be unexpected behavior. I will look into it. |
|
Caused by a breaking change in error handling in PHP 8.1 that overrides the error control operator. |
|
I was hoping for an easy fix, but a breaking change in the mysqli driver could affect the entire DB interface for XMB. I will have to figure out if it's best to accommodate all default configurations, or just force the new defaults onto older PHP servers. The installer never actually implemented the XMB interface in the past, only the config file, which could mean re-factoring all the DB code in the installer now. |
|
I have a compile-able solution here. It's a rewrite of about a third of the MySQLi abstraction, and related adjustments needed in the installer and header.php. https://sourceforge.net/p/xmb-forum/code/HEAD/tree/xmb19x/branches/1.9.12.06/ It needs some polish and a lot of testing. |
Date Modified | Username | Field | Change |
---|---|---|---|
2024-04-01 15:50 | flushedpancake | New Issue | |
2024-04-01 15:50 | flushedpancake | File Added: Screenshot_2024-04-01_23-39-28.png | |
2024-04-01 15:50 | flushedpancake | File Added: Screenshot_2024-04-01_23-42-11.png | |
2024-04-01 22:15 | lottos | Relationship added | related to 0000681 |
2024-04-01 22:16 | lottos | Note Added: 0000439 | |
2024-04-01 22:29 | lottos | Note Added: 0000440 | |
2024-04-02 00:47 | flushedpancake | Note Added: 0000441 | |
2024-04-02 00:47 | flushedpancake | File Added: 915130E6-2104-45C6-A5C7-8DEB892E60DF.png | |
2024-04-02 06:22 | miqrogroove | Assigned To | => miqrogroove |
2024-04-02 06:22 | miqrogroove | Status | new => acknowledged |
2024-04-02 06:22 | miqrogroove | Note Added: 0000442 | |
2024-04-02 06:23 | miqrogroove | Description Updated | |
2024-04-02 06:23 | miqrogroove | Steps to Reproduce Updated | |
2024-04-03 07:54 | miqrogroove | Status | acknowledged => confirmed |
2024-04-03 07:54 | miqrogroove | Target Version | => 1.9.12.06 |
2024-04-03 07:54 | miqrogroove | Summary | Installation script issues => Installer Throws MySQL Exception in PHP 8.1+ |
2024-04-03 07:54 | miqrogroove | Description Updated | |
2024-04-03 07:54 | miqrogroove | Steps to Reproduce Updated | |
2024-04-03 07:54 | miqrogroove | Additional Information Updated | |
2024-04-03 07:54 | miqrogroove | MySQL Version | 10.11.6 => |
2024-04-03 07:54 | miqrogroove | PHP Version | 8.2.10 => 8.1 |
2024-04-03 07:54 | miqrogroove | Note Added: 0000443 | |
2024-04-03 07:57 | miqrogroove | Product Version | 1.9.12.05 => 1.9.12.04 |
2024-04-03 07:58 | miqrogroove | Note Edited: 0000443 | |
2024-04-03 07:59 | miqrogroove | Reproducibility | sometimes => always |
2024-04-03 07:59 | miqrogroove | Status | confirmed => assigned |
2024-04-03 07:59 | miqrogroove | OS | xubuntu => |
2024-04-03 07:59 | miqrogroove | OS Version | 23.10 => |
2024-04-03 07:59 | miqrogroove | Additional Information Updated | |
2024-04-03 13:52 | miqrogroove | Status | assigned => resolved |
2024-04-03 13:52 | miqrogroove | Resolution | open => fixed |
2024-04-03 13:52 | miqrogroove | Fixed in Version | => 1.9.12.06 |
2024-04-03 13:52 | miqrogroove | SVN Revision | => 3023 |
2024-04-03 13:52 | miqrogroove | Status | resolved => assigned |
2024-04-03 13:52 | miqrogroove | Fixed in Version | 1.9.12.06 => |
2024-04-03 13:52 | miqrogroove | SVN Revision | 3023 => |
2024-04-04 02:05 | miqrogroove | Note Added: 0000449 | |
2024-04-04 07:02 | miqrogroove | Resolution | fixed => open |
2024-04-05 08:21 | miqrogroove | Note Added: 0000450 | |
2024-04-06 18:56 | miqrogroove | Status | assigned => resolved |
2024-04-06 18:56 | miqrogroove | Resolution | open => fixed |
2024-04-06 18:56 | miqrogroove | Fixed in Version | => 1.9.12.06 |
2024-04-06 18:56 | miqrogroove | SVN Revision | => 3031 |
2024-04-15 04:35 | miqrogroove | Status | resolved => closed |