Plugin 2.3 (2012081502)

Plugin 2.3 (2012081502)

by Carlos Kiyan Tsunami -
Number of replies: 7
Picture of Plugin developers

I have installed the plugin 2.3 (2012081502) for moodle 2.3.1. it doesnt allow me to create a new certificate, and some of the existing certificates were delated.

here are the errors

===============================================

Debug info: Field 'reportcert' doesn't have a default value

INSERT INTO mdl_certificate (name,emailteachers,emailothers,delivery,savecert,requiredtime,printdate,datefmt,printnumber,printgrade,gradefmt,printoutcome,printhours,printteacher,customtext,certificatetype,orientation,borderstyle,bordercolor,printwmark,printsignature,printseal,course,intro,introformat,timemodified) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

[array (

0 => 'ce',

1 => '0',

2 => '',

3 => '0',

4 => '0',

5 => 0,

6 => '0',

7 => '1',

8 => '0',

9 => '0',

10 => '1',

11 => '0',

12 => '',

13 => '0',

14 => '',

15 => 'A4_non_embedded',

16 => 'L',

17 => 'Fancy2-green.jpg',

18 => '0',

19 => 'Fleursdelis.png',

20 => 'RVincent.png',

21 => 'Teamwork.png',

22 => '179',

23 => '<p>dfdf</p>',

24 => '1',

25 => 1346183626,

)]

Error code: dmlwriteexception

Stack trace:

◦    line 410 of /lib/dml/moodle_database.php: dml_write_exception thrown

◦    line 948 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()

◦    line 990 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()

◦    line 54 of /mod/certificate/lib.php: call to mysqli_native_moodle_database->insert_record()

◦    line 447 of /course/modedit.php: call to certificate_add_instance()

============================================

Does anybody knows how to solve this problem

Thanks in advance

Regards

Carlos

Average of ratings: -
In reply to Carlos Kiyan Tsunami

Re: Plugin 2.3 (2012081502)

by Mark Nelson -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers

Hi Carlos,

The latest release fixes this issue. Sorry about that.

Regards,

Mark

In reply to Mark Nelson

Re: Plugin 2.3 (2012081502)

by Marcus Hoberg -

As an alternative, you can also set a default =0 in the data base field.

Marcus

In reply to Marcus Hoberg

Re: Plugin 2.3 (2012081502)

by Carlos Kiyan Tsunami -
Picture of Plugin developers

Hello Marcus.

thanks for replying,  I am not so familiar to change it.  

Do I have to run SQL query/queries on database moodle:

===> ALTER reportcert SET DEFAULT 0;

Thanks in advance

 

Carlos

In reply to Mark Nelson

Re: Plugin 2.3 (2012081502)

by Carlos Kiyan Tsunami -
Picture of Plugin developers

Hi Mark

what do you suggest me to do it right now?

I am not able to create any certificate

Regards

Carlos

In reply to Carlos Kiyan Tsunami

Re: Plugin 2.3 (2012081502)

by Mark Nelson -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers

Hi Carlos,

I suggest upgrading the certificate module to the latest code release. smile If you can use git to download and install the certificate module that will be far more efficient for future updates, if not simply download the plugin and replace the mod/certificate folder with the one you downloaded and then log in as an admin and visit the notifications page to complete the upgrade.

Regards,

Mark