- support - lists.drupal.org

FW: Upgrading Drupal from 5.19 to 6.13
by David Christensen 16 Oct '09

16 Oct '09

drupal: Does anybody know the answer to this question? TIA, David -----Original Message----- From: David Christensen [mailto:dpchrist@holgerdanske.com] Sent: Friday, August 21, 2009 10:21 PM To: support(a)drupal.org Subject: RE: Upgrading Drupal from 5.19 to 6.13 support(a)drupal.org: I am attempting to upgrade Drupal from 5.19 to 6.13. Do I need to worry about the following warning messages? First update.php page: user warning: Table 'cache_block' already exists query: CREATE TABLE cache_block ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. Third update.php page: user warning: Table 'cache_form' already exists query: CREATE TABLE cache_form ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/modules/system/system.install on line 1413. user warning: Table 'menu_router' already exists query: CREATE TABLE menu_router ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Table 'menu_links' already exists query: CREATE TABLE menu_links ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128)) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Table 'menu_custom' already exists query: CREATE TABLE menu_custom ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Duplicate entry 'navigation' for key 1 query: INSERT INTO menu_custom (menu_name, title, description) VALUES ('navigation', 'Navigation', 'The navigation menu is provided by Drupal and is the main interactive menu for any site. It is usually the only menu that contains personalized links for authenticated users, and is often not even visible to anonymous users.') in /home/holger/drupal-6.13/modules/system/system.install on line 1749. user warning: Table 'upload' already exists query: ALTER TABLE file_revisions RENAME TO upload in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 249. user warning: Duplicate column name 'nid' query: ALTER TABLE upload ADD `nid` INT unsigned NOT NULL DEFAULT 0 in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 298. user warning: Duplicate key name 'nid' query: ALTER TABLE upload ADD INDEX nid (nid) in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 434. user warning: Multiple primary key defined query: ALTER TABLE upload ADD PRIMARY KEY (vid, fid) in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 374. user warning: Duplicate key name 'fid' query: ALTER TABLE upload ADD INDEX fid (fid) in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 434. user warning: Table 'actions_old_contrib' already exists query: ALTER TABLE actions RENAME TO actions_old_contrib in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 249. user warning: Table 'actions' already exists query: CREATE TABLE actions ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters` LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0', PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Table 'actions_aid' already exists query: CREATE TABLE actions_aid ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Table 'search_node_links' already exists query: CREATE TABLE search_node_links ( `sid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(16) NOT NULL DEFAULT '', `nid` INT unsigned NOT NULL DEFAULT 0, `caption` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid, type, nid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/holger/drupal-6.13/includes/database.inc on line 517. user warning: Duplicate column name 'weight' query: ALTER TABLE upload ADD `weight` TINYINT NOT NULL DEFAULT 0 in /home/holger/drupal-6.13/includes/database.mysql-common.inc on line 298. TIA, David

3 8

Drafts and required fields
by Dani Matielo 16 Oct '09

16 Oct '09

Hello, all, I am working in a system that should have the following workflow: After a user has registered, he is able to create one (and just one) node of a certain content type, which has several fields. In order to "submit" que node type, there are several fields that should be filled, and thus I marked them as required. However, this person should also be able to save an "Incomplete" content type, as a "draft", before submiting it. And, in this case, the fields wouldn't have to be filled. After the content is submitted, the user should not be able to edit it anymore. Ok, so, how have I done it so far? I created the content type and then used save&edit ( http://drupal.org/project/save_edit) to create two status: published and saved. Then I used Skip validation (http://drupal.org/project/skip_validation) so, when the person just saves the content type, it skips validation. And the validation is just done when the person publishes the node, which is when I used Rules (http://drupal.org/project/rules) in order to prevent send e-mail and prevent further access to the content. Sounded good, but the problem is that the content is not being save after skipping validation. So, here I am, trying to think about another way of doing this. My doubts/thoughts until now are: - is there a module that makes a different kind of validation which is not the core validation? - why is the content type not being save after skipping validation? - does anybody have any different idea of how i could do this? thank you in advance, best regards, daniela - -- Daniela de Carvalho Matielo dacamat.com.br | weblab.tk | lixoeletronico.org twitter: @danimatielo "The only people for me are the mad ones, the ones who are mad to live, mad to talk, mad to be saved, desirous of everything at the same time, the ones who never yawn or say an uncommon-place thing, but burn, burn, burn like fabulous yellow roman candles." ~ Jack Kerouac

1 0

Re: [support] Is it possible to change the date to something easier to read?
by brendan, fresh-off.com 16 Oct '09

16 Oct '09

Hmmm Since you're happy with the Long Date format, I'm *guessing* there's no need for you to add a Custom Format on the date-time configure page. Just chose which Long Date format makes the most sense. But, thats just a guess. I had to do this recently for the first time myself - creating a custom date/time for a View. I guess I'll just tell you what I did for my View; I needed it to show an hour , in a format that would make sense to US based users (e.g. 5:52a). Here's what I did Under "Add format type" on the date/time configure page I typed: ------- Name: Hour Stamp Type: hour_stamp ------ I just chose "names" that made sense to me and my audience. (Again, I'm not sure you need to create a custom format..) for the "Format string" I looked at the php manual (Drupal shows a link to it) and found what I needed to just show the hour in a familiar US format. Next I went over to my View, and under "Fields" I chose "Content: Date (field_date) - From date" Next I chose: "Link this field to its node" (personal preference) And for "Format" I chose: "Hour Stamp" (see if you can choose "Long" here). Thats what I needed to do for my situation. I dont know if that will help or not, but hopefully it points you in the right direction! ------ brendan, fresh-off.com Creative Direction & Consultation: Web | Print | Brand http://fresh-off.com hello(a)fresh-off.com 206.328.1067 From: Tine Müller [mailto:tinem@email.dk] Sent: Thursday, October 15, 2009 10:18 PM To: brendan, fresh-off.com Subject: Re: [support] Is it possible to change the date to something easier to read? Thanks for trying to help but I don't know what to do? If I for instance want the Long date format: what shall I then write in the box Name: and the box Type:? /Tine ----- Original Message ----- From: brendan, fresh-off.com <mailto:hello@fresh-off.com> To: support(a)drupal.org ; 'Tine Müller' <mailto:tinem@email.dk> Sent: Thursday, October 15, 2009 10:37 PM Subject: RE: [support] Is it possible to change the date to something easier to read? this might be what you're looking for: http://www.tinemuller.dk/drupal/admin/settings/date-time/formats/configure ------ brendan, fresh-off.com Creative Direction & Consultation: Web | Print | Brand http://fresh-off.com hello(a)fresh-off.com 206.328.1067 From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Tine Müller Sent: Thursday, October 15, 2009 8:06 AM To: support(a)drupal.org Subject: [support] Is it possible to change the date to something easier to read? Is it possible to change the date to something easier to read and if yes where? Should it be in excel, phpmyadmin or Content type field date? http://www.tinemuller.dk/drupal/Crime look in InfoWindow Date: 20070328T07:03:00. It's made from this CSV-file http://www.tinemuller.dk/drupal/crime_data.csv and from this tutorial http://zacker.org/screencast-drupal-mashup-machine#comment-3556 M.v.h. Tine Müller http://tine_muller.homepage.dk/ http://www.findbiblioteket.dk/ 0 <http://www.jqkt4b2xwhj198.ReadNotify.com/nocache/jqkt4b2xwhj199/footer0.gif > Error! Filename not specified. _____ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.18/2437 - Release Date: 10/15/09 03:57:00 0 <http://www.kj6vxskfssmle8.ReadNotify.com/nocache/kj6vxskfssmle9/footer0.gif > Error! Filename not specified.

1 0

Re: [support] PHP 5.3 upgrade problems
by andy baxter 16 Oct '09

16 Oct '09

The majority of the errors I am getting are of the form: 'Parameter n to function_name() /expected to be a reference, value given/ in //path/to/file/ on line m//.' This error is a known issue with PHP 5.3 and drupal from what I have read so far. I have seen a few reported issues where people are recommending finding the relevant function and changing the parameter definition from '&$variable' to just '$variable'. But I'm worried that this is just a quick fix which might throw up problems elsewhere - I don't really know either PHP or the drupal codebase well enough to know for sure what is the right way to fix these problems. andy Daniel Horning wrote: > could you be a tiny bit more specific as to the errors you are getting > > also - you might want to check your error display settings in both PHP.ini's > and see if they are the same > it could just be that the errors were occurring on your test server and you > might not have been seeing them. > > -- > Dan Horning > > American Digital Services - Where you are only limited by imagination. > dan.horning(a)planetnoc.com :: http://www.americandigitalservices.com > 1-518-444-0213 x502 . toll free 1-800-863-3854 . fax 1-888-474-6133 > 15 Third Street, PO Box 746, Troy, NY 12180 (by appointment only) > > >> -----Original Message----- >> From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On >> Behalf Of andy baxter >> Sent: Tuesday, October 13, 2009 12:30 PM >> To: support(a)drupal.org >> Subject: [support] PHP 5.3 upgrade problems >> >> Hi all, >> >> I have recently moved a site from my test server (which is running php >> 5.2) to the live server (which is running php 5.3). >> >> Since doing this, a lot of pages are throwing error messages about a >> function expecting a reference argument. >> >> I have done enough research to get some idea of what the basic problem >> is, but still don't feel that I understand it well enough to dive in to >> trying to patch the code. So far all I have done is add something to >> the >> template to suppress warnings for non-admin users. >> >> If anyone can help with this, I would appreciate it - the site is going >> public in two days and I still have some other things I need to sort >> out >> before then. Does anyone know of any well written explanations on-line >> of how this issue has come about and how it affects drupal? Or if >> someone on the list could take the time to explain to me what the issue >> is, that would be good as well. >> >> cheers, >> >> andy >> -- >> [ Drupal support list | http://lists.drupal.org/ ] >> > >

9 17

Permission problem
by A-NO-NE Music 15 Oct '09

15 Oct '09

Drupl 6.14 I just created a new role for my assistant to post 'page' content type but not other content type, then I realized Publishing Option is disengaged so she can't post to the front page nor sticking it to the top. To my surprise, there is no permission setting for Publishing Option. I realized the publishing option comes online if I give Administer Nodes permission, but this causes to allow, not only Page but also any content type to be created even though they are not engaged for this role. I am hoping to solve this problem before morning. Any help would be appreciated. -- - Hiro Hiroaki Honshuku, A-NO-NE Music, Greater Boston http://a-no-ne.com http://anonemusic.com

3 4

Expanded part of the menu
by Emma Badger 15 Oct '09

15 Oct '09

This is an example of part of my menu. <li class="expanded last active-trail"> <a class="active" title="" href="/workflow">Workflow</a> <ul class="menu"> <li class="collapsed first"><a title="Workflow Terminology" href="/ workflow-terminology">Terminology</a></li> <li class="collapsed"><a title="" href="/setting-workflow">Setting up a Workflow</a></li> <li class="collapsed"><a title="" href="/ frmGeneric.ADMWFPROCESS">Processes</a></li> <li class="collapsed"><a title="Workflow Actions" href="/ frmGeneric.ADMWFACTIONS">Actions</a></li> <li class="leaf last"><a title="Workflow Workbench" href="/ FRMEADM021">Workbench</a></li> </ul> </li> I'd like to replicate this <ul class="menu"> <li class="collapsed first"><a title="Workflow Terminology" href="/ workflow-terminology">Terminology</a></li> <li class="collapsed"><a title="" href="/setting-workflow">Setting up a Workflow</a></li> <li class="collapsed"><a title="" href="/ frmGeneric.ADMWFPROCESS">Processes</a></li> <li class="collapsed"><a title="Workflow Actions" href="/ frmGeneric.ADMWFACTIONS">Actions</a></li> <li class="leaf last"><a title="Workflow Workbench" href="/ FRMEADM021">Workbench</a></li> </ul> i.e. the pages below the current page, and put it underneath the node content. I'm thinking that I can do this in my template but I'm not sure where to find the menu code to see how the menu is being generated. Can someone point me in the right direction please. Thanks very much. Emma

1 0

Looking for tutorials on converting Photoshop PSD files into Drupal 6 themes
by Kelly Tanguay 14 Oct '09

14 Oct '09

First of all, I'd like to mention how helpful this support list has been. I don't know how I could have gotten started with Drupal without it! I'm just getting started with creating my own themes. I feel like I understand the structure of creating a Drupal 6 theme using CSS and template files, and I am also pretty familiar with Photoshop though I haven't worked much cutting up PSDs to use on a website. I was wondering if there were any good tutorials, resources, or books that show how to convert a PSD file into a Drupal 6 theme from beginning to end. Any help at all would be appreciated! -Kelly

2 2

File dimension: wrong size but only for a user
by Michel Morelli 13 Oct '09

13 Oct '09

Hi all. I have a problem with a D6 site. I have an user that can upload image via cck filefield image item. And it works. Now I have "activated" the upload module to permit the upload of "attached file". But the same user can not upload nothing with this error: The selected file /1211449416.png/ could not be uploaded. The file is /84.63 KB/ which would exceed your disk quota of /1 MB/. Ehh ???? 84.63KB is bigger than 1MB ??? I have no quota on my server. And the administrator haven't this problem. Where is the error ? Tnx. M. -- Michel 'ZioBudda' Morelli michel(a)ziobuddalabs.net Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel(a)ziobuddalabs.it JABBER: michel(a)ziobuddalabs.it

5 6

PHP 5.3 upgrade problems
by andy baxter 13 Oct '09

13 Oct '09

Hi all, I have recently moved a site from my test server (which is running php 5.2) to the live server (which is running php 5.3). Since doing this, a lot of pages are throwing error messages about a function expecting a reference argument. I have done enough research to get some idea of what the basic problem is, but still don't feel that I understand it well enough to dive in to trying to patch the code. So far all I have done is add something to the template to suppress warnings for non-admin users. If anyone can help with this, I would appreciate it - the site is going public in two days and I still have some other things I need to sort out before then. Does anyone know of any well written explanations on-line of how this issue has come about and how it affects drupal? Or if someone on the list could take the time to explain to me what the issue is, that would be good as well. cheers, andy

6 7

Create Content and Permissions
by Pete Gervais 12 Oct '09

12 Oct '09

Gents, I'm new to the list and would appreciate help from anyone who has seen these problems before. 1) I cannot get rid of the Create Content menu entry as part of my secondary menu. 2) I seemed to have lost access to all permissions. Therefore User Management -> Permissions issues the following : This webpage is not available. The webpage at http://www.oasfc.com/index.php/?q=admin/user/permissions might be temporarily down or it may have moved permanently to a new web address. You can see this at www.oasfc.com/index.php I have searched the archives and cant find anything that relates to this . I'm using Drupal 6.13. Regards, Peter J. Gervais Vice President of Information Technology/Owner OTTAWA AVIATION SERVICES 220 Hunt Club Road Ottawa, Ontario,Canada K1V 1C1 Office: 613-737-2933 Cell: 613-864-7370 E-mail: pgervais(a)ottawaaviationservices.com Web: www.ottawaaviationservices.com cid:image001.jpg@01CA3148.41EA4940

3 2