The Elearning Community

appLms/index.php?modname=storage&op=organization

Error on _addFolder: INSERT into learning_organization( idOrg, idParent, path, lev, title, objectType, idResource, idCategory, idUser, idAuthor, version, difficult, description, language, resource, objective, dateInsert, idCourse, prerequisites, isTerminator, idParam, visible, milestone, width, height, publish_from, publish_to, access, publish_for ) VALUES (NULL,'0','/root/00000007','1', 'TEST4', '', '0', '0', '0', '0', '', '', '', '', '', '', '' , '2', '', '0', '0', '1', '-', 0, 0, '', '', '', '' ) Data truncated for column 'difficult' at row 1

You're trying to store a blank value in af field (difficult) that is defined as enum('_VERYEASY','_EASY','_MEDIUM','_DIFFICULT','_VERYDIFFICULT') NOT NULL DEFAULT '_VERYEASY'
What operation were you trying to do? I can't see the objectType field defined, so I don't know how to replicate.

Hi Alfa,

I go to learning object management >> Course objects >> New Folder >> Name "day 123" click new folder

treeview_create_folder_organization
class="TreeViewAction"

Error on _addFolder: INSERT into learning_organization( idOrg, idParent, path, lev, title, objectType, idResource, idCategory, idUser, idAuthor, version, difficult, description, language, resource, objective, dateInsert, idCourse, prerequisites, isTerminator, idParam, visible, milestone, width, height, publish_from, publish_to, access, publish_for ) VALUES (NULL,'0','/root/00000007','1', 'day 123', '', '0', '0', '0', '0', '', '', '', '', '', '', '' , '2', '', '0', '0', '1', '-', 0, 0, '', '', '', '' ) Data truncated for column 'difficult' at row 1

I cannot replicate, sorry. It could be related to IIS.