0000605: Invalid SQL Syntax in member.php

ID	Project	Category	View Status	Date Submitted	Last Update

0000605	XMB1	Bugs	public	2020-09-19 08:12	2020-10-19 09:12

Reporter	miqrogroove	Assigned To	miqrogroove
Priority	normal	Severity	major	Reproducibility	sometimes
Status	closed	Resolution	fixed
Product Version	1.9.8 SP2
Fixed in Version	1.9.9

Summary	0000605: Invalid SQL Syntax in member.php
Description	I recently had the opportunity to troubleshoot a database error on a v1.9.5 installation. This does not affect versions 1.9.9 and higher, so I am documenting this only for posterity. In summary, the REGEXP phrase ([:space:]) is not valid. I don't know how this made it into the codebase, but presumably it actually worked on older SQL engines. So depending on the environment, this should always cause the member profiles to fail to load for everyone trying to view them except the Super Admin. The underlying error might look like this: MySQL encountered the following error: Got error 'POSIX named classes are supported only within a class at offset ' from regexp However, older versions of XMB had poor SQL error reporting and that message might never be displayed or logged anywhere. Per the MySQL 4.1 manual, [:space:] may only be used WITHIN a character class, which actually means [[:space:]] but never ([:space:])
Additional Information	https://sourceforge.net/p/xmb-forum/code/HEAD/tree/xmb19x/tags/XMB-1.9.3-final/Files/member.php
Tags	No tags attached.

MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision

Date Modified	Username	Field	Change
2020-09-19 08:12	miqrogroove	New Issue
2020-09-19 08:12	miqrogroove	Status	new => resolved
2020-09-19 08:12	miqrogroove	Resolution	open => fixed
2020-09-19 08:12	miqrogroove	Fixed in Version	=> 1.9.9
2020-10-19 09:12	miqrogroove	Assigned To	=> miqrogroove
2020-10-19 09:12	miqrogroove	Status	resolved => closed