I am having similar problems, can you explain what 'mdl_course' is so I can answer your question.
Thanks
Dave
Dear Dave Kirby,
mdl_course is the table in your moodle database that stores your courses.
If you unzip and upload the database administration adon MYSQL Admin to your moodle/admin folder the administrator will see a new database icon on the main page. Click it to enter the database. You will see a long list of tables in your database in the left hand frame. One of them is the mdl_course table (or perhaphs moodle_course). If you click it and press view in the right hand frame you will see the array of data about your courses. I think that Eloy is asking how many rows there are in that table. There should be one row for each course.
It is not advisable to change anything in the database unless you know what you are doing, but it is okay to looko.
Hi Timothy Takemoto
I have uploaded the complete unzipped folder to moodle/admin. Unfortunately I don't see any icon on the main page. Should I have emptied the folder into moodle/admin or is it right to leave it in the MYSQL folder?
I have managed via PHPmyadmin on cPanel to access the database mdl_course, there are 11 lines, the same number of courses, the only problem I can see is that the ID number starts at 0, misses out 3, 6, 10 and 13-20. Is this where I have deleted courses, which I have done?
Thanks
Dave
Dear Dave Kirby
The instructions say (with my commend in blue) "This module is a repackaged version of phpMyAdmin 2.6.0. To install, just unzip this archive inside the moodle/admin folder. (that is for people that can unzip on their servers - I can't so I unzip first and then upload) You should end up with a folder in there called 'mysql' in there that contains all the necessary files. Now when you look at your Moodle admin menus you will see a new item: 'Database'."
So it is strange that you do not see the database icon. You are logging in as an administrator? Perhaps you need to go to the admin page first but I do not think so. Nah. Hmm... I have no answer for this one. I have uploaded the database administrator to all my moodles and I always see the icon. I have to just refresh the main page. You did refresh? The icon looks like a stack of CDs. You can also see a "manage the database" or some such on the main admin page too.
But since you have access via cPanel, then you have the answer that Eloy wants. I am not sure what he is going to make of that.
Perhaps the email assumes that there are 20 courses, and complains about the fact that some of them are missing??
Eloy will probably tell you soon, since he is saint (in my experience).
Tim
Ps. I write names at the top of postings since I find it difficult to tell which posts are addressed to me. Thanks for returning the favour(?).
Hi Timothy Takemoto
What I have now done is moved the MYsql folder out of the 'moodle-1.4-mysql-admin' directly into moodle/admin folder and it now works, ironically it gives me the same view as in cPanel, bit easier than signing into the control panel everytime. 
I know that I have created courses in the past and then deleted them, I was haaving a few other problems which I have now sorted out. Whether it is because of this i'm not sure, but that might account for the missing id numbers when I view the database.
Thanks for all your help.
Dave
Hi Timothy Allen
I have an error email saying four courses are not backed up, when I look in mdl_backup_courses, there are 4 courses with zeros by them.
I only have 11 courses actually on moodle, but in mdl_backup_courses it shows 21. Would it be safe to delete them?
Thanks
Dave
Hi Tim
What I might do is wait until you have carried out more tests as my site is being used by students, I will check the id numbers in the backup, mdl_backup_courses and in mdl_courses. I will let you know if I find anything.
Thanks
Dave
Hi Tim
I took a chance last night and deleted the courses with 0 by them in mdl_backup_courses and received no error report this morning. It still says it is backing up 17 courses and I on have 11 in mdl_courses, so there maybe a bug there too. 
Dave
Hi Tim and Eloy
Since upgrading to 1.4.2 the backup email represents the correct amount of courses. Before it was saying 17, it now says 11, which is right.
Thanks
Dave
|
|
||||||||
|---|---|---|---|---|---|---|---|---|
|
|
|
|
17 | 18 | 1149040856 | 1149040861 | 3 | 1149213600 |
