El Giro Afectivo.

Publication Type  Journal Article
Year of Publication  2013
Authors  Enciso, G.; Lara, A.
Journal Title  Athenea Digital - Revista de Pensamiento e Investigación Social
Volume  13
Pages  101-119
ISSN Number  1578-8946
Key Words  Giro Afectivo; Ciencias Sociales; Afecto; Emoción; Metodología; Sentimientos
Abstract  En la última década los estudios del afecto y las emociones han cobrado relevancia en las ciencias sociales. Esto no es simplemente una directriz de moda, es un indicador simultáneo de las modificaciones en la vida pública y de la experiencia subjetiva; a partir del cual se está transformando la producción de conocimiento. Tal tendencia ha sido conocida en la academia sajona como ‘The Affective Turn’, aquí traducido como ‘El giro afectivo’ y que hasta el momento no ha incursionado como tal en la literatura de las ciencias sociales escrita en castellano. Este artículo dibuja un panorama singular de las discusiones en torno a los estudios sociales contemporáneos del afecto y la emoción, vertebrado a partir de algunas de sus expresiones en la academia contemporánea.
Full Text  


The propouse of this code is assist the process of duplicating a site (that you setup and filled with common/essential content) into different "subsites".

This script will "clone" your BASE site (where your SHARED tables will remain stored) creating new tables with the same content than in BASE site but with your new tables prefixes. It aslo creates the needed symbolic links for the new sites and default settings.php will be placed in /sites/sitenameurl directory so in most of the cases (only in gnu/linux platforms), the new subsites will be ready to login.

I hope it will be useful for those that create a "drupal site model" that like to replicate into new site instances and only want a single database.

WARNING: A few tables of drupal will NOT be exactly cloned. Here you can find an explanation and a reference to the point of the code where the operation is performed:
  • [1] sequence: Durpal needs the right subprefix in this table to work, so "BASE_sequence" table's structure will be cloned, but content will be parsed with the right subsite's prefix (instead of BASE one). This replacement of prefixes is mandatory if you expect your new subsites will be able to add new data to some important tables.
  • [2] sessions: A session table with inconsistent data will be a nightmare in your future subsite's logins. If is requested to clone _session table's structure will be duplicated, but not it's content.
  • [3] cache tables: Any table with "cache" word in it's name will be cloned at structure level, but not it's content. Are you sure you need to be risky with cache issues?
  • [4] watchdog: I can't imagine why do you want to duplicate your development log in your destination sites.

License: GPL2 (so feel free to modify if this don't fit with your needs)
Road map: If I found time or somebody likes to follow this work, this script will become a module that I suggest could be called "Site cloner".
Author: Marc Bria (marc.bria[nospam]uab.es (May 2007)
Disclaimer: Don't call or mail or chase me if this pice of code kills your cat or remove any important data in your Drupal. I just share this to help, but last responsible is only yours. BTW, yes.. I'm a really bad programmer far from being a Drupal expert so improve this code and share with us if you can do it better.

Array ( [0] => drupal-5.12 [1] => includes ) includes
ALL-IN-ONE SQL CREATION QUERY: Table creation for every prefix

The following script will generate a SQL query to clone ALL your tables from [Array] to your prefixes:
COPY AND PASTE THIS CODE to your phpadmin or your favorite mysql administrator
ALL-IN-ONE SQL REMOVE QUERY: Table drop for every prefix

Oooops! Got an error? Execute this query to drop EVERY prefixed table (except [Array]):
COPY AND PASTE THIS CODE to your phpadmin or your favorite mysql administrator
Export  Tagged XML BibTex