Hi,
I'm trying to move a section inside a lesson, when I drag and dropped the session occurs an error message is displayed indicating that there was trouble to write to database.
The error message showed is attached. And the log of MySQL for this operation is above.
130227 23:15:12 28793 Connect fit_ead@localhost on fit_ead
28793 Query SET NAMES utf8
28793 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES'
28793 Query SELECT name,value FROM mdl_config
28793 Query SELECT * FROM mdl_context WHERE contextlevel = '10'
28793 Query SELECT * FROM mdl_course WHERE category = '0'
28793 Query SELECT * FROM mdl_course WHERE id = '87'
28793 Query SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '87'
28793 Query SELECT name,value FROM mdl_user_preferences WHERE userid = '2'
28793 Query SELECT name,value FROM mdl_config_plugins WHERE plugin = 'theme_magazine'
28793 Query SELECT 'x' FROM mdl_course_sections WHERE course = '87' AND section = '1' LIMIT 0, 1
28793 Query SELECT * FROM mdl_capabilities ORDER BY id, name, captype, riskbitmask
28793 Query SELECT name,value FROM mdl_config_plugins WHERE plugin = 'moodlecourse'
28793 Query SELECT id,name,value FROM mdl_course_format_options WHERE courseid = '87' AND format = 'weeks' AND sectionid = '0'
28793 Query SELECT id, section FROM mdl_course_sections WHERE course = '87' ORDER BY section ASC, id ASC
28793 Query SELECT engine
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = DATABASE() AND table_name = 'mdl_config'
28793 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
28793 Query START TRANSACTION
28793 Query UPDATE mdl_course_sections SET section = '0' WHERE id = '1659'
28793 Query ROLLBACK