support September 2007

support@drupal.org

86 participants
120 discussions

Drupal weirdness, please help
by Krister Ekstrom 09 Sep '07

09 Sep '07

Hello, I'm helping a friend get started with her web site which we are planning on creating in Drupal. She has a remote server using CPanel and fantastico and it's through this that we have installed Drupal. When we installed, nothing seemed to go wrong, it indicated that the installation had gone all right but when we started enabling modules and create user roles the following error message started to appear: user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/nanna/public_html/includes/database.mysql.inc on line 172. After this we no longer can access administrative tasks and we can't do anything else than read the newly created home page and the pages it points to, but no user login or nothing. What could I/we have done wrong? Do i have to uninstall the whole system and reinstall it again? /Krister

4 3

linking the categories
by paola.dimaio＠gmail.com 09 Sep '07

09 Sep '07

Okay, my latest question about to ensure 'uniqueness of values' was unanswered This could be because it was (again) an unclear question (apologies if thats the case) Or because nobody knows the answer. This is a case of having hit a limitation of the current module, or simply not knowing how to use it Let me try again. same module (taxonomy) I need to find out a clever way to structure our 'categories' and 'tags' in a way that they can be be combined I think this can be done by creating a hierarchy of vocabularies/categories so what I wonder is can I make a category become the parent or child of another category? at the moment I dont see this option (I can see that I can make a term become the child or parent of another term, but what I need is a group of terms to be the parent of another group of terms) The reason why I need this, its because the drop down menus at the moment are toooo long. For each term, I have say 10 child terms, which in turn have 10 child terms so its very difficult to select the right one(s) cause one gets lost before finding the right category Plus I cannot selectively make one term mandatory, say a parent, and the children optional (for those who may want to have more granular keywords) So one way of doing that (perhaps) would be for each parent term have a new 'category', so that each parent term can be made mandatory (hence creating a superstructure) and then making one or more children optional, and then linking a freeflowing tags to that. Has someone implemented a nice complex hierarchy using taxonomy module and has advice ? thanks -- Paola Di Maio School of IT www.mfu.ac.th *********************************************

2 2

people schema
by paola.dimaio＠gmail.com 08 Sep '07

08 Sep '07

okay, foaf is not that good really but its the only people schema in use is there a way of implementing a better people xml for drupal? doesnt have to be foaf has to be a people schema, flaxible so that users can create their own field I think profile module can be easly used for that (add a field) but I need to export the profiles via xml, both individually, selectively as an aggragate feed (select all the profile with tha criteria and export to xml) does drupal have something like this in mind? If not, I can put in the pipeline and work at it if useful to others too cheers -- Paola Di Maio School of IT www.mfu.ac.th *********************************************

2 1

CCK add field behaving differently on 2 sites, why?
by Jean Gazis 08 Sep '07

08 Sep '07

I have 2 Drupal-5 sites (I think it is 5.1x) and I have CCK, Date, TinyMCE, Viewfield and Views on both. Different themes, but nothing weird - standard Drupal themes that have not yet been customized. On one site, when I go "Add Field" to create or edit a content type, I get a dropdown list of existing fields. On the other site, I just get a "create new field" box. Naturally, the second one is where I need a content type that has the same fields 12 times (for a list of wine selections, I need 12 fields for "vintage" etc). The only thing that I know is different is the first site has Organic Groups, but why would that make content type behave differently? I haven't configured TinyMCE yet on the second site, would that matter? Do I get any brownie points for following up the beer site question with a wine site question? ;-) -- Jean Gazis www.jeangazis.com www.boxofrain.us "Believe those who are seeking the truth; doubt those who find it." - André Gide

1 0

Liniing one database to another
by Steven Vermoere 07 Sep '07

07 Sep '07

Hello, I'm trying to implement a database of Belgian beers. Therefore, I created 2 different nodes with CCK: 1 for the brewer, 1 for the beer. Now I need a link between the node of the beer and the node of the brewer. The purpose is that, when I enter a beer, I can link it to a brewer, without typing in all the data of the brewer. And when the beer is visible, a simple link to the brewer must be shown. And if you click on that link, the node of the brewer opens with all the data and the beers that the brewer is brewing. I've already looked at Node Family, but I do not understand it very good. Can some-one help ? Kind regards, Steven Vermoere

4 5

Batch tagging or update of nodes
by Vasileios Lourdas 07 Sep '07

07 Sep '07

Hi all, Is there a way to batch process the nodes? I'm mostly interested in batch tagging, so that I don't have to go through each node. Maybe a module? Thanks. -- # Vasileios Lourdas, # Informatics Engineer, Thessaloniki (Greece) # http://www.lourdas.name

2 2

A beginner's questions
by Kovács István 07 Sep '07

07 Sep '07

Hi, I'd like to set up a VPS hosting two sites (in two different domains), on top of Ubuntu (Debian) Linux. I'd like to know the following: - how do I configure the two sites, sharing a single Drupal installation, to use different configuration and databases? My web server is Apache; - is it possible to theme different parts of the same site differently? E.g. my wife would probably prefer different colours for her blog than I would for mine :-) TIA, Kofa

2 3

Theme a CCK input form
by Fred Jones 07 Sep '07

07 Sep '07

There is a fantastic handbook with the name "Theme a CCK input form" that I used for another site and it worked perfectly. For this other site, however, it fails. I am trying this method: http://drupal.org/node/101092#comment-262746 in the comments of that handbook page, yet the function function phptemplate_node_form($form) { in template.php is never called on node/add/d which is my CCK content type. In fact print_r($form); reveals that $form is empty. This site was built (or mostly built) by someone else so I don't know what they may have done. Anyone have any ideas about what is going on? Thank you very much. I appreciate the assistance. Fred

2 2

Update CCK Node via Code
by Fred Jones 07 Sep '07

07 Sep '07

I wrote a custom module which updates one value in my content_type_d table. Code appears to work perfectly. The problem is that when I view the node afterward in the browser, the new value is NOT seen. Even though I confirm that the new value IS in MySQL, the old value appears on the page. The only way to get a new value to appear is to edit the node manually. The field type is integer text field. I realize there is something that I am missing. Can someone clue me in? Thanks.

4 6

Node "reads" not working in "most popular" view
by Jean Gazis 07 Sep '07

07 Sep '07

I've been having some issues with Views on a couple of sites. The All-Time Most Popular view that comes with the module isn't showing the number of reads or sorting on it. The default sort is supposed to be popularity, but they seem to be sorting on create date instead. Here is the page view: http://urbanorganic.jeangazis.com/popular/alltime . I turned off the block, but it showed the items like this: "Calabacitas ()" Do I need to have a "reads" counter in the content item itself? If so, how do I add that field? -- Jean Gazis www.jeangazis.com www.boxofrain.us "Believe those who are seeking the truth; doubt those who find it." - André Gide

2 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support September 2007