Moodle plugins directory: Learning plan

Some additional info: I deleted all the tables inside the database but the error remains. Tables are recreated and then seen as already existing
Best regards,
Stefan

Fixed now - after two times deleting all the relevant tables it finally installed without errors.
Cheers,
stefan

Dear Stefan,

Sorry for the long silence. I am glad you figured out a way, In future if you find any difficulty you may directly reach us at lms@3ilogic.com.

Regards,
3i Logic LMS Team

Hello,

Would it be possible to allow students to change the status of their learning plans?

Dear Tevin,

Thank you for using learning plan plugin. It can be possible by customization as per the requirement but it comes under our customization service. If you wants to avail our customization service I can forward your query to our marketing department.Please send me your detail requirements at lms@3ilogic.com.

Regards,
3i Logic LMS Team

Hello,

looking forward to using this resource, however I just installed and hit the same error that Stefan hit above. Now, it appears im kind of stuck in limbo. It keeps taking me back to the plugins "plugins check" page and under the "Learning_Plan" block, it notes "to be installed" however if i click "upgrade database, it just keeps getting the same error.

I noted what Stefan did above to fix, but Im not as confident or skilled in this as he and im afraid of doing more damage. Could you please advise? Thank you!

Moodle version 2.9



block_learning_plan

DDL sql execution error

More information about this error

Debug info: Table 'mdl_block_learning_plan' already exists
CREATE TABLE mdl_block_learning_plan (
id BIGINT(10) NOT NULL auto_increment,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for block_learning_plan, please edit me'
;
CREATE TABLE mdl_learning_learningplan (
id BIGINT(10) NOT NULL auto_increment,
learning_plan VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
description LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Learning Plan'
;
CREATE TABLE mdl_learning_training (
id BIGINT(10) NOT NULL auto_increment,
training_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
type_id BIGINT(10) NOT NULL,
file VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
url VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
start_date BIGINT(10),
end_date BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_plan_training (
id BIGINT(10) NOT NULL auto_increment,
lp_id BIGINT(10) NOT NULL,
t_id BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learplantrai_lp__ix (lp_id)
, KEY mdl_learplantrai_t_i_ix (t_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_traningtype (
id BIGINT(10) NOT NULL auto_increment,
training_type VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
description LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_user_learningplan (
id BIGINT(10) NOT NULL auto_increment,
u_id BIGINT(10) NOT NULL,
lp_id BIGINT(10) NOT NULL,
assignee_id BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learuserlear_lp_2_ix (lp_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
;
CREATE TABLE mdl_learning_user_trainingplan (
id BIGINT(10) NOT NULL auto_increment,
lpt_id BIGINT(10) NOT NULL,
u_id BIGINT(10) NOT NULL,
status VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'Not Yet Started',
remarks VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_learusertrai_lpt2_ix (lpt_id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Default comment for the table, please edit me'
Error code: ddlexecuteerror
Stack trace:
line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 412 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 364 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 867 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 426 of /lib/upgradelib.php: call to upgrade_plugins_blocks()
line 1630 of /lib/upgradelib.php: call to upgrade_plugins()
line 433 of /admin/index.php: call to upgrade_noncore()

Dear Luke,

Thank you for using learning plan plugin. we'll get back to you after diagnose this issue.

Regards,
3i Logic LMS Team

Installed plugin not able to add it to course kindly provide solution

Hi, can anyone assist me on this? How to add a teacher/manager on the Learning plan? Thanks

Dear Leslie,
Thank you for using Learning Plan plugin. Moodle default role of teacher/manager will work with Learning Plan.

Regards,
3i Logic LMS Team

Dear Aishwaria,

Can you provide plugin version so we can diagnose the problem?

Regards,
3i Logic LMS Team

Hi, It's version 2.9 (2016021201). I'm using moodle 3.0. The Learning plan works with eh admin role. How do I assigned a teacher or a manager to managed the Learning Plan?

Dear Leslie,

There is no need to assigned manager to manage Learning Plan activities, by default manager can manage all learning plan activities. You need to create user and assign manager role, when the user having manager role access the learning plan than they have rights to do management activities in the Learning Plan.

Thanks,
3i Logic LMS Team

sorry for my query, but I can't seem to add a manager to manage training plan.

example: Peter has 10 students, Peter dont have any role on the site. I want him to be the manager of the training block to manage the 10 students. how do I do that?

Thanks

Hi Leslie,

Can you provide your email address? so we can send you a detail process of assigning a manager. You can also reach us directly too at lms@3ilogic.com

Regards,
3i Logic LMS Team