|
|
| Database: |
Any
|
| Participants: |
Eloy Lafuente (stronk7) and Petr Skoda
|
| Security Level: |
None
|
| Resolved date: |
17/Sep/07
|
| Affected Branches: |
MOODLE_19_STABLE
|
| Fixed Branches: |
MOODLE_19_STABLE
|
|
I'm getting some SQL erros. The main cause seems to be that some queries use double-quotes to enclose literals.
For example:
ERROR: column "site" does not exist<br /><br />SELECT id,courseid,userid,content,format,created,lastmodified,usermodified,publishstate FROM mdl_post WHERE userid=2 AND publishstate="site" AND module="notes" ORDER BY lastmodified DESC
in the note_list() function.
It would be interesting to fix this and to perform a quick review to detect-and-kill such quoting.
Ciao :-)
|
|
Description
|
I'm getting some SQL erros. The main cause seems to be that some queries use double-quotes to enclose literals.
For example:
ERROR: column "site" does not exist<br /><br />SELECT id,courseid,userid,content,format,created,lastmodified,usermodified,publishstate FROM mdl_post WHERE userid=2 AND publishstate="site" AND module="notes" ORDER BY lastmodified DESC
in the note_list() function.
It would be interesting to fix this and to perform a quick review to detect-and-kill such quoting.
Ciao :-)
|
Show » |
made changes - 17/Sep/07 05:48 AM
| Field |
Original Value |
New Value |
|
Assignee
|
Luiz Cruz
[ luiz.laydner
]
|
Petr Skoda
[ skodak
]
|
committed 1 file to 'Moodle CVS' - 17/Sep/07 05:48 AM
MDL-10820 Fixed double quotes in SQL statements
|
|
|
made changes - 17/Sep/07 05:48 AM
|
Status
|
Open
[ 1
]
|
Resolved
[ 5
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
|
Sub-task
Resolved
Major
