From: Franck VILLAUME <franck.villaume@capgemini.com>
Date: Sun, 1 Aug 2010 12:52:55 +0000 (+0000)
Subject: fix cronjob for reindex data word
X-Git-Tag: v5.1~1837
X-Git-Url: https://scm.fusionforge.org/anonscm/gitweb?p=fusionforge%2Ffusionforge.git;a=commitdiff_plain;h=424a1351b9431182a4198f92daafd7fc29c59f9c

fix cronjob for reindex data word
---

diff --git a/src/cronjobs/update_docdata_dataword.php b/src/cronjobs/update_docdata_dataword.php
index 4b98d66c22..d9dfc32091 100644
--- a/src/cronjobs/update_docdata_dataword.php
+++ b/src/cronjobs/update_docdata_dataword.php
@@ -24,23 +24,23 @@
  * USA
  */
 
-require dirname(__FILE__).'/../www/env.inc.php';
+require (dirname(__FILE__).'/../www/env.inc.php');
 
-require_once $gfcommon.'include/pre.php';
-require_once $gfwww.'docman/include/doc_utils.php';
-require_once $gfcommon.'docman/Parsedata.class.php';
-require_once $gfcommon.'docman/Document.class.php';
-require_once $gfcommon.'docman/DocumentFactory.class.php';
-require_once $gfcommon.'docman/DocumentGroupFactory.class.php';
+require_once ('include/pre.php');
+require_once ('docman/include/doc_utils.php');
+require_once ('docman/Parsedata.class.php');
+require_once ('docman/Document.class.php');
+require_once ('docman/DocumentFactory.class.php');
+require_once ('docman/DocumentGroupFactory.class.php');
 
-$engine_path = $gfcommon.'docman/engine/';
+$engine_path = dirname(__FILE__).'/../common/docman/engine/';
 $p = new Parsedata ($engine_path);
 
 $timestarttrait = microtime_float();
 // documents list
 $resarr = array();
-$result = db_query_params ('SELECT docid, group_id, filename, title, createdate, filename, description, filetype, data FROM doc_data',
-			   array());
+$result = db_query_params ('SELECT doc_data.docid, doc_data.group_id, doc_data.filename, doc_data.title, doc_data.createdate, doc_data.filename, doc_data.description, doc_data.filetype,doc_data.data from doc_data,groups where doc_data.group_id = groups.group_id and groups.force_docman_reindex = $1',
+			   array('1'));
 if ($result)
 {
 	while ($arr = db_fetch_array($result))
@@ -68,6 +68,7 @@ foreach ($resarr as $item)
 }
 $timeendtrait = microtime_float();
 $timetot = $timeendtrait - $timestarttrait;
+db_query_params('UPDATE groups set force_docman_reindex = $1', array('0'));
 print_debug ("End analyze : $compt files, $timetot secs.");
 
 
diff --git a/src/packaging/cron.d/cron.fusionforge b/src/packaging/cron.d/cron.fusionforge
index abad2a99c8..88eb919295 100644
--- a/src/packaging/cron.d/cron.fusionforge
+++ b/src/packaging/cron.d/cron.fusionforge
@@ -44,6 +44,9 @@ MAILTO=""
 # Daily sweep of the stats into final tables
 45 0 * * * $FFUSER $PHP $FFCRON/db_stats_agg.php
 
+# Daily reindex search engine doc_data , if any
+0 4 * * * root $PHP $FFCRON/update_docdata_dataword.php
+
 # Hourly send pending massmailings, if any
 48 * * * * root $PHP $FFCRON/massmail.php