SQL error

Install and configure FormaLMS and DoceboCE
mlapl1
Newbie
Posts: 9
Joined: Fri Mar 13, 2015 1:24 pm
Version: forma.lms 1.3

SQL error

Postby 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

User avatar
anellic
FormaLms Guru
Posts: 347
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 1.4.2
Contact:

Re: SQL error

Postby anellic » 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
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------

mlapl1
Newbie
Posts: 9
Joined: Fri Mar 13, 2015 1:24 pm
Version: forma.lms 1.3

Re: SQL error

Postby 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

User avatar
anellic
FormaLms Guru
Posts: 347
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 1.4.2
Contact:

Re: SQL error

Postby anellic » 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 ?
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------

mlapl1
Newbie
Posts: 9
Joined: Fri Mar 13, 2015 1:24 pm
Version: forma.lms 1.3

Re: SQL error

Postby 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

User avatar
anellic
FormaLms Guru
Posts: 347
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 1.4.2
Contact:

Re: SQL error

Postby anellic » 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 ?
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------

xenothan
Newbie
Posts: 10
Joined: Sun Jan 20, 2013 3:27 am

Re: SQL error

Postby 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
Xenothan Hojem
Jetweb (Pty) Ltd
http://www.jetweb.co.za/

User avatar
alberto
FormaLms Guru
Posts: 757
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: SQL error

Postby alberto » Sun Sep 24, 2017 9:45 am

Hi xenothan, thanks for sharing your solution
--------------------------------------------------
Become a CONTRIBUTOR

Support the project for FREE!
www.Elearnit.net


Return to “Installation and configuration”

Who is online

Users browsing this forum: No registered users and 1 guest