0000667: MySQL && Operator is Deprecated

ID	Project	Category	View Status	Date Submitted	Last Update

0000667	XMB1	Bugs	public	2023-07-14 23:43	2023-08-03 01:47

Reporter	miqrogroove	Assigned To	miqrogroove
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.9.11.15
Target Version	1.9.12.04	Fixed in Version	1.9.12.04

Summary	0000667: MySQL && Operator is Deprecated
Description	Queries containing &&, \|\|, or ! will cause deprecated messages to be logged in XMB debug mode, beginning with the MySQL version released 2019-07-22. [14-Jul-2023 23:35:00 America/Los_Angeles] MySQL generated 1 warnings in the following query: DELETE FROM xmb_whosonline WHERE ((ip='x.x.x.x' && username='xguest123') OR (username='') OR (time < '1689402300')) array ( 'Level' => 'Warning', 'Code' => '1287', 'Message' => '\'&&\' is deprecated and will be removed in a future release. Please use AND instead', )
Additional Information	https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-17.html#mysqld-8-0-17-deprecation-removal
Tags	No tags attached.

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

Date Modified	Username	Field	Change
2023-07-14 23:43	miqrogroove	New Issue
2023-07-15 00:04	miqrogroove	Note Added: 0000431
2023-07-15 05:15	miqrogroove	Assigned To	=> miqrogroove
2023-07-15 05:15	miqrogroove	Status	new => assigned
2023-07-15 05:19	miqrogroove	Status	assigned => resolved
2023-07-15 05:19	miqrogroove	Resolution	open => fixed
2023-07-15 05:19	miqrogroove	Fixed in Version	=> 1.9.12.04
2023-07-15 05:19	miqrogroove	SVN Revision	=> 3003
2023-07-15 08:33	miqrogroove	Status	resolved => closed
2023-08-03 01:47	miqrogroove	Relationship added	related to 0000662
2023-08-03 01:47	miqrogroove	Relationship deleted	related to 0000662
2023-08-03 01:47	miqrogroove	Relationship added	related to 0000679

miqrogroove 2023-07-15 00:04 administrator ~0000431	Testing shows the != operator is unaffected.