support April 2011

support@drupal.org

84 participants
110 discussions

Start a nNew thread

module for cutom t-shirts?
by Adam Tong 19 Apr '11

19 Apr '11

Hi, Do you know if there is any module for creating and ordering custom t-shirts online? Thank you

4 6

Auto increment fields
by Austin Einter 19 Apr '11

19 Apr '11

Anybody observed, the auto-increment fileds in a table is NOT always incremented by 1 with each row insert. But as per SQL manual it should be increased by 1. Is this behavior Ok? Or I am doing something wrong. Note: I do not write any value to this coulmn in my INSERT statement, this coulmn values are set by system automatically. Values I have seen for auto-incrment field -> 1,2,3,4,8,9,10,18,19,20 etc... So in between the values incremented by more than 1. Thanks Austin

3 2

Drupal 7 versions
by Roger 19 Apr '11

19 Apr '11

Drupal 7 comes in a number of testing updates Drupal7 now, Drupal 7 alpha 7 and, Drupal 7 beta 3 Do fixes for d7a7 and d7b3 end up in Drupal 7, the official test release? Which is the latest test release, beta 3 or alpha 7? My Drupal 7 install has significant problems with views, views-systems, views_bulk_operations , it doesn't work at all well, Drupal 7 alpha 3 does work almost. CKeditor is hopeless in Drupal 7 for me, a real shocker. I deleted it and enter the html markup code by hand. CKFinder is useless also because Drupal 7 seems to require the full url aka: http://var/www/html/drupal7/sites/default/files/images/image.jpg before it renders the image. CKFinder does not provide the full url. This problem means that I can't just copy my files over to the server without changing each and every image url. I have /sites/default/files/images set in the configuration which seems to be ignored. What am I doing incorrectly? Help appreciated Roger

2 1

Re: [support] Drupal 7 versions
by Roger 19 Apr '11

19 Apr '11

Walt, thank you. Taking your advice, I got mine-self to Drupal 7 just now, Even views-calc behaves -- although how it adds 20+15 and gets 55, and 135+25 +100 and gets 395 I haven't figured yet. Now to see correct results from 'computed field' and I'm in raptures. Thanks again Roger

1 0

Create menu item for content type
by nan wich 18 Apr '11

18 Apr '11

<:avglsdata id=avglsdata> I am upgrading a client site to D6, on the way to D7. There is a specific content type that has 134 nodes that all need to be inserted into the menu under a specific parent inorder to make the menu sidebar and breadcrumbs work right. Hook_menu() isn't getting the entries under the correct parent, or hidden. I'm having trouble unravelling menu's code to use the API. I need this done by tomorrow. Has anyone got any brilliant ideas before I start manually entering 134 items and not get enough sleep? Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

1 0

Today from the Date API
by Joel Willers 18 Apr '11

18 Apr '11

I have Date API and Calendar modules installed on my D6.20 site, and I need to send ‘Today’ to the function date_real_url(); I’ve tried date_real_url($view, 'day', date("Y-m-d")) and even tried to hard code a date (‘2011-01-01’) and it doesn’t seem to work. Any suggestions? Joel

2 2

Good drupal 7 book
by Adam Tong 18 Apr '11

18 Apr '11

Hi, What book would you recommend for drupal 7? Thank you

2 1

DRUPAL and menu item permissions
by Hector Muñoz 18 Apr '11

18 Apr '11

Hi all! I have Drupal 6.20 core and i'd like to show/hide certain menu items i made in Navigation menu depending user role. I have trying with menu per role module but it didnt work. :( How can i do it? Thanks in advance!

2 1

multilingual site
by Adam Tong 17 Apr '11

17 Apr '11

Hi, I installed successfuly the variable and internationalization modules. I'm able at this moment to see the language link on each page, and once this link is clicked I have the page in that language as I entered it. What I would like to do is have the language link at the top of the page, and then when the link is clicked evrything should change to the choosen language (including the main menu). Is there a way to do that? is there any docs about this? Thank you

2 1

Re: [support] [development] SQL Query Doubt
by nan wich 17 Apr '11

17 Apr '11

<:avglsdata id=avglsdata> Please, this should not be in development; it belongs in support. Actually, Ivan's query won't work because each skill is on a separate row. Your query, AFAICT, is the only way the way to actually find multiple skill combinations. It also has the advantage of scaling to handle even more skills. But let's make it truly Drupalized: SELECT e.employee_id FROM {employees} e WHERE EXISTS(SELECT 1 FROM {skills} s WHERE s.employee_id = e.employee_id AND s.skill_id = 'java') AND EXISTS(select 1 FROM {skills} s WHERE s.employee_id = e.employee_id AND s.skill_id = 'C++') Of course, to use it in a db_query(), you will need to further parameterize it. $skills_desired = array('java', 'c++', 'php'); // Values can be filled however you prefer. $wheres = array_fill(0, count($skills_desired), "EXISTS(SELECT 1 FROM {skills} s WHERE s.employee_id = e.employee_id AND s.skill_id = '%s')"); $query = "SELECT e.employee_id FROM {employees} e WHERE " . implode(' AND ', $wheres); if ($result = db_query($query, $skills_desired)) { while ($result = db_result($result)) { // ... do something with the employee. } } else { return t('No matches found.'); } This is, of course, Drupal 6 code. DBTNG can do this more efficiently. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: David Metzler Select * form employees e where exists (select 1 from skills s where s.employee_id=e.employee_id and s.skill_id = 'java') AND exists(select 1 from skills s where s.employee_id=e.employee_id and s.skill_id='C++') I have heard that mysql will perform better with Ivan's query, but I haven't verified that this is the case.

3 3

← Newer
1
2
3
4
5
6
7
8
9
10
11
Older →

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support April 2011