View Issue Details

IDProjectCategoryView StatusLast Update
0000690XMB1Bugspublic2024-04-15 04:35
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.9.12.04 
Target Version1.9.12.06Fixed in Version1.9.12.06 
Summary0000690: Super Admin Account is Invisible After Install Until Editing Own Profile
DescriptionWhile testing the installer, I noticed the original user account was created with the invisible field set to an empty string or similar value. In this state, logging in and logging out appears to have no effect on the invisibility of the user.

It looks like there's an old, inappropriate numeric default of 0 which literally assigns an empty set (neither '0' nor '1' nor null) to the field. It may be necessary to always interpret this field as either === '1' or !== '1'.

Complicating this, we have different results for equality when comparing an empty string value from MySQL against an integer zero in PHP 7.4 and PHP 8.0. Without coercing the empty string to either '0' or 0 the results become unpredictable. Also remember, the empty string is not equal to '0' in any version of PHP.

There's also a bug in addWhosonline() where the invisible field is being set numerically instead of using string input.

The cinst.php routine has a buggy query that effectively duplicates the newer \XMB\SQL\addMember(). It's time to implement the newer function.
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision3033

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2024-04-05 16:13 miqrogroove New Issue
2024-04-05 16:58 miqrogroove Description Updated
2024-04-05 17:05 miqrogroove Description Updated
2024-04-05 17:19 miqrogroove Status new => acknowledged
2024-04-05 17:19 miqrogroove Target Version => 1.9.12.06
2024-04-05 17:19 miqrogroove Description Updated
2024-04-06 18:37 miqrogroove Assigned To => miqrogroove
2024-04-06 18:37 miqrogroove Reproducibility have not tried => always
2024-04-06 18:37 miqrogroove Status acknowledged => assigned
2024-04-06 18:37 miqrogroove Product Version => 1.9.12.04
2024-04-07 05:27 miqrogroove Description Updated
2024-04-09 13:04 miqrogroove Status assigned => resolved
2024-04-09 13:04 miqrogroove Resolution open => fixed
2024-04-09 13:04 miqrogroove Fixed in Version => 1.9.12.06
2024-04-09 13:04 miqrogroove SVN Revision => 3033
2024-04-15 04:35 miqrogroove Status resolved => closed