Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By Astren on
Hi, I am tryting to install drupal correctly already the second day in a row but no luck yet :) My configuration:
Ubuntu 14.04, Apache 2.4.7, php5.5.9, mysql 5.5.41
I was trying first to install drupal7.35 on localhost, but after database configuration stage, the page "refreshes" itself droping all data entrered in the form, after entering data the second time (or refreshing the page, both scenarios tried on clean installations) I am getting a white screen. Trying to return to localhost throws you on the last stage of the installtion process (configure site, skipping actual installation), where after entering the required data, I am getting white screen once again.
Drupal seem to install something, at least it defenitely connects to DB, as it for example, creates a "users" table, and fills it with "something". But, with this something (the credentials entered on installation stage), one can't login in the site, deleting the first user, and inserting manually with same credentials (smae data and md5 sum for password), allows to enter the site through browser, but still leads to white screen.
Workaround tried: I've tried to drop the DB and reinstall, with and without 'SET utf8 COLLATE utf8_general_ci'. Tried running the installation script on FF, chrome, chromium. Tried to install 7.25, 7.2. 7.1 ( almost same behavior). Gave chmod a+rwx to /sites/default and /sites/default/settings.php, tried to enable errors in install.php and index.php.
Error I got:
Fatal error: Call to undefined function field_attach_load() in /your/site/root/includes/entity.inc on line 321
For drupal 7.3x, 7.2x
And for 7.1:
Error
The website encountered an unexpected error. Please try again later.
Error message
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2112 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
Warning: preg_match(): Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 2113 in truncate_utf8() (line 340 of /var/www/html/includes/unicode.inc).
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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: SELECT * FROM {menu_router} WHERE path IN () ORDER BY fit DESC LIMIT 0, 1; Array ( ) in menu_get_item() (line 443 of /var/www/html/includes/menu.inc).Also I've tried to install drupal8 -- the installation went without any exceptions and very easy, no white screens, I even was able to 'play around' with a site there, though, I need drupal 7.
The review of the settings.php doesn't seem to me anyhow strange (for 7.1):
diff default.settings.php settings.php
181c181,195
< $databases = array();
---
> $databases = array (
> 'default' =>
> array (
> 'default' =>
> array (
> 'database' => 'drupal7',
> 'username' => 'drupal7',
> 'password' => '**here is actual password**',
> 'host' => 'localhost',
> 'port' => '',
> 'driver' => 'mysql',
> 'prefix' => '',
> ),
> ),
> );
213c227
< $drupal_hash_salt = '';
---
> $drupal_hash_salt = '**here is actual sault**';
Simillar image for other 7.x verstions.
Also, the "install profile" stage is basically skipped -- it appears for a second but no progress bar present, and then it moves to "configure site" stage (for 7.1, 7.35). On 7.2, the progress bar appears, "installs" only one component and then skippes later part of installation, or behaves as 7.1 and 7.35.
The db user has all priveleges he can have, for each installation I create fresh db, and create a fresh user.
Any ideas how I can fix it, or get "better" error output, w/o getting involved into the drupal php code and inner structure?
Comments
Tried to perform "minimal"
Tried to perform "minimal" instalation, tried to restart mysqld, to change the db user to root in the settinggs.php, chnage localhost to 127.0.0.1 in settings.php, to add ini_set('memory_limit', '128M'); in settings.php, to write explicitly the port number to the db connection both in sttings php, and under advanced settings during installation. Also mysql log (/var/log/mysql/error.log) seem to have nothing concerning the issue.
=-=
what if any errors, are in your php and apache logs?
after reading: https://www.drupal.org/node/1171756
my suggestions are to:
empty the database
clear all cookies in the browser
make sure cookies are enabled in the browser and retest.
check php and apache logs if unsuccessful
Thank you, just solved the
Thank you, just solved the problem.
You are right, the cookies should be turned on. Most of the attempes of installation I did through my main browser, and there I have cookies turned off by default for all sites.. I found somewhere that this might be the issue, so enabled them and started to clean them before installations. Also I delved a little bit into the php code and found out that the main cause should be that db configures incorrectly. Then I moved back to 7.35, as I decided anyways to read the php code :) And tried the following workaround (that worked, just as you say):
1) cleared installation with cookies enabled and cleared, proceeded to this white screen, i.e. to the db configuration page, entered all the data and got white screen.
2) without modifying the settings.php dropped the db, and created it once again, checked that the user described in settings.php exists and has all rights on the db.
3) ran explicitly the install.php through calling "localhost/intall.php", without cleaning cookies.
4) flushed first user credentials: UPDATE yourdb.users SET pass = MD5('yourpass'), name = 'yourname' WHERE uid=1;
And it woked out.
P.S. That's true what they say about the learning curve for drupal, I wanted to install it first, and ended up reading php code listings, tons of forum topics and with a "magical" solution on hands.. But also that's true that you have a wonderful communtiy. :)
Hope this thread will help someone to save their time.
Okay, I've solved the issue
Okay, I've solved the issue with "magical" workaround.
*Important: do the installation on browser that supports cookies, on mine main browser I have turned them off, and I believe this is part of the problem*
If you have the same problem, you might be interested in this topic https://www.drupal.org/node/1990326
First, I've tried to delve into the php code, and found out that the error for 7.1 is caused by the fact that the function for creating ancestors is returning empty array, which happens because it is provided wrong data, which happens due to not fully configured DB data on the installation phase. No idea what's the reason here, but I've decided, as I am anyways delving into the code, do it on most recent version, and moved on 7.35. So here the problem was saying
Call to undefined function field_attach_load() in /var/www/html/includes/entity.inc on line 316While, the funciton is defenitely present. But once again, the problem was with DB configuration. What worked for me, was:
clean installation:
1) perform steps until db connection arameters, provide them, get white screen.
2) do not change the settings.php or remove it, but drop the db you've indecated.
3) create the db (empty) with same name once again, check that specified in settings.php user still have all rights on it.
4) explicitly run install.php script (for example by calling localhost/install.php) in browser. Finish all the steps (you should be able to finish the installation now).
5) go to DB and execute
UPDATE your_database.users SET pass = MD5('your_password'), name = 'your_username' WHERE uid=1;replacing your_password, your_database, your_username with corresponding values for youself.
6) you should be now able to login in your drupal7 page.
P.S. Didn't expect that it will be so true what they say about studying curve for drupal -- two days, tons of forum posts read, lots of drupal installation attempts, drupal php code reading and understanding of the installation process..
Hope my solution will help someone save their time.