- support - lists.drupal.org

DB error on upgrade
by Geoff Staples 31 May '06

31 May '06

In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below. It looks like the column vid was already added and the data from uid copied as per the update code. I had to manually modify the table to make vid unique. Geoff php Date Saturday, May 27, 2006 - 21:10 User admin <http://www.greatresultsmarketing.com/?q=user/1> Location http://www.xxxxx.com/update.php?op=do_update <http://www.greatresultsmarketing.com/update.php?op=do_update> Referrer http://www.xxxxx.com/update.php?op=selection <http://www.greatresultsmarketing.com/update.php?op=selection> Message Duplicate key name 'vid' query: ALTER TABLE node ADD UNIQUE (vid) in /services/webpages/x/x/xxxx.com/public/includes/database.mysql.inc on line 120. -- Geoff Staples Warning. Use this email system for confidential communications at your own risk. The President of the United States has issued an executive order allowing the National Security Agency to surveil domestic email, telephonic communication, U. S. Mail and all other forms of communicaton. Although no communication can be guaranteed to be secure, confidential communications made in person at an unknown location arranged via pigeon carrier, smoke signal, or commercial courier are suggested.

4 4

Updating from 4.5.2 (in CivicSpace distro) to 4.6.7 Drupal
by blogdiva＠culturekitchen.com 30 May '06

30 May '06

And of course, there's an error message (those who've heard of me know I'm jinxed) > Fatal error: Unknown column 'severity' in 'field list' query: > INSERT INTO civsp_watchdog (uid, type, message, severity, link, > location, hostname, timestamp) VALUES (1, 'php', 'Table > 'liza_dailygotham_2.civsp_queue' doesn't exist > \nquery: SELECT uid, vote FROM civsp_queue WHERE nid = 1856 in / > home/liza/domains/dailygotham.com/public_html/NEW/includes/ > database.mysql.inc on line 66.', 2, '', '/NEW/index.php', > '207.237.24.22', 1148953436) in /home/liza/domains/dailygotham.com/ > public_html/NEW/includes/database.mysql.inc on line 66 I've followed the following instructions to the t : http://drupal.org/node/30699 And here's where I got in trouble : When I read step #6, I assumed it meant the latest version of 4.6 not the actual 4.6.0. is this a correct assumption? That I will have to upgrade to 4.6.0 first before going on to 4.6.7? What do I do now? I did not get any blaring red messages after the DB upgrade; but, am I supposed to get an update after each date annotated by the program? Also, would it be possible to fix this extremely important page by linking each version to the actual download page I'd have to go to? Thanks, Liza Sabater, Publisher www.culturekitchen.com www.dailygotham.com

3 3

clean paths - but /admin is hard-wired to another location
by Volker Wegert 29 May '06

29 May '06

Hi, I'm running Drupal 4.7.1 on a Cobalt RaQ box or something similar. The problem with this box is that the /admin location is hard-wired to their internal admin interface - this makes navigation inside the Drupal admin menu a little tedious. Even worse, according the the ISP support, this mapping cannot be disabled. Is there a simple way to consistently rename the Drupal paths e. g. from "/admin/..." to "/dadmin/..." or something like this? Best regards Volker -- * Volker Wegert * http://www.volker-wegert.de/contact * * Das Tieferlegen der Festplattenköpfe erhöht keineswegs die * Zugriffszeit! *

1 0

Re: [support] links page
by morten＠unschooling.dk 28 May '06

28 May '06

1 0

links page
by Morten Holmstrup 27 May '06

27 May '06

Hi, I'm a newbie - you've been warned :o) I'm looking for a way to set up a links page. I've managed to install the experimental links package, and it seems to work ok, although I can't find a way to style it. Is using this package the best way to set up a links page, or should I try something else? My links page should contain categories and subcategories, and the links should have descriptions - much like Yahoo, I guess. You can take a look at my first feeble attempts here: http://unschooling.dk/?q=links/weblink it's in Danish... As I said, I can't figure out how to style the categories table, and I would love some help with this - how do I for instance move the two categories longer apart? I do know some php and I'm comfortable with css, but I can't get this to work - please help!!! cheers Morten

2 1

4.7 Site Check - Please
by Tony Budak 27 May '06

27 May '06

Collaborative 4.7 Site check - Please I would like help with a new 4.7 drupal site from those that know their way around the Drupal program, perhaps some you have time and can advise as well. I would appreciate your comments regarding both the design from a technical and a content analysis. I have it installed at www.clnews.org/drupal/ Please take a look. My goal is to build an online community of labor and/or community activists, using the theme or notion of " action stories". I'm totally blown away by the concept of taxonomy. Yet, necessarily the site must be designed with a minimum of classes or categories as starting points to hang any submitted stories on. Can anyone discuss this with me? So the problem I am asking for help is a discussion on both a technical design evaluation and an overall site narrative design evaluation. Anybody interested in suggesting how to proceed. With Respect and Cheers, Tony Budak

1 0

Search and flexinode
by pablov g2 26 May '06

26 May '06

Hi all, This is my first mail to the list, i hope you can help me and i will try to help anyone i can.. well, my problem is that i use fleximode, i have a large site using 5 o 6 different content with flexinode... and i need a searcher usefull. I want some things.. 1) Introduce a radio-buttom or select to mark where flexinode will go to search on. 2) Make a search result order by different flexinode and more things but these are the most important.. any idea?

2 1

pager_query problem
by Fehér János 26 May '06

26 May '06

Hi there, I have a problem with the pager_query() or with the theme_pager() under v4.7. They are a bit mysterious for me, because they don't work for me correctly. The query is "good", if copy&paste to the MySQL console, it's working. If I set the 20 to 500 in the $nodes = pager_query(db_rewrite_sql($sql), 20); all of the record (400something) cappearing, but if I set the "20", nor I don't see the theme_pager(). Vica versa: if the rownum is 2, the pager is there. I've tried to force the pager put the page variable into the URL, but it hasn't helped. My query using "only" LEFT JOINs so it shouldn't be a problem to the db_rewrite_sql() . What Am I do wrong? Thanks, -- Aries

1 1

About SQL Search / Tripsearch
by Abalieno 26 May '06

26 May '06

Is it really not possible to keep supporting it as a module? I'm not going to continue to update the engine only to lose functionalities and the current search module in 4.7.0 still misses basic functions that I'm relying on (like searching by date or parts of words).

1 0

trouble with permissions for book module
by Mike Hartman 25 May '06

25 May '06

I recently upgraded to 4.7 and I'm still getting the hang of Drupal. I'm also using the Taxonomy Access module to restrict access to certain nodes by user role. I'm using the book module for one area of the site along with the Taxonomy Access module to make them viewable for only certain user roles. In permissions I have everything pertaining to the book module such as "create book pages", "edit book pages", etc turned off for a user role. But when I log in as that user I still see the "view" and "edit" tabs on the pages of the book and I'm still able to click on the "edit" tab and make changes to the book page. While trouble shooting this I turned off every permission setting except "access content" for that user role and I still see the "vew" and "edit" tabs when logged in as that user. I've also noticed the "authenticated user" role will effect the other roles I've created so I unchecked all permissions for that role as well with no result. Any ideas? Thanks Mike Hartman

2 1