https://docs.moodle.org/310/en/api.php?action=feedcontributions&feedformat=atom&user=McampbellMoodleDocs - User contributions [en]2026-04-18T11:28:15ZUser contributionsMediaWiki 1.43.5https://docs.moodle.org/310/en/index.php?title=Custom_SQL_queries_report&diff=70880Custom SQL queries report2010-04-09T21:49:10Z<p>Mcampbell: /* Monthly Usage by Role */</p>
<hr />
<div>Created by The Open University<br />
<br />
This admin report plugin allows Administrators to set up arbitrary database queries to act as ad-hoc reports. Reports can be of two types: either run on demand, or scheduled to run automatically. Other users with the right capability can go in and see a list of queries that they have access to. Results can be viewed on-screen or downloaded as CSV.<br />
<br />
==Installing this report==<br />
<br />
Follow the generic [[Installing contributed modules or plugins]] documentation.<br />
<br />
<br />
==Screen shots==<br />
<br />
Here are two example screen shots, showing the two main screens.<br />
<br />
[[Image:Custom_report_list.png|thumb|none|600px|The list of available reports]]<br />
[[Image:Custom_report.png|thumb|none|600px|The results of running one of the reports]]<br />
<br />
(Note, these screen shots are in the OU theme, not the standard Moodle theme, and iCMA is OU-jargon for quiz.)<br />
<br />
==Interface for normal users==<br />
<br />
===List of available queries===<br />
<br />
Users with the report/customsql:view capability can access the list of reports in the admin block. Each query is accessible only to a certain people. There are three levels of access:<br />
* Available to any one who can access the report at all (those with report/customsql:view).<br />
* Available to people who are able to see other system reports (those with moodle/site:viewreports)<br />
* Available to administrators only (those with moodle/site:config)<br />
<br />
When you go to the list, it will only show the queries you have access to. There is a note beside each query saying when it was last run, and how long it took to generate.<br />
<br />
The list shows on-demand and scheduled queries separately.<br />
<br />
<br />
===Running an on-demand query===<br />
<br />
To run an on-demand query, click on its name in the list of queries.<br />
<br />
The query will be run, and the results will be displayed as a table. Any URLs in the table will automatically be made into hyperlinks.<br />
<br />
A description of the query may appear above the table.<br />
<br />
The summary of when the query was run and how long it took is shown at the bottom, along with a link to download the CSV file (for example to get the data into Excel) and a link back to the list of all available queries.<br />
<br />
<br />
===Viewing the results of scheduled queries===<br />
<br />
Scheduled queries can work in one of two ways. Either each run of the report generates and entire table of reasults, or each run just creates one line of results, and the report builds up a row at a time.<br />
<br />
When you click the name in the list of queries, you get taken to a display of the latest results, just like in the on-demand case.<br />
<br />
However, if each scheduled run generates a complete report, then at the bottom of a page there will be a list of all the previous runs of the report, so that you can go and see how the report changed over time.<br />
<br />
<br />
==Interface for administrators==<br />
<br />
Administrators (that is, users with report/customsql:definequeries) see everything that other users see, but with some additions.<br />
<br />
<br />
===Additional controls in the staff interface===<br />
<br />
Administrators get shown who each report in the list is available to.<br />
<br />
They also get an edit and a delete icon next to each query.<br />
<br />
There is an '''Add new query button''' at the end of the list of queries.<br />
<br />
When viewing a particular query, Administrators get an edit and a delete link underneath the table of results.<br />
<br />
<br />
===Adding or editing a query===<br />
<br />
When you click the '''Add new query button''', you get taken to an editing form that lets you define the query.<br />
<br />
You must give the query a name.<br />
<br />
You can optionally enter a description that is displayed above the results table. You should use this to explain what the results of the query mean.<br />
<br />
You must enter the SQL to generate the results you want displayed. This must be an SQL select statement. You must use the prefix prefix_ for table names. It should not be possible to enter any SQL that would alter the contents of the database.<br />
<br />
You choose who you want the query to be accessible to.<br />
<br />
You choose whether the query should be run on-demand or scheduled weekly or monthly. If the report is scheduled, you can say whether the each run returns one row to be added to a single table, or whether each run generates a separate table.<br />
<br />
When you save the new query, the SQL is checked to make sure that it will execute without errors. If you have said that the report will only return a single row, this is also checked.<br />
After saving the query, if this was a manual query, you are taken to the query results page, so you can see what the results look like. If it was an automatic query or if you cancel the form, you are taken to the list of available queries.<br />
<br />
Editing an existing query uses the same form as for adding a new query, but to change the properties of an existing query.<br />
<br />
Note that at the OU, weeks start on Saturday. If you don't like that, there is a fairly obvious constant to hack at the top of locallib.php.<br />
<br />
===Deleting a query===<br />
<br />
When you click the delete icon or link for a query, you are taken to a confirmation page that shows you SQL of the query you are about to delete. The query is only deleted if you click Yes on the confirmation page.<br />
<br />
After deleting a query, you are taken back to the list of queries.<br />
<br />
==Share your interesting queries here==<br />
<br />
If you come up with any interesting SQL to custom reports, you can share it here.<br />
<br />
===Quiz attempts in the last week/month===<br />
<br />
Set this up as a scheduled report:<br />
<br />
<code sql><br />
SELECT COUNT(*)<br />
FROM prefix_quiz_attempts<br />
WHERE timefinish > %%STARTTIME%%<br />
AND timefinish <= %%ENDTIME%%<br />
AND preview = 0<br />
</code><br />
<br />
This '''must''' be set up as a '''Scheduled, on the first day of each week''' or '''Scheduled, on the first day of each month''' report, or it will not work.<br />
<br />
===Usage summary===<br />
<br />
This report shows roughly the same usage statistics that are sent to moodle.org when you register your site. The ones that are aggregated at http://moodle.org/stats/. (The only difference is that the registration form does not do AND confirmed = 1 for some reason.<br />
<br />
<code sql><br />
SELECT<br />
(SELECT COUNT(id) FROM prefix_course) - 1 AS courses,<br />
(SELECT COUNT(id) FROM prefix_user WHERE deleted = 0 AND confirmed = 1) AS users,<br />
(SELECT COUNT(DISTINCT ra.userid)<br />
FROM prefix_role_capabilities rc<br />
JOIN prefix_role_assignments ra ON ra.roleid = rc.roleid<br />
WHERE rc.capability IN ('moodle/course:upd' || 'ate', 'moodle/site:doanything')) AS teachers,<br />
(SELECT COUNT(id) FROM prefix_role_assignments) AS enrolments,<br />
(SELECT COUNT(id) FROM prefix_forum_posts) AS forum_posts,<br />
(SELECT COUNT(id) FROM prefix_resource) AS resources,<br />
(SELECT COUNT(id) FROM prefix_question) AS questions<br />
</code><br />
<br />
There are two interesting queries in this blog post [http://tjhunt.blogspot.com/2010/03/when-do-students-submit-their-online.html When do students submit their online tests?].<br />
<br />
===Monthly Usage by Role===<br />
<br />
This report shows a distinct count of users by their role, accessing your site. Each instance of user and role is counted once per month, no matter how many courses they access. We use this to show the total number of students and teachers accessing our site.<br />
<br />
<code sql><br />
SELECT <br />
month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)) AS calendar_month,<br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)) AS calendar_year,<br />
prefix_role.name as user_role,<br />
COUNT(DISTINCT prefix_stats_user_monthly.userid) AS total_users<br />
FROM<br />
prefix_stats_user_monthly<br />
Inner Join prefix_role_assignments ON prefix_stats_user_monthly.userid = prefix_role_assignments.userid<br />
Inner Join prefix_context ON prefix_role_assignments.contextid = prefix_context.id<br />
Inner Join prefix_role ON prefix_role_assignments.roleid = prefix_role.id<br />
WHERE prefix_context.contextlevel = 50<br />
AND `prefix_stats_user_monthly`.`stattype` = 'activity'<br />
AND prefix_stats_user_monthly.courseid <>1<br />
GROUP BY month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
prefix_stats_user_monthly.stattype,<br />
prefix_role.name<br />
ORDER BY <br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)), month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
prefix_role.name<br />
</code><br />
<br />
You must have Statistics turned on to be able to generate any data with this report.<br />
<br />
==See also==<br />
<br />
* [[Reports_(administrator)]] for other admin reports<br />
* [[Installing contributed modules or plugins]]<br />
* [http://moodle.org/mod/forum/discuss.php?d=136484 Custom SQL queries report] forum announcement<br />
<br />
[[Category: Administrator]]<br />
[[Category:Report]]<br />
[[Category:Contributed_code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Custom_SQL_queries_report&diff=70879Custom SQL queries report2010-04-09T21:47:50Z<p>Mcampbell: </p>
<hr />
<div>Created by The Open University<br />
<br />
This admin report plugin allows Administrators to set up arbitrary database queries to act as ad-hoc reports. Reports can be of two types: either run on demand, or scheduled to run automatically. Other users with the right capability can go in and see a list of queries that they have access to. Results can be viewed on-screen or downloaded as CSV.<br />
<br />
==Installing this report==<br />
<br />
Follow the generic [[Installing contributed modules or plugins]] documentation.<br />
<br />
<br />
==Screen shots==<br />
<br />
Here are two example screen shots, showing the two main screens.<br />
<br />
[[Image:Custom_report_list.png|thumb|none|600px|The list of available reports]]<br />
[[Image:Custom_report.png|thumb|none|600px|The results of running one of the reports]]<br />
<br />
(Note, these screen shots are in the OU theme, not the standard Moodle theme, and iCMA is OU-jargon for quiz.)<br />
<br />
==Interface for normal users==<br />
<br />
===List of available queries===<br />
<br />
Users with the report/customsql:view capability can access the list of reports in the admin block. Each query is accessible only to a certain people. There are three levels of access:<br />
* Available to any one who can access the report at all (those with report/customsql:view).<br />
* Available to people who are able to see other system reports (those with moodle/site:viewreports)<br />
* Available to administrators only (those with moodle/site:config)<br />
<br />
When you go to the list, it will only show the queries you have access to. There is a note beside each query saying when it was last run, and how long it took to generate.<br />
<br />
The list shows on-demand and scheduled queries separately.<br />
<br />
<br />
===Running an on-demand query===<br />
<br />
To run an on-demand query, click on its name in the list of queries.<br />
<br />
The query will be run, and the results will be displayed as a table. Any URLs in the table will automatically be made into hyperlinks.<br />
<br />
A description of the query may appear above the table.<br />
<br />
The summary of when the query was run and how long it took is shown at the bottom, along with a link to download the CSV file (for example to get the data into Excel) and a link back to the list of all available queries.<br />
<br />
<br />
===Viewing the results of scheduled queries===<br />
<br />
Scheduled queries can work in one of two ways. Either each run of the report generates and entire table of reasults, or each run just creates one line of results, and the report builds up a row at a time.<br />
<br />
When you click the name in the list of queries, you get taken to a display of the latest results, just like in the on-demand case.<br />
<br />
However, if each scheduled run generates a complete report, then at the bottom of a page there will be a list of all the previous runs of the report, so that you can go and see how the report changed over time.<br />
<br />
<br />
==Interface for administrators==<br />
<br />
Administrators (that is, users with report/customsql:definequeries) see everything that other users see, but with some additions.<br />
<br />
<br />
===Additional controls in the staff interface===<br />
<br />
Administrators get shown who each report in the list is available to.<br />
<br />
They also get an edit and a delete icon next to each query.<br />
<br />
There is an '''Add new query button''' at the end of the list of queries.<br />
<br />
When viewing a particular query, Administrators get an edit and a delete link underneath the table of results.<br />
<br />
<br />
===Adding or editing a query===<br />
<br />
When you click the '''Add new query button''', you get taken to an editing form that lets you define the query.<br />
<br />
You must give the query a name.<br />
<br />
You can optionally enter a description that is displayed above the results table. You should use this to explain what the results of the query mean.<br />
<br />
You must enter the SQL to generate the results you want displayed. This must be an SQL select statement. You must use the prefix prefix_ for table names. It should not be possible to enter any SQL that would alter the contents of the database.<br />
<br />
You choose who you want the query to be accessible to.<br />
<br />
You choose whether the query should be run on-demand or scheduled weekly or monthly. If the report is scheduled, you can say whether the each run returns one row to be added to a single table, or whether each run generates a separate table.<br />
<br />
When you save the new query, the SQL is checked to make sure that it will execute without errors. If you have said that the report will only return a single row, this is also checked.<br />
After saving the query, if this was a manual query, you are taken to the query results page, so you can see what the results look like. If it was an automatic query or if you cancel the form, you are taken to the list of available queries.<br />
<br />
Editing an existing query uses the same form as for adding a new query, but to change the properties of an existing query.<br />
<br />
Note that at the OU, weeks start on Saturday. If you don't like that, there is a fairly obvious constant to hack at the top of locallib.php.<br />
<br />
===Deleting a query===<br />
<br />
When you click the delete icon or link for a query, you are taken to a confirmation page that shows you SQL of the query you are about to delete. The query is only deleted if you click Yes on the confirmation page.<br />
<br />
After deleting a query, you are taken back to the list of queries.<br />
<br />
==Share your interesting queries here==<br />
<br />
If you come up with any interesting SQL to custom reports, you can share it here.<br />
<br />
===Quiz attempts in the last week/month===<br />
<br />
Set this up as a scheduled report:<br />
<br />
<code sql><br />
SELECT COUNT(*)<br />
FROM prefix_quiz_attempts<br />
WHERE timefinish > %%STARTTIME%%<br />
AND timefinish <= %%ENDTIME%%<br />
AND preview = 0<br />
</code><br />
<br />
This '''must''' be set up as a '''Scheduled, on the first day of each week''' or '''Scheduled, on the first day of each month''' report, or it will not work.<br />
<br />
===Usage summary===<br />
<br />
This report shows roughly the same usage statistics that are sent to moodle.org when you register your site. The ones that are aggregated at http://moodle.org/stats/. (The only difference is that the registration form does not do AND confirmed = 1 for some reason.<br />
<br />
<code sql><br />
SELECT<br />
(SELECT COUNT(id) FROM prefix_course) - 1 AS courses,<br />
(SELECT COUNT(id) FROM prefix_user WHERE deleted = 0 AND confirmed = 1) AS users,<br />
(SELECT COUNT(DISTINCT ra.userid)<br />
FROM prefix_role_capabilities rc<br />
JOIN prefix_role_assignments ra ON ra.roleid = rc.roleid<br />
WHERE rc.capability IN ('moodle/course:upd' || 'ate', 'moodle/site:doanything')) AS teachers,<br />
(SELECT COUNT(id) FROM prefix_role_assignments) AS enrolments,<br />
(SELECT COUNT(id) FROM prefix_forum_posts) AS forum_posts,<br />
(SELECT COUNT(id) FROM prefix_resource) AS resources,<br />
(SELECT COUNT(id) FROM prefix_question) AS questions<br />
</code><br />
<br />
There are two interesting queries in this blog post [http://tjhunt.blogspot.com/2010/03/when-do-students-submit-their-online.html When do students submit their online tests?].<br />
<br />
===Monthly Usage by Role===<br />
<br />
This report shows a distinct count of users by their role, accessing your site. Each instance of user and role is counted once per month, no matter how many courses they access. We use this to show the total number of students and teachers accessing our site.<br />
<br />
<code sql><br />
SELECT <br />
month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)) AS calendar_month,<br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)) AS calendar_year,<br />
prefix_role.name,<br />
COUNT(DISTINCT prefix_stats_user_monthly.userid) AS TOTAL_COURSES<br />
FROM<br />
prefix_stats_user_monthly<br />
Inner Join prefix_role_assignments ON prefix_stats_user_monthly.userid = prefix_role_assignments.userid<br />
Inner Join prefix_context ON prefix_role_assignments.contextid = prefix_context.id<br />
Inner Join prefix_role ON prefix_role_assignments.roleid = prefix_role.id<br />
WHERE prefix_context.contextlevel = 50<br />
AND `prefix_stats_user_monthly`.`stattype` = 'activity'<br />
AND prefix_stats_user_monthly.courseid <>1<br />
GROUP BY month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
prefix_stats_user_monthly.stattype,<br />
prefix_role.name<br />
ORDER BY <br />
year(from_unixtime(`prefix_stats_user_monthly`.`timeend`)), month(from_unixtime(`prefix_stats_user_monthly`.`timeend`)),<br />
prefix_role.name<br />
</code><br />
<br />
You must have Statistics turned on to be able to generate any data with this report.<br />
<br />
==See also==<br />
<br />
* [[Reports_(administrator)]] for other admin reports<br />
* [[Installing contributed modules or plugins]]<br />
* [http://moodle.org/mod/forum/discuss.php?d=136484 Custom SQL queries report] forum announcement<br />
<br />
[[Category: Administrator]]<br />
[[Category:Report]]<br />
[[Category:Contributed_code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Message_Log&diff=54950Message Log2009-04-27T18:01:35Z<p>Mcampbell: </p>
<hr />
<div>The message log report is based on code originally written by Will H and Mike Worth, and converted to an admin report by Matt Campbell.<br />
<br />
Filters include the order of the message, the number of days worth of messages to get, and the username to, from, or both.<br />
<br />
Clicking on the [more] link in the to or from columns will filter the messages which involve that user. Clicking on the user's name will take you to their profile.<br />
<br />
PLEASE NOTE:<br />
This report is compatible with Moodle 1.9, but you must add a line to core Moodle files to make it work with Moodle 1.9.1-1.9.3.<br />
<br />
It works as expected with Moodle 1.9.4, simply copy the messagelog directory into the /admin/report directory of your install.<br />
<br />
For earlier versions of Moodle 1.9, please see http://tracker.moodle.org/browse/CONTRIB-1185<br />
Once you add the following line to /admin/settings/misc.php, the report will work as expected:<br />
<br />
$ADMIN->add('reports', new admin_externalpage('messagelog', get_string('messagelog', 'report_messagelog'), "$CFG->wwwroot/$CFG->admin/report/messagelog/index.php?days=30",'moodle/site:readallmessages')); <br />
<br />
<br />
==See also==<br />
*http://moodle.org/mod/forum/discuss.php?d=27559 Development of the SQL and code for the initial report<br />
*http://moodle.org/mod/data/view.php?d=13&rid=2285 Modules and Plugins database entry<br />
*http://download.moodle.org/plugins/admin/report/messagelog.zip Latest version in CVS<br />
<br />
[[Category:Contributed code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Message_Log&diff=53601Message Log2009-03-31T13:18:37Z<p>Mcampbell: /* See also */</p>
<hr />
<div>The message log report is based on code originally written by Will H and Mike Worth, and converted to an admin report by Matt Campbell.<br />
<br />
To install, simply copy the messagelog directory into the /admin/report directory of your install, and it will then be available under Reports in the Site Administration block.<br />
<br />
Filters include the order of the message, the number of days worth of messages to get, and the username to, from, or both.<br />
<br />
Clicking on the [more] link in the to or from columns will filter the messages which involve that user. Clicking on the user's name will take you to their profile.<br />
<br />
==See also==<br />
*http://moodle.org/mod/forum/discuss.php?d=27559 Development of the SQL and code for the initial report<br />
*http://moodle.org/mod/data/view.php?d=13&rid=2285 Modules and Plugins database entry<br />
*http://download.moodle.org/plugins/admin/report/messagelog.zip Latest version in CVS<br />
<br />
[[Category:Contributed code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Message_Log&diff=53600Message Log2009-03-31T13:18:00Z<p>Mcampbell: /* See also */</p>
<hr />
<div>The message log report is based on code originally written by Will H and Mike Worth, and converted to an admin report by Matt Campbell.<br />
<br />
To install, simply copy the messagelog directory into the /admin/report directory of your install, and it will then be available under Reports in the Site Administration block.<br />
<br />
Filters include the order of the message, the number of days worth of messages to get, and the username to, from, or both.<br />
<br />
Clicking on the [more] link in the to or from columns will filter the messages which involve that user. Clicking on the user's name will take you to their profile.<br />
<br />
==See also==<br />
http://moodle.org/mod/forum/discuss.php?d=27559 Development of the SQL and code for the initial report<br />
http://moodle.org/mod/data/view.php?d=13&rid=2285 Modules and Plugins database entry<br />
http://download.moodle.org/plugins/admin/report/messagelog.zip Latest version in CVS<br />
<br />
[[Category:Contributed code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Message_Log&diff=53599Message Log2009-03-31T13:14:42Z<p>Mcampbell: </p>
<hr />
<div>The message log report is based on code originally written by Will H and Mike Worth, and converted to an admin report by Matt Campbell.<br />
<br />
To install, simply copy the messagelog directory into the /admin/report directory of your install, and it will then be available under Reports in the Site Administration block.<br />
<br />
Filters include the order of the message, the number of days worth of messages to get, and the username to, from, or both.<br />
<br />
Clicking on the [more] link in the to or from columns will filter the messages which involve that user. Clicking on the user's name will take you to their profile.<br />
<br />
==See also==<br />
http://moodle.org/mod/forum/discuss.php?d=27559 Development of the SQL and code for the initial report<br />
<br />
[[Category:Contributed code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Message_Log&diff=53598Message Log2009-03-31T13:13:51Z<p>Mcampbell: message log report documentation</p>
<hr />
<div>The message log report is based on code originally written by Will H and Mike Worth, discussed at http://moodle.org/mod/forum/discuss.php?d=27559. <br />
<br />
To install, simply copy the messagelog directory into the /admin/report directory of your install, and it will then be available under Reports in the Site Administration block.<br />
<br />
Filters include the order of the message, the number of days worth of messages to get, and the username to, from, or both.<br />
<br />
Clicking on the [more] link in the to or from columns will filter the messages which involve that user. Clicking on the user's name will take you to their profile.<br />
<br />
==See also==<br />
http://moodle.org/mod/forum/discuss.php?d=27559 Development of the SQL and code for the initial report<br />
<br />
[[Category:Contributed code]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Development:Progress_tracking&diff=40189Development:Progress tracking2008-07-21T21:07:13Z<p>Mcampbell: /* Issues */</p>
<hr />
<div><p class="note">'''Note''': This page outlines ideas for the Progress tracking feature planned for Moodle 2.0. It's a ''specification under construction''! If you have any comments or suggestions, please add them to the [[https://docs.moodle.org/en/Development_talk:Progress_tracking|page comments]].''</p><br />
<br />
==Introduction==<br />
<br />
This feature will allow tracking of the progress of each student, displaying what has been achieved and what is still to be achieved.<br />
<br />
There are two ways to do this: by course and by competency:<br />
<br />
#Showing progress by course is pretty obvious and can work on any Moodle site: we just list the courses that have been completed and some courses that are still to be done. The completed courses can show the final grades and the date completed. Courses which are not yet completed can be shown with dates of when they start (if courses use a 'weekly' course format) or shown with the text "not yet completed". In Moodle 2.0, the '''course completion''' feature should also allow courses to be shown as either completed or not yet complete (see [[Development:Course_completion]]). <br />
#Showing progress using competencies requires the Outcomes features in Moodle 1.9 to be enabled and used across the whole site. When outcomes are enabled, we have a way of saying "these courses and these activities are intended to achieve these outcomes" and teachers can grade students against those outcomes. The progress report can then show a list of outcomes as past achievements and future goals for each user.<br />
<br />
==Definitions==<br />
'''Scale''' : A way to measure ability<br />
eg : Terrible, Bad, Good, Excellent<br />
'''Outcome''' : A statement about potential knowledge together combined with a scale<br />
eg : “Can catch a ball” Scale: Terrible, Bad, Good, Excellent<br />
'''Skill''' : An outcome and the actual grade a learner obtained<br />
eg : Can catch a ball - “Bad”<br />
'''Required grade''' : The minimum grade that is needed to deem a competency<br />
eg : "Good" <br />
'''Actual grade''' : The grade a learner obtained for an outcome<br />
eg : "Bad"<br />
'''Competency''' : A meaningful ability a learner acquires when achieving one or more skills.<br />
Eg : An "admin" may define a competency as “Ability to play cricket” with the following skills<br />
and corresponding required grades.<br />
“Ability to catch a ball” – good<br />
“Ability to throw a ball” – good<br />
“Ability to swing a bat” – good.<br />
If a learner obtains good, bad, excellent respectively for the above three outcomes, then the<br />
learner fails to achieve an “Ability to play cricket” competency.<br />
'''Organization role''' : A name for a role that has one or more required competencies.<br />
Eg : Athlete - "Ability to play cricket", "Ability to swim", "Ability to ski"<br />
<br />
==Goals==<br />
<br />
# Allow "admins" to devise a '''learning plan''' for an individual user. This can be either in terms of "courses" or "competencies".<br />
# Allow "admins" to develop a '''learning plan template'''. This can also be either in terms of "courses" or "competencies".<br />
# Allow "admins" to assign a learning plan from a learning plan template to an individual a user or a group of users. This assignment can be made manually in one action (similar to role or group assignments), or automatically using methods such as external databases or parsing text files containing data.<br />
# Allow "admins" to adjust an individual learning plan for a user, including a portion previously assigned from a learning plan template.<br />
# Allow "admins" to assign a due date for completing each "course" or "competency".<br />
# Allow "students" to see their own individual learning plan and their current progress along it (showing what is: done; in progress; or not done).<br />
# Allow "admins" the ability to see different reports for this data and answer questions like "how many people fit this profile" or "what is everybody working on right now?" or "which people haven't met this competency"?<br />
<br />
==General architecture==<br />
<br />
Most of the scripts will be in a top-level subdirectory called "track". This directory will have a similar structure to the [http://cvs.moodle.org/moodle/grade grade subdirectory], with plugin support for reports, import and export plugins.<br />
<br />
===Course-based progress tracking===<br />
<br />
# Each user can have courses linked to them (past, current and future).<br />
# For each course, we look if the course is finished or not.<br />
# Finished courses are show as "Done", with final grade<br />
# Unfinished but currently-enrolled courses are shown as "In progress"<br />
# Other courses are shown as "Not done yet" and will be done in the future<br />
<br />
===Competency-based progress tracking===<br />
<br />
# Each user can have outcomes linked to them , with a required level of competency (grade) for that outcome<br />
# For each outcome, we look at completed courses to see what grades they have<br />
# These are aggregated in some admin-defined way (Mean? Maximum?)<br />
# Outcomes with high grades are show as "Done", with final grade<br />
# Other outcomes in currently-enrolled courses are shown as "In progress"<br />
# Other outcomes are shown as "Not done yet" and will be done in the future. They can be used to suggest further courses by matching outcomes.<br />
<br />
===Learning plan===<br />
<br />
# Each user can have a set of either courses to be completed, outcomes to be completed, or a mixture of both. These comprise an individual user's learning plan.<br />
# Due dates for course completions and outcome completions can be assigned in an individual user's learning plan.<br />
# A comment can be added to a user's learning plan item when a course or outcome is manually added or removed from it.<br />
<br />
===Learning plan template===<br />
<br />
# Each template can contain a set of courses to be completed, outcomes to be completed, or a mixture of both.<br />
# A course or outcome can be assigned to a learning plan template (using an interface similar to assigning a user to a role or group).<br />
# A course or group of courses can be selected for a template from a list of all courses (by drilling-down category/sub-category) or from the results of a search (by course name or course description). Since outcomes are defined within a course, an outcome or a group of outcomes can be selected from a list of courses or search result.<br />
<br />
==Requirements==<br />
<br />
* We'll need to access and use the existing site-wide Outcomes [https://docs.moodle.org/en/Development:Grades#grade_outcomes Outcomes tables]<br />
<br />
* We'll need to use the tables that indicate completion status for courses (these are not yet in place) [https://docs.moodle.org/en/Development:Course_completion Course Completion]<br />
<br />
* We need to get aggregate information about the course outcomes and aggregate grades for each user from the gradebook API<br />
<br />
==Standards support==<br />
<br />
Moodle should support global standards in order to enable importing and exporting of competency information. IMS specifications will be used on this matter. IMS RDCEO (IMS Reusable Definition of Competency or Educational Objectives) will be used to capture the competencies/educational objectives and IMS LIP (IMS Learner Information Package) will be used to model the user profiles and their competencies.<br />
<br />
===IMS RDCEO===<br />
<br />
IMS Global Learning Consortium, Inc released IMS RDCEO for describing, referencing, and exchanging definitions of competencies, primarily in the context of online and distributed learning. Mostly the specification information are unstructured text and intended for human interpretation. This specification provides means to create common understandings of competencies that appear as a part of a learning plan. The IMS RDCEO also provides a way to store competency information in many languages at a time.<br />
<br />
'''IMS RDCEO specification contains following elements:'''<br />
<br />
*'''Identifier :''' Globally unique label that identifies the Competency or Learning objects.<br />
<br />
*'''Title''' : A single short mandatory human readable text for competency.<br />
<br />
*'''Description''' : Human readable unstructured description of competency and this is an optional element.<br />
<br />
*'''Definition''' : An optional structured description that provides more meaning to the competency.<br />
<br />
*'''Metadata''' : An optional meta-data used to denote authors information, creation date etc. It is recommended that this should conform to IEEE LOM standard.<br />
<br />
'''Definition''' element contains following sub elements :<br />
<br />
*'''Model source''' : An identifier of the model or structure upon which the definition is based. It is good to have a URI as model source.<br />
<br />
*'''Statement''' : Description about single characteristic of a definition and a definition must contain one or more statements.<br />
<br />
*'''Statement Id''' : An optional string that is local identifier for the statement within the model<br />
<br />
*'''Statement Name''' : This is an optional sub elements used to label the statement.<br />
<br />
*'''Statement text''' : An optional unstructured textual description of those aspects of the competency referred to by the statement Name.<br />
<br />
*'''Statement token''' : An optional vocabulary token, along with an identifier of the source of the vocabulary.<br />
<br />
===IMS LIP===<br />
<br />
IMS LIP describes the characteristics of a learner, which are needed for recording and managing learning-related history, goals, and accomplishments, engaging a learner in a learning experience, and discovering learning opportunities for learners. Here, the learner information is a collection of information about a learner (individual or group learners) or a producer of learning content (creators, providers or vendors). <br />
In competency modeling, the IMS LIP can be used to merge the competencies in IMS RDCEO and the users.<br />
<br />
'''IMS LIP Core datastructures:'''<br />
*'''Identification:''' Biographic and demographic data relevant to learning; <br />
*'''Goal:''' Learning, career and other objectives and aspirations; <br />
*'''Qualifications, Certifications and Licenses (qcl):''' Qualifications, certifications and licenses granted by recognized authorities; <br />
*'''Activity:''' Any learning-related activity in any state of completion. Could be self-reported. Includes formal and informal education, training, work experience, and military or civic service; <br />
*'''Transcript:''' A record that is used to provide an institutionally-based summary of academic achievement. The structure of this record can take many forms; <br />
*'''Interest:''' Information describing hobbies and recreational activities; <br />
*'''Competency:''' Skills, knowledge, and abilities acquired in the cognitive, affective, and/or psychomotor domains; <br />
*'''Affiliation:''' Membership of professional organizations, etc. Membership of groups is covered by the IMS Enterprise specification; <br />
*'''Accessibility:''' General accessibility to the learner information as defined through language capabilities, disabilities, eligibilities and learning preferences including cognitive preferences (e.g. issues of learning style), physical preferences (e.g. a preference for large print), and technological preferences (e.g. a preference for a particular computer platform); <br />
*'''Securitykey:''' The set of passwords and security keys assigned to the learner for transactions with learner information systems and services; <br />
*'''Relationship:''' The set of relationships between the core components. The core structures do not have within them identifiers that link to the core structures. Instead all of these relationships are captured in a single core structure thereby making the links simpler to identify and manage.<br />
<br />
None of the above data structures is mandatory and also the multiple occurrences of these data structures are allowed. Each of these data structures itself has various sub elements.<br />
<br />
<br />
'''An example : '''<br />
<br />
An outcome is defined as "ability to identify verbs in simple sentences" and the scale is Aways, Sometimes and Never. If it is also defined that, learner can gets the "ability to identify verbs in simple sentences" competency if obtain Sometimes grade. Assume that a Lerner called Jenney has deemed this competency. <br />
This information can be modeled as follows using IMS RDCEO and IMS LIP. Here the Pseudo-Structures of IMS RDCEO and IMS LIP are used. Note that the given structure is not complete.<br />
<br />
''' IMS RDECEO Pseudo-Structure'''<br />
rdceo.identifier = rdceo434323<br />
rdceo.title = Identify verbs in simple sentences<br />
rdceo.description = “Identify verbs in simple sentences”<br />
rdceo.definition.statement.<br />
statementid = 123<br />
statementname = Always<br />
statementtext = Scale<br />
statementtoken = scl55435<br />
rdceo.definition.statement.<br />
statementid = 124<br />
statementname = Never<br />
statementtext = Scale<br />
statementtoken = scl55436<br />
rdceo.definition.statement.<br />
statementid = 125<br />
statementname = Sometimes<br />
statementtext = Scale<br />
statementtoken = scl55437<br />
<br />
''' IMS LIP Pseudo-Structure'''<br />
lip.contenttype.referencial.sourceid.id = jenney_profile<br />
lip.identification.cotenttype.referential.indexid = id123<br />
lip.identification.name.partname.typename=Jenny <br />
lip.competency<br />
cotenttype.referential.indexid = j123<br />
exrefrecord = rdceo434323<br />
description = Always<br />
<br />
==Tables==<br />
===competency _required_grade===<br />
<br />
This table is used to map the outcome and required the grade to the corresponding competency. A competencyid can be mapped to more than one outcome and the required grade when competency comprises more than one outcome. <br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|Auto incrementing <br />
<br />
|-<br />
|'''outcomeid'''<br />
|int(10)<br />
|<br />
|The id of the outcome being assigned to the required grade<br />
<br />
|-<br />
|'''competencyid'''<br />
|int(10)<br />
|<br />
|The competency that the outcome belongs too<br />
<br />
|-<br />
|'''timecreated'''<br />
|int(10)<br />
|<br />
|The time that the required grade was first assigned to outcome<br />
<br />
|-<br />
|'''timemodified'''<br />
|int(10)<br />
|<br />
|The time that the required grade was last modified<br />
<br />
|-<br />
|'''usermodified'''<br />
|int(10)<br />
|<br />
|The userid of the person who last modified the required grade<br />
|}<br />
<br />
<br />
<br />
===competency_items===<br />
<br />
This table is used to describe the competencies in text form. As the example in the section above that defines Competency, this may have an entry like "Ability to play cricket". If so it also should have 3 corresponding entries “Ability to catch a ball” – good, “Ability to throw a ball” – good and “Ability to swing a bat” – good in '''competency _required_grade''' table.<br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|Auto incrementing <br />
<br />
|-<br />
|'''description'''<br />
|Text<br />
|<br />
|Competency description<br />
<br />
|-<br />
|'''timecreated'''<br />
|int(10)<br />
|<br />
|The time that a competency was first created<br />
<br />
|-<br />
|'''timemodified'''<br />
|int(10)<br />
|<br />
|The time that a competency was last modified<br />
<br />
|-<br />
|'''usermodified'''<br />
|int(10)<br />
|<br />
|The userid of the person who last modified the competency<br />
|}<br />
<br />
<br />
===learning_plan_competency===<br />
<br />
This table is used to describe the competency based learning plan of a user. This table also states whether a user has achieved a competency or not. <br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|Auto incrementing <br />
<br />
|-<br />
|'''userid'''<br />
|int(10)<br />
|<br />
|Userid of the user who is assigned to the competency based leaning plan<br />
<br />
|-<br />
|'''competencyid'''<br />
|int(10)<br />
|<br />
|Id of the competency which belongs to the competency based learning plan<br />
<br />
|-<br />
|'''learningtemplateid'''<br />
|int(10)<br />
|<br />
|Id of the template that the competency based plan belongs to<br />
<br />
|-<br />
|'''competencyachieved'''<br />
|Text<br />
|<br />
|Describe whether a competency has been achieved by a user or not.<br />
<br />
|-<br />
|'''timeachieved'''<br />
|int(10)<br />
|<br />
|The time when this has been achieved<br />
<br />
|-<br />
|'''timecreated'''<br />
|int(10)<br />
|<br />
|The time that the competency based learning plan was first created<br />
<br />
|-<br />
|'''timemodified'''<br />
|int(10)<br />
|<br />
|The time that the competency based learning plan was last modified<br />
<br />
|-<br />
|'''usermodified'''<br />
|int(10)<br />
|<br />
|The userid of the person who last modified the competency based learning plan<br />
|}<br />
<br />
<br />
===learning_plan_course===<br />
<br />
This table is used to describe the course based learning plan of a user. Initially a set of courses that the user has to sit for can be defined and whether it is completed or not is derived from [https://docs.moodle.org/en/Development:Course_completion course completion] <br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|Auto incrementing <br />
<br />
|-<br />
|'''userid'''<br />
|int(10)<br />
|<br />
|Userid of the user who is assigned to the course based leaning plan<br />
<br />
|-<br />
|'''timecreated'''<br />
|int(10)<br />
|<br />
|The time that the course based learning plan was first created<br />
<br />
|-<br />
|'''timemodified'''<br />
|int(10)<br />
|<br />
|The time that the course based learning plan was last modified<br />
<br />
|-<br />
|'''usermodified'''<br />
|int(10)<br />
|<br />
|Id of the course which belongs to the course based learning plan<br />
|}<br />
<br />
<br />
<br />
===learning_plan_template===<br />
<br />
This table is used to describe a learning template, which describes the competencies that need to achieve a particular role, like Software Engineer. Therefore if this template is assigned to a user, then all the required competencies also will be mapped to the user. Admin does not have to assign the competencies one by one.<br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|Auto incrementing <br />
<br />
|-<br />
|'''title'''<br />
|Text<br />
|<br />
|Title of the learning plan<br />
<br />
|-<br />
|'''Description'''<br />
|Text<br />
|<br />
|Description of the Learning plan<br />
<br />
|-<br />
|'''timecreated'''<br />
|int(10)<br />
|<br />
|The time when the learning template was first created<br />
<br />
|-<br />
|'''timemodified'''<br />
|int(10)<br />
|<br />
|The time this learning template was last modified<br />
<br />
|-<br />
|'''usermodified'''<br />
|int(10)<br />
|<br />
|The userid of the person who last modified the learning template<br />
|}<br />
<br />
==Development plan==<br />
<br />
===Learner windows===<br />
<br />
<br />
When a learner logins to the system, leaner will see the Progress Monitor block in the SITE.<br />
[[Image:progress_block.jpg]]<br />
<br />
Learner will get a similar window like below when she clicks on Find more link in the above picture.<br />
<br />
[[Image:progress_moni.jpg]]<br />
<br />
By clicking on the Course based or Competency based links the learner can see their detail progress. These will be similar to the Grade reports.<br />
Also there will be a graphical representation of the progress will be visible in the bottom right hand bottom corner.<br />
In addition to these, an option can be added to suggest the learner that this course has this competency, you can follow this course, etc.<br />
<br />
''Note : In the above interface, the graph and the table are not real. The table may contain some more information and there may be some more options too.''<br />
<br />
<br />
===Progress tracking administration===<br />
<br />
===='''Course based tracking administration'''====<br />
<br />
<br />
There should be a link called Progress in the site admin area and it should contain the links to handle course based progress tracking and the competency based progress tracking. Currently, here only the course based progress tracking is considered. As given in the following diagram, Progress link should contain 4 sub menus to handle the course based progress tracking.<br />
<br />
<br />
[[Image:siteadmin.JPG]]<br />
<br />
*'''Create learning template''' should direct us to a page where we can create / edit template, assign courses to the template and can sequence the courses.<br />
*'''Upload learning template''' shold help us to create a template and assign courses in order by importing them from an external file.<br />
*'''Assign users''' should help to assign users to a learning template<br />
*'''Progress monitor''' should allow us to do learning based monitoring and the template based monitoring<br />
<br />
'''Add Learning template'''<br />
<br />
This screen should look like this :<br />
<br />
[[Image:add_template.JPG]]<br />
<br />
Here admin can add a new template, edit existing template and delete a template. This should be a ‘paged’ page. As shown 1,2 ,3… at the bottom, if there are 100s of template those should be displayed as part by part in separate pages. <br />
When admin adds a template, then admin should be directed to a new page where the courses can be added and sequenced.<br />
Also if admin click on the Edit link, the admin should get a page (similar to the sample given below) where admin can sequence or add new courses to the existing learning template.<br />
<br />
A page similar to following one should be devloped to facilitate admin to add and sequence the courses.<br />
<br />
[[Image:assign_course1.JPG]]<br />
<br />
In the available course area, only the short name of the courses that are about to start or the will start in the future should be listed. Admin can filter the courses by clicking on the corresponding starting letter on the left. Also admin should be able to search for a course by typing a keyword (can be course name, etc). Also there a facility should be provided in the available course pane is that when admin double click on a course, a pop-up should be displayed with important course inforamtion. <br />
If a course is not available in the list, then admin should be able to add a new course by giving minimal information using the [New Course] link. <br />
Admin ought to shift the required courses from left pane right using the Add selection button and the other two remove button should give the functionality as there are meant. <br />
Among the selected courses which are on right pane, the admin able to sequence the courses. There are two ways this can be developed.<br />
*By dragging the courses up and down using mouse pointer.<br />
*As shown in the below picture, the course should be moving up and down using arrow links.<br />
<br />
[[Image:assign_course2.JPG]]<br />
<br />
Admins also should be able to create a template by importing the details form an external file. To achieve this as proposed before there should be a link added to the Site administration called upload template. That should give an interface like below, where user also should be able to select the CSV and the encoding before importing the file. <br />
The importing file should consist following format : "Template_name, course1, course2, course3, etc." where course1, course2.. should be the shortname of the courses and it should be properly ordered. <br />
<br />
[[Image:upload_template.JPG]]<br />
<br />
<br />
<br />
'''Assign a template to users'''<br />
<br />
Once the learning templates are created then they should be assignable to users. There is an interface as given below should be provided to admin to do this. According to the filter information, the users name should be listed in the left hand side pane. Those users name should be able to further filtered using the filter links provided in the left side of the Users pane. When admin click on a Letter the name that start with that letter should be listed.<br />
Moreover the admin should be able to search for a user by giving a keyword (Here keyword can be First name, Last name, Username etc.) <br />
Also when admin click on a User’s name a short description about that user should be pop-up.<br />
After selecting the required users, the admin should be able to move those users to selected user pane using Add to Selection button. The Remove from selection and Remove all button also should do the intended functions.<br />
Then there should be a drop down menu, in which all the available template should be listed. <br />
<br />
[[Image:add_users.JPG]]<br />
<br />
As given below, there should be an interface to filter out the student names. This interface part should go in the NEW FILTER area of the above interface.<br />
<br />
[[Image:add_filter.JPG]]<br />
<br />
The filter should have following functionality and it should be a course based filter. The filtration should be made based on the courses, whether a learner did / doing /didn’t do a course. <br />
There should be a drop down and where all “did”, “didn’t do”, “doing”, “incomplete” etc should be listed. And there also should be a textarea where the admin should be allowed to input courses. Here the courses’ short name should be listed and separated by commas. <br />
Once the admin added a filter, it should go to active filter block. Likewise the admin can have many filers. According to the selection that admin do on this active filer block the user names should be displayed in the user pane.<br />
<br />
<br />
<br />
'''Progress monitoring'''<br />
<br />
Progress monitoring based on courses should be able to done in two ways :<br />
*Learner based progress monitoring<br />
*Learning template based progress monitoring<br />
<br />
To do the learner based monitoring; there should be a keyword search to select the learner. The keyword can be a first name, last name, username etc. When admin click on the corresponding user’s name the user’s course profile should be listed with the status as depicted in the following diagram.<br />
<br />
[[Image:learner_based.JPG]]<br />
<br />
There is another interface like below should be provided to monitor the learners performance from courses point of view. According to this, when admin select a learning template name the all courses corresponds to the template should be listed as follows with the status of completion. For each course these should be a [view] link and using which it should be able to view the learners information corresponds to that state.<br />
<br />
[[Image:template_based.JPG]]<br />
<br />
===Directory Structure===<br />
<br />
There will be two directories with the name Progress. One will be there in Moodle root and the other will be inside the Blocks folder. The Progress which is in the Blocks will contain the scripts that are needed to display the block to the learners. <br />
The progress directory, which is in Moodle root directory, will contain following scripts :<br />
*Library files<br />
*Scripts for admin feature development<br />
*Scripts for the report generation for the learner.<br />
<br />
==Issues==<br />
<br />
# Does completing a course mean all the outcomes in a course have been met? Or should we treat them independently of the course grade? Perhaps the admin needs to decide this as a setting.<br />
# How do we deal with the same outcome being used by more than one course? Should the admin specify an aggregation method for this?<br />
# Rather than assigning these duties to the admin, they should be capabilities that could be assigned to a role.<br />
# Could there be more ways of assigning students to a template? Perhaps from the same database that controls course enrollments, or a CSV file, or a field in their profile?<br />
<br />
==See also==<br />
<br />
*[[GSOC/2008]]<br />
*[http://code.google.com/soc/2008/moodle/appinfo.html?csaid=BCC1F568283CE8D4 User Competency Tracking Module application abstract]<br />
*[http://www.imsglobal.org/competencies/index.html IMS RDCEO home ]<br />
*[http://www.imsglobal.org/profiles/index.html IMS LIP home ]<br />
<br />
[[Category:Project]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Development:Repository_API&diff=38321Development:Repository API2008-06-25T21:11:30Z<p>Mcampbell: /* Teacher linking to an external file as a new resource (think video repository) */</p>
<hr />
<div>This page describes the specification for a future feature, currently being worked on for Moodle 2.0. This spec is STILL UNDER CONSTRUCTION.<br />
<br />
See MDL-13766 to track the status of the implementation.<br />
<br />
The page is open for everyone so everyone can help correct mistakes and help with the evolution of this document. However, if you have questions to ask, problems to report or major changes to suggest, please add them to the [[Development_talk:Repository_API|page comments]], or start a discussion in the [http://moodle.org/mod/forum/view.php?id=1807 Repositories forum]. We'll endeavour to merge all such suggestions into the main spec before we start development.<br />
<br />
Note that parts of this document have been now split off into a separate [[Development:File_API]]<br />
<br />
==Objectives==<br />
<br />
# Allow all Moodle users to easily bring content into Moodle from external repositories<br />
# Provide a consistent interface to any external repository, for any Moodle module<br />
<br />
==Use cases==<br />
<br />
===Teacher adding an external file as a new resource===<br />
<br />
# Teacher wants to add a new resource to a course <br />
# Teacher clicks the "Choose a resource" button<br />
# Teacher is presented with a simple file picker to choose a file (with a menu to switch between multiple configured repositories)<br />
# Teacher chooses a file in an external repository<br />
# File is COPIED into Moodle and stored by the resource module<br />
# File is marked as owned by that user<br />
# Whenever someone wants to view that file, the resource module controls access (see [[Development:File API]] )<br />
<br />
===Teacher linking to an external file as a new resource (think video repository) ===<br />
<br />
# Teacher wants to display a file in the repository <br />
# Teacher clicks the "Choose a resource" button<br />
# Teacher is presented with a simple file picker to choose a file (with a menu to switch between multiple configured repositories)<br />
# Teacher chooses a file in an external repository<br />
# Link to the file is COPIED into Moodle and stored by the resource module<br />
# Link is marked as owned by that user<br />
# Whenever someone wants to follow that link, the resource module controls access (see [[Development:File API]] )<br />
<br />
===Student submitting an assignment===<br />
# Student needs to submit an assignment and presses the "Choose files" button<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories ([https://docs.moodle.org/en/Image:Filepicker_login.jpg file picker login], [https://docs.moodle.org/en/Image:Filepicker_browser.jpg file picker browser], [https://docs.moodle.org/en/Image:Filepicker_search.jpg file picker search])<br />
# Student chooses MySpace from the list<br />
# Student is prompted to enter MySpace username/password (if admin allows it, a checkbox could be there to "remember this for next time" but remember security)<br />
# Student sees their files in MySpace and chooses one or more<br />
# Files are copied from MySpace to Moodle <br />
# Assignment module controls the permissions so that only the Student and assignment graders can see the file (other students would not have permission).<br />
<br />
===Student attaching an image to a forum===<br />
# Student needs to attach an image and presses the "Choose files" button in the posting screen<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories<br />
# Student chooses Mahara from the list<br />
# Student is prompted to enter Mahara username/password<br />
# Student sees their files in Mahara and chooses one image<br />
# Image is copied to Moodle <br />
# Image file is attached to forum post by Forum module (by reference)<br />
# Forum module controls permissions so that anyone who can read that forum can see that file<br />
<br />
===Student attaching the same image in another forum===<br />
<br />
# Student needs to submit an assignment and presses the "Choose files" button<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories<br />
# Student chooses "Local files" from the list and sees all the files they've uploaded before<br />
# A COPY of the image file is attached to forum post by Forum module<br />
# Forum module controls access to this file.<br />
<br />
<br />
<br />
Please add more use cases in this same format<br />
<br />
==Mock screenshots==<br />
When you first call up the file picker and choose a repository, you might be asked to log in (if saving of passwords is not allowed):<br />
<br />
[[Image:Filepicker_login.jpg]]<br />
<br />
Browsing files could look something like this:<br />
<br />
[[Image:Filepicker_browser.jpg]]<br />
<br />
And you can also search:<br />
<br />
[[Image:Filepicker_search.jpg]]<br />
<br />
==General architecture==<br />
<br />
Each repository plugin (a standard Moodle plugin stored under /repository/xxx) will subclass the standard API and override methods specific to that repository.<br />
<br />
As is usual in Moodle, there will be admin settings to disable/enable certain repository plugins as standard, as well as user settings so that users can add their own personal repositories to the standard list (eg [http://briefcase.yahoo.com Yahoo Briefcase] or [http://docs.google.com Google Docs]) and to select their default repository.<br />
<br />
Once a repository has been used the file will usually be copied into Moodle there and then. However there will also be options to:<br />
* only return the URL to the file if it's desired to keep it external (but this does present security and integrity risks), or<br />
* refresh the local file copy regularly and automatically<br />
* refresh the file manually if desired<br />
<br />
Once in Moodle, it is subject to the [[Development:File API]] for access control like any other file.<br />
<br />
==Repository requirements==<br />
<br />
From the Moodle point of view, each repository is just a hierarchy of nodes.<br />
<br />
The repository MUST provide:<br />
# A URI to download each node (eg file).<br />
# A list of the nodes (eg files and directories) under a given node (eg directory). This allows Moodle to construct a standard browse interface (much like a standard OS file picker). However some repository plugins may choose to completely override the repository_browse() method and implement their own interface, that's OK, as long as they end up with a URL for the file.<br />
<br />
The repository can OPTIONALLY:<br />
# Require some authentication credentials <br />
# Provide more metadata about each node (mime type, size, dates, related files, dublin core stuff, etc)<br />
# Describe a search facility (so that Moodle can construct a search form)<br />
# Provide copyright and usage rules (or just information about the rules)<br />
<br />
==Repository plugins==<br />
<br />
Some plugins I'd like to see developed for the first version are:<br />
* local - very similar to the current course-based file manager, except user-based<br />
* moodle - an interface to another Moodle site, accessed over a secure mnet connection<br />
* jsr170 - an interface that can talk to anything that supports jsr170 (eg [http://www.alfresco.com/ Alfresco])<br />
* oki - an OKI emulator allowing us to access things with OKI interfaces,like [http://www.fedora.info/ Fedora]<br />
* briefcase - an interface to [http://briefcase.yahoo.com/ Yahoo Briefcase]<br />
* myspace - an interface to MySpace files (perhaps via [http://www.programmableweb.com/api/myspace this MySpace API])<br />
* googledocs - an interface to [http://docs.google.com Google Docs]<br />
* s3 - an interface to [http://www.amazon.com/gp/browse.html?node=16427261 Amazon S3]<br />
* skydrive - an interface to Microsoft's [http://skydrive.live.com/ SkyDrive] files<br />
* box - an interface to [http://box.net box.net]<br />
* facebook - an interface to Facebook files<br />
* merlot - an interface to the learning materials in [http://www.merlot.org/merlot/materials.htm Merlot.org]<br />
* flickr - an interface to [http://flickr.com flickr]<br />
* youtube - an interface to [http://youtube.com YouTube]<br />
* mahara - an interface to a Mahara installation<br />
* Dspace - a repository from MIT<br />
* DOOR - another popular open source repository<br />
* SMB shares - An interface for windows shares e.g. personal folders on network drives. Would need to link with LDAP as usernames will often be wholly/partially the same as network folder names. This could be done using SAMBA, but would also need to work on windows machines natively. See [http://moodle.org/mod/data/view.php?d=13&rid=991 this block] for a linux implementation.<br />
* WebDAV - to access arbitrary external WebDAV servers<br />
<br />
==Tables==<br />
<br />
=== repository ===<br />
<br />
This table contains one entry for every configured external repository instance.<br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|autoincrementing <br />
<br />
|-<br />
|repositoryname<br />
|varchar<br />
|<br />
|A custom name for this repository (non-unique)<br />
<br />
|-<br />
|'''repositorytype''' <br />
|varchar<br />
| <br />
|The name of the plugin being used (1 special case: "local" which covers all files uploaded from desktop)<br />
<br />
|-<br />
|'''userid''' <br />
|int(10)<br />
| <br />
|The person who created this repository instance<br />
<br />
|-<br />
|'''contextid''' <br />
|int(10)<br />
| <br />
|The context that this repository is available to ( = system context for site-wide ones)<br />
<br />
|-<br />
|username<br />
|varchar<br />
| <br />
|username to log in with, if required<br />
<br />
|-<br />
|password<br />
|varchar<br />
| <br />
|password to log in with, if required<br />
<br />
|-<br />
|option1<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option2<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option3<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option4<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option5<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|timecreated<br />
|int(10)<br />
|<br />
|The time this repository was created<br />
<br />
|-<br />
|timemodified<br />
|int(10)<br />
|<br />
|The last time the repository was modified<br />
|}<br />
<br />
<br />
===File types===<br />
<br />
The context at which someone is inserting a file may require certain file types (eg uploading a new user profile image is only looking for images). <br />
<br />
To support this, the calling code needs to be able to specify the required mimetypes, and the listing code should be able to filter the results based on these mimetypes. Ideally the repository itself can do the filtering for ultimate speed (though not all repositories will support this).<br />
<br />
We will have to develop special new mimetypes for Moodle files like backups (application/vnd.moodle.backup) and IMS learning design (application/vnd.moodle.imsld) etc<br />
<br />
==Invoking the API==<br />
<br />
Moodle module code doesn't generally need to call the repository API directly. Instead it will add a "fileopen" moodleform item:<br />
<br />
$mform->addElement('fileopen' ...)<br />
<br />
to a form which will invoke the file picker (with file types etc), which in turn will call various repository plugins to create the display.<br />
<br />
We should pass the context too, to help the picker decide what repositories are available at this moment.<br />
<br />
<br />
===file_open()===<br />
<br />
(in lib/filelib.php ... usually called by moodleforms)<br />
<br />
Creates a text field for containing a human-readable filename, together with a hidden field containing a file reference, as well as a button to launch the file picker (repository/picker.php). If a file has already been chosen, it could also show a preview (depends on file type).<br />
<br />
<br />
===repository/picker.php===<br />
<br />
The main script that displays the picker dialog. It looks through all the repository settings to give the user what they need to see.<br />
<br />
==Repository plugins==<br />
<br />
Each repository plugin is required to contain the following elements:<br />
<br />
===class repository()===<br />
<br />
This class implements the interface to a particular repository, for browsing, selecting and updating files. The base class (repository) is defined in /repository/repository.class.php, while each repository defines an inherited class (eg repository_alfresco) in /repository/repositoryname/repository.class.php<br />
<br />
Repositories can redefine any of these methods as required (and in some instances, MUST redefine them):<br />
<br />
====get_file($path)====<br />
<br />
Given a URL, get a file from there.<br />
<br />
====get_listing($parent='/', $search='''''''')====<br />
<br />
Given a path, and perhaps a search, get a listing of files.<br />
<br />
====print_login()====<br />
<br />
Show the login screen, if required<br />
<br />
====print_listing====<br />
<br />
Given a listing from get_listing, print it.<br />
<br />
====print_search==== <br />
<br />
Print the search form.<br />
<br />
====store_login($username, $password, $userid='''''''')====<br />
<br />
If you do want to cache login details for various repositories, then use this method.<br />
<br />
====more to come====<br />
<br />
====cron()====<br />
<br />
Defines operations that happen occasionally on cron.<br />
<br />
===icon.png===<br />
<br />
A logo that represents the repository. Ideally square but we should handle all sizes.<br />
<br />
==See also==<br />
<br />
* [[Development:File API]]<br />
* [[Development:Portfolio API]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Development:Repository_API&diff=38320Development:Repository API2008-06-25T21:09:05Z<p>Mcampbell: /* Use cases */</p>
<hr />
<div>This page describes the specification for a future feature, currently being worked on for Moodle 2.0. This spec is STILL UNDER CONSTRUCTION.<br />
<br />
See MDL-13766 to track the status of the implementation.<br />
<br />
The page is open for everyone so everyone can help correct mistakes and help with the evolution of this document. However, if you have questions to ask, problems to report or major changes to suggest, please add them to the [[Development_talk:Repository_API|page comments]], or start a discussion in the [http://moodle.org/mod/forum/view.php?id=1807 Repositories forum]. We'll endeavour to merge all such suggestions into the main spec before we start development.<br />
<br />
Note that parts of this document have been now split off into a separate [[Development:File_API]]<br />
<br />
==Objectives==<br />
<br />
# Allow all Moodle users to easily bring content into Moodle from external repositories<br />
# Provide a consistent interface to any external repository, for any Moodle module<br />
<br />
==Use cases==<br />
<br />
===Teacher adding an external file as a new resource===<br />
<br />
# Teacher wants to add a new resource to a course <br />
# Teacher clicks the "Choose a resource" button<br />
# Teacher is presented with a simple file picker to choose a file (with a menu to switch between multiple configured repositories)<br />
# Teacher chooses a file in an external repository<br />
# File is COPIED into Moodle and stored by the resource module<br />
# File is marked as owned by that user<br />
# Whenever someone wants to view that file, the resource module controls access (see [[Development:File API]] )<br />
<br />
===Teacher linking to an external file as a new resource (think video repository) ===<br />
<br />
# Teacher wants to add a new resource to a course <br />
# Teacher clicks the "Choose a resource" button<br />
# Teacher is presented with a simple file picker to choose a file (with a menu to switch between multiple configured repositories)<br />
# Teacher chooses a file in an external repository<br />
# Link to the file is COPIED into Moodle and stored by the resource module<br />
# Link is marked as owned by that user<br />
# Whenever someone wants to follow that link, the resource module controls access (see [[Development:File API]] )<br />
<br />
===Student submitting an assignment===<br />
# Student needs to submit an assignment and presses the "Choose files" button<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories ([https://docs.moodle.org/en/Image:Filepicker_login.jpg file picker login], [https://docs.moodle.org/en/Image:Filepicker_browser.jpg file picker browser], [https://docs.moodle.org/en/Image:Filepicker_search.jpg file picker search])<br />
# Student chooses MySpace from the list<br />
# Student is prompted to enter MySpace username/password (if admin allows it, a checkbox could be there to "remember this for next time" but remember security)<br />
# Student sees their files in MySpace and chooses one or more<br />
# Files are copied from MySpace to Moodle <br />
# Assignment module controls the permissions so that only the Student and assignment graders can see the file (other students would not have permission).<br />
<br />
===Student attaching an image to a forum===<br />
# Student needs to attach an image and presses the "Choose files" button in the posting screen<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories<br />
# Student chooses Mahara from the list<br />
# Student is prompted to enter Mahara username/password<br />
# Student sees their files in Mahara and chooses one image<br />
# Image is copied to Moodle <br />
# Image file is attached to forum post by Forum module (by reference)<br />
# Forum module controls permissions so that anyone who can read that forum can see that file<br />
<br />
===Student attaching the same image in another forum===<br />
<br />
# Student needs to submit an assignment and presses the "Choose files" button<br />
# Student sees a "file picker" where they can see files listed on any of several configured repositories<br />
# Student chooses "Local files" from the list and sees all the files they've uploaded before<br />
# A COPY of the image file is attached to forum post by Forum module<br />
# Forum module controls access to this file.<br />
<br />
<br />
<br />
Please add more use cases in this same format<br />
<br />
==Mock screenshots==<br />
When you first call up the file picker and choose a repository, you might be asked to log in (if saving of passwords is not allowed):<br />
<br />
[[Image:Filepicker_login.jpg]]<br />
<br />
Browsing files could look something like this:<br />
<br />
[[Image:Filepicker_browser.jpg]]<br />
<br />
And you can also search:<br />
<br />
[[Image:Filepicker_search.jpg]]<br />
<br />
==General architecture==<br />
<br />
Each repository plugin (a standard Moodle plugin stored under /repository/xxx) will subclass the standard API and override methods specific to that repository.<br />
<br />
As is usual in Moodle, there will be admin settings to disable/enable certain repository plugins as standard, as well as user settings so that users can add their own personal repositories to the standard list (eg [http://briefcase.yahoo.com Yahoo Briefcase] or [http://docs.google.com Google Docs]) and to select their default repository.<br />
<br />
Once a repository has been used the file will usually be copied into Moodle there and then. However there will also be options to:<br />
* only return the URL to the file if it's desired to keep it external (but this does present security and integrity risks), or<br />
* refresh the local file copy regularly and automatically<br />
* refresh the file manually if desired<br />
<br />
Once in Moodle, it is subject to the [[Development:File API]] for access control like any other file.<br />
<br />
==Repository requirements==<br />
<br />
From the Moodle point of view, each repository is just a hierarchy of nodes.<br />
<br />
The repository MUST provide:<br />
# A URI to download each node (eg file).<br />
# A list of the nodes (eg files and directories) under a given node (eg directory). This allows Moodle to construct a standard browse interface (much like a standard OS file picker). However some repository plugins may choose to completely override the repository_browse() method and implement their own interface, that's OK, as long as they end up with a URL for the file.<br />
<br />
The repository can OPTIONALLY:<br />
# Require some authentication credentials <br />
# Provide more metadata about each node (mime type, size, dates, related files, dublin core stuff, etc)<br />
# Describe a search facility (so that Moodle can construct a search form)<br />
# Provide copyright and usage rules (or just information about the rules)<br />
<br />
==Repository plugins==<br />
<br />
Some plugins I'd like to see developed for the first version are:<br />
* local - very similar to the current course-based file manager, except user-based<br />
* moodle - an interface to another Moodle site, accessed over a secure mnet connection<br />
* jsr170 - an interface that can talk to anything that supports jsr170 (eg [http://www.alfresco.com/ Alfresco])<br />
* oki - an OKI emulator allowing us to access things with OKI interfaces,like [http://www.fedora.info/ Fedora]<br />
* briefcase - an interface to [http://briefcase.yahoo.com/ Yahoo Briefcase]<br />
* myspace - an interface to MySpace files (perhaps via [http://www.programmableweb.com/api/myspace this MySpace API])<br />
* googledocs - an interface to [http://docs.google.com Google Docs]<br />
* s3 - an interface to [http://www.amazon.com/gp/browse.html?node=16427261 Amazon S3]<br />
* skydrive - an interface to Microsoft's [http://skydrive.live.com/ SkyDrive] files<br />
* box - an interface to [http://box.net box.net]<br />
* facebook - an interface to Facebook files<br />
* merlot - an interface to the learning materials in [http://www.merlot.org/merlot/materials.htm Merlot.org]<br />
* flickr - an interface to [http://flickr.com flickr]<br />
* youtube - an interface to [http://youtube.com YouTube]<br />
* mahara - an interface to a Mahara installation<br />
* Dspace - a repository from MIT<br />
* DOOR - another popular open source repository<br />
* SMB shares - An interface for windows shares e.g. personal folders on network drives. Would need to link with LDAP as usernames will often be wholly/partially the same as network folder names. This could be done using SAMBA, but would also need to work on windows machines natively. See [http://moodle.org/mod/data/view.php?d=13&rid=991 this block] for a linux implementation.<br />
* WebDAV - to access arbitrary external WebDAV servers<br />
<br />
==Tables==<br />
<br />
=== repository ===<br />
<br />
This table contains one entry for every configured external repository instance.<br />
<br />
{| border="1" cellpadding="2" cellspacing="0"<br />
|'''Field''' <br />
|'''Type''' <br />
|'''Default''' <br />
|'''Info''' <br />
<br />
|-<br />
|'''id'''<br />
|int(10)<br />
|<br />
|autoincrementing <br />
<br />
|-<br />
|repositoryname<br />
|varchar<br />
|<br />
|A custom name for this repository (non-unique)<br />
<br />
|-<br />
|'''repositorytype''' <br />
|varchar<br />
| <br />
|The name of the plugin being used (1 special case: "local" which covers all files uploaded from desktop)<br />
<br />
|-<br />
|'''userid''' <br />
|int(10)<br />
| <br />
|The person who created this repository instance<br />
<br />
|-<br />
|'''contextid''' <br />
|int(10)<br />
| <br />
|The context that this repository is available to ( = system context for site-wide ones)<br />
<br />
|-<br />
|username<br />
|varchar<br />
| <br />
|username to log in with, if required<br />
<br />
|-<br />
|password<br />
|varchar<br />
| <br />
|password to log in with, if required<br />
<br />
|-<br />
|option1<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option2<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option3<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option4<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|option5<br />
|varchar<br />
| <br />
|Other information useful to the plugin<br />
<br />
|-<br />
|timecreated<br />
|int(10)<br />
|<br />
|The time this repository was created<br />
<br />
|-<br />
|timemodified<br />
|int(10)<br />
|<br />
|The last time the repository was modified<br />
|}<br />
<br />
<br />
===File types===<br />
<br />
The context at which someone is inserting a file may require certain file types (eg uploading a new user profile image is only looking for images). <br />
<br />
To support this, the calling code needs to be able to specify the required mimetypes, and the listing code should be able to filter the results based on these mimetypes. Ideally the repository itself can do the filtering for ultimate speed (though not all repositories will support this).<br />
<br />
We will have to develop special new mimetypes for Moodle files like backups (application/vnd.moodle.backup) and IMS learning design (application/vnd.moodle.imsld) etc<br />
<br />
==Invoking the API==<br />
<br />
Moodle module code doesn't generally need to call the repository API directly. Instead it will add a "fileopen" moodleform item:<br />
<br />
$mform->addElement('fileopen' ...)<br />
<br />
to a form which will invoke the file picker (with file types etc), which in turn will call various repository plugins to create the display.<br />
<br />
We should pass the context too, to help the picker decide what repositories are available at this moment.<br />
<br />
<br />
===file_open()===<br />
<br />
(in lib/filelib.php ... usually called by moodleforms)<br />
<br />
Creates a text field for containing a human-readable filename, together with a hidden field containing a file reference, as well as a button to launch the file picker (repository/picker.php). If a file has already been chosen, it could also show a preview (depends on file type).<br />
<br />
<br />
===repository/picker.php===<br />
<br />
The main script that displays the picker dialog. It looks through all the repository settings to give the user what they need to see.<br />
<br />
==Repository plugins==<br />
<br />
Each repository plugin is required to contain the following elements:<br />
<br />
===class repository()===<br />
<br />
This class implements the interface to a particular repository, for browsing, selecting and updating files. The base class (repository) is defined in /repository/repository.class.php, while each repository defines an inherited class (eg repository_alfresco) in /repository/repositoryname/repository.class.php<br />
<br />
Repositories can redefine any of these methods as required (and in some instances, MUST redefine them):<br />
<br />
====get_file($path)====<br />
<br />
Given a URL, get a file from there.<br />
<br />
====get_listing($parent='/', $search='''''''')====<br />
<br />
Given a path, and perhaps a search, get a listing of files.<br />
<br />
====print_login()====<br />
<br />
Show the login screen, if required<br />
<br />
====print_listing====<br />
<br />
Given a listing from get_listing, print it.<br />
<br />
====print_search==== <br />
<br />
Print the search form.<br />
<br />
====store_login($username, $password, $userid='''''''')====<br />
<br />
If you do want to cache login details for various repositories, then use this method.<br />
<br />
====more to come====<br />
<br />
====cron()====<br />
<br />
Defines operations that happen occasionally on cron.<br />
<br />
===icon.png===<br />
<br />
A logo that represents the repository. Ideally square but we should handle all sizes.<br />
<br />
==See also==<br />
<br />
* [[Development:File API]]<br />
* [[Development:Portfolio API]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=35405Course categories2008-04-29T14:51:48Z<p>Mcampbell: /* Editing a category */</p>
<hr />
<div>Location: Category link in ''Administration block > Courses > Add/edit courses''<br />
<br />
<br />
Course categories organize courses for all Moodle site participants. Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Editing a category==<br />
{{Moodle 1.9}}You can edit a category in Moodle 1.9, which gives you access to change the Parent category (if applicable), change the name of the cateory, add or edit the course category description, and force a theme for the category (if enabled in ''Administration block > Appearance > Themes > Theme Settings'').<br />
<br />
If the category is visible, the course category description will be displayed to users when they enter the category, above the list of courses.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
{{Moodle 1.9}}Starting with Moodle 1.9, you can add sub-categories directly in the category you want it in. Simply enter the course category, Turn Editing On, and click 'Add a sub-category'.<br />
<br />
==Hiding categories==<br />
[[Image:Hidden_categories.JPG|thumb|Hidden categories]]<br />
Categories may be easily hidden or shown via ''Administration block > Courses > Add/edit courses''. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to ''Administration > Front Page >Front Page Settings'' and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
==Setting category depth==<br />
<br />
You can limit the number of categories that are displayed in the front page 'List of Categories' or 'Combo List' by adding the following line to your config.php:<br />
<br />
$CFG->max_category_depth = n;<br />
<br />
Where n is the maximum number of categories you wish to display.<br />
<br />
==See also==<br />
<br />
*[[Edit category settings]] in Moodle 1.9 onwards<br />
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=47954 Course Summary Sometimes Not Appearing] forum discussion<br />
<br />
[[Category:Course]]<br />
<br />
[[pl:Dodaj/edytuj_kategorie]]<br />
[[pt:Adicionar/editar categorias de disciplinas]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=35404Course categories2008-04-29T14:51:30Z<p>Mcampbell: /* Editing a category */</p>
<hr />
<div>Location: Category link in ''Administration block > Courses > Add/edit courses''<br />
<br />
<br />
Course categories organize courses for all Moodle site participants. Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Editing a category==<br />
{{Moodle 1.9}}You can edit a category in Moodle 1.9, which gives you access to change the Parent category (if applicable), change the name of the cateory, add or edit the course category description, and force a theme for the category (if enabled in ''Administration block > Appearance > Themes > Theme Settings'').<br />
<br />
If the category is visible, the course category description will be displayed to users when the enter the category, above the list of courses.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
{{Moodle 1.9}}Starting with Moodle 1.9, you can add sub-categories directly in the category you want it in. Simply enter the course category, Turn Editing On, and click 'Add a sub-category'.<br />
<br />
==Hiding categories==<br />
[[Image:Hidden_categories.JPG|thumb|Hidden categories]]<br />
Categories may be easily hidden or shown via ''Administration block > Courses > Add/edit courses''. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to ''Administration > Front Page >Front Page Settings'' and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
==Setting category depth==<br />
<br />
You can limit the number of categories that are displayed in the front page 'List of Categories' or 'Combo List' by adding the following line to your config.php:<br />
<br />
$CFG->max_category_depth = n;<br />
<br />
Where n is the maximum number of categories you wish to display.<br />
<br />
==See also==<br />
<br />
*[[Edit category settings]] in Moodle 1.9 onwards<br />
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=47954 Course Summary Sometimes Not Appearing] forum discussion<br />
<br />
[[Category:Course]]<br />
<br />
[[pl:Dodaj/edytuj_kategorie]]<br />
[[pt:Adicionar/editar categorias de disciplinas]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=35403Course categories2008-04-29T14:49:44Z<p>Mcampbell: </p>
<hr />
<div>Location: Category link in ''Administration block > Courses > Add/edit courses''<br />
<br />
<br />
Course categories organize courses for all Moodle site participants. Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Editing a category==<br />
{{Moodle 1.9}}You can edit a category in Moodle 1.9, which gives you access to change the Parent category (if applicable), change the name of the cateory, add or edit the course category description, and force a theme for the category (if enabled in ''Administration block > Appearance > Themes > Theme Settings'').<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
{{Moodle 1.9}}Starting with Moodle 1.9, you can add sub-categories directly in the category you want it in. Simply enter the course category, Turn Editing On, and click 'Add a sub-category'.<br />
<br />
==Hiding categories==<br />
[[Image:Hidden_categories.JPG|thumb|Hidden categories]]<br />
Categories may be easily hidden or shown via ''Administration block > Courses > Add/edit courses''. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to ''Administration > Front Page >Front Page Settings'' and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
==Setting category depth==<br />
<br />
You can limit the number of categories that are displayed in the front page 'List of Categories' or 'Combo List' by adding the following line to your config.php:<br />
<br />
$CFG->max_category_depth = n;<br />
<br />
Where n is the maximum number of categories you wish to display.<br />
<br />
==See also==<br />
<br />
*[[Edit category settings]] in Moodle 1.9 onwards<br />
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=47954 Course Summary Sometimes Not Appearing] forum discussion<br />
<br />
[[Category:Course]]<br />
<br />
[[pl:Dodaj/edytuj_kategorie]]<br />
[[pt:Adicionar/editar categorias de disciplinas]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=34784Course categories2008-04-12T23:35:35Z<p>Mcampbell: </p>
<hr />
<div>Location: Category link in ''Administration block > Courses > Add/edit courses''<br />
<br />
<br />
Course categories organize courses for all Moodle site participants. Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
==Hiding categories==<br />
[[Image:Hidden_categories.JPG|thumb|Hidden categories]]<br />
Categories may be easily hidden or shown via ''Administration block > Courses > Add/edit courses''. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to ''Administration > Front Page >Front Page Settings'' and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
==Setting category depth==<br />
<br />
You can limit the number of categories that are displayed in the front page 'List of Categories' or 'Combo List' by adding the following line to your config.php:<br />
<br />
$CFG->max_category_depth = n;<br />
<br />
Where n is the maximum number of categories you wish to display.<br />
<br />
==See also==<br />
<br />
*[[Edit category settings]] in Moodle 1.9 onwards<br />
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=47954 Course Summary Sometimes Not Appearing] forum discussion<br />
<br />
[[Category:Course]]<br />
<br />
[[pl:Dodaj/edytuj_kategorie]]<br />
[[pt:Adicionar/editar categorias de disciplinas]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Development:External_Database_Plugin&diff=32958Development:External Database Plugin2008-02-27T16:29:11Z<p>Mcampbell: Development page for Gradebook External Database Plugin</p>
<hr />
<div>This is for discussion regarding development of a plugin that will interface between the Moodle 1.9 gradebook and an external database in order to synchronize grade items, categories, scales, and outcomes and transfer data between them.<br />
<br />
Site settings<br />
<br />
Once the plugin has been installed, it will be available for the site administrator to configure in Admin->Grades.<br />
<br />
At the site level, the plugin will give the site administrator the ability to define external database server settings and remote database fields, including settings for grades, categories, outcomes, and scales. <br />
<br />
These fields may map to multiple or the same tables and are optional (if not defined, that functionality will not be enabled in the plugin). <br />
<br />
The site administrator will be able to define which system (Moodle, external database, most recent update) is the ‘master’ record. The site administrator will be able to determine if course teachers have the ability to add new records of each type to the external database, and if course teachers are allowed to keep Moodle grade items unassigned. Depending on how this is set up, a number of different scenarios are possible.<br />
<br />
Sample screenshot of configuration page follows. It is understood that the layout and design for this page will change to accommodate help buttons, information regarding these settings, etc. It has merely been presented in this format to show options needed in a compact manner. The ‘Allow’ checkboxes may be removed from this screen if enabled as Gradebook roles and clearly documented.<br />
<br />
Please note that the site administrator will also need a way to associate course and user id between the two systems, ensuring proper synchronization for course and user data. Either fields for this information must be included, or if external database enrollment has been configured, the administrator may choose to use those settings. These settings are not included in the following screenshot.<br />
<br />
[[Image:Gradebook_plugin_site_settings.JPG]]<br />
<br />
These settings are assuming that ‘remote_desc’ will map to ‘itemname’ (grades & categories), ‘fullname (outcomes), and ‘name’ (scale). It may be necessary to add options to set this relationship. Categories should use mdl_grade_items with an itemtype of category and the same localfield mapping as Grade Items. <br />
<br />
Course settings<br />
<br />
Once external database integration has been enabled, a new set of options is available in the Moodle gradebook under the ‘View’ dropdown, similar to what is seen for report, import and export plugins. This is controlled by the options that have been configured and capabilities defined in the user’s role. Screenshot of all options enabled follows:<br />
<br />
[[Image:Gradebook_plugin_view_dropdown.JPG]]<br />
<br />
Selecting any of the external database plugin options will present the course teacher with a screen similar to the screen seen for that item under the Edit options, but will enable the teacher to assign Moodle items to the external database, create new mappings for the external database, or leave Moodle items unassigned. Once this is done and saved, the remoteid and remotedesc will be mapped to the proper location in the Moodle database.<br />
<br />
A sample screenshot of the Categories and items selection page follows.<br />
<br />
[[Image:Gradebook_plugin_course_settings.JPG]]<br />
<br />
Please note that when a category is selected, only categories from the external database should be displayed, likewise with grade items. These pages will need some sort of check when changes are saved to ensure that a one-to-one relationship exists – the user should not be allowed to map multiple items from Moodle or the external database to a single item in the other. Attempts to create one to many relationships should return the page with the offending items clearly marked. <br />
<br />
Additional functionality could include the use of AJAX to remove already chosen items from the dropdown list.</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=File:Gradebook_plugin_course_settings.JPG&diff=32957File:Gradebook plugin course settings.JPG2008-02-27T16:27:27Z<p>Mcampbell: </p>
<hr />
<div></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=File:Gradebook_plugin_view_dropdown.JPG&diff=32956File:Gradebook plugin view dropdown.JPG2008-02-27T16:25:44Z<p>Mcampbell: </p>
<hr />
<div></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=File:Gradebook_plugin_site_settings.JPG&diff=32955File:Gradebook plugin site settings.JPG2008-02-27T16:24:05Z<p>Mcampbell: </p>
<hr />
<div></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Development:Developer_notes&diff=32954Development:Developer notes2008-02-27T16:21:06Z<p>Mcampbell: /* Modules and other recognised plugin types */</p>
<hr />
<div><p class="note">'''Note:''' New developer documentation pages should be added to the ''Development namespace'' by typing <code>Development:</code> before the new page name i.e. <code><nowiki>[[Development:New page name]]</nowiki></code>.</p><br />
<br />
This area is for developers to work on various bits of code and documentation as necessary. Once material has matured it should be linked to from the main [[Development:Developer documentation|Developer documentation]] page.<br />
<br />
==Core code==<br />
<br />
*[[Other lang issues|Language issues]] <br />
*[[Datalib Notes]]<br />
*[[Application/session variables]]<br />
*[[Filters schema]]<br />
*[[Filterall support]]<br />
*[[Groups documentation for module developers]]<br />
*[[Development:Plan to improve ability to delegate administrator tasks to course category level|Plan to improve ability to delegate administrator tasks to course category level]]<br />
*[[Development:Stealth mode and nested activities|Stealth mode and nested activities]]<br />
<br />
==Modules and other recognised plugin types==<br />
<br />
===Lesson===<br />
<br />
*[[Adding_question_types_to_lesson|Adding question types to lesson module]]<br />
*[[Development:New lesson navigation | New lesson navigation]]<br />
*[[Development:Adding blocks to lesson | Adding blocks to lesson]]<br />
<br />
===Quiz & question types===<br />
<br />
*[[Calculated question development]]<br />
*[[Development:quiz_navigation | Quiz navigation]]<br />
*[[Numerical question units and intervals]]<br />
*[[Development:Plans for adaptive mode|Plans for adaptive mode]]<br />
*[[Development:Quiz UI redesign prototype | Quiz UI redesign prototype]]<br />
*[[Development:Open_protocol_for_accessing_question_engines|Open protocol for accessing question engines]]<br />
*[[Development:Implementation of true negative marks in MC-type questions]]<br />
*[[Development:Quiz report enhancements|Quiz report enhancements]]<br />
<br />
===Other activity modules===<br />
<br />
*[[Forum development|Forum functional upgrade]]<br />
*[[Wiki development|Wiki module development]]<br />
<br />
===Gradebook Plugins===<br />
<br />
*[[Development:External Database Plugin]]<br />
<br />
===Other===<br />
<br />
*[[Blogs and forums|Blogs, forums and the nature of discussion]]<br />
*[[Conditional activities]]<br />
*[[Improved Payment Plugin]]<br />
*[[Development:Moodle-specific customisations to the HTML editor]]<br />
<br />
==Other==<br />
<br />
*[[MoodleDocs development]]<br />
*[[Usability]]<br />
*[[Document Management API]]<br />
*[[wikindx|Possible integration of WIKINDX with Moodle]]<br />
*[[Quiz and quesions community testing day]]<br />
*[[Development:Snapshot - flat HTML export of complete course]]<br />
*[[Development:Offline Moodle | Development:Offline Moodle - A Moodle that runs on a mobile device with the internet]]<br />
<br />
==Archive: past proposals==<br />
<br />
===Things that got implemented===<br />
<br />
*[[Roles]] - in Moodle 1.7<br />
*[[Moodle forms library]] - in Moodle 1.8<br />
**[[Martin form notes]]<br />
*[[Development:Plan_to_Improve_Flexibility_of_Question_Category_Sharing_and_Permissions|Plans for enhancing the question bank]] - in Moodle 1.9<br />
*[[Development:Email notification when a quiz is submitted|Email notification when a quiz is submitted]] - in Moodle 1.9<br />
*[[Development:Plans for enhancing import/export in questiontype plugins]] - in Moodle 1.9<br />
<br />
[[Category:Developer]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32245Administration FAQ2008-02-15T14:05:00Z<p>Mcampbell: /* How do I enable/disable debugging? */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodle/config.php</nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug';<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug';<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32244Administration FAQ2008-02-15T14:04:21Z<p>Mcampbell: /* How do I enable/disable debugging? */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php</nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug';<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug';<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32243Administration FAQ2008-02-15T14:03:42Z<p>Mcampbell: /* See also */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php</nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug';<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug';<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32242Administration FAQ2008-02-15T14:03:12Z<p>Mcampbell: /* How do I enable/disable debugging? */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php</nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug';<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug';<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32241Administration FAQ2008-02-15T14:01:55Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php</nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug'<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug'<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32240Administration FAQ2008-02-15T13:59:13Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php<nowiki> you can add these lines<br />
<br />
<br />
<br />
Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following<br />
<br />
<br />
<br />
To turn it back off, use this command<br />
<br />
<br />
<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32239Administration FAQ2008-02-15T13:57:13Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php<nowiki> you can add these lines<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug'<br />
<br />
To turn it back off, use this command<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug'<br />
<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32238Administration FAQ2008-02-15T13:55:22Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php<nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
:Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug'<br />
<br />
:To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug'<br />
:<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32237Administration FAQ2008-02-15T13:53:02Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php<nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug'<br />
<br />
To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug'<br />
<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administration_FAQ&diff=32236Administration FAQ2008-02-15T13:51:22Z<p>Mcampbell: </p>
<hr />
<div>{{FAQ}}<br />
<br />
==Changing text in Moodle==<br />
<br />
Text in Moodle may be changed by editing the language files via Administration >> Configuration >> [[admin/lang | Language]].<br />
<br />
== How do the limits on uploaded files work? ==<br />
<br />
File upload sizes are restricted in a number of ways - each one in the list restricts the following ones.<br />
<br />
1. Firstly, there is a setting in Apache 2 which you may need to change. On Redhat this setting is very low by default, you can change the limit by adding or editing a line in Apache's ''/etc/httpd/conf/httpd.conf'' and/or ''/etc/httpd/conf.d/php.conf'' with the upload size in bytes (different operating systems may have these files in different locations):<br />
<br />
LimitRequestBody 10485760<br />
<br />
2. PHP also has two more byte limits, which you can set in ''php.ini'' and sometimes in a ''.htaccess'' file:<br />
<br />
php_value upload_max_filesize 50000000<br />
php_value post_max_size 50000000<br />
<br />
To convert from Bytes to Megabytes use [http://www.onlineconversion.com/computer.htm this convertor ]<br />
<br />
Please note that a server re-start may be required for the above changes to take effect.<br />
<br />
3. Moodle has a site-wide limit called maxbytes that may be set in Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
4. A limit may be set by teachers in the [[course/edit|Course settings]].<br />
<br />
5. Activity modules such as [[Forums]] and [[Assignments]] have their own limits which may be set when adding or editing the activity.<br />
<br />
'''See also'''<br />
<br />
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=39625 Detailed instructions to increase the maximum allowed size for uploaded files] forum discussion<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change upload file size on a Windows localhost==<br />
In a localhost (using a [[Complete install packages]] on a computer) for 1.6 it is easy to change the uploaded file size to something larger than the default 16M. <br />
<br />
Here is an example of how to change the upload file size to 100M.<br />
*Find ..'''/Apache/bin/php.ini''' and open it with WordPad by right-clicking -> Open With -> then choose WordPad. <br />
*In this file scroll or do a search on the text "_max_" to find <code>upload_max_filesize = 16M</code> <br />
*Change that line to<br />
upload_max_filesize = 100M<br />
*In the same way, find <code>post_max_size = 16M</code> <br />
*Change that line to<br />
post_max_size = 100M<br />
*Save the file. <br />
<br />
After any changes to the php.ini file you need to restart Apache. So restart xampp and browse to localhost. You should find that the Upload file size in Configuration now reads 100M.<br />
<br />
'''See also'''<br />
<br />
* Instructions below on How to change the maximum execution time<br />
<br />
== How to change the maximum execution time ==<br />
<br />
A side-effect of increasing the file upload limit is that the php scripts may execute beyond the limit set by default (300 seconds/5 minutes). To change this, look for max_execution_time in php.ini and change to something like this:<br />
<br />
max_execution_time = 600<br />
<br />
If you are using Apache and have a .htaccess file to change php settings, add this line to your .htaccess file:<br />
<br />
php_value max_execution_time 600<br />
<br />
Restart your webserver for these changes to take effect, and check that the values have been changed by looking at your phpinfo output in the moodle admin -> environment page.<br />
<br />
== I have forgotten the admin password ==<br />
Firstly, try using the button "Send my details via email". Otherwise, you will need to access the database using MySQL admin. Passwords for all users, including admin, are stored encrypted in the table ''mdl_user''. Copy the guest password (guest) into the admin password field then login using it.<br />
<br />
Additional solutions are detailed in the discussions [http://moodle.org/mod/forum/discuss.php?d=18103 change admin's password] and [http://moodle.org/mod/forum/discuss.php?d=4552&parent=38070 login/password].<br />
<br />
== My log table has disappeared - No logs found! ==<br />
The most likely cause is that the mdl_log table has become corrupted. See the [[#How_do_I_repair_a_corrupted_Moodle_database.3F|database repair section]] below.<br />
<br />
==My style sheet changes aren't showing up==<br />
<br />
Browsers usually cache style sheets and so a forced refresh (CTRL + F5) is required before any changes show up.<br />
<br />
==How do I make my Moodle site homepage look like the moodle.org homepage?==<br />
<br />
Please see the theme how-to [[Homepage design|homepage design of moodle.org]] for full details.<br />
<br />
== Site-wide scales ==<br />
To add a site-wide scale, available in all courses, follow the Scales link in any course Administration block. Add a new scale, then use the move down arrow to move the scale from custom scales to standard scales.<br />
<br />
==Why do I see <nowiki>[[missing strings]]</nowiki>?==<br />
<br />
Double square brackets around text indicate that language strings are missing. Try checking for untranslated words or phrases in ''Administration > Language > [[Language editing]]'' and update local language packs in ''Administration > Language > [[Language packs]]'' (or ''Administration > Configuration > Language'' in Moodle 1.6).<br />
<br />
Language strings for non-standard modules and plugins are generally contained in a ''lang'' folder within the module or plugin folder. For sites which have migrated to UTF-8, it may be necessary to re-name the folder e.g. ''en'' should be re-named ''en_utf8''.<br />
<br />
==How do I find the version of Moodle currently installed?==<br />
See the [[Moodle version]] information.<br />
<br />
==How do I repair a corrupted Moodle database?==<br />
Database corruption usually occurs as a result of a hardware (especially disk-based) failure, or when a disk becomes full. Typical symptoms are failure on login, with this message displayed:<br />
<br />
Session Replace: Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
The problem can be repaired using the mysqlcheck command (the command you type is in bold and we assume the database name is 'moodle' and its type is MySQL):<br />
<br />
#'''mysqlcheck –u moodleuser –p –-auto-repair moodle'''<br />
Enter password:<br />
moodle.adodb_logsql OK<br />
moodle.mdl_assignment OK<br />
moodle.mdl_assignment_submissions OK<br />
...<br />
moodle.mdl_log<br />
error : Table './moodle/mdl_log' is marked as crashed and should be repaired<br />
...<br />
moodle.mdl_sessions2<br />
error : Table './moodle/mdl_sessions2' is marked as crashed and should be repaired<br />
<br />
Repairing tables<br />
moodle_18_latest.mdl_log OK<br />
moodle_18_latest.mdl_sessions2 OK<br />
<br />
Your mysql database server must be running when executing the mysqlcheck command. If there are problems with the tables, the auto-repair option will fix them as shown above. Note that the repair process can take a long time to complete. Re-run the command again to double-check that all is OK. <br />
<br />
Individual Moodle tables may be repaired using MySQL Admin/PHPMyAdmin as follows:<br />
*In the databases section, select the Moodle database.<br />
*Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type<br />
REPAIR TABLE mdl_tablename<br />
*Click the Go button.<br />
For example, to repair the Moodle log tables, type <code>REPAIR TABLE mdl_log</code><br />
<br />
See also: <br />
*[http://moodle.org/mod/forum/discuss.php?d=58208#279638 Forum discussion] on a moodle database optimization script<br />
*[[Performance#MySQL_performance | Performance Documentation]] on database repair and optimization<br />
*[http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2 Database Journal article on repairing database corruption in MySQL]<br />
<br />
==Re. Site files, what does "files placed here can be accessed by anyone" mean?==<br />
<br />
Unlike course files, which require a user to have appropriate rights in order to access them, files within the site files folder are accessible by anyone provided with the URI. For example visitors to the site may view images stored in the site files folder without being logged in. Please refer to [[Site files]] for more information.<br />
<br />
==My site is stuck in maintenance mode==<br />
<br />
Sometimes Moodle gets stuck in maintenance mode and you'll see the message "This site is undergoing maintenance and is currently unavailable" despite your attempts to turn-off maintenance mode. When you put Moodle into maintenance mode it creates a file called maintenance.html in moodledata/1/maintenance.html (the site files folder). To fix this try the following:<br />
<br />
* Check that the web server user has write permissions to the moodledata folder.<br />
* Manually delete the maintenance.html file.<br />
<br />
==Incomplete page displayed when I click "Turn Editing On"==<br />
This is usually as a result of an incompatible non-standard module or block that you have installed. Follow these steps:<br />
#Find any non-standard modules or blocks you have installed in the moodle/mod or moodle/blocks folders.<br />
#Move these to another folder outside the moodle folder. <br />
#Re-visit your course page and try clicking on the "Turn Editing On" button again. <br />
#Repeat the process until you find the one that is causing the problems. <br />
<br />
Once you have found an incompatible module/block, please report the problem to the author in the [http://moodle.org/mod/data/view.php?id=6009 Modules and Plugins] page. <br />
<br />
=="a request parameter (id) was missing" when uploading a file==<br />
<br />
This message sometimes is generated when attempting to upload a file larger than the upload limit.<br />
<br />
==I cannot delete the News Forum on a course==<br />
The News Forum is deleted by setting the number of items to display to zero. To do this, change the setting in Course Admin menu -> Settings -> News Items to Show.<br />
<br />
==How can I change the URL of the moodle service==<br />
<br />
You should configure your Apache server, at httpd.conf, using Listen, Port and DocumentRoot directives and Directory section. After restarting Apache, you also must open config.php in a text editor, and change the line:<br />
$CFG->wwwroot = 'http://mydomain/testmoodle';<br />
<br />
Your Moodle site will also contain absolute links to resources which point to the previous URL. To change this see the [[Moodle_migration#Migrating_a_complete_Moodle_site | migrating a complete Moodle site]] instructions.<br />
<br />
'''See also''': [http://moodle.org/mod/forum/discuss.php?d=51667 Forum discussion]<br />
<br />
==Why is the Moodle Registration button still displayed after I register my site?==<br />
The registration button is provided so that you can place your moodle site to the http://www.moodle.org/sites list. Before registering, the button is displayed at the top of the Site Administration -> Notifications page. Once you have successfully registered, this is moved to the bottom of the same page. The button remains there so that you can update the details of your registration.<br />
<br />
If the registration process fails for some reason to complete fully, there are two methods of letting your local Moodle install know that you have registered:<br />
<br />
* The preferred method is to use your mysql client program to execute these commands (assuming your Moodle database is called "moodle"):<br />
mysql> USE moodle;<br />
mysql> INSERT INTO mdl_config (name,value) VALUES ('registered',unix_timestamp());<br />
<br />
* Alternatively, edit your <nowiki>moodle/config.php</nowiki> file and add this line:<br />
$CFG->registered = '9999999999';<br />
:Note that this line in your config.php will stop the reminders about re-registering.<br />
<br />
For an explanation of the idea behind the button see [http://tracker.moodle.org/browse/MDL-7359 MDL-7359] in the moodle tracker.<br />
<br />
For an explanation of how sites are checked see [[Verification_of_sites_on_moodle.org | the site verification page]]<br />
<br />
==How do I enable/disable debugging?==<br />
There are a few ways you can enable or disable debugging on your site. If you are able to login as an administrator and access the Site Administration block, then the easiest way is to go to Admin->Server->Debugging and set it there. There are several options - the most often recommended setting for debugging is 'ALL: Show all reasonable PHP debugging messages'. To disable debugging, simply set this to 'NONE: Do not show any errors or warnings.'.<br />
<br />
If you are unable to set your debugging level in this manner, you still have a couple ways to set it - in your config.php or in the database.<br />
<br />
* In <nowiki>moodleroot/config.php<nowiki> you can add these lines:<br />
<br />
$CFG->debug=2047; <br />
$CFG->debugdisplay=1;<br />
<br />
Then simply remove them (or comment them out) when you're done.<br />
<br />
* To enable debugging in the database, simply use a database utility such as the MySQL Admin plugin for Moodle, or PHPMyAdmin, etc., and enter the following:<br />
<br />
UPDATE `mdl_config` SET `value` = '2047' WHERE `name` ='debug'<br />
<br />
To turn it back off, use this command:<br />
<br />
UPDATE `mdl_config` SET `value` = '0' WHERE `name` ='debug'<br />
<br />
==See also==<br />
* [[Administration hacks]]<br />
<br />
[[Category:FAQ]]<br />
<br />
[[es:FAQ Administración]]<br />
[[fr:FAQ d'administration]]<br />
[[pl:Administracja FAQ]]</nowiki></div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=29540Course categories2007-11-29T19:17:00Z<p>Mcampbell: /* Hiding categories */</p>
<hr />
<div>Course categories organize courses for all Moodle site participants. Adding, editing, moving and deleting these categories is best done through the [[Site administration block]] > courses > add/edit courses link. <br />
<br />
Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
==Hiding categories==<br />
<br />
Categories may be easily hidden or shown. From the Site Administration block, click Courses then 'Add/edit courses'. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to Site Administration->Front Page->Front Page Settings and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
[[Image:Hidden_categories.JPG]]<br />
<br />
[[Category:Administrator]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=File:Hidden_categories.JPG&diff=29539File:Hidden categories.JPG2007-11-29T19:16:29Z<p>Mcampbell: Screenshot showing hidden categories with courses.</p>
<hr />
<div>Screenshot showing hidden categories with courses.</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=29538Course categories2007-11-29T19:15:09Z<p>Mcampbell: /* Hiding categories */</p>
<hr />
<div>Course categories organize courses for all Moodle site participants. Adding, editing, moving and deleting these categories is best done through the [[Site administration block]] > courses > add/edit courses link. <br />
<br />
Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
==Hiding categories==<br />
<br />
Categories may be easily hidden or shown. From the Site Administration block, click Courses then 'Add/edit courses'. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to Site Administration->Front Page->Front Page Settings and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
[[Image:http://instructor.metrotech.org/~mcampbell/hidden_categories.JPG]]<br />
<br />
[[Category:Administrator]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=29537Course categories2007-11-29T19:11:46Z<p>Mcampbell: /* Hiding categories */</p>
<hr />
<div>Course categories organize courses for all Moodle site participants. Adding, editing, moving and deleting these categories is best done through the [[Site administration block]] > courses > add/edit courses link. <br />
<br />
Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
==Hiding categories==<br />
<br />
Categories may be easily hidden or shown. From the Site Administration block, click Courses then 'Add/edit courses'. Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to Site Administration->Front Page->Front Page Settings and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
[[Category:Administrator]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Course_categories&diff=29536Course categories2007-11-29T19:10:42Z<p>Mcampbell: </p>
<hr />
<div>Course categories organize courses for all Moodle site participants. Adding, editing, moving and deleting these categories is best done through the [[Site administration block]] > courses > add/edit courses link. <br />
<br />
Miscellaneous is the default course category on a new Moodle site. A course creator or administrator can put all courses in the miscellaneous category. However, teachers and students will find it easier to find their classes if they are organized in descriptive categories.<br />
<br />
The list of courses within a category by default shows the teachers and the summary of each course. If the number of courses within a category exceeds 9 (10 or more), then a short list without teachers and summary is shown.<br />
<br />
==Adding a category==<br />
Most people organize their courses by department and college or by topic. Be sure to test the organizational scheme with a few users before entering a large number of courses, to save time in moving them later.<br />
<br />
Adding categories is very simple:<br />
<br />
#From the Site Administration block, click Courses then "Add/edit courses".<br />
#At the top of the "Course Categories" page is a text area and an "Add new category" button. Type the name of your new category in the text area and click the button.<br />
<br />
==Adding sub course categories==<br />
<br />
Course sub-categories may be created by adding a new course category then using the "move category to" drop-down menu to move the category inside another category. Similarly, sub-sub-categories etc. may be created. <br />
<br />
==Hiding categories==<br />
<br />
Categories may be hidden/shown from the Site Administration block, click Courses then "Add/edit courses". Click on the icon to show or hide a category. Hidden categories are only visible to site administrators. By default, all courses inside a hidden category are not available for students to access, but you can go to Site Administration->Front Page->Front Page Settings and click the checkbox to 'Allow visible courses in hidden categories'.<br />
<br />
[[Category:Administrator]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Installation_FAQ&diff=22244Installation FAQ2007-04-11T15:29:58Z<p>Mcampbell: /* Installation hangs when setting-up database tables */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==PHP - is it installed and what version do I have?==<br />
<br />
Make a new file on your web site called ''info.php'', containing the following text, and call it from your browser:<br />
<br />
<?PHP phpinfo() ?><br />
<br />
If nothing happens then you don't have PHP installed or your webserver is not configured to handle .php files properly. See the installation docs for some information about where to download it for your computer. See the [[phpinfo]] page for details about the content of this page.<br />
<br />
== System information needed for Installation Forum ==<br />
When posting questions to the installation forum, try to provide as much background information as possible about your moodle system. Use this template to copy and paste into your post:<br />
* Server OS name (version also if possible): <br />
* Browser name (version also if possible):<br />
* Moodle version:<br />
* Moodle config.php attached?(Y/N):<br />
* Phpinfo attached? (Y/N):<br />
<br />
For the last two items, try to include the following in your post as an attachment:<br />
* A copy of your phpinfo output as shown in your browser (see the instructions above for an explanation of how to obtain this).<br />
* A copy of the Moodle configuration file. This is located in the directory moodle and is named config.php<br />
<br />
Copy and paste both of these into a single text file (using vi, Notepad, etc) and attach this to your post.<br />
<br />
If you cannot provide your phpinfo, try to copy & paste and complete these in your post:<br />
* Apache version:<br />
* MySQL version:<br />
* PHP version:<br />
<br />
For installation on web hosting accounts: contact your support desk who should be able to tell you this information.<br />
<br />
: '''Security Warning''': Make sure you edit any files and delete any passwords before posting onto the forum.<br />
<br />
==What & where are Moodle's configuration settings stored?==<br />
Configuration settings are stored in the config.php file stored in your moodle folder. This file is created during the installation process. If there is a problem and the installation cannot create the file, you can try creating it manually from the [[Configuration file]] docs. Please remember that manually editing the file is not recommended and may lead to blank pages, especially if there are additional spaces and/or lines after the final php closing tag "?>".<br />
<br />
==Running a health check==<br />
Moodle contains a script that will help identify common php and webserver configuration problems as well as configuration problems. It is a good idea to run this script to check if you are having post-installation problems. Use your browser to run this file:<br />
<br />
http://www.mymoodle.com/moodle/admin/health.php<br />
<br />
Change the above line if you have installed moodle in the webroot instead of a folder inside the webroot.<br />
<br />
==Any text I add with an apostrophe (') or a quote (") causes errors or comes up with a slash added==<br />
<br />
Problems caused by apostrophes are caused by incorrect "magic quotes" settings. Moodle requires the following settings in the php.ini file (which are usually the default):<br />
<br />
magic_quotes_gpc = On<br />
magic_quotes_runtime = Off<br />
<br />
Please see [[Installing Moodle]] for more details.<br />
<br />
==Email copies are not being sent from my forums==<br />
<br />
You ''must'' set up cron properly if you want Moodle to send out automatic email from forums, assignments etc. This same process also performs a number of clean-up tasks such as deleting old unconfirmed users, unenrolling old students and so on.<br />
<br />
Basically, you need to set up a process to regularly call the script <code><nowiki>http://yoursite/admin/cron.php</nowiki></code>. Please refer to the [[Cron|cron instructions]].<br />
<br />
'''Tip:''' Try the default setting in Moodle variables page. Leave the smtphost blank. This will be acceptable for the majority of users.<br />
<br />
'''Tip:''' Make sure that allowuseremailcharset in Administration > Configuration > Variables > Mail is set to No. Setting this to Yes might cause this problem in some versions of Moodle.<br />
<br />
==Error: database connection failed==<br />
<br />
If you get errors like "database connection failed" or "could not connect to the database you specified", here are some possible reasons and some possible solutions.<br />
<br />
* Your '''database server''' isn't installed or running. To check this for MySQL try typing the following command line<br />
$telnet database_host_name 3306<br />
:You should get a cryptic response which includes the version number of the MySQL server. <br />
* If you are attempting to run '''two instances of Moodle on different ports''', use the ip address of the host (not localhost) in the $CFG->dbhost setting, e.g. $CFG->dbhost = 127.0.0.1:3308.<br />
* You don't have the '''PHP mysql or postgresql extensions''' installed (please refer to FAQ re. whether PHP is installed).<br />
* You haven't created a '''Moodle database and assigned a user''' with the correct privileges to access it. <br />
* The '''Moodle database settings''' are incorrect. The database name, database user or database user password in your Moodle configuration file ''config.php'' are incorrect. Use phpMyAdmin to set up and check your MySQL installation.<br />
* Check that there are '''no apostrophes or non-alphabetic letters''' in your MySQL username or password.<br />
* You are using MySQL version 4.1 or higher but the PHP MySQL extension is pre-4.1 (check in your phpinfo output). In this case the '''default password hashing algorithm''' is incompatible with that available in the PHP mysql extension versions 4.x.x. Use these MySQL commands to change the passwords to the old format:<br />
<br />
mysql>SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('password');<br />
mysql>SET PASSWORD FOR 'moodleuser'@'localhost' = OLD_PASSWORD('password');<br />
<br />
:Also, consider upgrading your PHP MySQL extension. See http://dev.mysql.com/doc/mysql/en/old-client.html for further information on how to deal with this problem.<br />
* You are using Fedora core 3 or some other Linux system with '''SELinux installed''' and enabled. See the following URL for information on how to disable SELinux: http://fedora.redhat.com/projects/selinux/<br />
* Mac OSX users -- if you are running MySQL on a Mac OSX, try changing '''$CFG->dbhost''' from 'localhost' to '127.0.0.1'<br />
<br />
==I can't log in - I just stay stuck on the login screen==<br />
<br />
The most common cause for this is that your own computer (not your Moodle server) has a firewall that is stripping referrer information from the browser. Here are some instructions for fixing [http://service1.symantec.com/SUPPORT/nip.nsf/46f26a2d6dafb0a788256bc7005c3fa3/b9b47ad7eddd343b88256c6b006a85a8?OpenDocument&src=bar_sch_nam Norton firewall products].<br />
<br />
The server admin can also fix this for everyone by changing the ''secureforms'' variable to 'No' in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
Another possible cause of this problem is that sessions are not configured properly on the server. You can test this by calling the script <nowiki>http://yourserver/moodle/lib/session-test.php</nowiki>.<br />
<br />
If you are still having problems, read the [[Can_not_log_in | Cannot log in]] page.<br />
<br />
==I keep getting this error: Failed opening required '/web/moodle/lib/setup.php'==<br />
<br />
In your ''config.php'', the setting that you use for the dirroot variable must be the complete path from the root of your server's hard drive.<br />
<br />
Sometimes people only use the path from their home directory, or relative to the root of the web server directory.<br />
<br />
==I log in but the login link doesn't change. I am logged in and can navigate freely.==<br />
<br />
Make sure the URL in your <code>$CFG->wwwroot</code> setting is exactly the same as the one you are actually using to access the site.<br />
<br />
==My pages show fatal errors such as : Parse error, call to undefined function: get_string()==<br />
<br />
If you see errors like:<br />
<br />
Parse error: parse error, unexpected T_VARIABLE in /path/to/moodle/config.php on line 94 <br />
Fatal error: Call to undefined function: get_string() in /path/to/moodle/mod/resource/lib.php on line 11<br />
<br />
then you have probably left out a semi-colon or closing quote from a line in ''config.php'' (previous to line 94).<br />
<br />
Another possibility is that you edited ''config.php'' in a program like Word and saved it as a HTML web page, instead of using a plain text editor like Notepad.<br />
<br />
Another thing to check, particularly if you are using 3rd party modules or plugins, is whether any of the php scripts use short open tags (<? ?>) instead of proper ones (<?php ?>). Short tags are bad for various reasons, so first contact the author of that extension to tell them about the problem. Then either replace short tags with conventional ones, or set this line in php.ini:<br />
<br />
short_open_tag = On<br />
<br />
You should never find short tags in core moodle code. If you do, please file a bug in the bug tracker.<br />
<br />
==Serious Error! Could not set up the site!==<br />
<br />
Please refer to the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=32071 Serious Error! Could not set up the site!].<br />
<br />
==Uploaded files give "File not found"==<br />
<br />
For example: Not Found: The requested URL /moodle/file.php/2/myfile.jpg was not found on this server.<br />
<br />
Your web server needs to be configured to allow the part of the URL after a script name to be passed directly to the script. This is usually enabled in Apache 1, but is usually disabled by default in Apache 2. To turn it on, add this line to your ''httpd.conf'', or to a ''.htaccess'' file in your local directory (see [[Installing Moodle]] for more details):<br />
<br />
'''AcceptPathInfo''' on<br />
<br />
Note, this will ONLY work for Apache versions 2.x.<br />
<br />
If you are not using Apache 2 and you still have this problem (unlikely) then you can switch Moodle to use an alternative method. The disadvantages are a slight loss of performance for your users and you won't be able to use relative links within HTML resources.<br />
<br />
To use this alternative method, you should change the ''slasharguments'' variable in the Operating System section of Administration >> Configuration >> [[admin/config|Variables]]. You should now be able to access your uploaded files.<br />
<br />
==When I go to the admin page, I get told to make dirroot blank!==<br />
<br />
If you see errors like this:<br />
<br />
Please fix your settings in config.php: You have: $CFG->dirroot = "/home/users/fred/public_html/moodle"; <br />
but it should be: $CFG->dirroot = "";<br />
<br />
then you have encountered a small bug that occurs on some servers. The problem is with the error-checking mechanism, not with your actual path. To fix it, find this line (line 66) in the file ''admin/index.php'':<br />
<br />
if ($dirroot != $CFG->dirroot) {<br />
<br />
and change it to this:<br />
<br />
if (!empty($dirroot) and $dirroot != $CFG->dirroot) {<br />
<br />
==When trying to add a resource I receive error messages==<br />
<br />
Assuming you are using Apache, then it's quite likely that your setting in ''config.php'' for <code>$CFG->wwwroot</code> is different from the actual URL you are using to access the site. Also try turning off the ''secureforms'' variable in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
==Why are all my pages blank?==<br />
<br />
Check the dirroot variable in ''config.php''. You must use complete, absolute pathnames e.g.<br />
<br />
$CFG->dirroot = "d:\inetpub\sites\www.yoursite.com\web\moodle";<br />
<br />
Another reason might be that PHP has not been configured to support MySQL. This is common on Redhat and OpenBSD installations. In this case, an error is generated, but since error displays are often disabled by default, all that is seen on the browser is a blank screen. To enable PHP error displays, set these lines in your ''php.ini'' file and reload the web page.<br />
<br />
display_errors = On<br />
display_startup_errors = On<br />
<br />
To determine if MySQL support is your problem, insert this as the second line in your ''config.php'' file<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Examine the output closely to see if MySQL is supported. If not look for a package you are missing.<br />
<br />
== Why is a particular page blank or incomplete? ==<br />
<br />
Check your web server log files!!<br />
<br />
If a particular page is blank or incomplete (it doesn't display the footer), before you do anything else check your error logs.<br />
<br />
PHP can be set up to log errors in a variety of different ways. These settings are contained in the php.ini file on the server. If you don't know were that is, edit your Moodle ''config.php'' and add the following as the second line<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Look for the entry '''Configuration File (php.ini) Path'''.<br />
<br />
When you have located php.ini open it in your favorite text editor. Find the '''Error handling and logging''' section of the php.ini file. Make sure that both '''display_errors = On''' and '''log_errors = On''' are present and uncommented. Check the value of '''error_log''' - this tells you the location of the file errors are logged to. If it is commented out then errors will be sent to the web server error log file. Remember, if you make any changes to this file you will need to restart the web server (or just reboot the server).<br />
<br />
Having established that logging is working, reproduce the error. Immediately check the error log file right at the end. Hopefully you will see a PHP error message at or very near the end of the file. This may solve your problem directly or makes it a lot easier to diagnose the problem in the Moodle forums.<br />
<br />
If you are upgrading to a new version of Moodle, check that you do not have an old version of a non-standard block or module installed. Remove any such blocks or modules installed remove them using the admin settings page and start the install process again.<br />
<br />
==Installation hangs when setting-up database tables==<br />
*Sometimes the installation will hang when setting up tables. This will be an abrupt hang with half the page displayed in the browser and/or other outputs removed, e.g. the “Scroll to continue” link is displayed but no “Continue” button is there. If this is the case, it is usually a mysql error and not a php error. Check that there is no limit placed on your mysql database, e.g. a "questions" limit.<br />
<br />
*If the install is on a webhost, adding <br />
AddType x-mapp-php5 .php<br />
to the .htaccess file in the moodle directory has been known to solve the problem.<br />
*Try also renaming the .htaccess file so that it is disabled.<br />
<br />
*You may also want to look and see if you've customized any of your code. Look at the last successful table, and then look at the block, mod, or other code that is referenced by that table. (For example, if your install hangs and continues to say that the forum tables were successful as the last message, look at /mod/forum/ for any custom code. If you have customized code, backup those files and replace with the correct files. You can then restart the install by renaming config.php or reinstalling your database from the backup. If your install is successful, you can make your code changes back into the stock Moodle code.<br />
<br />
==Why can't I upload a new image into my profile?==<br />
<br />
If you don't see anything on your user profile pages to let you upload user images then it's usually because GD is not enabled on your server. GD is a library that allows image processing.<br />
<br />
1. Make sure GD has been included in your PHP installation. You can check this by going into Administration >> Configuration >> [[Variables]] and looking for the gdversion setting. This setting is chosen automatically every time you visit that page. If it shows GD version 1 or version 2 then everything should be fine. Save that configuration page and go back to your user profile.<br />
<br />
2. If Moodle thinks GD is not installed, then you will need to install it. On Windows this is usually a matter of "turning on" the module in PHP (see the [[Installing AMP|installation instructions]] for help). On Unix you may need to re-compile PHP with arguments something like this:<br />
<br />
./configure --with-apxs=/usr/local/apache/bin/apxs --with-xml --with-gd <br />
--with-jpeg-dir=/usr/local --with-png-dir=/usr --with-ttf --enable-gd-native-ttf <br />
--enable-magic-quotes --with-mysql --enable-sockets --enable-track-vars <br />
--enable-versioning --with-zlib<br />
<br />
3. Remember to re-visit the Moodle configuration page after making any changes to PHP so it can pick up the correct version of GD.<br />
<br />
Please see the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=44271 Profile pictures] for additional information.<br />
<br />
==Why do I keep getting error messages about "headers already sent"?==<br />
<br />
If you see errors like this:<br />
<br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87) <br />
in /webs/moodle/lib/moodlelib.php on line 1322 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/lib/moodlelib.php on line 1323 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/login/index.php on line 54<br />
<br />
you have blank lines or spaces after the final <code>?></code> in your ''config.php'' file. Sometimes text editors add these - for example Notepad on Windows - so you may have to try a different text editor to remove these spaces or blank lines completely.<br />
<br />
== Why doesn't my Moodle site display the time and date correctly? ==<br />
<br />
Each language requires a specific language code (called a '''locale''' code) to allow dates to be displayed correctly. The language packs contain default standard codes, but sometimes these don't work on Windows servers.<br />
<br />
You can find the correct locale codes for Windows on these two pages: [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_language_strings.asp Language codes] and [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_country_strings.asp Country/region] codes (e.g. "esp_esp" for spanish)<br />
<br />
These new locale codes can be entered on the Administration >> Configuration >> [[admin/config|Variables]] page, where they override the ones in the currently chosen language pack.<br />
<br />
==I can't log in with message "Please verify that the current setting of session.save_path is correct" ==<br />
[http://moodle.org/mod/forum/discuss.php?d=55925#254596 See this Using Moodle Forum Summary]<br />
<br />
==How do I uninstall Moodle?==<br />
'''Moodle package installation''': If you have downloaded a Moodle package, simply uninstall using your system commands. On Windows PCs, you should access the Control Panel -> Add/Remove Programs. Select the package name and click Change or Remove Programs.<br />
<br />
'''Webhost/manual installation''': If you have installed Moodle manually or have installed onto a webhost, follow these steps:<br />
*Delete the moodle database using this mysql command (or delete using your mysql client, e.g. PHPMyAdmin):<br />
<pre>sql>DROP DATABASE moodle;</pre><br />
:In the above example replace 'moodle' with the name of the moodle database you created when installing.<br />
*Delete the moodledata directory. If you, or your users, have uploaded materials into this directory take a copy of these before deleting this directory.<br />
*Delete the moodle directory itself. This will delete all of the moodle PHP script files.<br />
<br />
[[Category:Core]]<br />
[[Category:Administrator]]<br />
[[Category:FAQ]]<br />
[[Category:Installation]]<br />
<br />
[[es:FAQ Instalación]]<br />
[[fr:FAQ d'installation]]<br />
[[nl:Installatie FAQ]]<br />
[[ja:インストールFAQ]]<br />
[[ru:Установка FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Installation_FAQ&diff=22243Installation FAQ2007-04-11T15:29:24Z<p>Mcampbell: /* Installation hangs when setting-up database tables */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==PHP - is it installed and what version do I have?==<br />
<br />
Make a new file on your web site called ''info.php'', containing the following text, and call it from your browser:<br />
<br />
<?PHP phpinfo() ?><br />
<br />
If nothing happens then you don't have PHP installed or your webserver is not configured to handle .php files properly. See the installation docs for some information about where to download it for your computer. See the [[phpinfo]] page for details about the content of this page.<br />
<br />
== System information needed for Installation Forum ==<br />
When posting questions to the installation forum, try to provide as much background information as possible about your moodle system. Use this template to copy and paste into your post:<br />
* Server OS name (version also if possible): <br />
* Browser name (version also if possible):<br />
* Moodle version:<br />
* Moodle config.php attached?(Y/N):<br />
* Phpinfo attached? (Y/N):<br />
<br />
For the last two items, try to include the following in your post as an attachment:<br />
* A copy of your phpinfo output as shown in your browser (see the instructions above for an explanation of how to obtain this).<br />
* A copy of the Moodle configuration file. This is located in the directory moodle and is named config.php<br />
<br />
Copy and paste both of these into a single text file (using vi, Notepad, etc) and attach this to your post.<br />
<br />
If you cannot provide your phpinfo, try to copy & paste and complete these in your post:<br />
* Apache version:<br />
* MySQL version:<br />
* PHP version:<br />
<br />
For installation on web hosting accounts: contact your support desk who should be able to tell you this information.<br />
<br />
: '''Security Warning''': Make sure you edit any files and delete any passwords before posting onto the forum.<br />
<br />
==What & where are Moodle's configuration settings stored?==<br />
Configuration settings are stored in the config.php file stored in your moodle folder. This file is created during the installation process. If there is a problem and the installation cannot create the file, you can try creating it manually from the [[Configuration file]] docs. Please remember that manually editing the file is not recommended and may lead to blank pages, especially if there are additional spaces and/or lines after the final php closing tag "?>".<br />
<br />
==Running a health check==<br />
Moodle contains a script that will help identify common php and webserver configuration problems as well as configuration problems. It is a good idea to run this script to check if you are having post-installation problems. Use your browser to run this file:<br />
<br />
http://www.mymoodle.com/moodle/admin/health.php<br />
<br />
Change the above line if you have installed moodle in the webroot instead of a folder inside the webroot.<br />
<br />
==Any text I add with an apostrophe (') or a quote (") causes errors or comes up with a slash added==<br />
<br />
Problems caused by apostrophes are caused by incorrect "magic quotes" settings. Moodle requires the following settings in the php.ini file (which are usually the default):<br />
<br />
magic_quotes_gpc = On<br />
magic_quotes_runtime = Off<br />
<br />
Please see [[Installing Moodle]] for more details.<br />
<br />
==Email copies are not being sent from my forums==<br />
<br />
You ''must'' set up cron properly if you want Moodle to send out automatic email from forums, assignments etc. This same process also performs a number of clean-up tasks such as deleting old unconfirmed users, unenrolling old students and so on.<br />
<br />
Basically, you need to set up a process to regularly call the script <code><nowiki>http://yoursite/admin/cron.php</nowiki></code>. Please refer to the [[Cron|cron instructions]].<br />
<br />
'''Tip:''' Try the default setting in Moodle variables page. Leave the smtphost blank. This will be acceptable for the majority of users.<br />
<br />
'''Tip:''' Make sure that allowuseremailcharset in Administration > Configuration > Variables > Mail is set to No. Setting this to Yes might cause this problem in some versions of Moodle.<br />
<br />
==Error: database connection failed==<br />
<br />
If you get errors like "database connection failed" or "could not connect to the database you specified", here are some possible reasons and some possible solutions.<br />
<br />
* Your '''database server''' isn't installed or running. To check this for MySQL try typing the following command line<br />
$telnet database_host_name 3306<br />
:You should get a cryptic response which includes the version number of the MySQL server. <br />
* If you are attempting to run '''two instances of Moodle on different ports''', use the ip address of the host (not localhost) in the $CFG->dbhost setting, e.g. $CFG->dbhost = 127.0.0.1:3308.<br />
* You don't have the '''PHP mysql or postgresql extensions''' installed (please refer to FAQ re. whether PHP is installed).<br />
* You haven't created a '''Moodle database and assigned a user''' with the correct privileges to access it. <br />
* The '''Moodle database settings''' are incorrect. The database name, database user or database user password in your Moodle configuration file ''config.php'' are incorrect. Use phpMyAdmin to set up and check your MySQL installation.<br />
* Check that there are '''no apostrophes or non-alphabetic letters''' in your MySQL username or password.<br />
* You are using MySQL version 4.1 or higher but the PHP MySQL extension is pre-4.1 (check in your phpinfo output). In this case the '''default password hashing algorithm''' is incompatible with that available in the PHP mysql extension versions 4.x.x. Use these MySQL commands to change the passwords to the old format:<br />
<br />
mysql>SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('password');<br />
mysql>SET PASSWORD FOR 'moodleuser'@'localhost' = OLD_PASSWORD('password');<br />
<br />
:Also, consider upgrading your PHP MySQL extension. See http://dev.mysql.com/doc/mysql/en/old-client.html for further information on how to deal with this problem.<br />
* You are using Fedora core 3 or some other Linux system with '''SELinux installed''' and enabled. See the following URL for information on how to disable SELinux: http://fedora.redhat.com/projects/selinux/<br />
* Mac OSX users -- if you are running MySQL on a Mac OSX, try changing '''$CFG->dbhost''' from 'localhost' to '127.0.0.1'<br />
<br />
==I can't log in - I just stay stuck on the login screen==<br />
<br />
The most common cause for this is that your own computer (not your Moodle server) has a firewall that is stripping referrer information from the browser. Here are some instructions for fixing [http://service1.symantec.com/SUPPORT/nip.nsf/46f26a2d6dafb0a788256bc7005c3fa3/b9b47ad7eddd343b88256c6b006a85a8?OpenDocument&src=bar_sch_nam Norton firewall products].<br />
<br />
The server admin can also fix this for everyone by changing the ''secureforms'' variable to 'No' in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
Another possible cause of this problem is that sessions are not configured properly on the server. You can test this by calling the script <nowiki>http://yourserver/moodle/lib/session-test.php</nowiki>.<br />
<br />
If you are still having problems, read the [[Can_not_log_in | Cannot log in]] page.<br />
<br />
==I keep getting this error: Failed opening required '/web/moodle/lib/setup.php'==<br />
<br />
In your ''config.php'', the setting that you use for the dirroot variable must be the complete path from the root of your server's hard drive.<br />
<br />
Sometimes people only use the path from their home directory, or relative to the root of the web server directory.<br />
<br />
==I log in but the login link doesn't change. I am logged in and can navigate freely.==<br />
<br />
Make sure the URL in your <code>$CFG->wwwroot</code> setting is exactly the same as the one you are actually using to access the site.<br />
<br />
==My pages show fatal errors such as : Parse error, call to undefined function: get_string()==<br />
<br />
If you see errors like:<br />
<br />
Parse error: parse error, unexpected T_VARIABLE in /path/to/moodle/config.php on line 94 <br />
Fatal error: Call to undefined function: get_string() in /path/to/moodle/mod/resource/lib.php on line 11<br />
<br />
then you have probably left out a semi-colon or closing quote from a line in ''config.php'' (previous to line 94).<br />
<br />
Another possibility is that you edited ''config.php'' in a program like Word and saved it as a HTML web page, instead of using a plain text editor like Notepad.<br />
<br />
Another thing to check, particularly if you are using 3rd party modules or plugins, is whether any of the php scripts use short open tags (<? ?>) instead of proper ones (<?php ?>). Short tags are bad for various reasons, so first contact the author of that extension to tell them about the problem. Then either replace short tags with conventional ones, or set this line in php.ini:<br />
<br />
short_open_tag = On<br />
<br />
You should never find short tags in core moodle code. If you do, please file a bug in the bug tracker.<br />
<br />
==Serious Error! Could not set up the site!==<br />
<br />
Please refer to the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=32071 Serious Error! Could not set up the site!].<br />
<br />
==Uploaded files give "File not found"==<br />
<br />
For example: Not Found: The requested URL /moodle/file.php/2/myfile.jpg was not found on this server.<br />
<br />
Your web server needs to be configured to allow the part of the URL after a script name to be passed directly to the script. This is usually enabled in Apache 1, but is usually disabled by default in Apache 2. To turn it on, add this line to your ''httpd.conf'', or to a ''.htaccess'' file in your local directory (see [[Installing Moodle]] for more details):<br />
<br />
'''AcceptPathInfo''' on<br />
<br />
Note, this will ONLY work for Apache versions 2.x.<br />
<br />
If you are not using Apache 2 and you still have this problem (unlikely) then you can switch Moodle to use an alternative method. The disadvantages are a slight loss of performance for your users and you won't be able to use relative links within HTML resources.<br />
<br />
To use this alternative method, you should change the ''slasharguments'' variable in the Operating System section of Administration >> Configuration >> [[admin/config|Variables]]. You should now be able to access your uploaded files.<br />
<br />
==When I go to the admin page, I get told to make dirroot blank!==<br />
<br />
If you see errors like this:<br />
<br />
Please fix your settings in config.php: You have: $CFG->dirroot = "/home/users/fred/public_html/moodle"; <br />
but it should be: $CFG->dirroot = "";<br />
<br />
then you have encountered a small bug that occurs on some servers. The problem is with the error-checking mechanism, not with your actual path. To fix it, find this line (line 66) in the file ''admin/index.php'':<br />
<br />
if ($dirroot != $CFG->dirroot) {<br />
<br />
and change it to this:<br />
<br />
if (!empty($dirroot) and $dirroot != $CFG->dirroot) {<br />
<br />
==When trying to add a resource I receive error messages==<br />
<br />
Assuming you are using Apache, then it's quite likely that your setting in ''config.php'' for <code>$CFG->wwwroot</code> is different from the actual URL you are using to access the site. Also try turning off the ''secureforms'' variable in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
==Why are all my pages blank?==<br />
<br />
Check the dirroot variable in ''config.php''. You must use complete, absolute pathnames e.g.<br />
<br />
$CFG->dirroot = "d:\inetpub\sites\www.yoursite.com\web\moodle";<br />
<br />
Another reason might be that PHP has not been configured to support MySQL. This is common on Redhat and OpenBSD installations. In this case, an error is generated, but since error displays are often disabled by default, all that is seen on the browser is a blank screen. To enable PHP error displays, set these lines in your ''php.ini'' file and reload the web page.<br />
<br />
display_errors = On<br />
display_startup_errors = On<br />
<br />
To determine if MySQL support is your problem, insert this as the second line in your ''config.php'' file<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Examine the output closely to see if MySQL is supported. If not look for a package you are missing.<br />
<br />
== Why is a particular page blank or incomplete? ==<br />
<br />
Check your web server log files!!<br />
<br />
If a particular page is blank or incomplete (it doesn't display the footer), before you do anything else check your error logs.<br />
<br />
PHP can be set up to log errors in a variety of different ways. These settings are contained in the php.ini file on the server. If you don't know were that is, edit your Moodle ''config.php'' and add the following as the second line<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Look for the entry '''Configuration File (php.ini) Path'''.<br />
<br />
When you have located php.ini open it in your favorite text editor. Find the '''Error handling and logging''' section of the php.ini file. Make sure that both '''display_errors = On''' and '''log_errors = On''' are present and uncommented. Check the value of '''error_log''' - this tells you the location of the file errors are logged to. If it is commented out then errors will be sent to the web server error log file. Remember, if you make any changes to this file you will need to restart the web server (or just reboot the server).<br />
<br />
Having established that logging is working, reproduce the error. Immediately check the error log file right at the end. Hopefully you will see a PHP error message at or very near the end of the file. This may solve your problem directly or makes it a lot easier to diagnose the problem in the Moodle forums.<br />
<br />
If you are upgrading to a new version of Moodle, check that you do not have an old version of a non-standard block or module installed. Remove any such blocks or modules installed remove them using the admin settings page and start the install process again.<br />
<br />
==Installation hangs when setting-up database tables==<br />
*Sometimes the installation will hang when setting up tables. This will be an abrupt hang with half the page displayed in the browser and/or other outputs removed, e.g. the “Scroll to continue” link is displayed but no “Continue” button is there. If this is the case, it is usually a mysql error and not a php error. Check that there is no limit placed on your mysql database, e.g. a "questions" limit.<br />
<br />
*If the install is on a webhost, adding <br />
AddType x-mapp-php5 .php<br />
to the .htaccess file in the moodle directory has been known to solve the problem.<br />
*Try also renaming the .htaccess file so that it is disabled.<br />
<br />
*You may also want to look and see if you've customized any of your code. Look at the last successful table, and then look at the block, mod, or other code that is referenced by that table. (For example, if your install hangs and continues to say that the forum tables were successful as the last message, look at /mod/forum/ for any custom code. If you have customized, backup those files and replace with the correct files. You can then restart the install by renaming config.php or reinstalling your database from the backup. If your install is successful, you can make your code changes back into the stock Moodle code.<br />
<br />
==Why can't I upload a new image into my profile?==<br />
<br />
If you don't see anything on your user profile pages to let you upload user images then it's usually because GD is not enabled on your server. GD is a library that allows image processing.<br />
<br />
1. Make sure GD has been included in your PHP installation. You can check this by going into Administration >> Configuration >> [[Variables]] and looking for the gdversion setting. This setting is chosen automatically every time you visit that page. If it shows GD version 1 or version 2 then everything should be fine. Save that configuration page and go back to your user profile.<br />
<br />
2. If Moodle thinks GD is not installed, then you will need to install it. On Windows this is usually a matter of "turning on" the module in PHP (see the [[Installing AMP|installation instructions]] for help). On Unix you may need to re-compile PHP with arguments something like this:<br />
<br />
./configure --with-apxs=/usr/local/apache/bin/apxs --with-xml --with-gd <br />
--with-jpeg-dir=/usr/local --with-png-dir=/usr --with-ttf --enable-gd-native-ttf <br />
--enable-magic-quotes --with-mysql --enable-sockets --enable-track-vars <br />
--enable-versioning --with-zlib<br />
<br />
3. Remember to re-visit the Moodle configuration page after making any changes to PHP so it can pick up the correct version of GD.<br />
<br />
Please see the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=44271 Profile pictures] for additional information.<br />
<br />
==Why do I keep getting error messages about "headers already sent"?==<br />
<br />
If you see errors like this:<br />
<br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87) <br />
in /webs/moodle/lib/moodlelib.php on line 1322 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/lib/moodlelib.php on line 1323 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/login/index.php on line 54<br />
<br />
you have blank lines or spaces after the final <code>?></code> in your ''config.php'' file. Sometimes text editors add these - for example Notepad on Windows - so you may have to try a different text editor to remove these spaces or blank lines completely.<br />
<br />
== Why doesn't my Moodle site display the time and date correctly? ==<br />
<br />
Each language requires a specific language code (called a '''locale''' code) to allow dates to be displayed correctly. The language packs contain default standard codes, but sometimes these don't work on Windows servers.<br />
<br />
You can find the correct locale codes for Windows on these two pages: [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_language_strings.asp Language codes] and [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_country_strings.asp Country/region] codes (e.g. "esp_esp" for spanish)<br />
<br />
These new locale codes can be entered on the Administration >> Configuration >> [[admin/config|Variables]] page, where they override the ones in the currently chosen language pack.<br />
<br />
==I can't log in with message "Please verify that the current setting of session.save_path is correct" ==<br />
[http://moodle.org/mod/forum/discuss.php?d=55925#254596 See this Using Moodle Forum Summary]<br />
<br />
==How do I uninstall Moodle?==<br />
'''Moodle package installation''': If you have downloaded a Moodle package, simply uninstall using your system commands. On Windows PCs, you should access the Control Panel -> Add/Remove Programs. Select the package name and click Change or Remove Programs.<br />
<br />
'''Webhost/manual installation''': If you have installed Moodle manually or have installed onto a webhost, follow these steps:<br />
*Delete the moodle database using this mysql command (or delete using your mysql client, e.g. PHPMyAdmin):<br />
<pre>sql>DROP DATABASE moodle;</pre><br />
:In the above example replace 'moodle' with the name of the moodle database you created when installing.<br />
*Delete the moodledata directory. If you, or your users, have uploaded materials into this directory take a copy of these before deleting this directory.<br />
*Delete the moodle directory itself. This will delete all of the moodle PHP script files.<br />
<br />
[[Category:Core]]<br />
[[Category:Administrator]]<br />
[[Category:FAQ]]<br />
[[Category:Installation]]<br />
<br />
[[es:FAQ Instalación]]<br />
[[fr:FAQ d'installation]]<br />
[[nl:Installatie FAQ]]<br />
[[ja:インストールFAQ]]<br />
[[ru:Установка FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Installation_FAQ&diff=22242Installation FAQ2007-04-11T15:28:55Z<p>Mcampbell: /* Installation hangs when setting-up database tables */</p>
<hr />
<div>{{FAQ}}<br />
<br />
==PHP - is it installed and what version do I have?==<br />
<br />
Make a new file on your web site called ''info.php'', containing the following text, and call it from your browser:<br />
<br />
<?PHP phpinfo() ?><br />
<br />
If nothing happens then you don't have PHP installed or your webserver is not configured to handle .php files properly. See the installation docs for some information about where to download it for your computer. See the [[phpinfo]] page for details about the content of this page.<br />
<br />
== System information needed for Installation Forum ==<br />
When posting questions to the installation forum, try to provide as much background information as possible about your moodle system. Use this template to copy and paste into your post:<br />
* Server OS name (version also if possible): <br />
* Browser name (version also if possible):<br />
* Moodle version:<br />
* Moodle config.php attached?(Y/N):<br />
* Phpinfo attached? (Y/N):<br />
<br />
For the last two items, try to include the following in your post as an attachment:<br />
* A copy of your phpinfo output as shown in your browser (see the instructions above for an explanation of how to obtain this).<br />
* A copy of the Moodle configuration file. This is located in the directory moodle and is named config.php<br />
<br />
Copy and paste both of these into a single text file (using vi, Notepad, etc) and attach this to your post.<br />
<br />
If you cannot provide your phpinfo, try to copy & paste and complete these in your post:<br />
* Apache version:<br />
* MySQL version:<br />
* PHP version:<br />
<br />
For installation on web hosting accounts: contact your support desk who should be able to tell you this information.<br />
<br />
: '''Security Warning''': Make sure you edit any files and delete any passwords before posting onto the forum.<br />
<br />
==What & where are Moodle's configuration settings stored?==<br />
Configuration settings are stored in the config.php file stored in your moodle folder. This file is created during the installation process. If there is a problem and the installation cannot create the file, you can try creating it manually from the [[Configuration file]] docs. Please remember that manually editing the file is not recommended and may lead to blank pages, especially if there are additional spaces and/or lines after the final php closing tag "?>".<br />
<br />
==Running a health check==<br />
Moodle contains a script that will help identify common php and webserver configuration problems as well as configuration problems. It is a good idea to run this script to check if you are having post-installation problems. Use your browser to run this file:<br />
<br />
http://www.mymoodle.com/moodle/admin/health.php<br />
<br />
Change the above line if you have installed moodle in the webroot instead of a folder inside the webroot.<br />
<br />
==Any text I add with an apostrophe (') or a quote (") causes errors or comes up with a slash added==<br />
<br />
Problems caused by apostrophes are caused by incorrect "magic quotes" settings. Moodle requires the following settings in the php.ini file (which are usually the default):<br />
<br />
magic_quotes_gpc = On<br />
magic_quotes_runtime = Off<br />
<br />
Please see [[Installing Moodle]] for more details.<br />
<br />
==Email copies are not being sent from my forums==<br />
<br />
You ''must'' set up cron properly if you want Moodle to send out automatic email from forums, assignments etc. This same process also performs a number of clean-up tasks such as deleting old unconfirmed users, unenrolling old students and so on.<br />
<br />
Basically, you need to set up a process to regularly call the script <code><nowiki>http://yoursite/admin/cron.php</nowiki></code>. Please refer to the [[Cron|cron instructions]].<br />
<br />
'''Tip:''' Try the default setting in Moodle variables page. Leave the smtphost blank. This will be acceptable for the majority of users.<br />
<br />
'''Tip:''' Make sure that allowuseremailcharset in Administration > Configuration > Variables > Mail is set to No. Setting this to Yes might cause this problem in some versions of Moodle.<br />
<br />
==Error: database connection failed==<br />
<br />
If you get errors like "database connection failed" or "could not connect to the database you specified", here are some possible reasons and some possible solutions.<br />
<br />
* Your '''database server''' isn't installed or running. To check this for MySQL try typing the following command line<br />
$telnet database_host_name 3306<br />
:You should get a cryptic response which includes the version number of the MySQL server. <br />
* If you are attempting to run '''two instances of Moodle on different ports''', use the ip address of the host (not localhost) in the $CFG->dbhost setting, e.g. $CFG->dbhost = 127.0.0.1:3308.<br />
* You don't have the '''PHP mysql or postgresql extensions''' installed (please refer to FAQ re. whether PHP is installed).<br />
* You haven't created a '''Moodle database and assigned a user''' with the correct privileges to access it. <br />
* The '''Moodle database settings''' are incorrect. The database name, database user or database user password in your Moodle configuration file ''config.php'' are incorrect. Use phpMyAdmin to set up and check your MySQL installation.<br />
* Check that there are '''no apostrophes or non-alphabetic letters''' in your MySQL username or password.<br />
* You are using MySQL version 4.1 or higher but the PHP MySQL extension is pre-4.1 (check in your phpinfo output). In this case the '''default password hashing algorithm''' is incompatible with that available in the PHP mysql extension versions 4.x.x. Use these MySQL commands to change the passwords to the old format:<br />
<br />
mysql>SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('password');<br />
mysql>SET PASSWORD FOR 'moodleuser'@'localhost' = OLD_PASSWORD('password');<br />
<br />
:Also, consider upgrading your PHP MySQL extension. See http://dev.mysql.com/doc/mysql/en/old-client.html for further information on how to deal with this problem.<br />
* You are using Fedora core 3 or some other Linux system with '''SELinux installed''' and enabled. See the following URL for information on how to disable SELinux: http://fedora.redhat.com/projects/selinux/<br />
* Mac OSX users -- if you are running MySQL on a Mac OSX, try changing '''$CFG->dbhost''' from 'localhost' to '127.0.0.1'<br />
<br />
==I can't log in - I just stay stuck on the login screen==<br />
<br />
The most common cause for this is that your own computer (not your Moodle server) has a firewall that is stripping referrer information from the browser. Here are some instructions for fixing [http://service1.symantec.com/SUPPORT/nip.nsf/46f26a2d6dafb0a788256bc7005c3fa3/b9b47ad7eddd343b88256c6b006a85a8?OpenDocument&src=bar_sch_nam Norton firewall products].<br />
<br />
The server admin can also fix this for everyone by changing the ''secureforms'' variable to 'No' in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
Another possible cause of this problem is that sessions are not configured properly on the server. You can test this by calling the script <nowiki>http://yourserver/moodle/lib/session-test.php</nowiki>.<br />
<br />
If you are still having problems, read the [[Can_not_log_in | Cannot log in]] page.<br />
<br />
==I keep getting this error: Failed opening required '/web/moodle/lib/setup.php'==<br />
<br />
In your ''config.php'', the setting that you use for the dirroot variable must be the complete path from the root of your server's hard drive.<br />
<br />
Sometimes people only use the path from their home directory, or relative to the root of the web server directory.<br />
<br />
==I log in but the login link doesn't change. I am logged in and can navigate freely.==<br />
<br />
Make sure the URL in your <code>$CFG->wwwroot</code> setting is exactly the same as the one you are actually using to access the site.<br />
<br />
==My pages show fatal errors such as : Parse error, call to undefined function: get_string()==<br />
<br />
If you see errors like:<br />
<br />
Parse error: parse error, unexpected T_VARIABLE in /path/to/moodle/config.php on line 94 <br />
Fatal error: Call to undefined function: get_string() in /path/to/moodle/mod/resource/lib.php on line 11<br />
<br />
then you have probably left out a semi-colon or closing quote from a line in ''config.php'' (previous to line 94).<br />
<br />
Another possibility is that you edited ''config.php'' in a program like Word and saved it as a HTML web page, instead of using a plain text editor like Notepad.<br />
<br />
Another thing to check, particularly if you are using 3rd party modules or plugins, is whether any of the php scripts use short open tags (<? ?>) instead of proper ones (<?php ?>). Short tags are bad for various reasons, so first contact the author of that extension to tell them about the problem. Then either replace short tags with conventional ones, or set this line in php.ini:<br />
<br />
short_open_tag = On<br />
<br />
You should never find short tags in core moodle code. If you do, please file a bug in the bug tracker.<br />
<br />
==Serious Error! Could not set up the site!==<br />
<br />
Please refer to the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=32071 Serious Error! Could not set up the site!].<br />
<br />
==Uploaded files give "File not found"==<br />
<br />
For example: Not Found: The requested URL /moodle/file.php/2/myfile.jpg was not found on this server.<br />
<br />
Your web server needs to be configured to allow the part of the URL after a script name to be passed directly to the script. This is usually enabled in Apache 1, but is usually disabled by default in Apache 2. To turn it on, add this line to your ''httpd.conf'', or to a ''.htaccess'' file in your local directory (see [[Installing Moodle]] for more details):<br />
<br />
'''AcceptPathInfo''' on<br />
<br />
Note, this will ONLY work for Apache versions 2.x.<br />
<br />
If you are not using Apache 2 and you still have this problem (unlikely) then you can switch Moodle to use an alternative method. The disadvantages are a slight loss of performance for your users and you won't be able to use relative links within HTML resources.<br />
<br />
To use this alternative method, you should change the ''slasharguments'' variable in the Operating System section of Administration >> Configuration >> [[admin/config|Variables]]. You should now be able to access your uploaded files.<br />
<br />
==When I go to the admin page, I get told to make dirroot blank!==<br />
<br />
If you see errors like this:<br />
<br />
Please fix your settings in config.php: You have: $CFG->dirroot = "/home/users/fred/public_html/moodle"; <br />
but it should be: $CFG->dirroot = "";<br />
<br />
then you have encountered a small bug that occurs on some servers. The problem is with the error-checking mechanism, not with your actual path. To fix it, find this line (line 66) in the file ''admin/index.php'':<br />
<br />
if ($dirroot != $CFG->dirroot) {<br />
<br />
and change it to this:<br />
<br />
if (!empty($dirroot) and $dirroot != $CFG->dirroot) {<br />
<br />
==When trying to add a resource I receive error messages==<br />
<br />
Assuming you are using Apache, then it's quite likely that your setting in ''config.php'' for <code>$CFG->wwwroot</code> is different from the actual URL you are using to access the site. Also try turning off the ''secureforms'' variable in the security section of Administration >> Configuration >> [[admin/config|Variables]].<br />
<br />
==Why are all my pages blank?==<br />
<br />
Check the dirroot variable in ''config.php''. You must use complete, absolute pathnames e.g.<br />
<br />
$CFG->dirroot = "d:\inetpub\sites\www.yoursite.com\web\moodle";<br />
<br />
Another reason might be that PHP has not been configured to support MySQL. This is common on Redhat and OpenBSD installations. In this case, an error is generated, but since error displays are often disabled by default, all that is seen on the browser is a blank screen. To enable PHP error displays, set these lines in your ''php.ini'' file and reload the web page.<br />
<br />
display_errors = On<br />
display_startup_errors = On<br />
<br />
To determine if MySQL support is your problem, insert this as the second line in your ''config.php'' file<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Examine the output closely to see if MySQL is supported. If not look for a package you are missing.<br />
<br />
== Why is a particular page blank or incomplete? ==<br />
<br />
Check your web server log files!!<br />
<br />
If a particular page is blank or incomplete (it doesn't display the footer), before you do anything else check your error logs.<br />
<br />
PHP can be set up to log errors in a variety of different ways. These settings are contained in the php.ini file on the server. If you don't know were that is, edit your Moodle ''config.php'' and add the following as the second line<br />
<br />
phpinfo();<br />
<br />
then reload the web page. Look for the entry '''Configuration File (php.ini) Path'''.<br />
<br />
When you have located php.ini open it in your favorite text editor. Find the '''Error handling and logging''' section of the php.ini file. Make sure that both '''display_errors = On''' and '''log_errors = On''' are present and uncommented. Check the value of '''error_log''' - this tells you the location of the file errors are logged to. If it is commented out then errors will be sent to the web server error log file. Remember, if you make any changes to this file you will need to restart the web server (or just reboot the server).<br />
<br />
Having established that logging is working, reproduce the error. Immediately check the error log file right at the end. Hopefully you will see a PHP error message at or very near the end of the file. This may solve your problem directly or makes it a lot easier to diagnose the problem in the Moodle forums.<br />
<br />
If you are upgrading to a new version of Moodle, check that you do not have an old version of a non-standard block or module installed. Remove any such blocks or modules installed remove them using the admin settings page and start the install process again.<br />
<br />
==Installation hangs when setting-up database tables==<br />
*Sometimes the installation will hang when setting up tables. This will be an abrupt hang with half the page displayed in the browser and/or other outputs removed, e.g. the “Scroll to continue” link is displayed but no “Continue” button is there. If this is the case, it is usually a mysql error and not a php error. Check that there is no limit placed on your mysql database, e.g. a "questions" limit.<br />
<br />
*If the install is on a webhost, adding <br />
AddType x-mapp-php5 .php<br />
to the .htaccess file in the moodle directory has been known to solve the problem.<br />
*Try also renaming the .htaccess file so that it is disabled.<br />
<br />
You may also want to look and see if you've customized any of your code. Look at the last successful table, and then look at the block, mod, or other code that is referenced by that table. (For example, if your install hangs and continues to say that the forum tables were successful as the last message, look at /mod/forum/ for any custom code. If you have customized, backup those files and replace with the correct files. You can then restart the install by renaming config.php or reinstalling your database from the backup. If your install is successful, you can make your code changes back into the stock Moodle code.<br />
<br />
==Why can't I upload a new image into my profile?==<br />
<br />
If you don't see anything on your user profile pages to let you upload user images then it's usually because GD is not enabled on your server. GD is a library that allows image processing.<br />
<br />
1. Make sure GD has been included in your PHP installation. You can check this by going into Administration >> Configuration >> [[Variables]] and looking for the gdversion setting. This setting is chosen automatically every time you visit that page. If it shows GD version 1 or version 2 then everything should be fine. Save that configuration page and go back to your user profile.<br />
<br />
2. If Moodle thinks GD is not installed, then you will need to install it. On Windows this is usually a matter of "turning on" the module in PHP (see the [[Installing AMP|installation instructions]] for help). On Unix you may need to re-compile PHP with arguments something like this:<br />
<br />
./configure --with-apxs=/usr/local/apache/bin/apxs --with-xml --with-gd <br />
--with-jpeg-dir=/usr/local --with-png-dir=/usr --with-ttf --enable-gd-native-ttf <br />
--enable-magic-quotes --with-mysql --enable-sockets --enable-track-vars <br />
--enable-versioning --with-zlib<br />
<br />
3. Remember to re-visit the Moodle configuration page after making any changes to PHP so it can pick up the correct version of GD.<br />
<br />
Please see the Using Moodle forum discussion [http://moodle.org/mod/forum/discuss.php?d=44271 Profile pictures] for additional information.<br />
<br />
==Why do I keep getting error messages about "headers already sent"?==<br />
<br />
If you see errors like this:<br />
<br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87) <br />
in /webs/moodle/lib/moodlelib.php on line 1322 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/lib/moodlelib.php on line 1323 <br />
Warning: Cannot add header information - headers already sent by (output started at /webs/moodle/config.php:87)<br />
in /webs/moodle/login/index.php on line 54<br />
<br />
you have blank lines or spaces after the final <code>?></code> in your ''config.php'' file. Sometimes text editors add these - for example Notepad on Windows - so you may have to try a different text editor to remove these spaces or blank lines completely.<br />
<br />
== Why doesn't my Moodle site display the time and date correctly? ==<br />
<br />
Each language requires a specific language code (called a '''locale''' code) to allow dates to be displayed correctly. The language packs contain default standard codes, but sometimes these don't work on Windows servers.<br />
<br />
You can find the correct locale codes for Windows on these two pages: [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_language_strings.asp Language codes] and [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_country_strings.asp Country/region] codes (e.g. "esp_esp" for spanish)<br />
<br />
These new locale codes can be entered on the Administration >> Configuration >> [[admin/config|Variables]] page, where they override the ones in the currently chosen language pack.<br />
<br />
==I can't log in with message "Please verify that the current setting of session.save_path is correct" ==<br />
[http://moodle.org/mod/forum/discuss.php?d=55925#254596 See this Using Moodle Forum Summary]<br />
<br />
==How do I uninstall Moodle?==<br />
'''Moodle package installation''': If you have downloaded a Moodle package, simply uninstall using your system commands. On Windows PCs, you should access the Control Panel -> Add/Remove Programs. Select the package name and click Change or Remove Programs.<br />
<br />
'''Webhost/manual installation''': If you have installed Moodle manually or have installed onto a webhost, follow these steps:<br />
*Delete the moodle database using this mysql command (or delete using your mysql client, e.g. PHPMyAdmin):<br />
<pre>sql>DROP DATABASE moodle;</pre><br />
:In the above example replace 'moodle' with the name of the moodle database you created when installing.<br />
*Delete the moodledata directory. If you, or your users, have uploaded materials into this directory take a copy of these before deleting this directory.<br />
*Delete the moodle directory itself. This will delete all of the moodle PHP script files.<br />
<br />
[[Category:Core]]<br />
[[Category:Administrator]]<br />
[[Category:FAQ]]<br />
[[Category:Installation]]<br />
<br />
[[es:FAQ Instalación]]<br />
[[fr:FAQ d'installation]]<br />
[[nl:Installatie FAQ]]<br />
[[ja:インストールFAQ]]<br />
[[ru:Установка FAQ]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Front_page&diff=17741Front page2006-11-03T18:41:14Z<p>Mcampbell: </p>
<hr />
<div>*[[Make News on Front Page viewable to Teachers only]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administrator_documentation&diff=17736Administrator documentation2006-11-03T18:16:37Z<p>Mcampbell: /* See also */</p>
<hr />
<div>The purpose of this page is to list useful links by general topics for administrators.<br />
<br />
== Installation ==<br />
<br />
*[[Installing Moodle]]<br />
*[[Installing AMP|Installing Apache, MySQL and PHP]]<br />
* [[Installation Quickstart]]<br />
*[[Installation FAQ]]<br />
*[[Upgrading|Upgrading Moodle]]<br />
*[[Complete install packages]]<br />
<br />
==Security and performance==<br />
<br />
*[[Security]]<br />
*[[Performance]]<br />
*[[Manage roles]] 1.7<br />
<br />
== Configuration ==<br />
<br />
*[[Variables]]<br />
*[[Site settings]]<br />
*[[Themes]]<br />
*[[Language]]<br />
*[[Modules (administrator)|Modules]]<br />
*[[Blocks (administrator)|Blocks]]<br />
*[[Filters (administrator)|Filters]]<br />
*[[Backup (administrator)|Backup]]<br />
*[[Editor settings]]<br />
*[[Calendar (administrator)|Calendar]]<br />
*[[Maintenance mode]]<br />
<br />
==Users==<br />
<br />
*[[Authentication]]<br />
*[[Edit user accounts]]<br />
*[[Edit profile|Add a new user]]<br />
*[[Flat file|Upload users]]<br />
*[[Enrolment plugins]]<br />
*[[Courses (administrator)|Enrol students]]<br />
*[[Courses (administrator)|Assign teachers]]<br />
*[[Assign creators]]<br />
*[[Assign admins]]<br />
<br />
==Other==<br />
<br />
*[[Courses (administrator)|Courses]] and [[Course formats|course formats]]<br />
*[[Logs]]<br />
*[[Site files]]<br />
*[[Moodle database|Database]]<br />
*[[Environment]]<br />
<br />
==See also==<br />
<br />
*[[Integrations]]<br />
*[[CVS (administrator)|CVS documentation]]<br />
*[[Email processing]]<br />
*[[Search engine optimization]]<br />
*[[Messaging]]<br />
*[[Migration]]<br />
*[[Metacourses]]<br />
*[[Block layout]]<br />
*[[Customizing Moodle]]<br />
*[[Backup FAQ]]<br />
*[[Administration FAQ]]<br />
*[[Administrator do's and don'ts]]<br />
*[http://download.moodle.org/docs/using_moodle/ch16_server_admin.pdf Using Moodle Chapter 16: Moodle Administration]<br />
<br />
[[Category: Administrator]]<br />
[[cs:Rukověť správce]]<br />
[[es:Documentación para Administradores]]<br />
[[fr:Documentation administrateur]]<br />
[[nl:Documentatie voor beheerders]]<br />
[[zh:管理员文档]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administrator_documentation&diff=17735Administrator documentation2006-11-03T18:16:13Z<p>Mcampbell: /* See also */</p>
<hr />
<div>The purpose of this page is to list useful links by general topics for administrators.<br />
<br />
== Installation ==<br />
<br />
*[[Installing Moodle]]<br />
*[[Installing AMP|Installing Apache, MySQL and PHP]]<br />
* [[Installation Quickstart]]<br />
*[[Installation FAQ]]<br />
*[[Upgrading|Upgrading Moodle]]<br />
*[[Complete install packages]]<br />
<br />
==Security and performance==<br />
<br />
*[[Security]]<br />
*[[Performance]]<br />
*[[Manage roles]] 1.7<br />
<br />
== Configuration ==<br />
<br />
*[[Variables]]<br />
*[[Site settings]]<br />
*[[Themes]]<br />
*[[Language]]<br />
*[[Modules (administrator)|Modules]]<br />
*[[Blocks (administrator)|Blocks]]<br />
*[[Filters (administrator)|Filters]]<br />
*[[Backup (administrator)|Backup]]<br />
*[[Editor settings]]<br />
*[[Calendar (administrator)|Calendar]]<br />
*[[Maintenance mode]]<br />
<br />
==Users==<br />
<br />
*[[Authentication]]<br />
*[[Edit user accounts]]<br />
*[[Edit profile|Add a new user]]<br />
*[[Flat file|Upload users]]<br />
*[[Enrolment plugins]]<br />
*[[Courses (administrator)|Enrol students]]<br />
*[[Courses (administrator)|Assign teachers]]<br />
*[[Assign creators]]<br />
*[[Assign admins]]<br />
<br />
==Other==<br />
<br />
*[[Courses (administrator)|Courses]] and [[Course formats|course formats]]<br />
*[[Logs]]<br />
*[[Site files]]<br />
*[[Moodle database|Database]]<br />
*[[Environment]]<br />
<br />
==See also==<br />
<br />
*[[Integrations]]<br />
*[[CVS (administrator)|CVS documentation]]<br />
*[[Email processing]]<br />
*[[Search engine optimization]]<br />
*[[Messaging]]<br />
*[[Migration]]<br />
*[[Metacourses]]<br />
*[[Block layout]]<br />
[Customizing_Moodle]<br />
*[[Backup FAQ]]<br />
*[[Administration FAQ]]<br />
*[[Administrator do's and don'ts]]<br />
*[http://download.moodle.org/docs/using_moodle/ch16_server_admin.pdf Using Moodle Chapter 16: Moodle Administration]<br />
<br />
[[Category: Administrator]]<br />
[[cs:Rukověť správce]]<br />
[[es:Documentación para Administradores]]<br />
[[fr:Documentation administrateur]]<br />
[[nl:Documentatie voor beheerders]]<br />
[[zh:管理员文档]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Administrator_documentation&diff=17734Administrator documentation2006-11-03T18:15:33Z<p>Mcampbell: /* See also */</p>
<hr />
<div>The purpose of this page is to list useful links by general topics for administrators.<br />
<br />
== Installation ==<br />
<br />
*[[Installing Moodle]]<br />
*[[Installing AMP|Installing Apache, MySQL and PHP]]<br />
* [[Installation Quickstart]]<br />
*[[Installation FAQ]]<br />
*[[Upgrading|Upgrading Moodle]]<br />
*[[Complete install packages]]<br />
<br />
==Security and performance==<br />
<br />
*[[Security]]<br />
*[[Performance]]<br />
*[[Manage roles]] 1.7<br />
<br />
== Configuration ==<br />
<br />
*[[Variables]]<br />
*[[Site settings]]<br />
*[[Themes]]<br />
*[[Language]]<br />
*[[Modules (administrator)|Modules]]<br />
*[[Blocks (administrator)|Blocks]]<br />
*[[Filters (administrator)|Filters]]<br />
*[[Backup (administrator)|Backup]]<br />
*[[Editor settings]]<br />
*[[Calendar (administrator)|Calendar]]<br />
*[[Maintenance mode]]<br />
<br />
==Users==<br />
<br />
*[[Authentication]]<br />
*[[Edit user accounts]]<br />
*[[Edit profile|Add a new user]]<br />
*[[Flat file|Upload users]]<br />
*[[Enrolment plugins]]<br />
*[[Courses (administrator)|Enrol students]]<br />
*[[Courses (administrator)|Assign teachers]]<br />
*[[Assign creators]]<br />
*[[Assign admins]]<br />
<br />
==Other==<br />
<br />
*[[Courses (administrator)|Courses]] and [[Course formats|course formats]]<br />
*[[Logs]]<br />
*[[Site files]]<br />
*[[Moodle database|Database]]<br />
*[[Environment]]<br />
<br />
==See also==<br />
<br />
*[[Integrations]]<br />
*[[CVS (administrator)|CVS documentation]]<br />
*[[Email processing]]<br />
*[[Search engine optimization]]<br />
*[[Messaging]]<br />
*[[Migration]]<br />
*[[Metacourses]]<br />
*[[Block layout]]<br />
*[[https://docs.moodle.org/en/Customizing_Moodle]]<br />
*[[Backup FAQ]]<br />
*[[Administration FAQ]]<br />
*[[Administrator do's and don'ts]]<br />
*[http://download.moodle.org/docs/using_moodle/ch16_server_admin.pdf Using Moodle Chapter 16: Moodle Administration]<br />
<br />
[[Category: Administrator]]<br />
[[cs:Rukověť správce]]<br />
[[es:Documentación para Administradores]]<br />
[[fr:Documentation administrateur]]<br />
[[nl:Documentatie voor beheerders]]<br />
[[zh:管理员文档]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Blackboard_migration&diff=13298Blackboard migration2006-07-21T20:35:33Z<p>Mcampbell: </p>
<hr />
<div>A [http://moodle.org/mod/forum/discuss.php?d=32049 Blackboard content conversion tool] is available. It was designed to migrate Blackboard 6.1 to Moodle 1.4+ - it may be possible to make it work with other versions.<br />
<br />
According to Michael Penney in the forum discussion [http://moodle.org/mod/forum/discuss.php?d=1565 Migrating 10000 students from Blackboard to Moodle?] <br />
<br />
:''"It works pretty well with a couple of caveats:''<br />
<br />
:''1) It doesn't import all Blackboard question types: at CSU H, we wrote an essay question type and a 'rendered match' question type and a BB pool importer, we'd like to work with SF and others to get our qtype importer into theirs.''<br />
<br />
:''2) SF's tool is designed to make you think about your course when you import it and redesign it. That is a nice idea, however it can be pretty time consuming when you have hundreds of documents in a course (<rant>Blackboard's poor content development tools encourage what I call the 'datadump' course format, instead of delivering information in an effective elearning tool like Moodle's lesson, with BB folks tend to post hundreds of office documents and then massive quizzes about them</rant>).''"<br />
<br />
We recently migrated about 200 courses from Blackboard 6 to Moodle 1.5+, and I made a [http://instructor.metrotech.org/~mcampbell/Converting%20Blackboard%20to%20Moodle.ppt PowerPoint] for this routine. I've been asked to make a Captivate just on the import routine and will work on that.<br />
<br />
[[Category:Administrator]]<br />
[[Category:Developer]]</div>Mcampbellhttps://docs.moodle.org/310/en/index.php?title=Blackboard_migration&diff=13297Blackboard migration2006-07-21T20:34:02Z<p>Mcampbell: </p>
<hr />
<div>A [http://moodle.org/mod/forum/discuss.php?d=32049 Blackboard content conversion tool] is available. It was designed to migrate Blackboard 6.1 to Moodle 1.4+ - it may be possible to make it work with other versions.<br />
<br />
According to Michael Penney in the forum discussion [http://moodle.org/mod/forum/discuss.php?d=1565 Migrating 10000 students from Blackboard to Moodle?] <br />
<br />
:''"It works pretty well with a couple of caveats:''<br />
<br />
:''1) It doesn't import all Blackboard question types: at CSU H, we wrote an essay question type and a 'rendered match' question type and a BB pool importer, we'd like to work with SF and others to get our qtype importer into theirs.''<br />
<br />
:''2) SF's tool is designed to make you think about your course when you import it and redesign it. That is a nice idea, however it can be pretty time consuming when you have hundreds of documents in a course (<rant>Blackboard's poor content development tools encourage what I call the 'datadump' course format, instead of delivering information in an effective elearning tool like Moodle's lesson, with BB folks tend to post hundreds of office documents and then massive quizzes about them</rant>).''"<br />
<br />
We recently migrated about 200 courses from Blackboard 6 to Moodle 1.5+, and I made a [PowerPoint] for this routine. I've been asked to make a Captivate just on the import routine and will work on that.<br />
<br />
[[Category:Administrator]]<br />
[[Category:Developer]]</div>Mcampbell