>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #209862. --> Reported by: [kwurzel](https://www.drupal.org/user/186781) >>> <p>With Drupal 6 RC 2 it isn't possible to install multisites.</p> <p>Steps:<br> * Install Drupal with shared tables discribed in default.settings.php<br> * Copy settings.php to new foldes (sub.example.com) and edit table name (main_ --&gt; sub_) and base_url<br> * Go to sub.example.com/install.php</p> <p>Effect:<br> * new table (sub_) can't be created:</p> <pre>Warning: Table 'shared_sessions' already exists query: CREATE TABLE shared_sessions ( `uid` INT unsigned NOT NULL, `sid` VARCHAR(64) NOT NULL DEFAULT '', `hostname` VARCHAR(128) NOT NULL DEFAULT '', `timestamp` INT NOT NULL DEFAULT 0, `cache` INT NOT NULL DEFAULT 0, `session` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid), INDEX timestamp (timestamp), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Table 'shared_authmap' already exists query: CREATE TABLE shared_authmap ( `aid` INT unsigned NOT NULL auto_increment, `uid` INT NOT NULL DEFAULT 0, `authname` VARCHAR(128) NOT NULL DEFAULT '', `module` VARCHAR(128) NOT NULL DEFAULT '', PRIMARY KEY (aid), UNIQUE KEY authname (authname) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Table 'shared_role' already exists query: CREATE TABLE shared_role ( `rid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(64) NOT NULL DEFAULT '', PRIMARY KEY (rid), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Table 'shared_users' already exists query: CREATE TABLE shared_users ( `uid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(60) NOT NULL DEFAULT '', `pass` VARCHAR(32) NOT NULL DEFAULT '', `mail` VARCHAR(64) DEFAULT '', `mode` TINYINT NOT NULL DEFAULT 0, `sort` TINYINT DEFAULT 0, `threshold` TINYINT DEFAULT 0, `theme` VARCHAR(255) NOT NULL DEFAULT '', `signature` VARCHAR(255) NOT NULL DEFAULT '', `created` INT NOT NULL DEFAULT 0, `access` INT NOT NULL DEFAULT 0, `login` INT NOT NULL DEFAULT 0, `status` TINYINT NOT NULL DEFAULT 0, `timezone` VARCHAR(8) DEFAULT NULL, `language` VARCHAR(12) NOT NULL DEFAULT '', `picture` VARCHAR(255) NOT NULL DEFAULT '', `init` VARCHAR(64) DEFAULT '', `data` LONGTEXT DEFAULT NULL, PRIMARY KEY (uid), UNIQUE KEY name (name), INDEX access (access), INDEX created (created), INDEX mail (mail) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Duplicate entry '' for key 2 query: INSERT INTO shared_users (name, mail) VALUES('', '') in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Duplicate entry '1' for key 1 query: UPDATE shared_users SET uid = 1 WHERE name = 'placeholder-for-uid-1' in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Duplicate entry 'anonymous user' for key 2 query: INSERT INTO shared_role (name) VALUES ('anonymous user') in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: Duplicate entry 'authenticated user' for key 2 query: INSERT INTO shared_role (name) VALUES ('authenticated user') in /home/kinoformat/public_html/includes/database.mysqli.inc on line 133<br><br>Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/kinoformat/public_html/includes/database.mysqli.inc:133) in /home/kinoformat/public_html/includes/bootstrap.inc on line 967<br><br>Warning: Cannot modify header information - headers already sent by (output started at /home/kinoformat/public_html/includes/database.mysqli.inc:133) in /home/kinoformat/public_html/includes/bootstrap.inc on line 568<br><br>Warning: Cannot modify header information - headers already sent by (output started at /home/kinoformat/public_html/includes/database.mysqli.inc:133) in /home/kinoformat/public_html/includes/bootstrap.inc on line 569<br><br>Warning: Cannot modify header information - headers already sent by (output started at /home/kinoformat/public_html/includes/database.mysqli.inc:133) in /home/kinoformat/public_html/includes/bootstrap.inc on line 570<br><br>Warning: Cannot modify header information - headers already sent by (output started at /home/kinoformat/public_html/includes/database.mysqli.inc:133) in /home/kinoformat/public_html/includes/bootstrap.inc on line 571</pre><p>* </p> <pre>Fatal error: Call to undefined function user_access() in /home/kinoformat/public_html/includes/theme.inc on line 1651&lt;code&gt;<br>&nbsp; on sub.example.com<br>* &lt;code&gt;* user warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM video_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/kinoformat/public_html/includes/menu.inc on line 316.<br>&nbsp;&nbsp;&nbsp; * user warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM video_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/kinoformat/public_html/includes/menu.inc on line 316.</pre><p> when trying to run the installation again.</p>