View Issue Details

IDProjectCategoryView StatusLast Update
0000685XMB1Bugspublic2024-04-15 04:35
Reporterflushedpancake Assigned Tomiqrogroove  
PriorityhighSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version1.9.12.04 
Target Version1.9.12.06Fixed in Version1.9.12.06 
Summary0000685: Installer Throws MySQL Exception in PHP 8.1+
DescriptionBecause 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 Reproduce1) 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 Informationhttps://www.php.net/manual/en/mysqli-driver.report-mode.php
TagsNo tags attached.
MySQL Version
PHP Version8.1
Web ServerApache
BrowserChrome
Flags
Original Reporter
SVN Revision3031

Relationships

related to 0000681 closedmiqrogroove Installer Version Number is Stale and Doesn't Match header.php 

Activities

flushedpancake

2024-04-01 15:50

reporter  

lottos

2024-04-01 22:16

updater   ~0000439

Version issue has a bug report here: https://bugs.xmbforum2.com/view.php?id=681

lottos

2024-04-01 22:29

updater   ~0000440

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?

flushedpancake

2024-04-02 00:47

reporter   ~0000441

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.

miqrogroove

2024-04-02 06:22

administrator   ~0000442

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.

miqrogroove

2024-04-03 07:54

administrator   ~0000443

Last edited: 2024-04-03 07:58

Caused by a breaking change in error handling in PHP 8.1 that overrides the error control operator.

miqrogroove

2024-04-04 02:05

administrator   ~0000449

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.

miqrogroove

2024-04-05 08:21

administrator   ~0000450

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.

Issue History

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