Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.
Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca
This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
When I am trying to log in into to ojs. The login window comes wtih a error like that "DB Error: Table '.\ojsijceas\user_settings' is marked as crashed and should be repaired". I had connect to the database and clear all of the spam registered users (about 4.000 spam users) but nothing is changed. How can I repair the user_settings. I can not login the system.
Dr. Ibrahim GURLER
- Posts: 1
- Joined: Sun Mar 10, 2013 11:57 pm
You'll need to connect to your database directly, and run a repair table command. You can do this in one of two ways. The first is from the command line with the mysql command, which comes with MySQL:
Connect to your MySQL server with the 'mysql' command and run:
REPAIR TABLE user_settings;
Alternatively, from the shell become root and cd into your MySQL ojs database directory. Then run:
myisamchk -r user_settings
which should repair the table.
- Site Admin
- Posts: 910
- Joined: Tue Jan 10, 2006 6:20 am
Return to OJS Technical Support
Who is online
Users browsing this forum: Bing [Bot], Yahoo [Bot] and 2 guests