moodle-enrol_programs's People
Forkers
chrispratt-tonyyeb marcusgreen genealogical-studies lushonline albertolarah mordekai23 benutzer-prog catalystmoodle-enrol_programs's Issues
If no programs defined, all calendar events are deleted by \enrol_programs\task\cron
If there are no programs defined, the SQL at line 179 of enrol/programs/classes/local/calendar.php fetches all calendar events, not just those with a component=='enrol_programs' as both "LEFT JOIN"s just produce null values. I think the "AND e.component=..." in the first "LEFT JOIN" isn't doing what you think it is.
As a result, the following code then deletes every event.
This is from the moodle version 4 stable branch of your code.
This is run at 1 minute past every hour as a scheduled task, so you don't have long to create a program before all your calendar events are wiped.
few styles in styles.php a bit too generic
standard template text response follows... :-)
in your styles.css you define a number of generic styles that could clash with core moodle code or other locations where simliar names are used.
Moodle helpfully adds a number of classes to the body tag based on the path that you can use such as:
eg if you are have a file in mod/assign you would see the following class added to the body tag
path-mod-assign
so if you have an item with the class "filething" on the page you would target it like:
.path-mod-assign .filething {
color: red;
}
Please make sure your css classes in styles.css are specific enough so they cannot clash with other core code.
Foreign key violations
The table users does not exist in Moodle, the table user does
Foreign key userid on table enrol_programs_requests points to a non-existent table users.
Foreign key rejectedby on table enrol_programs_requests points to a non-existent table users.
Foreign key userid on table enrol_programs_allocations points to a non-existent table users.
Foreign key userid on table enrol_programs_evidences points to a non-existent table users.
Foreign key createdby on table enrol_programs_evidences points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_prg_snapshots points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_usr_snapshots points to a non-existent table users.
Foreign key userid on table enrol_programs_usr_snapshots points to a non-existent table users.
enrol/programs/db/install.xml
enrol_programs_programs
Key: foreign (contextid) references context (id) OK
enrol_programs_items
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (previtemid) references enrol_programs_items (id) OK
enrol_programs_groups
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (groupid) references groups (id) OK
enrol_programs_prerequisites
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (prerequisiteitemid) references enrol_programs_items (id) OK
enrol_programs_cohorts
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (cohortid) references cohort (id) OK
enrol_programs_sources
Key: foreign (programid) references enrol_programs_programs (id) OK
enrol_programs_requests
Key: foreign (sourceid) references enrol_programs_sources (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (rejectedby) references users (id) Refers to an unknown table
enrol_programs_allocations
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK
enrol_programs_completions
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
enrol_programs_evidences
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (createdby) references users (id) Refers to an unknown table
enrol_programs_prg_snapshots
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
enrol_programs_usr_snapshots
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK
PUBLIC is a SQL Server reserved word and cannot be used as a bare identifier.
Table mdl_enrol_programs_programs have a column name 'public'. 'Public' is a reserved word in SQL Server which made this plugin unrelevant with SQL server :(
For exampel, a simple insert in table get an error.
Query error (156): Incorrect syntax near the keyword 'public'.
Best regards,
Unable to add programs
Hi,
I have installed Moodle 4.0.4+ on Ubuntu 20.04 and using MySQL. Then, I installed moodle-enrol_programs, moodle-block_myprograms, and moodle-local_openlms. However, I am getting an error when I tried to add programs. Please find the details below:
Error details:
JSON.parse: unexpected character at line 1 column 5 of the JSON data
File: https://moodlesite/lib/javascript.php/1667111939/lib/jquery/jquery-3.6.0.min.js
Line: 2
ln: 79470
https://moodlesite/lib/javascript.php/1
ajax/l/s<
ln: 79587
https://moodlesite/lib/javascript.php/1
l
ln: 82355
https://moodlesite/lib/javascript.php/1
send/o/<
I need new allocation for students who completed another progrom
I really appreciate your hard work
Completion date not set automatically when a course is complete
The next course in the program does not appear automatically when the previous course is complete. we have to go to programs/program management/user select the user, and in that moment the completion date is set and the next course is visble.
Readme message: "This code is not yet suitable for production use"
The "Installation" section in the README.md file states that: "This code is not yet suitable for production use."
Approximately, when will this plugin be stable enough for production use?
external function get_programs not returning results
'All in Order' not working
Hi Team,
I installed this plugin with all it's dependencies. I use All in Order but I found it is not working as expected.
By default first course is coming to take but after completion of this 2nd or 3rd not getting enabled. I tried multiple time but same issue. I also tried running the CRON but no impact. Can you please check and fix. Also, please let me know in case I am missing something.
It didnt update the dates
If we create a program with no set program end date, enroll some users, and then create a ending date. The ending date of those users didn't update with the new information.
Am i wrong? or there is no way to auto-update this info?
Thanks 4 your work!
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.