View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000670XMB Hacks 1.9.xpublic2023-07-20 06:562024-04-03 14:07
Reportermiqrogroove Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Summary0000670: Sitemap: MySQL 8.0 Deprecated: User variables within expressions
Description[16-Jul-2023 16:33:13 America/Los_Angeles] MySQL generated 2 warnings in the following query:
SELECT *
         FROM ( SELECT tid, thedate, pages, @running_pages:=@running_pages + pages AS running_pages
         FROM
         (
           SELECT tid, SUBSTRING_INDEX(lastpost,'|',1) AS thedate, CEIL( (replies + 1) / 20 ) AS pages
           FROM xmb_threads
           WHERE fid IN(1, 468, 469, 29, 21, 105, 440, 353, 442, 431, 447, 349, 348, 441, 322, 427, 426, 355, 425, 420, 419, 391, 382, 462, 389, 422, 358, 424) AND closed NOT LIKE 'moved|%'
         ) AS t
         CROSS JOIN
         (
           SELECT @running_pages:=0
         ) AS init
         ORDER BY tid ) AS allthreads
         
         LIMIT 50000
array (
  'Level' => 'Warning',
  'Code' => '1287',
  'Message' => 'Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: \'SET variable=expression, ...\', or \'SELECT expression(s) INTO variables(s)\'.',
)
array (
  'Level' => 'Warning',
  'Code' => '1287',
  'Message' => 'Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: \'SET variable=expression, ...\', or \'SELECT expression(s) INTO variables(s)\'.',
)
TagsNo tags attached.

Relationships

child of 0000662 acknowledged XMB1 Add Sitemap Feature 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-07-20 06:56 miqrogroove New Issue
2024-04-03 14:07 miqrogroove Relationship added child of 0000662