Blog

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.


Error
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”
  • Etc.

Solution
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.


Error
"Mismatch between target UID (XXX) and UID (YYY) of file "/var/www/[youraccount]/html/index.php"".

Solution
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.


Error
"Internal Server Error
Directory "/var/www/[youraccount]/html" is writeable by group""

Solution
Try setting document root (i.e. "/var/www/[youraccount]/html") permissions to 755.


Error
"Access forbidden!
You don't have permission to access the requested directory. There is either no index document or the directory is read-protected."

Solution
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).


Issue
IP address appears in website URLs instead of domain name

Solution
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.


Issue
Joomla administration page protected via basic authentication (.htpasswd) stopped accepting credentials. Note: tools like Akeeba Backup use this method.

Solution
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! ;)

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
Image CAPTCHA
Enter the characters shown in the image.