The following are some of the most common installation problems.
I'm just installing v4 on my server and during the last step I get this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 31
To fix that error open the setup/config.php and change
define("DB_SET_CHARSET", "YES");
to
define("DB_SET_CHARSET", "NO");
.
On many hosts, you can edit your .htaccess file, and add the following code:
php_value register_globals 0