By drupyeah007 on

Hello,

So I had a drupal 7.31 install running fine then during an OS upgrade and restructuring I destroyed the web folder drupal was installed in and did not have a backup..

Long story short, now I am left with a MySQL database (complete and functional), and the content of what was stored in the "private filesystem path"..

I reinstalled Drupal (7.34) but the install insists that the DB be empty. So I emptied the DB, started the install again and it worked. Then I reimported the SQL dump into the drupal DB but when I login I get a messed-up welcome page (probably because the theme is missing) and after login I only get 404 errors such as 

Not Found

The requested URL /drupal/node was not found on this server.

On top of that, the path of the "private filesystem" has changed between OS'es rendering the entire situation hellish..

How would you guys bring this back up and running? I tried changing paths in the SQL database, seems drupal stores variables as BLOBS........ Not good.

Anyways anybody who has an idea please share!
Thanks

⋅ Categories: Drupal 7.x

Comments

yelvington’s picture

yelvington commented

Start by making sure your webserver is properly configured, is reading the .htaccess file, and is obeying everything in it, especially the rewrite instructions. This indicates yours is not:

Not Found
The requested URL /drupal/node was not found on this server.

It's a very bad idea to be poking around in the database.

drupyeah007’s picture

drupyeah007 commented

Hello yelvington,

thanks for replying! I did start off by making sure the webserver was able to use mod_rewrite... Sure thing, it wasnt!

Now I made it to the point where I rebuilt the drupal site but things are painful at best.. Simply put, with the database intact and the contents of the "provate" filesystem, is it possible to retrieve the list of modules that were installed in my previous drupal install and reinstall these modules? If not, I will simply keep rebuilding the way I am doing..

For now, there are several issues:

When I go in Content, and try to publish my nodes, I get
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /drupal/batch?render=overlay&id=120&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_country_value' in 'field list': INSERT INTO {field_data_field_country} (entity_type, entity_id, revision_id, bundle, delta, language, field_country_value) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 124 [:db_insert_placeholder_2] => 125 [:db_insert_placeholder_3] => vinyl_records [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ) in field_sql_storage_field_storage_write() (line 494 of /var/www/html/drupal/modules/field/modules/field_sql_storage/field_sql_storage.module).

When I go to Administration > Structure > Views and select one of my views and select Edit, then try to add something by clicking on "Add" next to Fields, the screen darkens and nothing happens.... No error messages.

I tried setting up a cronjob to maintain the site up to date, either using curl -s with the address of my site (including the UUID key) yields to no error but doesnt actually update the site, or using php /var/www/html/drupal/cron.php yields to

PHP Warning:  include_once(/var/www/html/drupal/sites/all/includes/bootstrap.inc): failed to open stream: No such file or directory in /var/www/html/drupal/cron.php on line 13
PHP Warning:  include_once(): Failed opening '/var/www/html/drupal/sites/all/includes/bootstrap.inc' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/drupal/cron.php on line 13
PHP Fatal error:  Call to undefined function drupal_bootstrap() in /var/www/html/drupal/cron.php on line 14

Little by little I am making my way but its not pain less... :)