March 2009 - support - lists.drupal.org

Trying to Understand How Data in the DB is Exposed to Search
by Shai Gluskin 11 Mar '09

11 Mar '09

Gang, Trying to understand how search works, both Google and Solr. So lets say I have a node/1234. There are no links to it on example.com. However, links to it will dynamically show up in a view if the right choices are made by a user via exposed filters. My guess is this won't be exposed to Google but would be exposed to Solr. Anybody know? Thanks, Shai

3 2

Strange Database Error
by Daniel Carrera 11 Mar '09

11 Mar '09

Hello, Whenever I visit a page on my Drupal 5 website I get the following warning: user warning: Duplicate entry '2196624' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('What are the Ingots?', 'node/1', '', '78.50.210.53', 0, 'ffdknj3d71h0p3ss7d5lb8ng66', 472, 1236783811 So I go to the 'accesslog' table. I can see that key 1 refers to the 'aid' field. I don't see anything unusual in this field. The value 2196624 is not at all present, so how can it be "duplicate"? I don't know what to try. Any ideas? Daniel.

1 1

warnings on /forum after replacing adv forum w/ og forum
by Christopher M. Jones 11 Mar '09

11 Mar '09

I took advanced forum out, uninstalled it, and replaced it with og forum. Unauthenticated users are getting this error when they visit /forum or forums/* Any ideas? * user warning: Unknown column 't.tid' in 'IN/ALL/ANY subquery' query: SELECT ts.tid, ts.name FROM term_synonym ts JOIN term_data td USING(tid) WHERE (t.tid NOT IN (SELECT DISTINCT ogt.tid FROM og_term ogt WHERE public < 2)) AND ( td.vid=13) in /var/www/mul/fertilityauthority.com/includes/database.mysql.inc on line 172. * user warning: Unknown column 't.tid' in 'IN/ALL/ANY subquery' query: SELECT DISTINCT(td.tid), td.name, td.description, COUNT(tn.nid) as nodes FROM term_data td LEFT JOIN term_node tn USING(tid) WHERE (t.tid NOT IN (SELECT DISTINCT ogt.tid FROM og_term ogt WHERE public < 2)) AND ( td.vid=13 ) GROUP BY td.tid, td.name, td.description ORDER BY LENGTH(td.name) DESC in /var/www/mul/fertilityauthority.com/includes/database.mysql.inc on line 172.

1 0

print menu tree
by John Callahan 11 Mar '09

11 Mar '09

Does anyone know of a way to directly print the menu tree of a custom menu? I thought there would be a simple function to accomplish this but for some reason I can't seem to get it. Searching the web reveals several other people asking the same question, or answers to do something similar (like printing $primary_links or just the first level links of a custom menu.) Any thoughts? This should be easy, right? - John ************************************************** John Callahan Geospatial Application Developer Delaware Geological Survey, University of Delaware 227 Academy St, Newark DE 19716-7501 Tel: (302) 831-3584 Email: john.callahan(a)udel.edu http://www.dgs.udel.edu **************************************************

3 4

pathauto, block menu generating wrong path
by Christopher M. Jones 09 Mar '09

09 Mar '09

I'm having a problem, I think with pathauto. I have a nav bar that I built from book pages. I'm displaying that navbar in a nice menu. Before I was using a nice menu I was using some custom code in a block to generate the menu, and I was having the same problem there, as well. So I don't think this is related to nice menus. The menu itself seems to have the correctly named paths, e.g., http://mydomain.com/article-title This is what I see when I mouse over the items in admin/build/menu, anyway. But the menu itself is displaying strange paths, such as http://mydomain.com/admin/build/path/node/1 Node 1 is the correct node, and obviously node/1 is a good path. But why isn't it using the alias, and why is it appending the path to the currently active path? You can see this behavior at http://www.fertilityauthority.com, in the horizontal nav at the top of the page. Any help would be greatly appreciated here, as this is a live site and it's only a matter of time before the client sees the problem.

3 3

Sharing 'users' table with another database?
by Thoughts Ltd 08 Mar '09

08 Mar '09

Has anyone here know how to get Drupal to share the 'users' table with another database? (Or, in other words, connect to a different database to access the 'users' table.) I have a "people" database that I share between all my different projects, so that all of my clients/users need not sign up multiple times. Signing up to anything gets them signed up to everything. Change their name/email/password once, it's changed everywhere. I've been able to do this because I was hand-coding all of my projects, but now I'd like to use Drupal, yet still access this central "users" table (I can make it exactly fit Drupal's specs/schema). Perhaps there's a different way to achieve what I'm trying to do? Any suggestions or pointers? Thanks much.

3 2

menu item issues
by Mohammad Towfiqul Islam 07 Mar '09

07 Mar '09

Hi guys, I am a newbie. Need some instruction. I have a five primary liks and each links has several childs (say 8/9). What I want, when I will click primary links suppose "Home" it will open a specific page linked to Home with its childs. It should not show other primary links child in a page linked to "Home". Like this when I will click other primary links it will open that primary links page with childs. What I mean every primary links child should be seperated when i click links. It should not show all. How can I achieve this? Any help will be appreciated. Thanks in advance.

9 16

Drupal .htaccess blocks access to domain in subfolder
by Steve Edwards 05 Mar '09

05 Mar '09

I'm trying to set up a Drupal site in a subfolder on my shared hosting account as it's own domain, and for reasons I can't understand, I get a 403 - Permission Denied error when I try to access it. I have a D5 site in my /public_html directory (www.mydomain.com) and the new site is a D6 site in /public_html/domain2 (www.domain2.org is using that folder). The name servers for domain2.org are pointed to the correct name servers, and I've added the domain as an addon domain on my account. I contacted my ISP, and they said the problem is the .htaccess in /public_html. If it is renamed (i.e. to .htaccessold), then I can access domain2.org, but I can' go to any page in my mydomain.com, since it's using clean URLs and the .htaccess contains the rewrite rules. I've done this setup multiple times before, and I've never had this problem. Can anyone explain what the problem is and how I would correct it? Thanks. Steve

3 2

HELP! with Views and relational data
by Chris McCreery 05 Mar '09

05 Mar '09

Hi I am creating a site that has the following content types: - Organization (Usernode) - Program (define a program) - Attendance Tracking (track attendance for that program) I would like to create an admin view that shows me all the details for either program or the attendance tracking with data from the usernode. For example: Program Name Organization Name Province Country Postal Code I'm just wondering what is the best way to have the Program and Attendance tracking content types reference this data. Would I need to create computed fields that query the database separately to get them into the content type? Thanks, any help would be much appreciated. -- Chris McCreery

5 19

FCKeditor and ICME
by Daniel Carrera 04 Mar '09

04 Mar '09

Hello, The project pages for FCKeditor and ICME both seem to indicate that it is possible to integrate FCKeditor with ICME: http://drupal.org/project/fckeditor http://drupal.org/project/imce However, after much searching, I really can't figure out any way to integrate them at all. When I was running TinyMCE, when the user clicked on the Image button they would get a list of images they had uploaded with ICME. It was very convenient. I would like to have something similar with FCK. Does anyone know if it is possible to get FCK to read the images from ICME? Do you know how to do this? Daniel.

2 6