- Domain Name
- Web Hosting Account - Opening and Basic Setup
- Web Hosting Account - Installation Drupal 5.7 (Applicable for 5.12 Too)
- Welcome To Your New Drupal Website!
- 'Standard Web Site' - 4 Pages
- Basic Concepts In A Nutshell
- Basic Site Settings, File Configurations
- Web Site 'Looks' Or Default Templates
- Contributed (External) Modules/Themes In 'public_html/sites' Folder
- Add Theme (External) - Aberdeen
- Adding 'External'/Contributed Module - Nodewords For Search Engine Keywords
- Feedback Form For Visitor To Send
- Image Gallery
- Learn To Put An Image Using HTML Image Tag
- Changing Background, Styling of Themes
- For Multiple Websites With One Drupal Installation
- Trouble Shooting
- Login Twice problem
- Block Header Error Messages
- Fatal error: Can't open file: 'sessions.MYI'
- Disable RSS Feed Icon
- Error "Cannot Modify Header ......."
- Fatal error: Call to undefined function: civicrm_initialize()
- Indentation - Left Justification Problem
- Invalid argument foreach()
- Parse error... unexpected T_DNUMBER
- Unable to connect to database server
- A Word About Taxonomy
- Some Basic Tools We Need
- Creating Book Content - Using Book Module
- User Settings And Our 3rd 'Login' (Authenticated) User 'Sam'
- Creating Blog Content With Attached Image Module
- Security, Security, More Security
- How To Upgrade Drupal 5.7 To 5.8
- Storage And Bandwidth - How Much We Need?
Fatal error: Can't open file: 'sessions.MYI'
Don't panic if you get something like this error:-
Fatal error: Can't open file: 'sessions.MYI' (errno: 145) query: SELECT u.*, s.* FROM
users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'eb41686f3dc5941ad09e162d1e
53088e' AND u.status < 3 LIMIT 0, 1 in /home/yoursitename/public_html/includes/database.
mysql.inc on line 66..
This is because mysql 'users' database table is corrupted and needs repair. This is not a Drupal problem. Read thread here.
MySQL Account Maintenance
Go to your cPanel. Open a web browser (Internet Explorer or Firefox) and enter directly into the url address box:
http://www.my_domain.com/cpanel.
Press Enter or Select 'Go'.
Enter username, password
Select mysql> 'Check' [and message like below appears..]
Checking Database
yoursite_drpl1 is now being checked.
yoursite_drpl1.access OK
yoursite_drpl1.accesslog OK
yoursite_drpl1.aggregator_category OK ...
..................................
yoursite_drpl1.sequences OK
yoursite_drpl1.sessions
warning : Table is marked as crashed
warning : 1 client is using or hasn't closed the table properly
error : Found 244 keys of 245
error : Corrupt
yoursite_drpl1.system
Now Clicked 'Repair' and you should see all tables as 'OK'.