Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By moramata on
When I run install.php it gives a few dozen warning like
Warning: Table blah blah doesn't exist query: SELECT ...
I know table does not exist.
That is the reason I am running install.php so that it will create the tables.
This is a headache for me.
Can some guru please tell what is going on and how can i fix it?
I am just fed up with these warning signs.
Comments
We'd love to help...
...but a few more details of what you've done up to the point where you got the errors would be enormously helpful.
What platform are you installing drupal on? Home computer, remote host etc.
Operating system (Windows, Mac, Linux...)
Also the versions of drupal, apache, php, mysql...
I know that getting a torrent of error messages during an install is very annoying, but it's telling you that you have a configuration problem somewhere that needs fixing.
It would be nice if it just told you exactly what the underlying problem was, but life's not like that :-)
Pete
Ok: This is what I did.1.
Ok: This is what I did.
1. Downloaded tar file
2. Unzipped every thing.
3. Moved it to my WIndows server
4. Created the database and assigned user permission
5. Made changes to the setting file ($db_url, $base_url)
6. Opened my browser and run mydomain/install.php
What happens when...
...you point your browser at mydomain/index.php?
I can try to replicate what you're doing on a test site here if that helps.
Pete.
Pete: Thank you very much
Pete:
Thank you very much for responding.
I am not sure if I can publish my client's url without their permission.
The issues is
I have pointed my browser to mydomain and mydomain/install.php
It gives two dozens or more warning that various tables do not exist.
I know tables don't exist. The installation is supposed to create the tables.
Why it does not create the tables instead of giving warnings that tables don't exist. If the tables don't exist, it shoud create it. Should not the instllation be that simple? Am I missing something?
Which version?
Hi again.
Which version of drupal have you downloaded?
I've just downloaded and installed 5.2.
mysite/install.php prompted me for the name of the database and a username and password; I created the database (via phpmyadmin) and filled in those fields, pressed the button, and after a second or two I had a page saying 'Drupal installation complete'.
Have you checked that the required privileges
(GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';
)
are available to the database user?
Pete.
Get a fresh settings.php
5. Don't make any changes to settings.php because then Drupal considers that it is already installed.
That could well be it...
Though in 4.7.x you had to do it manually. Knowing which version would help :-)
Good idea for a patch
This sounds like a good idea for a patch which would save people some time and many forum posts.
For example a test which would try to connect to $db_url and if successful would look for a $db_prefix . 'system' table (perhaps containing some standard drupal columns), and if it was not found would go ahead with the installation. Or, to be safe, at least a test whether the database has no tables.
I agree
Just checking if settings.php has been modified seems awfully crude; is that really how it works in 5.2?
I am using 5.2 I replaced
I am using 5.2
I replaced settings,php with the one that comes with the distribution.
Now I don't get all those warnings.
However, my browser now just sits with a connecting message forever. It may be a loop. But then I don't know why php is not timing out.
I cannot understand why a simple installation is so frustrating.
I don't understand why can't we have a software that at least installs without a problem. (Oh, sorry it is a free software. I cannot expect too much. I am now convinced that a free software is not really free because somebody has to spend enermous amount of time messing with it).
I don't know how it checks if the install script has been run previously or not.
Why does not it just create the tables if they are missing. Is it asking too much?
(no title)
It does install without a problem for many of us, but shit happens.
At which point did it freeze? Did the installation script ask you to enter the settings?
I am really sorry for
I am really sorry for showing my frustration in my post. In the evening after I return from work, I delete everything and start fresh. Hope I will be lucky this time. Thanks all for your inputs. I apologize for my ranting.
No problem!
We all know how frustrating this can be... you might like to try setting up your Apache/PHP/MySQL environment using something like XAMPP; it worked fine for me...
Pete.
oops
Edited: duplicate post.
Database issues
Hi again.
Sorry to hear that you're still having problems with your installation.
Which database are you using? MySQL? Have you checked that the database account has all the required privileges?
Pete.