Drupal 6.1 Install Tutorial

[lizon]

For users looking to use Drupal 7, Please click here for more info


The following tutorial is to help whose with little to no web experience install Drupal 6.15 onto their zymic account. I went ahead and made a new account from scratch with a fresh install to try and see every possible error that comes along and address each one.

Zymic Setup:


Goto the Zymic homepage and click on "Sign-up/Log-in"



Make up your username and e-mail address. Type in your password.



Be sure to make sure your human. ^.^



Click on the "login" link



Congrats you are now logged in! Now click on "Control Panel Home"



Click on "Create New Web Host Account"



Make up your subdomain name and primaty host



Type in your control panel password. Keep in mind this pasword is ALSO your FTP password. So remember it.



Don't be doing any naughty stuff with your website and check off "I agree"



I'm not sure if I'm a human....Resistance is Futile....o.O



Congradultaions!



Write down your ftp information, you'll need it later on then click on "Login to control panel"



Click on the login button as shown here



Type in your password, don't worry I won't look....



Now to get your database setup, click on "MySQL Database Management"



Create your database name and click on "create DataBase Name"



Now create your database username and password, be sure to confirm it and press "Create Username"



Now assign privileges to your username to the database you want, be sure everythign is checked off and click "Assign Privileges"



Congrats your database is now created. Be sure to write down your database name, database username, and password. You will need that info in a little bit.



Congrats your DONE with the Zymic setup! Now lets get to Drupal.

Drupal Setup

STEP 1:
Download the Drupal 6.15 Distribution here.

STEP 2: Unzip the file and save it's contents into a folder that you can refer back to easily (save it on your desktop if you want).

STEP 3:
Now for the fun part. Open up your drupal folder and find your default.settings.php file at /sites/default/

Open up the file in your favorite web editing tool (notepad, dreamweaver, ect ect) and find this section of code.

CODE

$db_url = 'mysql://username:password@localhost/databasename';

Input your DATABASE username and password into the spots provided. Leave the host as localhost.Then input your database name.

CODE

$db_url = 'mysql://90593_zymic:zymic132@localhost/lizontest_zxq_zymic';

STEP 4:
Next find this section of code

CODE

ini_set('arg_separator.output',     '&');
      ini_set('magic_quotes_runtime',     0);
      ini_set('magic_quotes_sybase',      0);
      ini_set('session.cache_expire',     200000);
      ini_set('session.cache_limiter',    'none');
      ini_set('session.cookie_lifetime',  2000000);
      ini_set('session.gc_maxlifetime',   200000);
      ini_set('session.save_handler',     'user');
      ini_set('session.use_cookies',      1);
      ini_set('session.use_only_cookies', 1);
      ini_set('session.use_trans_sid',    0);
      ini_set('url_rewriter.tags',        '');

Comment out the line by putting a # in front of each line till it looks liks this

CODE

@ini_set('arg_separator.output',     '&');
      @ini_set('magic_quotes_runtime',     0);
      @ini_set('magic_quotes_sybase',      0);
      @ini_set('session.cache_expire',     200000);
      @ini_set('session.cache_limiter',    'none');
      @ini_set('session.cookie_lifetime',  2000000);
      @ini_set('session.gc_maxlifetime',   200000);
      @ini_set('session.save_handler',     'user');
      @ini_set('session.use_cookies',      1);
      @ini_set('session.use_only_cookies', 1);
      @ini_set('session.use_trans_sid',    0);
      @ini_set('url_rewriter.tags',        '');

STEP 5:
Now save your default.settings.php AS settings.php This is VERY IMPORTANT!

Now lets open up bootstrap.inc file located at /includes/ in the base drupal directory. Find this line of code

CODE

  if (count(explode('.', $cookie_domain)) > 2 && !is_numeric(str_replace('.', '', $cookie_domain))) {
         ini_set('session.cookie_domain', $cookie_domain);
       }

Comment out the lines using // so it looks like this

CODE

//  if (count(explode('.', $cookie_domain)) > 2 && !is_numeric(str_replace('.', '', $cookie_domain))) {
     //    ini_set('session.cookie_domain', $cookie_domain);
     //  }

Save the file.

STEP 6:
Now open up the .htaccess file located in root directory (same spot where index.php is at). Scroll down to this code

CODE

  # If your site is running in a VirtualDocumentRoot at http://example.com/,
     # uncomment the following line:
     # RewriteBase /
     # Rewrite URLs of the form 'x' to the form 'index.php?q=x'.

Remove the # in front of RewriteBase / so it looks like this

CODE

  # If your site is running in a VirtualDocumentRoot at http://example.com/,
     # uncomment the following line:
     RewriteBase /
     # Rewrite URLs of the form 'x' to the form 'index.php?q=x'.

STEP 7:
Now using your favorite FTP program upload all the contents in the drupal folder to your website, Core FTP is a good one (www.coreftp.com). Grab a drink if you want, this should take a few minutes at least.

STEP 8:
Now in your ftp program goto your sites/default directory in your web directory and create a folder titles "files"



STEP 9:
Next right click on the folder and click on properties. This will allow you to set permissions for the directory. Set it up just how I've shown here. You can either check off the boxes or enter the value as 775



STEP 10:

Getting closer to the finish line. Goto your home directory. In this case it's lizontest.zxq.net/install.php



DON'T PANIC! ^.^

Click where indicated.

STEP 11:
Input the url to your website and click "Submit"



STEP 12:
It should now take you back to your homepage, if not simply go back to it, in this case it's lizontest.zxq.net/install.php. You should get the following screen. Click on "Install Drupal in English"



STEP 13: Installing.......




DONE!



STEP 14:
Put in your site name and e-mail address....



and your Admin username and e-mail address...



and your password for that username, be sure to confirm it....



Oh and click off "Enabled" for the Clean URLs. When I did this install I messed up with it, for you it should be available to click off.



Click "Save and Continue"

STEP 15:



Don't worry about the error message. The mail() function is disabled unless you pay for it. The website will still work. Click on the link that takes you to "your new website".

STEP 16:
Congrats your done!



Remember if you ever need help the drupal forums and knowledge base are an excellent reference tool. All can be found at drupal.org

SPECIAL THANKS:
To the Zymic support members in chat who suggested many of the changes here to make Drupal work for me. All credit goes to them and their efforts.[color="#FF0000"][/color]

[buyan]

Hi there ! I followed every step of the shown installation of Drupal 6.15,
cant get it to work. Please help?

gives me error messages:

Warning: MySQL server has gone away query: CREATE TABLE variable ( `name` VARCHAR(128) NOT NULL DEFAULT '', `value` LONGTEXT NOT NULL, PRIMARY KEY (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE actions ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters` LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0', PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE actions_aid ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE batch ( `bid` INT unsigned NOT NULL auto_increment, `token` VARCHAR(64) NOT NULL, `timestamp` INT NOT NULL, `batch` LONGTEXT DEFAULT NULL, PRIMARY KEY (bid), INDEX token (token) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache_form ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache_page ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache_menu ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE files ( `fid` INT unsigned NOT NULL auto_increment, `uid` INT unsigned NOT NULL DEFAULT 0, `filename` VARCHAR(255) NOT NULL DEFAULT '', `filepath` VARCHAR(255) NOT NULL DEFAULT '', `filemime` VARCHAR(255) NOT NULL DEFAULT '', `filesize` INT unsigned NOT NULL DEFAULT 0, `status` INT NOT NULL DEFAULT 0, `timestamp` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (fid), INDEX uid (uid), INDEX status (status), INDEX timestamp (timestamp) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE flood ( `fid` INT NOT NULL auto_increment, `event` VARCHAR(64) NOT NULL DEFAULT '', `hostname` VARCHAR(128) NOT NULL DEFAULT '', `timestamp` INT NOT NULL DEFAULT 0, PRIMARY KEY (fid), INDEX allow (event, hostname, timestamp) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE history ( `uid` INT NOT NULL DEFAULT 0, `nid` INT NOT NULL DEFAULT 0, `timestamp` INT NOT NULL DEFAULT 0, PRIMARY KEY (uid, nid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE menu_router ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` TEXT NOT NULL, `to_arg_functions` TEXT NOT NULL, `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX f in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE menu_links ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8 in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE 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 /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE system ( `filename` VARCHAR(255) NOT NULL DEFAULT '', `name` VARCHAR(255) NOT NULL DEFAULT '', `type` VARCHAR(255) NOT NULL DEFAULT '', `owner` VARCHAR(255) NOT NULL DEFAULT '', `status` INT NOT NULL DEFAULT 0, `throttle` TINYINT NOT NULL DEFAULT 0, `bootstrap` INT NOT NULL DEFAULT 0, `schema_version` SMALLINT NOT NULL DEFAULT -1, `weight` INT NOT NULL DEFAULT 0, `info` TEXT DEFAULT NULL, PRIMARY KEY (filename), INDEX modules (type(12), status, weight, filename), INDEX bootstrap (type(12), status, bootstrap, weight, filename), INDEX type_name (type(12), name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE url_alias ( `pid` INT unsigned NOT NULL auto_increment, `src` VARCHAR(128) NOT NULL DEFAULT '', `dst` VARCHAR(128) NOT NULL DEFAULT '', `language` VARCHAR(12) NOT NULL DEFAULT '', PRIMARY KEY (pid), UNIQUE KEY dst_language (dst, language), INDEX src_language (src, language) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE filters ( `fid` INT NOT NULL auto_increment, `format` INT NOT NULL DEFAULT 0, `module` VARCHAR(64) NOT NULL DEFAULT '', `delta` TINYINT NOT NULL DEFAULT 0, `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (fid), UNIQUE KEY fmd (format, module, delta), INDEX list (format, weight, module, delta) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE filter_formats ( `format` INT NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL DEFAULT '', `roles` VARCHAR(255) NOT NULL DEFAULT '', `cache` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (format), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache_filter ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename FROM system WHERE name = 'block' AND type = 'module' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE blocks ( `bid` INT NOT NULL auto_increment, `module` VARCHAR(64) NOT NULL DEFAULT '', `delta` VARCHAR(32) NOT NULL DEFAULT '0', `theme` VARCHAR(64) NOT NULL DEFAULT '', `status` TINYINT NOT NULL DEFAULT 0, `weight` TINYINT NOT NULL DEFAULT 0, `region` VARCHAR(64) NOT NULL DEFAULT '', `custom` TINYINT NOT NULL DEFAULT 0, `throttle` TINYINT NOT NULL DEFAULT 0, `visibility` TINYINT NOT NULL DEFAULT 0, `pages` TEXT NOT NULL, `title` VARCHAR(64) NOT NULL DEFAULT '', `cache` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (bid), UNIQUE KEY tmd (theme, module, delta), INDEX list (theme, status, region, weight, module) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE blocks_roles ( `module` VARCHAR(64) NOT NULL, `delta` VARCHAR(32) NOT NULL, `rid` INT unsigned NOT NULL, PRIMARY KEY (module, delta, rid), INDEX rid (rid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE boxes ( `bid` INT unsigned NOT NULL auto_increment, `body` LONGTEXT DEFAULT NULL, `info` VARCHAR(128) NOT NULL DEFAULT '', `format` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (bid), UNIQUE KEY info (info) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE cache_block ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename FROM system WHERE name = 'user' AND type = 'module' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE access ( `aid` INT NOT NULL auto_increment, `mask` VARCHAR(255) NOT NULL DEFAULT '', `type` VARCHAR(255) NOT NULL DEFAULT '', `status` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE 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 /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE permission ( `pid` INT NOT NULL auto_increment, `rid` INT unsigned NOT NULL DEFAULT 0, `perm` LONGTEXT DEFAULT NULL, `tid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (pid), INDEX rid (rid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE 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 /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE 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 '', `signature_format` SMALLINT NOT NULL DEFAULT 0, `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 /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE users_roles ( `uid` INT unsigned NOT NULL DEFAULT 0, `rid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (uid, rid), INDEX rid (rid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename FROM system WHERE name = 'node' AND type = 'module' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node ( `nid` INT unsigned NOT NULL auto_increment, `vid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(32) NOT NULL DEFAULT '', `language` VARCHAR(12) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `uid` INT NOT NULL DEFAULT 0, `status` INT NOT NULL DEFAULT 1, `created` INT NOT NULL DEFAULT 0, `changed` INT NOT NULL DEFAULT 0, `comment` INT NOT NULL DEFAULT 0, `promote` INT NOT NULL DEFAULT 0, `moderate` INT NOT NULL DEFAULT 0, `sticky` INT NOT NULL DEFAULT 0, `tnid` INT unsigned NOT NULL DEFAULT 0, `translate` INT NOT NULL DEFAULT 0, PRIMARY KEY (nid), UNIQUE KEY vid (vid), INDEX node_changed (changed), INDEX node_created (created), INDEX node_moderate (moderate), INDEX node_promote_status (promote, status), INDEX node_status_type (status, type, nid), INDEX node_title_type (title, type(4)), INDEX node_type (type(4)), INDEX uid (uid), INDEX tnid (tnid), INDEX translate (translate) ) /*!4010 in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node_access ( `nid` INT unsigned NOT NULL DEFAULT 0, `gid` INT unsigned NOT NULL DEFAULT 0, `realm` VARCHAR(255) NOT NULL DEFAULT '', `grant_view` TINYINT unsigned NOT NULL DEFAULT 0, `grant_update` TINYINT unsigned NOT NULL DEFAULT 0, `grant_delete` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (nid, gid, realm) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node_counter ( `nid` INT NOT NULL DEFAULT 0, `totalcount` BIGINT unsigned NOT NULL DEFAULT 0, `daycount` MEDIUMINT unsigned NOT NULL DEFAULT 0, `timestamp` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node_revisions ( `nid` INT unsigned NOT NULL DEFAULT 0, `vid` INT unsigned NOT NULL auto_increment, `uid` INT NOT NULL DEFAULT 0, `title` VARCHAR(255) NOT NULL DEFAULT '', `body` LONGTEXT NOT NULL, `teaser` LONGTEXT NOT NULL, `log` LONGTEXT NOT NULL, `timestamp` INT NOT NULL DEFAULT 0, `format` INT NOT NULL DEFAULT 0, PRIMARY KEY (vid), INDEX nid (nid), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node_type ( `type` VARCHAR(32) NOT NULL, `name` VARCHAR(255) NOT NULL DEFAULT '', `module` VARCHAR(255) NOT NULL, `description` MEDIUMTEXT NOT NULL, `help` MEDIUMTEXT NOT NULL, `has_title` TINYINT unsigned NOT NULL, `title_label` VARCHAR(255) NOT NULL DEFAULT '', `has_body` TINYINT unsigned NOT NULL, `body_label` VARCHAR(255) NOT NULL DEFAULT '', `min_word_count` SMALLINT unsigned NOT NULL, `custom` TINYINT NOT NULL DEFAULT 0, `modified` TINYINT NOT NULL DEFAULT 0, `locked` TINYINT NOT NULL DEFAULT 0, `orig_type` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (type) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename FROM system WHERE name = 'comment' AND type = 'module' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE comments ( `cid` INT NOT NULL auto_increment, `pid` INT NOT NULL DEFAULT 0, `nid` INT NOT NULL DEFAULT 0, `uid` INT NOT NULL DEFAULT 0, `subject` VARCHAR(64) NOT NULL DEFAULT '', `comment` LONGTEXT NOT NULL, `hostname` VARCHAR(128) NOT NULL DEFAULT '', `timestamp` INT NOT NULL DEFAULT 0, `status` TINYINT unsigned NOT NULL DEFAULT 0, `format` SMALLINT NOT NULL DEFAULT 0, `thread` VARCHAR(255) NOT NULL, `name` VARCHAR(60) DEFAULT NULL, `mail` VARCHAR(64) DEFAULT NULL, `homepage` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (cid), INDEX pid (pid), INDEX nid (nid), INDEX status (status) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE node_comment_statistics ( `nid` INT unsigned NOT NULL DEFAULT 0, `last_comment_timestamp` INT NOT NULL DEFAULT 0, `last_comment_name` VARCHAR(60) DEFAULT NULL, `last_comment_uid` INT NOT NULL DEFAULT 0, `comment_count` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (nid), INDEX node_comment_timestamp (last_comment_timestamp) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename FROM system WHERE name = 'taxonomy' AND type = 'module' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE term_data ( `tid` INT unsigned NOT NULL auto_increment, `vid` INT unsigned NOT NULL DEFAULT 0, `name` VARCHAR(255) NOT NULL DEFAULT '', `description` LONGTEXT DEFAULT NULL, `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (tid), INDEX taxonomy_tree (vid, weight, name), INDEX vid_name (vid, name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE term_hierarchy ( `tid` INT unsigned NOT NULL DEFAULT 0, `parent` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (tid, parent), INDEX parent (parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE term_node ( `nid` INT unsigned NOT NULL DEFAULT 0, `vid` INT unsigned NOT NULL DEFAULT 0, `tid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (tid, vid), INDEX vid (vid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE term_relation ( `trid` INT NOT NULL auto_increment, `tid1` INT unsigned NOT NULL DEFAULT 0, `tid2` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (trid), UNIQUE KEY tid1_tid2 (tid1, tid2), INDEX tid2 (tid2) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE term_synonym ( `tsid` INT NOT NULL auto_increment, `tid` INT unsigned NOT NULL DEFAULT 0, `name` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (tsid), INDEX tid (tid), INDEX name_tid (name, tid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE vocabulary ( `vid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL DEFAULT '', `description` LONGTEXT DEFAULT NULL, `help` VARCHAR(255) NOT NULL DEFAULT '', `relations` TINYINT unsigned NOT NULL DEFAULT 0, `hierarchy` TINYINT unsigned NOT NULL DEFAULT 0, `multiple` TINYINT unsigned NOT NULL DEFAULT 0, `required` TINYINT unsigned NOT NULL DEFAULT 0, `tags` TINYINT unsigned NOT NULL DEFAULT 0, `module` VARCHAR(255) NOT NULL DEFAULT '', `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (vid), INDEX list (weight, name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: CREATE TABLE vocabulary_node_types ( `vid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(32) NOT NULL DEFAULT '', PRIMARY KEY (type, vid), INDEX vid (vid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: SELECT filename, name, type, status, throttle, schema_version FROM system WHERE type = 'theme' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: DELETE FROM system WHERE type = 'theme' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('pushbutton', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:10:\"Pushbutton\";s:11:\"description\";s:52:\"Tabled, multi-column theme in blue and orange tones.\";s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1260996916\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";}s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\" in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('minnelli', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:\"name\";s:8:\"Minnelli\";s:11:\"description\";s:56:\"Tableless, recolorable, multi-column, fixed width theme.\";s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:10:\"base theme\";s:7:\"garland\";s:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:12:\"minnelli.css\";s:36:\"themes/garland/minnelli/minnelli.css\";}}s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1260996916\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Heade in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('garland', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:7:\"Garland\";s:11:\"description\";s:66:\"Tableless, recolorable, multi-column, fluid width theme (default).\";s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:11:\"stylesheets\";a:2:{s:3:\"all\";a:1:{s:9:\"style.css\";s:24:\"themes/garland/style.css\";}s:5:\"print\";a:1:{s:9:\"print.css\";s:24:\"themes/garland/print.css\";}}s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1260996916\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\" in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('marvin', '', 'a:13:{s:4:\"name\";s:6:\"Marvin\";s:11:\"description\";s:31:\"Boxy tabled theme in all grays.\";s:7:\"regions\";a:2:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";}s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:10:\"base theme\";s:9:\"chameleon\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1260996916\";s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_lin in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('chameleon', 'themes/chameleon/chameleon.theme', 'a:12:{s:4:\"name\";s:9:\"Chameleon\";s:11:\"description\";s:42:\"Minimalist tabled theme with light colors.\";s:7:\"regions\";a:2:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";}s:8:\"features\";a:4:{i:0;s:4:\"logo\";i:1;s:7:\"favicon\";i:2;s:4:\"name\";i:3;s:6:\"slogan\";}s:11:\"stylesheets\";a:1:{s:3:\"all\";a:2:{s:9:\"style.css\";s:26:\"themes/chameleon/style.css\";s:10:\"common.css\";s:27:\"themes/chameleon/common.css\";}}s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\& in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('bluemarine', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:10:\"Bluemarine\";s:11:\"description\";s:66:\"Table-based multi-column theme with a marine and ash color scheme.\";s:7:\"version\";s:4:\"6.15\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1260996916\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";}s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO users (name, mail) VALUES('', '') in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO users (name, mail, created, data) VALUES('placeholder-for-uid-1', 'placeholder-for-uid-1', 1263746051, 'a:0:{}') in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: UPDATE users SET uid = uid - uid WHERE name = '' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: UPDATE users SET uid = 1 WHERE name = 'placeholder-for-uid-1' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO role (name) VALUES ('anonymous user') in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO role (name) VALUES ('authenticated user') in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO permission (rid, perm, tid) VALUES (1, 'access content', 0) in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO permission (rid, perm, tid) VALUES (2, 'access comments, access content, post comments, post comments without approval', 0) in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO variable (name, value) VALUES ('theme_default', 's:7:\"garland\";') in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: UPDATE system SET status = 1 WHERE type = 'theme' AND name = 'garland' in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128 Warning: MySQL server has gone away query: INSERT INTO blocks (module, delta, theme, status, weight, region, pages, cache) VALUES ('user', '0', 'garland', 1, 0, 'left', '', -1) in /www/clanteam.com/b/u/y/buyan/htdocs/includes/database.mysql.inc on line 128

This post has been edited by Dave: Feb 6 2010, 12:46 AM

Reason for edit: codebox [Dave]

[lizon]

Hi there ! I followed every step of the shown installation of Drupal 6.15,
cant get it to work. Please help?

Would like to know at what step of the process that your on. If I were to guess you already uploaded everything and made all of the necessary changed. If that's the case if you've already updated the .haccess file then your getting that error during the initial instillation. You have to goto your /install.php file to begin the install. For example my test site was lizontest.zxq.net, so to begin the install I would goto lizontest.zxq.net/install.php.

If I simply goto the base URL I would get a similar error like the one you got because the tables for MySQL don't exist yet! For some reason the index.php file doesn't refer to the install.php page on the initial install on zymic. It's prob something to do with the ini_set settings that you have to comment out. No biggie though, it should still work.