#2746 - Sometimes block loading results in a MySQL query error
-
By PDStig
- Added
- 4 views
| Identifier | #2746 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | Sometimes block loading results in a MySQL query error |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | core |
| Description | Unfortunately a query has failed [UPDATE alfa_temp_block_permissions SET p_time=1469829230 WHERE (p_session_id=3514966991453 AND p_block_constraints='as_guest=0,attach_to_url_filter=0,block=main_news,blogs=0,defer=1,fallback_archive=6,fallback_full=3,member_based=0,multiplier=0\\.5,no_links=0,optimise=0,pagination=0,param=30,render_if_empty=0,select=8,show_in_full=0,start=0,title=Latest News,zone=_SEARCH') LIMIT 1] [<strong>Truncated incorrect DOUBLE value: '2f72590e4f149'</strong>] (version: 10 RC14, PHP version: 7.0.9, URL: /) @ https://wwsu1069.org/ |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
It happens when the session ID is numeric. PHP changes numeric array indices into integers, so we get it back with an integer and it breaks a query.
This is the chance of it happening:
(10/16)^13*100=0.222%
sources/users.php in my latest commit