[wp-meta] [Making WordPress.org] #1785: Trac uploads and report queries are failing (was: Error on listing "My Tickets" (No such function: CONCAT))

[Making WordPress.org]

#1785: Trac uploads and report queries are failing
-----------------------------+------------------
 Reporter:  xavortm          |       Owner:
     Type:  defect           |      Status:  new
 Priority:  highest omg bbq  |   Milestone:
Component:  Trac             |  Resolution:
 Keywords:  has-screenshots  |
-----------------------------+------------------
Changes (by netweb):

 * priority:  normal => highest omg bbq


Comment:

 See also #meta-tracdev Slack discussion
 https://wordpress.slack.com/archives/meta-tracdev/p1467013726000019

 * https://core.trac.wordpress.org/report/24: `OperationalError: no such
 function: CONCAT`
 * Trac reports `11`, `22`, `24`, `30`, `31` report `OperationalError: no
 such function: CURDATE`
 * Uploading patches results in: `database is locked`
  *
 [[Image(https://s3.amazonaws.com/f.cl.ly/items/3k0m0Z1h383X08140E1v/Internal_Error__WordPress_Trac_2016-06-27_09-59-12.jpg)]]

 The `CURDATE`  is a MySQL function, not available in SQLite, updating
 those Trac reports to use whatever compatible SQLite queries appears to be
 the fix required for that, not sure for patch uploads.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/1785#comment:1>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org