Error on _addFolder:

Install and configure FormaLMS and DoceboCE
Post Reply
User avatar
Crimzin
Newbie
Posts: 13
Joined: Wed Nov 13, 2019 7:31 am

Error on _addFolder:

Post by Crimzin »

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

alfa24
Senior Boarder
Posts: 1006
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Error on _addFolder:

Post by alfa24 »

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.
I'm Jasmines, the One. If you need, you can contact me.

User avatar
Crimzin
Newbie
Posts: 13
Joined: Wed Nov 13, 2019 7:31 am

Re: Error on _addFolder:

Post by Crimzin »

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

alfa24
Senior Boarder
Posts: 1006
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: Error on _addFolder:

Post by alfa24 »

I cannot replicate, sorry. It could be related to IIS.
I'm Jasmines, the One. If you need, you can contact me.

Post Reply