September 2012 - support - lists.drupal.org

D7 Sql USING syntax
by Kamal Palei 21 Sep '12

21 Sep '12

Hi All I am trying to write a sql query in D7. SELECT id, exp, name FROM {resubmt_users_skills} LEFT JOIN {resubmt_skill_ids} USING (id) WHERE resubmt_users_skills.uid = $user.uid The above query I want to write in D7. $query = db_select('resubmt_users_skills' , 'us'); $query->leftJoin('resubmt_skill_ids' , 'si'); $query->condition('USING(id)'); $query->condition('us.uid = :uid' , array(':uid' => $user->uid)); $result = $query->execute()->fetchAssoc(); Looks above syntaxt is not correct. Can somebody pls tell me whats the fault here and solution for that. Thanks Kamal

4 5

Ten Commandments
by Ms. Nancy Wichmann 21 Sep '12

21 Sep '12

I have recently started a full-time gig, after several months of contracting. In reviewing several extant sites, I identified several practices that I don't care for. So I mentioned the possibility of putting Drupal guidelines into place. They won't really be Commandments and I already have more than ten. What rules/guidelines would you suggest so that we consistently produce the best sites we can? Here's most of what I have now: 1. Follow Drupal Coding Standards; use lots of comments. 2. No PHP nodes. 3. No PHP blocks. (A sample block module is available.) 4. Minimize PHP in Views. 5. All code in Git, if possible. (It is best to create the repository even before using install.php). 6. Use Features for content types and views; and for other things that lend themselves thereto. Commit these to Git repository. 7. Security updates should be scheduled in the project’s issue tracker to be done as soon as practical. Other updates should be reviewed for priority and scheduled accordingly. 8. For views that have a block with a “more” page, limit the View to those functions so you can use the built-in more feature. 9. CSS is your friend, use it before programmatic or theme styling as much as possible. 10.Look for existing solutions before writing a custom one. 11.Even if it is not a project requirement, building an accessible site is better. 12.Themes should be built on a standard starter theme (Zen, Omega, Fusion, etc.) 13.Block visibility addresses should be URL aliases rather than node numbers. 14.Links, including menus, should use relative URLs. 15.Given that most sites will be in a multi-site set up, contributed modules should reside in sites/site-name/modules and files in sites/site-name/files. Views block names: views-name: function-name Code block names module: function-name Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

14 19

Re: [support] Ten Commandments
by Ken Robinson 21 Sep '12

21 Sep '12

I think that number 5 shouldn't specify a particular version control application. Ken At 09:13 AM 9/20/2012, Ms. Nancy Wichmann wrote: >I have recently started a full-time gig, after >several months of contracting. In reviewing >several extant sites, I identified several >practices that I don't care for. So I mentioned >the possibility of putting Drupal guidelines >into place. They won't really be Commandments >and I already have more than ten. > >What rules/guidelines would you suggest so that >we consistently produce the best sites we can? >Here's most of what I have now: > >1. Follow Drupal Coding Standards; use lots of comments. >2. No PHP nodes. >3. No PHP blocks. (A sample block module is available.) >4. Minimize PHP in Views. >5. All code in Git, if possible. (It is best >to create the repository even before using install.php). >6. Use Features for content types and views; >and for other things that lend themselves >thereto. Commit these to Git repository. >7. Security updates should be scheduled in >the projectâs issue tracker to be done as soon >as practical. Other updates should be reviewed >for priority and scheduled accordingly. >8. For views that have a block with a >âmoreâ page, limit the View to those >functions so you can use the built-in more feature. >9. CSS is your friend, use it before >programmatic or theme styling as much as possible. >10. Look for existing solutions before writing a custom one. >11. Even if it is not a project requirement, >building an accessible site is better. >12. Themes should be built on a standard starter >theme (Zen, Omega, Fusion, etc.) >13. Block visibility addresses should be URL aliases rather than node numbers. >14. Links, including menus, should use relative URLs. >15. Given that most sites will be in a >multi-site set up, contributed modules should >reside in sites/site-name/modules and files in sites/site-name/files. > >Views block names: > views-name: function-name >Code block names > module: function-name > >Nancy >Injustice anywhere is a threat to justice >everywhere. -- Dr. Martin L. King, Jr. >-- >[ Drupal support list | http://lists.drupal.org/ ]

3 2

Drupal 6 Vs Drupal 7
by Austin Einter 21 Sep '12

21 Sep '12

Hi Drupal Experts Is there any performance comparision data available between Drupal 6 and Drupal 7. If somebody need to start a developemnt for a big site (involving huge database operations, search engine tika/apachesolr etc), which one is recomonded D6 or D7. Thanks a lot. Austin

5 4

Re: [support] support Digest, Vol 117, Issue 39
by Roger 21 Sep '12

21 Sep '12

I don't understand concern about the 10 (15) commandments. These seem, to me, relevant, instructional and coherent. They seem a path to success. Thanks. Roger >> >I have recently started a full-time gig, after several months of >> >contracting. In reviewing several extant sites, I identified several >> >practices that I don't care for. So I mentioned the possibility of putting >> >Drupal guidelines into place. They won't really be Commandments and I >> >already have more than ten. >>

2 2

Adding a "spinner" to the site??
by Wipe_Out 20 Sep '12

20 Sep '12

Hi, Hopefully someone can tell me an easy way to do this.. I have built a web information system for our customers on our site.. Many seem to be using mobile and tablet devices to access it.. Because its slower they are often clicking links many times rather than waiting for a response.. Certain links trigger rules so these rules are getting run repeatedly.. Is there an easy way to add a "spinner" to the site when I link is clicked so they will just wait for it to load the new page? I have seen some CSS spinner generators online but don't know hoe to integrate that to it triggers when a link is clicked while a page is processing.. Any help would be appreciated.. Thanks.. PS. I am not really a coder so the more simple the solution the better.. :)

2 2

Messed Up Navigation Menu - Multiple "Add Content"s
by Kenneth Jacker 19 Sep '12

19 Sep '12

[ Ubuntu; Drupal-7.15 ] Check out the last few entries in my "Navigation menu": (1) I don't know how I got two extra "Add Content" entries, nor how to remove those two ... (2) How can I get rid of the first (disabled) "Add Content"? I don't really want any "Add Content" entries in the "Nav menu" (I've created a "shortcut" in "admin mode" to add content). Thanks for your help! -- Prof Kenneth H Jacker khj(a)cs.appstate.edu Computer Science Dept www.cs.appstate.edu/~khj Appalachian State Univ Boone, NC 28608 USA

3 4

Taxonomy, Views and Permissions
by Joel Willers 18 Sep '12

18 Sep '12

So I made View showing Taxonomy terms with the count of how many items in each in a block. There are no access restrictions on the View or the Block. However, unless I have "Bypass content access control" checked it won't display. I feel like I've toggled just about every switch I can. Any ideas why it's not showing for me? If I go to the taxonomy term's URL (following the link that SHOULD be there), the page comes up fine. I have to say, I'm pretty frustrated on this one. Any ideas? Joel

1 0

Sites communication
by Disnel Rodríguez Rodríguez 18 Sep '12

18 Sep '12

I have several Drupal sites, each one with a different purpose but all of them made for the same organization. But I have a problem since the same user must authenticate himself in every site..., and that is very unconfortable. Is there any module that allows a user puts his/her credentials in a site and then enter to another site using the same credentials?..., in other words, is it possible put all the sites together with the same authenticaton system (eg. local, LDAP, etc.)? Hope you can help me..., thanks...

4 4

Help with taxonomies
by Disnel Rodríguez Rodríguez 18 Sep '12

18 Sep '12

Hello everybody: I'm working with two taxonomies related to each other, what i need is put them together in a content type as fields, in a such a way when i select one term from the first, in the second one appears those terms related..., for example, i put in one vocabulary names of countries as terms and in the other names of states within those countries, so if i select "USA" in the first, the other shows its 51 states, not all the states in the world... i hope you can help me, thanks anyway

2 2