June 2008 - support - lists.drupal.org

Setting head_title and title independently
by David Carman 20 Jun '08

20 Jun '08

Thanks. As I understand it, those functions are used in an individual theme. I am trying to find a way to set those variables in the module itself so that it will work for any theme without having to add a template.php file to each individual theme with one of those functions in them. If I define a theme_[module_name]_page_title function would whatever it returns be passed as $page_title to the templates, or would there be a way within such a function to make sure a variable gets passed to the templates? I am still trying to figure out the flow between modules and themes. Thanks for the help, David

2 1

Views and Image question
by Edward Peters 20 Jun '08

20 Jun '08

I am trying to build an image gallery in Drupal 6 using Views. I want to define the Field as the image which has been uploaded using the image module, but I can't see any way of choosing it. It is not an 'uploaded file' in the sense that is used. Does this mean that Views for D6 does not yet have integration with the image module? Edward Peters Oxford, UK www.iofc.org

1 0

Possible to add block to node content?
by Jody Cleveland 20 Jun '08

20 Jun '08

Hello, I'm running Drupal 6.2 and I have a question. Is it possible to add a block into a content element? I want to create a page that includes a block I've created, but I want it in the content area of the page. -- Jody Cleveland

5 5

CCK 6.x field permission questions
by Jim Li 19 Jun '08

19 Jun '08

Hello, I was playing with CCK-6.x-2.0-beta, and had a couple questions on content_permission (previously field permission?). 1. What's the best way to allow a user to be able to edit a user-defined field, but not the default content body and title? Looks like a user have to have 'edit any my-content-type' permission, so he can get to the edit form. But it also gives him permission of editing the default content body and title, which is not what I wanted. One possible way I can think of getting around this, is to disable the default body/title field, and define my own ones, but it's kind of awkward to me. Is there a better way to do this, or am I missing something? 2. Is there a way to have fine-grained permission on multi-fields? What I want is users can add a multi-field, and edit their own multi-field but not the ones added by others. Is this possible with CCK-6.x? Thanks, Jim

1 0

Error when install two Drupal 6.2 with PGSQL and table prefix (and patch)
by Saint-Genest Gwenael 19 Jun '08

19 Jun '08

Hi, Today, i've tried to install two sets of datas into a drupal 6.2 database (with pgsql). With a table prefix i've take an error like : Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "int_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "int_unsigned" already exists query: CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159 Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "smallint_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "smallint_unsigned" already exists query: CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159 Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "bigint_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "bigint_unsigned" already exists query: CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159 Ok ... Drupal try to create data types two times ... and crash :( If anyone else has the same error, this patch can solve this problem : --=={ snip }==-- --- drupal-6.2-ref/modules/system/system.install 2008-06-19 10:19:36.000000000 +0200 +++ drupal-6.2/modules/system/system.install 2008-06-19 15:53:28.000000000 +0200 @@ -302,9 +302,15 @@ function system_install() { if ($GLOBALS['db_type'] == 'pgsql') { // Create unsigned types. - db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)"); - db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0)"); - db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)"); + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'int_unsigned'"))) { + db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)"); + } + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'smallint_unsigned'"))) { + db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0)"); + } + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'bigint_unsigned'"))) { + db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)"); + } // Create functions. db_query('CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS --=={ snip }==-- Gwen -- Gwenael Saint-Genest MAKINA CORPUS - www.makina-corpus.com 44 boulevard des Pas Enchantés FR-44230 Saint Sébastien sur Loire Tel : +33 (0) 2 40 94 96 08

1 0

Four excellent questions
by Lev Lafayette 18 Jun '08

18 Jun '08

... were recently submitted to me. (1) can an a current version of a page be publicly available on the website, whilst there is another version of that same page being updated but not publicly available (with this in-editing page later becoming the current page)? (2) we'd like to set a few users only with publishing authority, with all other users having create/edit authority, but not able to publish new or edited content. The "publishers" would review new/edited content and then publish it if OK. This issue rather presumes that (1) is possible? (3) if a page does not have a menu item (i.e. the "menu title" field is left blank), so that it is just linked from another page, for example, is there a handy way for authenticated users to find such pages if they are not published (I think that "recent posts" works only for published content?)? (4) can friendly URL's be created automatically, up to the last section which is the actual name of the page (e.g. x/y/z/PageTitle, with x/y/z/ being added automatically, and the page creator just having to add PageTitle)? This would "be nice" but not essential... I gave a workaround for (1), a 'no' for (2) and (4) - with an explanation for the latter, and suggested Administer > Content Management (admin/content/node) for the third. Any other ideas/solutions? All the best, -- Lev Lafayette (03) 9925 4909 Systems Administrator 110 Victoria St Carlton South, 3053

3 4

Dynamically display parent/child taxonomy terms in a separate list?
by Paul Kim 18 Jun '08

18 Jun '08

Is there a way to display a single-hierarchy taxonomy terms separately? For example, if we have this list: Parent1 --child1 --child2 Parent2 --child3 --child4 --child5 I want to show two drop-down menus, populating the first one with: Parent1 Parent2 Once a selection is selected in this first drop-down menu, a second drop-down menu is populated with the children based on the selection of the first drop-down menu. What's the best way to do this? Thanks!

2 2

Setting head_title and title independently
by David Carman 18 Jun '08

18 Jun '08

I have been trying to add support to the panels module (I am not associated with it) for a separate title in the title bar and in the in-page text. I have modified the module to get the two strings and store them in the database, but I am having trouble figuring out how to set $head_title and $title in the theme. It the title is currently set using the drupal_set_title function, which seems sets both of those variables. Is there was any way to set those variables independently or override the set_title function because I do not want to change the core? I apologize if this has been covered else where, I could not find it. Thanks. David Carman

2 1

Google Spreadsheet
by Fred Jones 17 Jun '08

17 Jun '08

While I see there have been discussions of implementing a Google Spreadsheet-like feature for Drupal or an API to share data with an actual Google Spreadsheet, I don't see any working code. Does such a thing exist? I have a site where the owner wants to keep the list of Drupal users (complete with a set of custom fields) in a Google Spreadsheet. My only solution is to hook into the registration form processor and use curl to post the fields to the Google Spreadsheet. This I believe can be done and would work. Updates are not yet accounted for, but I'm not sure this will be a requirement. Anyone have an alternative solution? Thanks!

3 3

Views show filters over empty text
by marolijo - Pol Maresma 17 Jun '08

17 Jun '08

Is ot possible? Or can I force to show always the Header? Thank's!

2 2