August 2009 - support - lists.drupal.org

views and calculated fields
by Lluís 27 Aug '09

27 Aug '09

I have a view with two fields (A and B), both of them numeric. I want to make a filter to show nodes when A + B = 0 How can I make this? I suppose I should add A and B as hidden fields and then there should be a calculated field anywhere allowing to add(), concatenate(), .... But I have been unable to find this module. Thanks -- *La vida és com una taronja, què esperes a exprimir-la? *Si creus que l'educació és cara, prova la ignorància. *La vida és com una moneda, la pots gastar en el que vulguis però només una vegada. *Abans d'imprimir aquest missatge, pensa en el medi ambient.

3 7

GAF clone with Drupal
by Giovanni R. 26 Aug '09

26 Aug '09

I'm going to create a clone of websites like GAF (getafreelancer.com) where people can submit projects to develop and developers can bid on them in order to work. Before starting, I'd like to be sure to choose the best way to do it. How would you build it? I'd use CCK to create two new content types, Project and Bid. I've seen it exists also the Node Comment module, and I could use it to represent the Bids. But I don't know if it's a good solution to do that. The biggest problem is the reference. I think I need a node relationship module in order to "link" one Project to many Bids and to display the "linked" Bids when viewing the Project. A kind of father-sons relation. I'd like to use URLs like /node/add/bid/123 to add a new Bid, where 123 is the Project nid. I've seen that they exist modules which deals with URLs, too. (there's a module for everything! ^^) Which is the best way to implement all this with Drupal? Thank you for any hint. Regards, Giovanni ps. I know there are already plenty of working GAF clones out there, I'm doing this just for learning purposes, so take your time to answer. :-)

1 0

Getting Garbled Chinese
by Tony Yet 25 Aug '09

25 Aug '09

Hi, I am new to drupal. After successfully installing the package on my server, I prepared some post in Chinese for publication. But the Chinese characters were rendered garbled when I hit save. I've already set my web server character-set configuration to utf-8. Could anyone tell me what I shall do? Thanks. - Tony

2 1

Drupal Association field values for Amazon API 6.x 1.0 Beta7
by David Christensen 25 Aug '09

25 Aug '09

http://forums.oreilly.com/content/Using-Drupal/5111/Drupal-Association-F ield-Values-For-Amazon-Api-6-x-1-0-Beta7/ Using Drupal: I am working my way through chapter 4 of "Using Drupal" with Drupal 6.13 and Amazon API 6.x 1.0 beta7, and have gotten stuck at configuring Amazon API. Figure 4-5 in the book shows "Amazon locale", "Amazon referral settings", "Your associate ID", and "Amazon API key" fields, but Home > Administer > Site configuration > Amazon API shows the first three and then "Amazon AWS Access Key ID" and "Amazon AWS Secret Access Key". I have tried various combinations of "Amazon referral settings" and the values printed in the book ("drupal-20" and "0CD9RCSD22JDH5DFD99") without any luck. I am not inclined to agree to a 17 page contract with Amazon to complete the exercise. Does anybody know the new Drupal Association field values to get this working? TIA, David

1 1

Changing a Content-type Directly in the DB, Kosher?
by Shai Gluskin 23 Aug '09

23 Aug '09

Folks, I have a content-type with about 50 nodes that I want to split into two content-types. The content-type has four cck fields including two filefield/imagefield fields. I want to create a new content-type and change the content-type of about 25 of those nodes to the new content-type. The new content-type will only have 1 cck field which will be one of the two filefield/imagefield fields from the original content-type. None of the nodes that I want to change have any content in the three fields that I won't be adding to the new content-type. For changing the content-type I was going to do it directly on the db in the node table. I don't see any bad consequences of this. But am I missing something? Shai

4 3

Problems with favicon in Internet Explorer
by Damian Soriano 22 Aug '09

22 Aug '09

Dear Drupallers, I have a problem showing the favicon in Internet Explorer while in Firefox it works perfectly fine. I try with a .png as well as a .jpg in 32x32, but can't solve it. Any idea how to make it work? BR Damián

2 1

Re: [support] Problems with favicon in Internet Explorer
by Steve Kessler 22 Aug '09

22 Aug '09

Try and save it as a .bmp file and then replace the exstention with .ico. Thanks, Steve -----Original Message----- From: "Damian Soriano" <damiansoriano(a)gmail.com> To: support(a)drupal.org Sent: 8/22/2009 1:49 PM Subject: [support] Problems with favicon in Internet Explorer Dear Drupallers, I have a problem showing the favicon in Internet Explorer while in Firefox it works perfectly fine. I try with a .png as well as a .jpg in 32x32, but can't solve it. Any idea how to make it work? BR Damián

1 0

Re: [support] Upgrading Drupal from 5.19 to 6.13
by David Christensen 22 Aug '09

22 Aug '09

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

1 0

Add Cluetip with image in mouseover
by Swatee Karpe 21 Aug '09

21 Aug '09

Hi All, Please help me, How to add Cluetip with image+text in mouseover? What I have done ?? For that I added following code into pag.tpl.php, <head> tag: <script type="text/javascript"> $(document).ready(function(){ var direccion = '/content/cajones-portamonedas'; top.$('.views-table td a img') .addClass('cluetip_title') .attr('rel',direccion) .attr('href',direccion); top.$('.cluetip-title').cluetip(); }); </script> Here I install Cluetip in drupal 6x with jq module dependency. -- I create a page with <a class="cluetip-title" href="#" rel="test">Click here..</a> -- rel="test" --> test is a page with image in it's content. -- but while mouseover on click here.. link I saw a full page with left,right,top,bottom and content also. -- It's not my requirement I need to display only content. -- Also anyone explain what is mean by : var direccion = '/content/cajones-portamonedas'; ?? thanks in advanced.. Please help me. -- Regards Swatee Amit Karpe

1 0

help with a profile error
by brendan, fresh-off.com 21 Aug '09

21 Aug '09

Hello, On this profile page [../admin/content/node-type/profile/profile profile page] I'm getting the following error: warning: array_filter() [function.array-filter <http://test.wewilldobetter.org/admin/content/node-type/profile/function.arr ay-filter> ]: The first argument should be an array in /home/content/s/m/g/smggdaddy/html/test/sites/all/modules/autoassignrole/aut oassignrole.module on line 460. I havent messed about with any of the code in the autoasignrole module, just uploaded and activated it. What does that error mean, and what should I do about it? Thanks for any input! ---- brendan, fresh-off.com Creative Direction & Consultation: Web | Print | Brand http://fresh-off.com hello(a)fresh-off.com 206.328.1067

1 0