support June 2012

support@drupal.org

62 participants
88 discussions

Problem with db_update containing a CONCAT condition.
by Nicolas Poulain 05 Jun '12

05 Jun '12

Hello, I have an update query i'd like to translate into a more «7» way but I don't know how to write one of the conditions that contains a CONCAT statement. db_query(" UPDATE {gbb_session} SET co_resp = (SELECT co_resp FROM {gbb_gresp_dafor} WHERE CONCAT(prenom,' ',nomu) = :formateur) WHERE sess_id = :sess_id" ", array( ':sess_id' => $form_state['values']['sess_id'], ':formateur' => $form_state['values']['formateur'])); Here is what i tried ; it doesn't work ... $subquery = db_select('gbb_gresp_dafor', 'r') ->fields('r', array('co_resp')) ->condition('CONCAT(prenom,\' \',nomu)', $form_state['values']['formateur'], '=') ->execute(); db_update('gbb_session','s') ->fields(array('co_resp' => $subquery)) ->condition('sess_id', $form_state['values']['sess_id'], '=') ->execute(); Any help, would be appreciate. -- Nicolas poulain http://exomatik.net

2 1

Fatal Error! :o
by Ron Eggler 04 Jun '12

04 Jun '12

hi, I installed the UberCart e-commerce module wanting to enable an online store in my website and I enabled some poarts of the module, gota a warning that i need to enable some depencies but I can't go back and do it as I aolways get this error now: "Fatal error: Cannot redeclare field_info_cache_clear() (previously declared in /home/content/86/9316986/html/site/modules/field/field.info.inc:29) in /home/content/86/9316986/html/site/sites/all/modules/commerce_kickstart-7.x-1.7/modules/field/field.info.inc on line 38" url: http://wittmerperformance.com/site/ What the heck is going on? Thanks! -- Ron Eggler Web Developer iNetGate (778) 230-9442 ron.eggler(a)inetgate.ca www.inetgate.ca

7 8

Page pagination in a non query page result.
by D. Michel Morelli 04 Jun '12

04 Jun '12

Hello all, I'm creating a website and show on the screen a series of titles. These titles do not come from a db query, but from a webservice in which I ask titles of page X. Now I would put to the bottom of the page a pager. I looked a bit around and all said to use a code like: <code> $total = $response->response->numFound; $num_per_page = $_GET['nrResult']; global $pager_page_array, $pager_total; pager_default_initialize($total, $num_per_page); $pager = theme('pager', array('quantity' => 3)); </ code> But to me it appears: <code> 1 2 3 </ code> while I would like: <code> first previous 1 2 ... 15 16 next end </ code> Where is that wrong? M. -- Michel 'ZioBudda' Morelli michel(a)ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) 0200619074 - 3939890025 (mobile)-- Fax: +39-0291390660 http://www.ziobuddalabs.it Skype: zio_budda

1 0

Re: [support] Multiple path aliases?
by DTH 02 Jun '12

02 Jun '12

Using the core path module it's possible to set up multiple aliases for the same node art admin/build/path/add [assuming D6] (e.g. foo/bar and baz/bar can both be aliases to node/4). Where the problem lies is that this doesn't play well with menus, so if you want to have both foo/bar and baz/bar in a menu it's not going to work as going to baz/bar will trigger active trails to foo/bar as well. Depending on your site structure/number of cloned pages/how often content changes etc, the way I've handled this in the past includes: 1. If there's only a few pages or if the content never/rarely changes just suck it up and quickly copy over the contents to a new node 2. Use views (e.g. create a node called bar, and views with paths foo and baz that take bar as an argument) 3. Either on the same content type or a new content type called Cloned Content etc, have a node reference field and then configure your display/templates to show the referenced content, so your workflow would be: create foo/bar and then if the same content is needed elsewhere, create a new node and choose foo/bar as the node reference, and then save it in the appropriate place in the menu as baz/bar. This last one is what I do currently (after somebody mentioned it on the list a while back when I asked a very similar question). > From: Gerald Klein <jk(a)zognet.com> > Subject: Re: [support] Multiple path aliases? > > Hi and thanks for the post, this is a great module but doesn't serve my > purpose. This module just redirects to another URL, I need something that > allows the setting of multiple aliases for the same page and the URL > remains intact after load. I want for example: > http://somesite/project1/bill > and > http://somesite/project2/bill > > to point to the same content. > > But thanks for this module I can see it's usefuleness. > > thanks for help and in advance for anyone who knows the answer to my > problem. > > thanks again > > --jerry > > On Fri, Jun 1, 2012 at 6:39 PM, Steve Edwards <killshot91(a)gmail.com> wrote: > >> Try PAth Redirect. >> >> http://drupal.org/project/path_redirect >> >> Steve >> >> On Jun 1, 2012, at 4:38 PM, Gerald Klein wrote: >> >> Hi, I have a site that I am working on that employees appear in a number >> of areas. To make the nav complete I have to recreate their pages multiple >> times. I have loaded the actual content into blocks and cloned them so I >> can solve that problem, but it would be much cleaner if I could simply >> apply multiple path aliases to a sinble page. Does anyone know how this can >> be done? >> >> thanks in advance for any help. >> >> thanks >> >> --jerry >> >> -- >> >> Gerald Klein DBA**** >> ContactMe(a)geraldklein.com >> www.geraldklein.com <http://geraldklein.com/>**** >> jk(a)zognet.com**** >> 708-599-0352**** >> >> >> Linux registered user #548580 >> >> >> >> -- >> [ Drupal support list | http://lists.drupal.org/ ] >> >> >> >> -- >> [ Drupal support list | http://lists.drupal.org/ ] >> > > > > -- > > Gerald Klein DBA**** > > ContactMe(a)geraldklein.com > > www.geraldklein.com <http://geraldklein.com/>**** > > jk(a)zognet.com**** > > 708-599-0352**** > > > Linux registered user #548580

3 3

Missing Tab in Safari
by Susan Mangold 02 Jun '12

02 Jun '12

I created a custom theme that uses tabs in the header block. I noticed today that seven tabs appear in Mac Firefox but only six in Mac Safari. Any thoughts on how to fix this? TIA. Sue

2 2

Multiple path aliases?
by Gerald Klein 02 Jun '12

02 Jun '12

Hi, I have a site that I am working on that employees appear in a number of areas. To make the nav complete I have to recreate their pages multiple times. I have loaded the actual content into blocks and cloned them so I can solve that problem, but it would be much cleaner if I could simply apply multiple path aliases to a sinble page. Does anyone know how this can be done? thanks in advance for any help. thanks --jerry -- Gerald Klein DBA**** ContactMe(a)geraldklein.com www.geraldklein.com <http://geraldklein.com/>**** jk(a)zognet.com**** 708-599-0352**** Linux registered user #548580

3 3

D7 Adding content to an empty region from template.php
by Jeff Greenberg 02 Jun '12

02 Jun '12

I was asking a slightly different question in the themes list, but I've narrowed down my issue, and believe it's more of a support question than a theme development question. I am trying to add content to a region from within template.php. The region has no content prior to doing this. I have tried drupal_add_region_content() from template_preprocess_page, template_preprocess_html and template_preprocess_region. I've also tried just making an assignment to $vars[page][my_region][my_section_name][content][#markup] from the same functions. Nothing results in output. Do I have to do it using hook_page_build from a module?

2 4

Memcache and JS
by Ms. Nancy Wichmann 01 Jun '12

01 Jun '12

We have a D6 site that we were using Memcache on. Various JS things, such as Views UI and attachment uploads, are failing with "HTTP error 0." If we disable Memcache the errors go away. I don't see anything terribly helpful on D.O. Has anyone encountered this? How did you get around it? Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

3 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support June 2012