Moodle

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9
• Fix Version/s: 1.9
• Component/s: Other
• Labels:

  None

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

• Assignee:

  Petr Škoda (skodak)

  Reporter:

  Eloy Lafuente (stronk7)

  Tester:

  Nobody

  Participants:

  Eloy Lafuente (stronk7), Petr Škoda (skodak)

• Created:

  12/Aug/07 5:13 PM

  Updated:

  17/Dec/10 1:08 PM

  Resolved:

  17/Sep/07 5:48 AM