Help - Search - Members - Calendar
Full Version: Drupal 6.1 Install Tutorial
Zymic Webmaster Forums > Zymic Free Web Hosting > Tutorials
Pages: 1, 2
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.... wink.gif



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]
swordz
But as uuuq is down, no-one can install Drupal anyway.

Well done btw, it's not often I approve threads in this forum. But (with a little minor editing) it looked quite complete and easy to follow.

swordz
Andrew
Hey great one, one thing though, when creating a new account you need to click "Control Panel Home" not the regular "Home" link. I would change it, but you've got the picture of it too, so I'll let you change it.
lizon
fixed
dzulkifl
i have a question. For step five, are those commands on line 757 supposed to be there already or am i supposed to add them. Cause my line 757 is nothing similar to your screenshot. Mine is drupal 6.1.

i have a question. For step five, are those commands on line 757 supposed to be there already or am i supposed to add them. Cause my line 757 is nothing similar to your screenshot. Mine is drupal 6.1.
lizon
QUOTE(dzulkifl @ Mar 7 2009, 02:04 AM) *
i have a question. For step five, are those commands on line 757 supposed to be there already or am i supposed to add them. Cause my line 757 is nothing similar to your screenshot. Mine is drupal 6.1.

i have a question. For step five, are those commands on line 757 supposed to be there already or am i supposed to add them. Cause my line 757 is nothing similar to your screenshot. Mine is drupal 6.1.


No their not supposed to be there, i was experimenting. I'll make a new screenshot and post it up when the service is back up.

(update) I took out the one extra line of code that was there and replaced the pictures. Those are how the lines should look like.
dzulkifl
QUOTE(lizon @ Mar 7 2009, 08:13 AM) *
No their not supposed to be there, i was experimenting. I'll make a new screenshot and post it up when the service is back up.

(update) I took out the one extra line of code that was there and replaced the pictures. Those are how the lines should look like.


Hey man thanks for the prompt response, waiting anxiously for the update. Thanks!!
lizon
QUOTE(dzulkifl @ Mar 7 2009, 06:24 AM) *
Hey man thanks for the prompt response, waiting anxiously for the update. Thanks!!


note: those lines are there, I had just included 1 extra line of code in my original posting that wasn't supposed to be there cause I was tryiing to figure out a work around for the error. The new screenshots have the offending line removed and the current pictures are accurate. If you cannot find the code you can always simply use the search function in your web editor (ctrl + f), and search for ini_set, you shoul dbe able tofind the line of code that way as well.
rsc1835
Rock solid tutorial! You can never have enough images spelling out exactly what to do. I'd only installed Drupal once before so this really helped remove the fog.
aerosol
hello:
I did try follow very carefully those introducions, but i get this error. And i dont know what should i do.

The following installation warning should be carefully reviewed:
Operations on Unicode strings are emulated on a best-effort basis. Install the PHP mbstring extension for improved Unicode support. (Currently using Unicode library Standard PHP)
vonline
thank for this tips & more:
http://drupal.org/server-permissions
http://th.php.net/mbstring

Now i just follow this tip but when go to Install site step: show error mess:
CODE
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 menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /www/uuuq.com/v/o/n/vonline/htdocs/mobile-clip/includes/menu.inc on line 315.
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 menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /www/uuuq.com/v/o/n/vonline/htdocs/mobile-clip/includes/menu.inc on line 315.


how to clear this err?
iconsult.tk
try to delete your drupal database by mysql management on cPanel mode

re-create your database(same older name) name again, then set Assign Privileges

next, run yourdrupalsite/install.php again & follow above step.
rolleyes.gif
http://iConsult.tk
vonline
thank for this tip & now i can install my drupal finish
Liqfan
Getting issues:
CODE
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /tmp/filemrbgiD owned by uid 2001 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 757.
    * warning: fopen(/tmp/filemrbgiD) [function.fopen]: failed to open stream: Success in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 757.
    * Het bestand kon niet aangemaakt worden.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: realpath() [function.realpath]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /www/uuuq.com/q/u/i/quinten/htdocs owned by uid 2003 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 188.
    * warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 70858 is not allowed to access /tmp/filerqjMSN owned by uid 2001 in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 757.
    * warning: fopen(/tmp/filerqjMSN) [function.fopen]: failed to open stream: Success in /www/uuuq.com/q/u/i/quinten/htdocs/includes/file.inc on line 757.
    * Het bestand kon niet aangemaakt worden.


Followed your exact steps. Since safe_mod is enabled on uuuq.com, would you like to explain how it can fail while you got success? Would be very nice of you.
rojerbinny3132
I really appriciate for this kind of shortcuts..thanks..
veligursky
domain vndv. Drupal 5.16 you can install locally (standart install) and move after install to zymic.
.htaccess-must bee deleted
veligursky
Drupal 5.16 - I enabled clear urls,
but have problem with images -when I add some content (blog, story etc - they are dissapear ), when i delete .htaccess from "files" directory -they show, but if I try add some content they dissapear again.

veligursky
all done and work
AlexeyNS
can you say in words what to coment out. Pictures don't work
lizon
QUOTE(AlexeyNS @ Apr 20 2009, 10:54 AM) *
can you say in words what to coment out. Pictures don't work



sorry been away addressing some issues. Their working again.
rcorveira
Hello,
When i follow the Drupal Setup, STEP 4:Next find this section of code.... what section of code????

Thanks
RC
ar3rocker
yhea stuck on taht line man what section of code ? lol
GektorGrom
oh NO, links to the photos will not work.

((( please fixed this
Jaes
Someone please make a new tutorial or fix the pictures, because this tutorial has become useless...
Dave

Topic Closed until tutorial is fixed.

Edit: Open again - pictures fixed.
BUSINESSMAN
thanks big thanks working smile.gif
renanorola
wow finally i found the step by step how to install drupal. Thanks for your idea..
yakuzax
thank you so much for this tutorial!
ArtPisanski
Followed the tutorial exactly.

I get some beef with the .htaccess file..
But I get this when I try to load index.php:

QUOTE
Warning: Table 'cwtest3_99k_cwdb3.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('99.250.226.233') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 1029

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 1029

Warning: Table 'cwtest3_99k_cwdb3.cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'cwtest3_99k_cwdb3.variable' doesn't exist query: SELECT * FROM variable in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128

Notice: Undefined variable: variables in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 480

Warning: Table 'cwtest3_99k_cwdb3.cache' doesn't exist query: UPDATE cache SET data = '', created = 1255671964, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128

Notice: Undefined variable: variables in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 487

Warning: Table 'cwtest3_99k_cwdb3.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 630

Warning: Cannot modify header information - headers already sent by (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 631

Warning: Cannot modify header information - headers already sent by (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 632

Warning: Cannot modify header information - headers already sent by (output started at /www/99k.org/c/w/t/cwtest3/htdocs/sites/default/settings.php:1) in /www/99k.org/c/w/t/cwtest3/htdocs/includes/bootstrap.inc on line 633

Warning: Table 'cwtest3_99k_cwdb3.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /www/99k.org/c/w/t/cwtest3/htdocs/includes/database.mysql.inc on line 128


I had it working on a different account, but couldn't get past the database part, even though I was entering the correct data.

Can anyone help?
elmerato
^I had the same issue with ArtPisanki. For some reason a transfer from an existing installation messes up something with regards to the database.

I suspect it has something to do with the zymic requirement to edit out the ini_set in settings.php and bootstrap.inc.

Subscribing.
4iriks
Hmm , hes saying when im typing the wrong database datas ! but all seems to be right !
dadajoke
thank you~!man biggrin.gif
lsimmons98
Thanks for the great tutorial.
Easy to use.


QUOTE(lizon @ Mar 4 2009, 06:38 AM) *
This installation tutorial will guide new users step by step through installing Drupal 6.x onto their Zymic webhost. The first section of this guide is designed for novice users who don't know anything about Zymic or websites in general at all. For those who already have webspace on Zymic you can skip this part and go directly to the instillation section. For everyone else listen up.

STEP 1:
Go and register your new account on Zymic.com and log into your account.

STEP 2:
Click on Control Panel Home


STEP 3:
Now click Create new Web Host Account


STEP 3:
Fill in your web name and password here


STEP 4:
Scroll down on the page and Tick the Checkbox and copy the 2 words at the bottom and click on Confirm Registration.


STEP 5:
Now click on login to go into your new web account


STEP 6:
Enter your password and click login again

STEP 7:
Now lets make our database, click on MYSQL Database Management


STEP 8:
First you want to create the database in the top field. Fill in a name then click Create Database. The name (including your site name) must be less than 16 characters, so keep it short.


STEP 9:
Next you make your username for the database and your password and confirm it in the next section (see circled area on the bottom). Again. less than 16 characters in total.

STEP 10:
Lastly select your Username from the drop down menu and then assign it to the corresponding database from the database name drop down menu. Click on Assign Privileges.


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

DRUPAL SETUP

STEP 1:
Download the Drupal 6.1 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 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.


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

Example: 'mysql://zymic_admin:zymic123@localhost/zymic_db'

STEP 4:
Next find this section of code

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


STEP 5:
Now save your settings.php file and now lets open up bootstrap.inc file located at /includes/ in the base drupal directory. Find this line of code

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

Save the file.

STEP 6:
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 7:
Once the files finish uploading it's time to goto your website using your browser (example: lizon.uuuq.com). You should get this page

If the page doesn't appear try going directly to the install.php file directly (example: lizon.uuuq.com/install.php).

Click on Install Drupal in English (or whatever language you prefer)

STEP 8:
Now if you had done everything that I had told you to do previously you should be rewarded with the following:

Huzzah! Almost done, fill in all the relevant information, site name, e-mail, ect ect. Click on the button on the bottom of the page to proceed.

Step 9:
W00t!

Congrats your done! Don't worry about the mail error, that's cause the mail function isn't available unless you pay for it. Click on the link and enjoy your new website.

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.

Q: Does Zymic support Clean Url's?
A: Sorry, it doesn't, this has to do with how Zymic handles .htaccess files, so Clean Url's currently aren't an option for Drupal users. This also means that you cannot use such modules like Brilliant Gallery which require Clean Url's to work. sad.gif

Q: Help I can't get RSS feeds to work!
A: I had this problem as well, this has to do with the coding within the page.tpl files. The easy fix for this is to find the .tpl files for the theme that you are using. This is useually something like a page.tpl or page-search.tpl file
Example:


You want to find part of the code that has /rss.xml listed


Change /rss.xml to ?q=rss.xml

This should solve the problem. This will also correct login and logout links such as /logout (change to ?q=logout) and /login (change to ?q=login).

The link to this tutorial on my website an be found at http://lizon.uuuq.com/?q=node/175

dadajoke
Warning: Table 'bokeyo_zxq_drupal.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('122.231.250.94') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 1037

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 1037

Warning: Table 'bokeyo_zxq_drupal.cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'bokeyo_zxq_drupal.variable' doesn't exist query: SELECT * FROM variable in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128

Notice: Undefined variable: variables in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 480

Warning: Table 'bokeyo_zxq_drupal.cache' doesn't exist query: UPDATE cache SET data = '', created = 1257058116, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128

Notice: Undefined variable: variables in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 487

Warning: Table 'bokeyo_zxq_drupal.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 636

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 637

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 638

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc:128) in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/bootstrap.inc on line 639

Warning: Table 'bokeyo_zxq_drupal.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /www/zxq.net/b/o/k/bokeyo/htdocs/includes/database.mysql.inc on line 128




what is the problem?
dionysosedhec
I have the exact same problem...
dionysosedhec
I deleted the settings.php file and that allowed me to start the install but now I get some other errors when checking the prerequirement:

QUOTE
Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 137

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 138

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 139

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 140

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 141

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 142

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 143

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 144

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 145

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 146

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 147

Warning: ini_set() has been disabled for security reasons in /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php on line 148

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php:137) in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/bootstrap.inc on line 636

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php:137) in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/bootstrap.inc on line 637

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php:137) in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/bootstrap.inc on line 638

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php:137) in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/bootstrap.inc on line 639

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/d/i/o/dionysosedhec/htdocs/sites/default/settings.php:137) in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/common.inc on line 148


I guess the ini_set warnings come from the modification of the bootstrap.inc file, but the rest is more important as it means that the install cannot access the settings.php file...

So I chose to set up the settings.php file myself and give the required access so site/default/files myself but then again I got new errors in the database:

QUOTE
* 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 menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/menu.inc on line 315.
* 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 menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /www/zxq.net/d/i/o/dionysosedhec/htdocs/includes/menu.inc on line 315.



...
I'd really hate to get back to my other webhost but I think i'll have to do it...
45tt
CODE

/**
* @file
* Functions that need to be loaded on every Drupal request.
*/

/**
* Indicates that the item should never be removed unless explicitly told to
* using cache_clear_all() with a cache ID.
*/
define('CACHE_PERMANENT', 0);

/**
* Indicates that the item should be removed at the next general cache wipe.
*/
define('CACHE_TEMPORARY', -1);

/**
* Indicates that page caching is disabled.
*/
define('CACHE_DISABLED', 0);

/**
* Indicates that page caching is enabled, using "normal" mode.
*/
define('CACHE_NORMAL', 1);

/**
* Indicates that page caching is using "aggressive" mode. This bypasses
* loading any modules for additional speed, which may break functionality in
* modules that expect to be run on each page load.
*/
define('CACHE_AGGRESSIVE', 2);

/**
*
* Severity levels, as defined in RFC 3164 http://www.faqs.org/rfcs/rfc3164.html
* @see watchdog()
* @see watchdog_severity_levels()
*/
define('WATCHDOG_EMERG', 0); // Emergency: system is unusable
define('WATCHDOG_ALERT', 1); // Alert: action must be taken immediately
define('WATCHDOG_CRITICAL', 2); // Critical: critical conditions
define('WATCHDOG_ERROR', 3); // Error: error conditions
define('WATCHDOG_WARNING', 4); // Warning: warning conditions
define('WATCHDOG_NOTICE', 5); // Notice: normal but significant condition
define('WATCHDOG_INFO', 6); // Informational: informational messages
define('WATCHDOG_DEBUG', 7); // Debug: debug-level messages

/**
* First bootstrap phase: initialize configuration.
*/
define('DRUPAL_BOOTSTRAP_CONFIGURATION', 0);

/**
* Second bootstrap phase: try to call a non-database cache
* fetch routine.
*/
define('DRUPAL_BOOTSTRAP_EARLY_PAGE_CACHE', 1);

/**
* Third bootstrap phase: initialize database layer.
*/
define('DRUPAL_BOOTSTRAP_DATABASE', 2);

/**
* Fourth bootstrap phase: identify and reject banned hosts.
*/
define('DRUPAL_BOOTSTRAP_ACCESS', 3);

/**
* Fifth bootstrap phase: initialize session handling.
*/
define('DRUPAL_BOOTSTRAP_SESSION', 4);

/**
* Sixth bootstrap phase: load bootstrap.inc and module.inc, start
* the variable system and try to serve a page from the cache.
*/
define('DRUPAL_BOOTSTRAP_LATE_PAGE_CACHE', 5);

/**
* Seventh bootstrap phase: find out language of the page.
*/
define('DRUPAL_BOOTSTRAP_LANGUAGE', 6);

/**
* Eighth bootstrap phase: set $_GET['q'] to Drupal path of request.
*/
define('DRUPAL_BOOTSTRAP_PATH', 7);

/**
* Final bootstrap phase: Drupal is fully loaded; validate and fix
* input data.
*/
define('DRUPAL_BOOTSTRAP_FULL', 8);

/**
* Role ID for anonymous users; should match what's in the "role" table.
*/
define('DRUPAL_ANONYMOUS_RID', 1);

/**
* Role ID for authenticated users; should match what's in the "role" table.
*/
define('DRUPAL_AUTHENTICATED_RID', 2);

/**
* No language negotiation. The default language is used.
*/
define('LANGUAGE_NEGOTIATION_NONE', 0);

/**
* Path based negotiation with fallback to default language
* if no defined path prefix identified.
*/
define('LANGUAGE_NEGOTIATION_PATH_DEFAULT', 1);

/**
* Path based negotiation with fallback to user preferences
* and browser language detection if no defined path prefix
* identified.
*/
define('LANGUAGE_NEGOTIATION_PATH', 2);

/**
* Domain based negotiation with fallback to default language
* if no language identified by domain.
*/
define('LANGUAGE_NEGOTIATION_DOMAIN', 3);

/**
* Language written left to right. Possible value of $language->direction.
*/
define('LANGUAGE_LTR', 0);

/**
* Language written right to left. Possible value of $language->direction.
*/
define('LANGUAGE_RTL', 1);

/**
* Start the timer with the specified name. If you start and stop
* the same timer multiple times, the measured intervals will be
* accumulated.
*
* @param name
* The name of the timer.
*/
function timer_start($name) {
global $timers;

list($usec, $sec) = explode(' ', microtime());
$timers[$name]['start'] = (float)$usec + (float)$sec;
$timers[$name]['count'] = isset($timers[$name]['count']) ? ++$timers[$name]['count'] : 1;
}

/**
* Read the current timer value without stopping the timer.
*
* @param name
* The name of the timer.
* @return
* The current timer value in ms.
*/
function timer_read($name) {
global $timers;

if (isset($timers[$name]['start'])) {
list($usec, $sec) = explode(' ', microtime());
$stop = (float)$usec + (float)$sec;
$diff = round(($stop - $timers[$name]['start']) * 1000, 2);

if (isset($timers[$name]['time'])) {
$diff += $timers[$name]['time'];
}
return $diff;
}
}

/**
* Stop the timer with the specified name.
*
* @param name
* The name of the timer.
* @return
* A timer array. The array contains the number of times the
* timer has been started and stopped (count) and the accumulated
* timer value in ms (time).
*/
function timer_stop($name) {
global $timers;

$timers[$name]['time'] = timer_read($name);
unset($timers[$name]['start']);

return $timers[$name];
}

*snip*

/**
* Choose a language for the current page, based on site and user preferences.
*/
function drupal_init_language() {
global $language, $user;

// Ensure the language is correctly returned, even without multilanguage support.
// Useful for eg. XML/HTML 'lang' attributes.
if (variable_get('language_count', 1) == 1) {
$language = language_default();
}
else {
include_once './includes/language.inc';
$language = language_initialize();
}
}

/**
* Get a list of languages set up indexed by the specified key
*
* @param $field The field to index the list with.
* @param $reset Boolean to request a reset of the list.
*/
function language_list($field = 'language', $reset = FALSE) {
static $languages = NULL;

// Reset language list
if ($reset) {
$languages = NULL;
}

// Init language list
if (!isset($languages)) {
if (variable_get('language_count', 1) > 1 || module_exists('locale')) {
$result = db_query('SELECT * FROM {languages} ORDER BY weight ASC, name ASC');
while ($row = db_fetch_object($result)) {
$languages['language'][$row->language] = $row;
}
}
else {
// No locale module, so use the default language only.
$default = language_default();
$languages['language'][$default->language] = $default;
}
}

// Return the array indexed by the right field
if (!isset($languages[$field])) {
$languages[$field] = array();
foreach ($languages['language'] as $lang) {
// Some values should be collected into an array
if (in_array($field, array('enabled', 'weight'))) {
$languages[$field][$lang->$field][$lang->language] = $lang;
}
else {
$languages[$field][$lang->$field] = $lang;
}
}
}
return $languages[$field];
}

/**
* Default language used on the site
*
* @param $property
* Optional property of the language object to return
*/
function language_default($property = NULL) {
$language = variable_get('language_default', (object) array('language' => 'en', 'name' => 'English', 'native' => 'English', 'direction' => 0, 'enabled' => 1, 'plurals' => 0, 'formula' => '', 'domain' => '', 'prefix' => '', 'weight' => 0, 'javascript' => ''));
return $property ? $language->$property : $language;
}

/**
* If Drupal is behind a reverse proxy, we use the X-Forwarded-For header
* instead of $_SERVER['REMOTE_ADDR'], which would be the IP address
* of the proxy server, and not the client's.
*
* @return
* IP address of client machine, adjusted for reverse proxy.
*/
function ip_address() {
static $ip_address = NULL;

if (!isset($ip_address)) {
$ip_address = $_SERVER['REMOTE_ADDR'];
if (variable_get('reverse_proxy', 0) && array_key_exists('HTTP_X_FORWARDED_FOR', $_SERVER)) {
// If an array of known reverse proxy IPs is provided, then trust
// the XFF header if request really comes from one of them.
$reverse_proxy_addresses = variable_get('reverse_proxy_addresses', array());
if (!empty($reverse_proxy_addresses) && in_array($ip_address, $reverse_proxy_addresses, TRUE)) {
// If there are several arguments, we need to check the most
// recently added one, i.e. the last one.
$ip_address = array_pop(explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']));
}
}
}

return $ip_address;
}

Parse error: syntax error, unexpected '}' in /www/zxq.net/4/5/t/45tt/htdocs/drupal/includes/bootstrap.inc on line 393
Can someone please fix it?

Note: Please use the [codebox ] tags for future bits of code that are THIS large. I have added them for you. ~Andrew
shavinder
I would like to add how I resolved an error which cropped up when tried to install drupal. After choosing the language presented by drupal page there was an error at the second step, ie, the requirements step. The error was

QUOTE
The directory sites/default/files does not exist. An automated attempt to create this directory failed, possibly due to a permissions problem. To proceed with the installation, either create the directory and modify its permissions manually, or ensure that the installer has the permissions to create it automatically.


For this I had to grant 'execute' permission for sites/default folder to the 'group'. After this installation went forward without error.
Of course after the install, drupal itself gave an error that 'cron has not been run' which i ran manually by visiting the link shown in the error.
mengbo
DrupalDrupal already installed
The following error must be resolved before you can continue the installation process:
Failed to select your database on your MySQL database server, which means the connection username and password are valid, but there is a problem accessing your data. MySQL reports the following message: Access denied for user '87446_mengbo'@'192.168.1.1' to database 'mengbo_zymichost_mengbo *'.
Are you sure you have the correct database name?
Are you sure the database exists?
Are you sure the username has permission to access the database?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
To start over, you must empty your existing database.
To install to a different database, edit the appropriate settings.php file in the sites folder.
To upgrade an existing installation, proceed to the update script.
View your existing site.
Please check the error messages and try again.
Andrew
QUOTE(mengbo @ Jan 12 2010, 12:27 AM) *
DrupalDrupal already installed
The following error must be resolved before you can continue the installation process:
Failed to select your database on your MySQL database server, which means the connection username and password are valid, but there is a problem accessing your data. MySQL reports the following message: Access denied for user '87446_mengbo'@'192.168.1.1' to database 'mengbo_zymichost_mengbo *'.
Are you sure you have the correct database name?
Are you sure the database exists?
Are you sure the username has permission to access the database?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
To start over, you must empty your existing database.
To install to a different database, edit the appropriate settings.php file in the sites folder.
To upgrade an existing installation, proceed to the update script.
View your existing site.
Please check the error messages and try again.

MySQL hostname is localhost, not 192.168.1.1
mengbo
DrupalSite off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.


--------------------------------------------------------------------------------

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user '87446_mengbo'@'192.168.1.1' to database 'mengbo_zymichost_mengbo *'.
mengbo
follow the drupal install way
i can't open my drupal web?



DrupalSite off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.


--------------------------------------------------------------------------------

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user '87446_mengbo'@'192.168.1.1' to database 'mengbo_zymichost_mengbo *'.


yes ,my settings.php host is localhost ,but drupal web display 192.168.1.1 i don't know why?the following is my code


$db_url = 'mysql://87446_mengbo:**@localhost/mengbo_zymichost_mengbo *';
$db_prefix = '';
lizon
I made a small update to the bottom of the post, mostly addressing the Files folder error and updating the fact that clean url's work with zymic now. I'm considering redoing the whole tutorial a bit but now now. Got other things to do atm. I also want to test Drupal 7.0 to see if it works with Zymic as well.

QUOTE(mengbo @ Jan 12 2010, 03:27 AM) *
$db_url = 'mysql://87446_mengbo:**@localhost/mengbo_zymichost_mengbo *';
$db_prefix = '';


Last I checked the database username is mengbo_87446 not 87446_mengbo It's the username_database-name not database-name_username
Ed
QUOTE(lizon @ Jan 15 2010, 07:02 AM) *
I made a small update to the bottom of the post, mostly addressing the Files folder error and updating the fact that clean url's work with zymic now. I'm considering redoing the whole tutorial a bit but now now. Got other things to do atm. I also want to test Drupal 7.0 to see if it works with Zymic as well.
Last I checked the database username is mengbo_87446 not 87446_mengbo It's the username_database-name not database-name_username


The new hosting server has swapped things up a bit to circumvent the 16 character issue, therefore 87446_mengbo is correct.
lizon
QUOTE(Ed @ Jan 15 2010, 01:37 AM) *
The new hosting server has swapped things up a bit to circumvent the 16 character issue, therefore 87446_mengbo is correct.


I stand corrected then, I'll prob make a test account to do a fresh install under the new host then to make sure everything is up to date.
Charm
Thanks
lizon
yep, a lot of changes it seems from before, took a bunch of new screen shots, should be updated in a bit.
lizon
updated the initial post with new screenshots covering some of the new steps with the zymic setup and database changes. I also put the coded sections into code format so they will always be there even if the pictures disappear.
Ed
QUOTE(lizon @ Jan 16 2010, 01:31 AM) *
updated the initial post with new screenshots covering some of the new steps with the zymic setup and database changes. I also put the coded sections into code format so they will always be there even if the pictures disappear.


Thank you for taking the time to write this, looks great and will be a godsend for those wanting to install Drupal.

One suggestion would be to use @ as opposed to commenting, this then means if the modifications are uploaded elsewhere it doesn't break the functionality, it merely suppresses the warnings.
lizon
QUOTE(Ed @ Jan 16 2010, 04:20 AM) *
Thank you for taking the time to write this, looks great and will be a godsend for those wanting to install Drupal.

One suggestion would be to use @ as opposed to commenting, this then means if the modifications are uploaded elsewhere it doesn't break the functionality, it merely suppresses the warnings.


I don't think it makes much of a difference personally. The sections I pointed out are the only areas where those modifications are needed. Everything else in drupal refers to that. So far I've yet to see it come up as an error. Right now I'm sprucing up the test page, going to see about using it as a repository of Drupal for Zymic information.

Drupal for Zymic

I'm going to see about adding new articles to it at least on a weekly basis. Mostly addressing common issues and mods that may need a bit help to work with Zymic (eyes SMF/Drupal integration keenly o.O)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.