FS#129 : Update the system for restrictive SQL

Quick Actions

View Dependency Graph

Status New
Percent Complete
0%
Task Type Bug Report
Category Core
Assigned To

Spider IT
Operating System All
Severity Low
Priority Very Low
Reported Version 2.0.7
Due in Version 2.1.0
Due Date Undecided
Votes
Private

Attached to Project: drugCMS
Opened by Spider IT - Y-m-d

FS#129 - Update the system for restrictive SQL

As SQL gets more restrictive, one can't use '0000-00-00 00:00:00' for a datetime field.
Also one can't GROUP BY or ORDER BY non selected fields, or have fields missing in GROUP BY which are selected.

Comments (0)
Related Tasks (0/0)

	Tasks related to this task (0)

Loading...

Keyboard shortcuts

Available keyboard shortcuts

Alt + ⇧ Shift + l Login Dialog / Logout
Alt + ⇧ Shift + a Add new task
Alt + ⇧ Shift + m My searches
Alt + ⇧ Shift + t focus taskid search

Tasklist

o open selected task
j move cursor down
k move cursor up

Task Details

n Next task
p Previous task
Alt + ⇧ Shift + e ↵ Enter Edit this task
Alt + ⇧ Shift + w watch task
Alt + ⇧ Shift + y Close Task

Task Editing

Alt + ⇧ Shift + s save task