Hi, I'm new in this community and I just installed the 7.9 version of Drupal, because I need to modify a site that a friend of mine sent me (problems fixing video playing). The problem is, he sent me the folder "sites", I installed wampserver to work on it offline, but when i try to open the projecton http://localhost it tells me

Drupal already installed

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.

Is it because I don't have the database he used for his project?
An important thing to say in this case I think is that if I try to click on update script, I get the message

Error

Error message
PDOException: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) in drupal_get_installed_schema_version() (line 150 of C:\wamp\www\mir\includes\install.inc).
The website encountered an unexpected error. Please try again later.

Does someone know a way to figure this out? Thanks in advance

Comments

aireworth’s picture

Well you're going to need the database. Get your friend to send you that, and import it into Mysql, using the database name, database user name and password found in the settings.php file - which is most probably in /sites/default/
You're then going to need the rest of a Drupal7 base install - download and install this on your WAMP server, then replace the /sites directory with the one you've been sent. The sites directory contains most of the individual customisation of the website that isn't stored in the database - but most is stored in the database .Then try again. Good luck. For someone with no experience this might be quite a challenge.

Colin

stokks’s picture

do you mean that i should open the settings.php file? with which software? and once I have the database, where shall I put it?, or what should i do next?

I forgot to say that I even have a .backup file, and another one called "projectname"-drupalDB (without extension). Is this important?

stokks’s picture

i think i have the database dump and the backup file, but now, after creating a new database, and deleting the settings.php files, i try to open again the project in localhost and i get this message
i tried to do what you suggested. but after trying to open the project in localhost i get this message

i tried to do what you suggested. but after trying to open the project in localhost i get this message

( ! ) Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\mir\includes\file.inc on line 2031
Call Stack
# Time Memory Function Location
1 0.0151 369336 {main}( ) ..\install.php:0
2 0.0513 831120 install_drupal( ) ..\install.php:26
3 2.4989 8289200 install_run_tasks( ) ..\install.core.inc:79
4 2.5007 8296584 install_run_task( ) ..\install.core.inc:342
5 2.5007 8296584 install_select_profile( ) ..\install.core.inc:473
6 2.8265 9122816 drupal_get_form( ) ..\install.core.inc:1014
7 2.8265 9123616 drupal_build_form( ) ..\form.inc:123
8 2.8266 9125192 drupal_retrieve_form( ) ..\form.inc:329
9 2.8268 9125872 call_user_func_array ( ) ..\form.inc:785
10 2.8268 9126160 install_select_profile_form( ) ..\form.inc:785
11 26.8734 9402136 install_profile_info( ) ..\install.core.inc:1067
12 26.8880 9405216 drupal_required_modules( ) ..\install.inc:1209
13 26.8880 9405440 drupal_system_listing( ) ..\module.inc:839
14 28.3282 9466600 file_scan_directory( ) ..\common.inc:5173
15 29.6742 9478952 file_scan_directory( ) ..\file.inc:2033
16 29.6764 9479912 file_scan_directory( ) ..\file.inc:2033
17 30.1404 9484584 file_scan_directory( ) ..\file.inc:2033
18 30.2393 9485584 file_scan_directory( ) ..\file.inc:2033

What should i do? anything wrong with what i've done?

pan0s’s picture

1- Have you deleted the settings.php file without replacing it ?
Listen ...
2-you must go to my php admin and import the .sql file, under operations.
3-you must also create a user for that database which should be the same with the one your friend is using - and of course the same password.

If (1) applies, then you must place a new settings.php file in the dir. You can edit the file either with html editors or wordpad.

stokks’s picture

i replaced the settings.php file of the folder they gave me with the default.settings.php of drupal original folder, then created the database, then changed the name of the file to settings.php... but now the problem is that i get this message

( ! ) Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\mir\includes\file.inc on line 2031
Call Stack
# Time Memory Function Location
1 0.0151 369336 {main}( ) ..\install.php:0
2 0.0513 831120 install_drupal( ) ..\install.php:26
3 2.4989 8289200 install_run_tasks( ) ..\install.core.inc:79
4 2.5007 8296584 install_run_task( ) ..\install.core.inc:342
5 2.5007 8296584 install_select_profile( ) ..\install.core.inc:473
6 2.8265 9122816 drupal_get_form( ) ..\install.core.inc:1014
7 2.8265 9123616 drupal_build_form( ) ..\form.inc:123
8 2.8266 9125192 drupal_retrieve_form( ) ..\form.inc:329
9 2.8268 9125872 call_user_func_array ( ) ..\form.inc:785
10 2.8268 9126160 install_select_profile_form( ) ..\form.inc:785
11 26.8734 9402136 install_profile_info( ) ..\install.core.inc:1067
12 26.8880 9405216 drupal_required_modules( ) ..\install.inc:1209
13 26.8880 9405440 drupal_system_listing( ) ..\module.inc:839
14 28.3282 9466600 file_scan_directory( ) ..\common.inc:5173
15 29.6742 9478952 file_scan_directory( ) ..\file.inc:2033
16 29.6764 9479912 file_scan_directory( ) ..\file.inc:2033
17 30.1404 9484584 file_scan_directory( ) ..\file.inc:2033
18 30.2393 9485584 file_scan_directory( ) ..\file.inc:2033

do you know what i'm supposed to do? or do you believe that it's better for me to not work on localhost (in that case, what should i do to enter the drupal installation?)

pan0s’s picture

You must have both files in your folder:
- settings.php
-default.settings.php

Do u?

stokks’s picture

no, i don't have them now... but look, there is something new, my friend told me:

i haven't used any drupal module to backup, to install it in your pc just create a new database, with the name you need and inside that restore backup files, then you just have to create a new drupal installation and indicate your database with username and password, then copy the "sites" folder in it.

what i don't understand now is how i can create a database (with phpmyadmin or with mysql shell), since i created one with myphpadmin but then it doesn't let me import the database because the dumpfile is too big. So i tried with mysql shell, but i don't know how to do that , because if i write mysql -u username -p
then he asks me a password that i don't know.

What do you think? and thanks in advance.