[#MDL-15904] File storage conversion Assignment

Issue Details (XML | Word | Printable)

Key:	MDL-15904
Type:	Sub-task
Status:	Resolved
Resolution:	Fixed
Priority:	Minor
Assignee:	Petr Skoda
Reporter:	Petr Skoda
Votes:	0
Watchers:	0

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Moodle

MDL-14589

File storage conversion Assignment

Created: 01/Aug/08 06:07 AM Updated: 19/Aug/08 06:27 AM

Component/s:

Assignment

Affects Version/s:

2.0

Fix Version/s:

2.0

File Attachments:

assignment_upgrade.patch.txt (1 kB)

Participants:	Eloy Lafuente (stronk7) and Petr Skoda
Security Level:	None
Resolved date:	19/Aug/08
Affected Branches:	MOODLE_20_STABLE
Fixed Branches:	MOODLE_20_STABLE

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

Petr Skoda added a comment - 01/Aug/08 06:16 AM

done except backup/restore

[ Permalink | « Hide ]

Eloy Lafuente (stronk7) added a comment - 18/Aug/08 11:26 PM

Reopening this because of some SQL cross-db annoyances (detected under PG)

[ Permalink | « Hide ]

Eloy Lafuente (stronk7) added a comment - 18/Aug/08 11:29 PM

Hi, while trying to upgrade to latest HEAD I'm getting this under PG:

ERROR: column "a.course" must appear in the GROUP BY clause or be used in an aggregate function

SELECT COUNT('x') FROM mdl_assignment_submissions s JOIN mdl_assignment a ON a.id = s.assignment JOIN mdl_modules m ON m.name = 'assignment' JOIN mdl_course_modules cm ON (cm.module = m.id AND cm.instance = a.id) ORDER BY a.course, s.assignment

Also, under MSSQL I get some errors.

Attaching patch that should fix the problem, by splitting the $sqlfrom into two components and not using it in the COUNT statement.

Important note: Both forum and glossary exhibit the same problem.

Ciao

[ Permalink | « Hide ]

Petr Skoda added a comment - 19/Aug/08 06:27 AM

thanks, fixed

All content on this web site is made available under the GNU General Public License, unless otherwise stated.