After installing Joomla many times and bumping into the same difficulties again and again you eventually start making notes to save some nerve cells during the next installation. I know errors and misconfigurations vary from environment to environment, but still there are common patterns. These are ours, let’s hope they will help some Joomla strugglers.
Database errors like:
- "Table '[databasename].[joomlaprefix]_session' doesn't exist SQL=INSERT INTO `[joomlaprefix]_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES ('orq75r1sblvc55ru9rl2rdr3r0', 0, 1, '1362044756', 0, '')"
- “Database connection error (2): Could not connect to MySQL”
Most probably you have wrong database name and/or username and/or password. Carefully check these values in configuration.php and compare to those configured in database.
"Mismatch between target UID (XXX) and UID (YYY) of file "/var/www/[youraccount]/html/index.php"".
This problem usually occurs when database admin moves/creates Joomla files using his/her OS account. Try changing ownership from admin’s account to the one that belongs to Apache.
"Internal Server Error
Directory "/var/www/[youraccount]/html" is writeable by group""
Try setting document root (i.e. "/var/www/[youraccount]/html") permissions to 755.
You don't have permission to access the requested directory. There is either no index document or the directory is read-protected."
DNS might not be updated/configured, so your domain name not (yet) pointing to your server. If you’re in enterprise environment and have internal DNS, you’ll need to add host entries to your "C:\Windows\System32\drivers\etc\hosts" file until everything will be set up. If you’re on shared host, hosting provider have temporary URL to access your site (can be found in cPanel).
IP address appears in website URLs instead of domain name
This can be really undesirable in enterprise environments, especially if load balancing is in use. Changing setting "live_site" in configuration.php from empty value to a website domain (i.e. http://example.com) can prevent this issue.
Joomla administration page protected via basic authentication (.htpasswd) stopped accepting credentials. Note: tools like Akeeba Backup use this method.
You probably moved your website from one location to another. This usually leads to paths change. And as path to .htpasswd has changed user authentication details can no longer be retrieved. To fix this problem, correct path has to be configured for AuthUserFile directive in .htaccess file located at your "administrator" folder.
If you have errors/issues to share I’ll be glad to add them to the list.
Good luck! ;)