SQL error

mlapl1 · Post by **mlapl1** » Fri Oct 02, 2015 1:57 pm

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 · Post by **canelli** » Sat Oct 03, 2015 9:12 am

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 · Post by **mlapl1** » Sat Oct 03, 2015 10:02 am

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 · Post by **canelli** » Sat Oct 03, 2015 12:14 pm

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 · Post by **mlapl1** » Sun Oct 04, 2015 10:55 pm

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 · Post by **canelli** » Mon Oct 05, 2015 4:25 pm

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 · Post by **xenothan** » Sat Sep 09, 2017 9:53 am

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 · Post by **alberto** » Sun Sep 24, 2017 9:45 am

Hi xenothan, thanks for sharing your solution

Login Form

SQL error

SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error