October 2009 - support - lists.drupal.org

File Attachment Problem
by Ryan Yip 20 Oct '09

20 Oct '09

Hi all, I'm an undergraduate student currently working with other undergraduates on a project for architecture students taking a class in digital design. The students upload their designs in the form of .jpg attachments inside of the comment content type within a post called assignment 1, 2, 3... Uploaded images are shown via the Brilliant Gallery module. We have been having trouble attaching files recently. The site was working fine the day before this attachment problem appeared. As far as I can tell, the changes that were made to the site include: - Modules folder permissions changed for all developer access, - CSS in the Brilliant Gallery module changed so that no background showed around each image, and - the new version of Token was installed. The currently installed modules are listed below: - FileField - FileField Paths - Category - Gradebook - ImageAPI - ImageCache - Brilliant Gallery - Comment Upload - Lightbox 2 - Token - Upload Preview - Upload Path - User Import - Views Upload Path is a module that routes the file attached to a specific content type to a specific folder, therefore allowing brilliant gallery to create a gallery out of the images from a specific title. *Problem*: Any attachments to the assignment content type are not attached, but when checking via a terminal connection / SSH / or SFTP access are uploaded to the files folder designated by the system. The files are not routed to the correct location as designated by the Upload Path module. When checking in the phpMyAdmin, the file is not attached to a specific node. Are they supposed to be attached to the nodes? *My Working Hypotheses*: 1) there might be a permissions problem. The comment upload works and routes to the specific folder correctly but the regular attachments are not attaching. (FYI: Comment Upload is a specific module that is different from the built-in Upload module but utilizes the features.) 2) the updated token module might have affected the workings of Upload Path. If there is some other information you need including checking out the site for yourself just let me know and I'll set up a special username and password. The site is located at http://fasttex-dev.diia.utexas.edu/drupal_dev/dri. Thanks for any help you can give me, Ryan Yip

1 0

move from mysql to postgresql database
by Vasiliy G Tolstov 20 Oct '09

20 Oct '09

Hello. I need to move exiting site from MySQL to Postgresql database. If i create new site with postgresql databases, dump exiting site in mysql (only data without schema, with ansi sql compatibility) and import into postgresql database, can new site work's properly? Or may be best choise - install some export module from old site, do export data, install some import module and inport data? Can You provide some link to succeseful converting mysql to postgresql? Thank You. -- Vasiliy G Tolstov <v.tolstov(a)selfip.ru> Selfip.Ru

4 4

File Attachment Problem
by Ryan Yip 20 Oct '09

20 Oct '09

Hi all, I'm an undergraduate student currently working with other undergraduates on a project for architecture students taking a class in digital design. The students upload their designs in the form of .jpg attachments inside of the comment content type within a post called assignment 1, 2, 3... Uploaded images are shown via the Brilliant Gallery module. We have been having trouble attaching files recently. The site was working fine the day before this attachment problem appeared. As far as I can tell, the changes that were made to the site include: - Modules folder permissions changed for all developer access, - CSS in the Brilliant Gallery module changed so that no background showed around each image, and - the new version of Token was installed. The currently installed modules are listed below: - FileField - FileField Paths - Category - Gradebook - ImageAPI - ImageCache - Brilliant Gallery - Comment Upload - Lightbox 2 - Token - Upload Preview - Upload Path - User Import - Views Upload Path is a module that routes the file attached to a specific content type to a specific folder, therefore allowing brilliant gallery to create a gallery out of the images from a specific title. *Problem*: Any attachments to the assignment content type are not attached, but when checking via a terminal connection / SSH / or SFTP access are uploaded to the files folder designated by the system. The files are not routed to the correct location as designated by the Upload Path module. When checking in the phpMyAdmin, the file is not attached to a specific node. Are they supposed to be attached to the nodes? *My Working Hypotheses*: 1) there might be a permissions problem. The comment upload works and routes to the specific folder correctly but the regular attachments are not attaching. (FYI: Comment Upload is a specific module that is different from the built-in Upload module but utilizes the features.) 2) the updated token module might have affected the workings of Upload Path. If there is some other information you need including checking out the site for yourself just let me know and I'll set up a special username and password. The site is located at http://fasttex-dev.diia.utexas.edu/drupal_dev/dri. Thanks for any help you can give me, Ryan Yip

1 0

organization question
by Vasiliy G Tolstov 19 Oct '09

19 Oct '09

Hello. I have 2 sites - first for stories and blog and second for shop, runs on ubercart. Two sites runs on different domain names Which solutions is best for performance, seo, stability: 1) install all needed modules (ubercart, google analytics and other) in only one site (shop available for example on /shop/ 2) install all modules in separate sites (like now)...? P.S. Sorry for my poor english. -- Vasiliy G Tolstov <v.tolstov(a)selfip.ru> Selfip.Ru

1 0

Node With Tabs
by Steve 19 Oct '09

19 Oct '09

Hi Guys! I have taken a look at tab module and CCK fieldgroup module and would like to come up with a node page that looks like these look at the attached image or you can visit these link http://www.pakreviews.com/restaurants/malees-cafe (its actually a drupal site) Thanks

1 1

Create a page (from views) with the url that start from the begin
by Michel Morelli 19 Oct '09

19 Oct '09

Hi all. I have a portal site, a vocabolary with 5 terms and some nodes (where these 5 terms are used). Call them "categories". Now I need to create a page with the last 10 posts from the category X (I can do it with views module) but with url like this: http://www.mysite.dom/[One of 5 terms/categories] . I have tried to use % in the path that I must to set in the view page, but I have this error: "%" may not be used for the first segment of a path Is there a way to do what I want to do ? M. PS: Sorry for my bad english. -- 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

2 1

Login alla digg
by Michel Morelli 19 Oct '09

19 Oct '09

Hi all, I need to recreate a login "alla digg.com". (New <div> with login+password textfield). Any docs or modules for this ? Thanks. 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

2 2

Update views argument via AJAX
by goliah 17 Oct '09

17 Oct '09

Dear list, I'd like to have this behaviour: imagine to have 2 columns, on the left a list of nodes (only titles for example) and on the right a view showing just one of the contents on the left. My idea would be to achieve this with an AJAX-fashion: clicking a link in the list on the left updates the view on the right with the actual node. Which is the best way to handle this? My idea is to use Panels, make 2 column panel with 2 views, one (left) filtered on content type, with no arguments, and one on the right which takes in as an argument the node id to be displayed. But how to link the 2 views with AJAX? (or, better, how to update the view on the right with an AJAX call?) is this possible? Any help or idea is really welcome Thanks! Cheers Mauro -- View this message in context: http://www.nabble.com/Update-views-argument-via-AJAX-tp25938378p25938378.ht… Sent from the Drupal - Support mailing list archive at Nabble.com.

1 0

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