April 2011 - Development - lists.drupal.org

Translatable fields
by Karen Stevenson 21 Apr '11

21 Apr '11

I'm trying to sort out how our fields are/should be handling translation in D7. I have date fields, which should not be translatable, being marked as translatable. I have been digging through the code to figure out how I can force them to not be translatable. The Field crud has a setting called 'translatable', which defaults to FALSE, but the Field UI sets translatable to TRUE for every field created in the UI. There is no place in the core UI to set a default for translatability in the field info and I can't see any way other than blunt force altering the data to change the behavior of a field created in the UI to keep it from being translated. I am running into problems now where Views are broken because I tried to create untranslatable fields (using 'und') while new fields use the site default language instead of 'und', and the language column is getting joined into the view because the field is 'translatable'. I see from a few blog posts, like http://randyfay.com/node/88, that we are recommending that people install the Entity Translation module to allow them to identify fields to translate, but it appears that anyone who does not have that module enabled (i.e. a core install) will end up with all fields marked as translatable and the language value for the field populated with the site language. I guess I have to just leave date fields alone and go with the flow, assume they are all translatable even if I don't want them to be. But I'm wondering if anyone has any other ideas for how to handle this in D7.

3 2

Re: [development] CCK and Node Access Duplicate Insert errors
by Blaine Lang 19 Apr '11

19 Apr '11

Regarding these duplicate entry records issue: I believe this is a race condition and is very similar to this core issue: http://drupal.org/node/230029 The issue for me is very easy to duplicate when uploading 3 or more files at one time - when the node_save is executed. Given that I'm surprised this issue with CCK has not surfaced before and there may very well be an issue on this already but I was not able to find it. Duplicate entry '16-0-all' for key 1 query: INSERT INTO node_access (nid, realm, gid, grant_view, grant_update, grant_delete) VALUES (16, 'all';, 0, 1, 0, 0) Duplicate entry '16-1' for key 1 query: INSERT INTO content_field_filedepot_file (vid, nid, delta, field_filedepot_file_fid, field_filedepot_file_list, field_filedepot_file_data) VALUES (16, 16, 1, 234, NULL, NULL) Following the ideas posted in issue 230029, I added the call to db_lock_table() around the node_save() db_lock_table($content_type['tables']['content_field_filedepot_file']); node_save($node); db_unlock_tables(); Now that solved my duplicate_insert issue and confirms (I believe) this is a race condition issue. BUT ... now I get about 10 warnings from other tables when the db_unlock_tables is called since they are not locked as in: user warning: Table 'node' was not locked with LOCK TABLES query: UPDATE node SET vid = 8, type = 'filedepot_folder', language = '', title = 'X1.2', uid = 1, status = 1, created = 1303222742, changed = 1303222771, comment = 0, promote = 0, moderate = 0, sticky = 0, tnid = 0, translate = 0 WHERE nid = 8 in F:\web4\nexdrupal\includes\common.inc on line 3538. There is not optional parameter to pass to db_unlock_tables - it's an all or nothing. This would appear to be a core or CCK issue - is anyone aware or can confirm my findings. Is there a known issue or work around? My backup option is to add my own queue logic to handle these inserts.

1 0

Custom template for taxonomy term page in Drupal 7
by Deva 19 Apr '11

19 Apr '11

Hi All, I want to customize taxonomy term page for particular vocabulary. (for all vocabulary is also fine) I am able to customize look and feel of node teasers by using http://drupal.org/node/1106090 It provides a way to style the node differently while listing vs displaying full node. Now i want to have separate template for taxonomy term page. I don't see any default "Drupal 7 Template Suggestions" at http://drupal.org/node/1089656 Anyone know how to achieve this? Thanks in advance. -- :DJ

4 9

Newbie Drupal 7 - Creating Attendence by user access
by Iain Wiseman 18 Apr '11

18 Apr '11

Hi, I have list of people who attended meetings who have a drupal account. I wish to - Upload a speadsheet with the attendence - Display to the users which have an account which meetings they attended - These events are not in drupal calendar I have reasonable knowledge of php/html and databases but no knowledge of drupal. Where do I start? (Please be gentle) Thanks, Iain

4 4

CCK and Node Access Duplicate Insert errors
by Blaine Lang 18 Apr '11

18 Apr '11

I am working on an enhancement to the filedepot module for a multifile uploader - drag & drop files to a hotspot on the browser. It was all working nicely but now consistently getting duplicate entry errors in both the node_access and the CCK table The filedepot_folder is a node and the files are attachments - using the filefield CCK widget. Duplicate entry '16-0-all' for key 1 query: INSERT INTO node_access (nid, realm, gid, grant_view, grant_update, grant_delete) VALUES (16, 'all';, 0, 1, 0, 0) Duplicate entry '16-1' for key 1 query: INSERT INTO content_field_filedepot_file (vid, nid, delta, field_filedepot_file_fid, field_filedepot_file_list, field_filedepot_file_data) VALUES (16, 16, 1, 234, NULL, NULL) I've stripped the module code down to only the following and modules HOOK_nodeapi is just doing a return so no other code in filedepot should be involved. $node = node_load($file->nid, NULL, TRUE); $field = content_fields('field_filedepot_file', 'filedepot_folder'); $validators = filefield_widget_upload_validators($field); $nodefile = field_file_save_file($file->tmp_name, $validators, $this->tmp_storage_path); // Need to populate the CCK fields for the filefield field - so node_save will update the CCK field $node->field_filedepot_file[] = $nodefile; node_save($node); // Clear CCK data cache so the new value will be loaded for display purposes cache_clear_all('content:' . $node->nid . ':' . $node->vid, 'cache_content'); I was suspecting a race condition as the files I'm uploading are small test files and thought the node_save was not completed before another update was attempted but attempts to remove this potential race condition still cause the same issue. Often the first 2 or 3 files get attached just fine to the folder node and then the next file triggers the SQL error then a few more may save ok and then SQL error but the pattern is not consistent. I initially thought it was a CCK cache issue but adding the cache_clear has not removed the issue. Any ideas or suggestions as to the source of this issue and how to solve it. Thanks! Blaine

2 1

drupal developer required for consultation
by Justin Kennedy 18 Apr '11

18 Apr '11

I've taken over a project that is partially complete. I last worked on drupal when it was at 5.0. This current project is built on drupal 7 and uses the newest features. As I'm a bit rusty with Drupal and because I'm not familiar with the new features, I'm looking for an experienced developer whom I can bounce questions off of and get suggestions on implementation. Thank you

3 2

SQL Query Doubt
by Austin Einter 16 Apr '11

16 Apr '11

Hi All Lets say I have one table in below format. EmployeeID.............. Skill ------------------------------------------------------ 1...............................PHP 1...............................SQL 1...............................Java 1................................VoIP 2................................Shell Scripting 2................................PHP 2................................Java 3............................... C++ 3................................C 3.................................Pearl I wan to do a SQL query for employess who MUST have skill PHP and Java. As per above table, the query result should show Employee 1 and 2. Now what should be the corresponding SQL query for it. Regards Austin

5 5

Multi DB
by Damian Adriel Perez Valdes 16 Apr '11

16 Apr '11

Hello: I have a question. It's a best practice if i use the table of my modules in another DB. Using two BD with drupal. thanks.

2 1

Re: [development] SQL Query Doubt
by Robbie The Geek 16 Apr '11

16 Apr '11

SELECT EmployeeID FROM {tablename} WHERE Skill IN ( 'PHP', 'Java'); ----- Reply message ----- From: "Austin Einter" <austin.einter(a)gmail.com> To: <development(a)drupal.org> Cc: "Jason Flatt" <drupal(a)oadaeh.net> Subject: [development] SQL Query Doubt Date: Sat, Apr 16, 2011 7:33 am Hi Thanks for reply. I have tried SELECT EmployeeID FROM {tablename} WHERE Skill = 'PHP' AND Skill = 'Java'; . It does not work. Probably in SQL in same row of table both values are not matching. Regards, Austin On Sat, Apr 16, 2011 at 4:54 PM, Jason Flatt <drupal(a)oadaeh.net> wrote: On Sat, 16 Apr 2011 16:09:59 +0530 Austin Einter <austin.einter(a)gmail.com> wrote: > Hi All > > Lets say I have one table in below format. > > EmployeeID.............. Skill > ------------------------------------------------------ > 1...............................PHP > 1...............................SQL > 1...............................Java > 1................................VoIP > > 2................................Shell Scripting > 2................................PHP > 2................................Java > > 3............................... C++ > 3................................C > 3.................................Pearl > > I wan to do a SQL query for employess who MUST have skill PHP and Java. > As per above table, the query result should show Employee 1 and 2. > > Now what should be the corresponding SQL query for it. SELECT EmployeeID FROM {tablename} WHERE Skill = 'PHP' AND Skill = 'Java'; This might help a bit: http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html -- Jason Flatt Custom Website development solutions: http://www.oadaeh.net/ Father of seven: http://www.flattfamily.com/ (Joseph, 18; Cramer, 16; Travis, 14; Angela; Harry, 10; William, 5; and Dolly, 2) Linux user: http://www.ubuntu.org/ Android user: http://www.android.com/ Drupal fanatic: http://drupal.org/

2 1

Using Drupal.(attach)behaviors instead of .live
by jeff＠ayendesigns.com 15 Apr '11

15 Apr '11

3 2