SQL error

[mlapl1]

Hello

Just returned to playing with FormaLMS. Yesterday installed the latest version and successfully uploaded a SCORM package. Today I can no longer create any learning object. I get an sql error which looks approximately as below. I am using a WAMP called vertrigoserv and which seems to be functioning ok otherwise.

Any help would be welcome.
Andrew

Code: Select all

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/00000002','1', 'gdgdf', 'htmlpage', '2', '0', '0', '11836', '1.0', '_DIFFICULT_MEDIUM', '', '', '', '', '2015-10-02 12:50:00' , '1', '', '0', '10', '1', '', 0, 0, '', '', '', '' ) Data truncated for column 'difficult' at row 1

[canelli]

your scorm package seems wrong

'gdgdf', 'htmlpage', '2', '0', '0', '11836', '1.0', '_DIFFICULT_MEDIUM', '', '', '', '', '2015-10-02 12:50:00' , '1', '', '0', '10', '1', '', 0, 0, '', '', '', '' ) Data truncated for column 'difficult' at row 1

The difficult column can have the following values:
'_VERYEASY',
'_EASY',
'_MEDIUM',
'_DIFFICULT',
'_VERYDIFFICULT'

these are the only token supported and compliant with SCORM standard

[mlapl1]

Hello

thanks for the feedback. As I said in the post, I cannot save ANY learning object - although previously I had successfully uploaded a SCORM package. The above feedback actually came from an attempt to save an HTML page not a SCORM package.

Cheers
Andrew

[canelli]

Uhmmmm...
Have you changed anything in your server configuration ?
Any update of WAMP server ( vertrigoserv ) ?

you have the last version of forma.lms ?
what PHP and mySQL version ?

[mlapl1]

Hi Claudio,

No. No change of anything at all. Latest forma. Apache 2.4.16; PHP 5.5.28; MySQL 5.6.26

Don't worry about it - I know it makes no sense. Must be some local problem.

Cheers
Andrew

[canelli]

Andrew
All thing in IT have sense, but can be very hard found it . the troubleshooting and bug analisys are very complex activities.

Can you try with PHP 5.4 ?

[xenothan]

I know this is an old thread, but had the same issue. so here is the solution:

Find my.cnf file, find the sql_mode setting and remove the part that says STRICT. Restart the mysql server

[alberto]

Hi xenothan, thanks for sharing your solution