The Elearning Community • SQL error
Page 1 of 1

SQL error

Posted: Fri Oct 02, 2015 1:57 pm
by 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

Re: SQL error

Posted: Sat Oct 03, 2015 9:12 am
by 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

Re: SQL error

Posted: Sat Oct 03, 2015 10:02 am
by 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

Re: SQL error

Posted: Sat Oct 03, 2015 12:14 pm
by 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 ?

Re: SQL error

Posted: Sun Oct 04, 2015 10:55 pm
by 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

Re: SQL error

Posted: Mon Oct 05, 2015 4:25 pm
by 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 ?

Re: SQL error

Posted: Sat Sep 09, 2017 9:53 am
by 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

Re: SQL error

Posted: Sun Sep 24, 2017 9:45 am
by alberto
Hi xenothan, thanks for sharing your solution

This site uses cookies.

Some of the cookies we use are essential for parts of the site to operate and have already been set. We also use Google Analytics scripts, which all use cookies.
You may delete or block all cookies from this site in your browser options.