support

support@drupal.org

7912 discussions

search
by Selvaraj Chnnasamy 28 Aug '12

28 Aug '12

Hi All Combining Search Files module with Search module. We have installed the regular Search module on our website without realizing that it didn't search documents. Then, we installed Search Files. I can see that it added a new search page to use for documents, but is there any way to combine this functionality with the regular Search module? It just seems increadably non-user-friendly to make our users have to search twice for every bit of information they want. (Not only searching twice, but doing so from different pages.) Idealy, there should be one search engine that searches the entire site, including all the files. Thanks&Regards Selvaraj.C

1 0

Full-text data search in InnoDB tables
by Kamal Palei 28 Aug '12

28 Aug '12

Hi All I am using Drupal 6.26, MySql (innodb). I tried to first to do full text data search in InnoDB table. A simple query statement is shown as below. *SELECT * FROM resubmt_skill_ids WHERE MATCH (name) AGAINST ('java')* But I get the below error. #1214 - The used table type doesn't support FULLTEXT indexes On further google search, came to know, only MyISAM type tables support full-text search. I am bit reluctant to change my tables from InnoDB to MyISAM. Can somebody suggest me is it not possible to do full-text search in InnoDB tables. Came across http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/ have not gone completely, but it looks author tells full-text search possible with innodb tables. If anybody has used full-text search on innodb tables, please let me know, how to do that from drupal perspective . Best Regards Kamal NECS, Bangalore

3 5

Re: [support] Mass Upload
by Daniel Germer 27 Aug '12

27 Aug '12

The migrate Module might provide some useful starting points, I am trying to do a similar thing, I'll post here if I found a solution. also Idan Arbel suggested to use node import module...

1 0

dbtng question
by a.sanchez75＠gmail.com 27 Aug '12

27 Aug '12

Hello, Sorry but I have a dummy question, is like a mistery for me. When I run this sql query $query = db_select('system', 'n'); $query->fields('n',array('type'))->condition('name', 'book'); $result = $query->execute()->fetchAssoc(); I get results, but when I get (I replace 'contexthelp' string instead of 'book' string) $query = db_select('system', 'n'); $query->fields('n',array('type'))->condition('name', 'contexthelp'); $result = $query->execute()->fetchAssoc(); I get empty results when I should get one row at least. Just in case I have checked out the string contexthelp and is stored in my system table. Someone has any idea why I get this behavior? Thanks in advance

1 0

Proximity search / view with contextual filter
by Christian 27 Aug '12

27 Aug '12

Hello, I am looking for a way to implement a view with contextual filters in the following way: /[term]/[city] The resulting site should display all nodes with the taxonomy term in the proximity of the city. This seems like a very common task to me but I have not been able to find an answer to this for weeks... Does anyone use this kind of view? Which modules (and versions) are you using? Might this be possible with Apache Solr? I tried so far: -locations: can only search in the proximity of zip codes, but I need cities -openlayers_proximity: the contextual search seams to be broken Please, any help is greatly appreciated! Christian

2 1

MySQL table data safety/protection
by Kamal Palei 27 Aug '12

27 Aug '12

Hi All I am using Drupal 6.26, MySQL (InnoDB). There are few mysql tables, that may be accessed by multiple users at sametime. Do I need to do anything extra to make sure mysql table data would not be corrupted. I read somewhere, I need to install transaction module to safeguard data. Can somebody advise me is it really required? Best Regards Kamal NECS, Bangalore

2 2

Searching keywords in tables also in file content
by Kamal Palei 27 Aug '12

27 Aug '12

Hi All I am using Drupal 6.26. Basically I am trying to develop a site where users can come and register their resumes . Recruiters can serach profiles with certain keywords and select the right profiles. While users register profile, they might have entered skill set in a text field, that is stored in tables. Also users upload their resumes. Now I am looking at how can do efficient searh both from tables , as well as from resume file content. Search from skill set stored in tables -------------------------------------------------------------- Probably here, I can have integer IDs corresponding to skill sets, and skill sets can be stored in integer format (1 skill for 1 user in 1 row in a table), I can probably develop some PHP code to do database query to get the required profiles. Search in resume file content --------------------------------------------------------------- The resume may be a .doc or .txt or .docx or .pdf file. How can I search the file contents, is there any module available to do that. Or I need to use PHP code to dig into files , read the content and search. I read about apachesolr module, just want to take experts opinion before I proceed to use apachesolr for file search content. Also I read about sphinx. Kindly guide me for both the case, searching skills sets from tables , and searching skill sets from file contents, what are best methods available today. Best Regards Kamal NECS, Bangalore

1 0

Database query cache issue
by Kamal Palei 27 Aug '12

27 Aug '12

Hi All I am using Drupal 6.26. I am trying to upload a file. One user can upload only one file. After a while, if user wants to upload another file, I need to delete the first file and upload the second file. To delete the first file, I do a query to get the first file name, deletes first file and uploads the second file. After a while, if user wants to upload another file, when I do query to get the second file name (as I want to delete the second file now), I always get the first file name. So I am not able to delete the second file. Probably database cache plays a role here, how can I make sure, my query returns the latest data present in table, query should not pick the data from cache. Please refer code below. global $user; $FID = -1; $result = db_query("SELECT fid, filepath FROM {resubmt_table} LEFT JOIN {files} USING (fid) WHERE resubmt_table.uid = %d", $user->uid); $obj = db_fetch_object($result); if($obj) { $FID = $obj->fid; if($obj->filepath) { if(file_exists($obj->filepath)) { drupal_set_message("File exists deleting " . $obj->filepath); unlink($obj->filepath); } else { drupal_set_message("File does not exists, so not able to delete, file = " . $obj->filepath); } } } Many times, I am not able to delete the file. Please suggest how can I fix this issue. Thanks Kamal NECS, Bangalore

3 3

Betterselect module warning
by Kamal Palei 26 Aug '12

26 Aug '12

Hi All I am using betterselect module. I have a custom form, part of code looks as below. $locations_arr = array( '0' => t('-Select-'), '1' => t('Anywhere in India'), '2' => t('Anywhere in North India'), '3' => t('Anywhere in South India'),); $form['name']['prefloc'] = array( '#type' => 'select', '#multiple' => TRUE, '#title' => t('Preferred Work Location'), '#options' => locations_arr, ); When I access the form page, I get warning "warning: Invalid argument supplied for foreach() in C:\http\wamp\www\netcloudjobs\sites\all\modules\betterselect\betterselect.module on line 104.". Please let me know, where I am wrong and how to fix this issue. Thanks Kamal NECS, Bangalore

2 2

Rotating Header Images
by Matthias Fechner 26 Aug '12

26 Aug '12

Dear list, I want to add a header block that consists of 4 pictures. The first picture should be fixed and all other picture should rotate. The pictures should all displayed in one row. The drupal version is 7. Are there some modules which make this possible? (I already played around with views, but it does not have a random functionality, I added the pictures as a custom content type). Thanks Matthias -- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning." -- Rich Cook

2 2

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support