Modification de notice en masse

  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:f19023c3623bcf2de1745b211de7397d' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\n<div>\n</div>\n', created = 1507749150, expire = 1507835550, headers = '', serialized = 0 WHERE cid = '4:f19023c3623bcf2de1745b211de7397d' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:f19023c3623bcf2de1745b211de7397d' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\n<div>\n</div>\n', created = 1507749150, expire = 1507835550, headers = '', serialized = 0 WHERE cid = '4:f19023c3623bcf2de1745b211de7397d' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:b34fc07846228b5cba27192e58508f19' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
  • user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,</p>\n<p>Sur plusieurs centaines de notices de thèse nous devons modifier les intitulés d\'écoles doctorales.</p>\n<p>Est raisonnable,correct et suffisant de faire une modif en masse du type :</p>\n<p>- UPDATE ORI_WORKFLOW_INSTANCE SET xmlContent=REPLACE(xmlContent,\'chaine 1\',\'chaine 2\') WHERE xmlContent LIKE \'%chaine 1%\'<br />\n- puis de lancer une ré-indexation complète</p>\n<p>Merci d\'avance pour toute info.</p>\n<p>Alain Le Drezen<br />\nResponsable Système d\'Information Documentaire et Informatique</p>\n<p>Service commun de la documentation<br />\nBibliothèques universitaires<br />\nUniversité Paul Verlaine - Metz<br />\nIle du Saulcy<br />\n57045 Metz Cedex 01<br />\nTél : 06 07 03 12 96</p>\n</div>\n', created = 1507749151, expire = 1507835551, headers = '', serialized = 0 WHERE cid = '4:b34fc07846228b5cba27192e58508f19' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
1 message / 0 nouveaux
Vous devez vous connecter pour poster des commentaires
Dernière contribution
8 septembre 2011 - 12:07pm
#1
ledrezen
Modification de notice en masse
Bonjour,

Sur plusieurs centaines de notices de thèse nous devons modifier les intitulés d'écoles doctorales.

Est raisonnable,correct et suffisant de faire une modif en masse du type :

- UPDATE ORI_WORKFLOW_INSTANCE SET xmlContent=REPLACE(xmlContent,'chaine 1','chaine 2') WHERE xmlContent LIKE '%chaine 1%'
- puis de lancer une ré-indexation complète

Merci d'avance pour toute info.

Alain Le Drezen
Responsable Système d'Information Documentaire et Informatique

Service commun de la documentation
Bibliothèques universitaires
Université Paul Verlaine - Metz
Ile du Saulcy
57045 Metz Cedex 01
Tél : 06 07 03 12 96

Haut
Étiquettes: