hi, i am getting this error message when trying to login, can anyone help please?
thanks
youssef kassab
Hi Youssef,
It may be the case that the database table mdl_user needs repairing. Assuming you have phpMyAdmin, this may be done as follows:
Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type
It may be the case that the database table mdl_user needs repairing. Assuming you have phpMyAdmin, this may be done as follows:
Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type
REPAIR TABLE mdl_user and click the Go button.
thanks helen, i tried it and it worked. do you know what is the reason of this problem?
Hi Youssef,
Thanks for your feedback - it's good to know your problem is solved. Sorry, I don't know the exact cause of your problem - there are probably a number of possibilities. I wouldn't worry unless it happens again.
Thanks for your feedback - it's good to know your problem is solved. Sorry, I don't know the exact cause of your problem - there are probably a number of possibilities. I wouldn't worry unless it happens again.
Thank you again and hope the problem won't happen again
How do you login to myphpadmin?
Thanks.
David
The specific location of phpmyadmin depends on your server configuration. If you don't know, I guess your sysadmin is the next best person to ask.
On Debian servers, it can be found on http://localhost/phpmyadmin (I don't think it's available remotely by default). For other configurations, you'll have to give us a lot more information, or ask your sysadmin.
I hope this helps a bit,
Mathieu
On Debian servers, it can be found on http://localhost/phpmyadmin (I don't think it's available remotely by default). For other configurations, you'll have to give us a lot more information, or ask your sysadmin.
I hope this helps a bit,
Mathieu
I just added phpmyadmin on my Ubuntu box with:
sudo apt-get install phpmyadmin
It installed fine and looks like you can access it on the LAN with http://<ip-address>/phpmyadmin/ by default...
Very useful... I think I will add it to my MySQL server when I get back to work tomorrow!
sudo apt-get install phpmyadmin
It installed fine and looks like you can access it on the LAN with http://<ip-address>/phpmyadmin/ by default...
Very useful... I think I will add it to my MySQL server when I get back to work tomorrow!
Hi David,
If phpMyAdmin is installed in the moodle/admin folder (as described for MySQL Admin 2.11.5.1), your site admin block will include a database link in the server folder for easy access to phpMyAdmin.
If phpMyAdmin is installed in the moodle/admin folder (as described for MySQL Admin 2.11.5.1), your site admin block will include a database link in the server folder for easy access to phpMyAdmin.
I had the same problem and your suggestion worked. Thank you very much! I'm glad I found this solution! 
Thanks!! Help me out too , and it was so quick.
Hi Helen Foster,
Thanks a Lot, it works perfectly fine!
Dhrubajyoti Doley (India)
Thanks a Lot, it works perfectly fine!
Dhrubajyoti Doley (India)
Good Day Helen
Please explain me as to how i go and Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type
Is there any coding that i need.
I have never worked with Moodle before ,I know how to login into phpMyAdmin but i am not sure what to do there after please explain,Thank You.
Regards
Preshentha
Please explain me as to how i go and Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type
REPAIR TABLE mdl_user
and click the Go button.Is there any coding that i need.
I have never worked with Moodle before ,I know how to login into phpMyAdmin but i am not sure what to do there after please explain,Thank You.
Regards
Preshentha
Hi!
Brainlock over "Could not create guest user record !!!" issue. I am using moodle for windows 1.9.5 stable. The problem is that if I cannot login to moodle using the regular login screen how could I use the REPAIR TABLE mdl_user command. Is there a different procedure to login for solving this problem or I need to install some extra software for that.!
I'd really appreciate your help in this respect.
Thank you.
Syed
I've just had the same problem. I used the solution as described above. It worked perfectly!
Probably this is too late to solve your problem. Moodle runs on a server that has MySQL installed. You need to access the MySql database on your server. This is not from within Moodle. You need to have phpMyAdmin installed in order to utilise the solution posted above. You will probably be able to log in by typing //localhost/phpmyadmin in the URL box of your browser, if you are working on the server. Otherwise just replace "localhost" with the name of your server. You will need the User Name and Password for the MySql database.
Probably this is too late to solve your problem. Moodle runs on a server that has MySQL installed. You need to access the MySql database on your server. This is not from within Moodle. You need to have phpMyAdmin installed in order to utilise the solution posted above. You will probably be able to log in by typing //localhost/phpmyadmin in the URL box of your browser, if you are working on the server. Otherwise just replace "localhost" with the name of your server. You will need the User Name and Password for the MySql database.
In order to prevent or minimize this from happening, I chose to script a nightly optimize and repair of my Mysql DB.
I simply setup a cronjob nightly to execute the following:
mysqlcheck dbname -c -o -a -r -f -h localhost -u root -pyourpassword
see here for all the switches:
http://linuxcommand.org/man_pages/mysqlcheck1.html
Cheers,
-n
I simply setup a cronjob nightly to execute the following:
mysqlcheck dbname -c -o -a -r -f -h localhost -u root -pyourpassword
see here for all the switches:
http://linuxcommand.org/man_pages/mysqlcheck1.html
Cheers,
-n
Hi!
Thank you for your reply. I too mangaged to solve this problem the second time using the same procedure. But, only after crashing my database and a fresh installation. I wish I'd have got your reply earlier.
Anyways thanks.
Hi..
I too have this problem. moodle.mdl.user table showing repair and this table read only, how to solve this problem. I couldn't add new user and couldn't update old user's details anything. Please give me the suggetions..
Thanks..
it not work
"The storage engine for the table doesn*t support repair"
Hi 佳波 钱,
A few tips:
1. Trying to get useful info from very old threads doesn't tend to work. That advice was given six years ago (and the original post is an eight year old one!) and it was intended for a MySQL MyISAM database engine, not for an InnoDB engine.
2. If there isn't a recent thread with your problem, then open a new thread.
3. One of the best practices when having a problem is to enable Debugging and to check the logs: the web server error log and the database and Moodle logs.
4. Do provide as much info as you can about your installation: OS, web server version, database server version, PHP version and Moodle version, at the very least.
5. Be as descriptive as possible about your problem by explaining what were you doing and what error messages you got (from recommendation #3).
Regarding these two last points, please read the moodle.org policy page for more info:
https://moodle.org/mod/page/view.php?id=7080
6. It is also a good practice to use a search engine, for example:
https://duckduckgo.com/?q=The+storage+engine+for+the+table+doesn%27t+support+repair
---
Given the lack of more information about your situation, I can only recommend you to see:
I was upgradiing from MySQL 5.0 to 5.1 (on CentOS 5.4 64 bit ) and all my InnoDB tables where deleted or corrupted 
One of them was mdl_user.
That is way i was getting this error message.
I issued mysqlcheck command to find out what was missing and i exported them (manually) from the old MySQL server and imported them into the new MySQL 5.1 server. successfully
mysqlcheack does not repair corrupted InooDB tables
One of them was mdl_user.
That is way i was getting this error message.
I issued mysqlcheck command to find out what was missing and i exported them (manually) from the old MySQL server and imported them into the new MySQL 5.1 server. successfully
mysqlcheack does not repair corrupted InooDB tables
phpCAS error: phpCAS::client(): type mismatched for parameter $server_version (should be `string') in D:\MoodleWindowsInstaller-latest-19\server\moodle\auth\cas\auth.php on line 178