- support - lists.drupal.org

hex codes in node_import files
by Marty Landman 29 Dec '09

29 Dec '09

I'm porting CCK content from a redesigned D4 site to D6 by extracting the data in a PHP script, generating CSV files then using node_import to create the new nodes. It's working out pretty well so far but I hit the following snag on one of the content types. There are hex encoded characters in the D4 content, somewhere in the importation process the text gets truncated at the first appearance of one of these eg. 0x99, 0x93, 0x94. Am thinking the easiest way to handle it would be to preprocess the data in my PHP script, converting to what it really should be anyway ie. HTML special characters such as the following: 0x99 -> ™ 0x93 -> “ 0x94 -> ” Anyone know of an existing utility to do this for me? Otherwise I can code up a conversion method to accomplish it. Marty

1 0

Retrive last nodes commented
by Michel Morelli 29 Dec '09

29 Dec '09

Hi all. I need to create a block (with views module) that contain last nodes that have new comments. The view that I have created return me this SQL: SELECT DISTINCT(node.nid) AS nid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node.title AS node_title, node.created AS node_created, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, comments.timestamp AS comments_timestamp FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN comments comments ON node.nid = comments.nid WHERE (node.type in ('articolo_corto', 'articolo_lungo', 'articolo_medio', 'dossier', 'story')) AND (node.status <> 0) AND (term_data.vid in ('1')) ORDER BY comments_timestamp DESC But there is a problem: results are not unique. Which is the correct SQL? "Group by nid" and "group by node_title" return me a non correct ordered list. 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

1 0

How to increase number of results for the drupal search
by Michel Morelli 28 Dec '09

28 Dec '09

Hi all. I have a site and a client that want to increase the number of items that search function returns: from 10 to 20. How can I do it ? Tnx. -- 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

adding an Onclick setting to jquery drupal settings
by Idan Arbel 27 Dec '09

27 Dec '09

Hello, I'm trying to add a onClick setting to the views slideshow imageflow module. Everything works great except that when I add the onClick setting it doesn't work. This is what is outputted by drupal: jQuery.extend(Drupal.settings, { "basePath": "/websites/shooky/", "admin_menu": { "margin_top": 1 }, "thickbox": { "close": "Close", "next": "Next \x3e", "prev": "\x3c Prev", "esc_key": "or Esc Key", "next_close": "Next / Close on last", "image_count": "Image !current of !total" }, "imageFlow": { "views-slideshow-imageflow-images-1": { "aspectRatio": "1.964", "imagesHeight": "0.67", "imageCursor": "pointer", "sliderCursor": "pointer", "startID": 1, "slider": 1, "captions": 1, "imageFocusM": "1.0", "scrollbarP": "0.6", "imageFocusMax": "4", "onClick" : "alert('tets');" } } }); the part with the onClick, does nothing. What am I doing wrong? Thanks Idan

3 10

Error on IE
by Néstor 24 Dec '09

24 Dec '09

I am gettinf an error when viewing our intranet site on IE8 and it does not display the site but on FF and Chrome the site displays. Thsi is the error on IE: ------------------------------------ Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Timestamp: Wed, 23 Dec 2009 16:29:37 UTC Message: Invalid argument. Line: 93 Char: 3 Code: 0 URI: http://milhouse2.sdcwa.org:8999/nestor/scroller612/sites/all/themes/newsfla… Message: 'document.body' is null or not an object Line: 3204 Char: 3 Code: 0 URI: http://milhouse2.sdcwa.org:8999/nestor/scroller612/misc/jquery.js?f ---------------------------------------------------- There is not line # 3204 on sdcwa_ddaccordion.js. There are only 200 lines on that js Any ideas? Thanks, Néstor :-)

3 8

Module dev white screen on form submit
by Dayton Perkins 23 Dec '09

23 Dec '09

While developing a module, I ran into a new problem with a twist. When submitting a form, I get a white screen. I have gone so far as to remove validate and submit functions with the same result. Ideas? Thanks. -- /Kindest regards,/ *Dayton Perkins* Good News Design Intelligent Web Programming for Business 3611 Butternut Drive, Suite 40 Holland MI 49424 616-399-5617 http://goodnewsdesign.com Signature <http://goodnewsdesign.com>

4 4

error with views in drupal 6.14
by Aldo Martinez Selleras 22 Dec '09

22 Dec '09

why i'm recieving this error when i try to add a field in my view?? Error: handler for node_data_field_picture > field_picture_fid doesn't exist! thks in advanced

1 0

Drupal online booking sites
by bharani kumar 22 Dec '09

22 Dec '09

Hi All , Is there any one developed the online booking/ train / taxi booking site using drupal , Please Refer that sites , Thanks

1 0

Using Minify
by David Hart 22 Dec '09

22 Dec '09

For various reasons [multisite/performance/boost], I'm using Minify [http://code.google.com/p/minify/] on my site rather than using Core to handle CSS compression. One way of using Minify is to pass it a string of CSS urls, in the form of <link rel="stylesheet" type="text/css" href="/min/?f=modules/node/node.css,modules/system/defaults.css,..."> I've been doing this by using a preprocess function in template.php to assemble the css files into a string. However, the better way to do it is by creating a file that just comprises an array in the form of <?php return array( 'css'=>array('//modules/node/node.css','//modules/system/defaults.css',...), 'print'=>array('//sites/all/themes/mytheme/css/print.css'), ); ?> and calling this like: <link rel="stylesheet" type="text/css" href="/min/?g=css" media="all"> <link rel="stylesheet" type="text/css" href="/min/?g=print" media="print"> I can create this by using a theme function that assembles the array and writes it to the file. However, writing to a file every time the page is called is an obvious overhead. Leaving the file static and updating it manually, however, means that if a new or updated module adds a new CSS file, I probably won't know about it and won't update the array. So my actual question is: in my theme, or in my custom module, is there anything I can hook into so that I write to this file only when the cache is cleared (which happens when modules are added/updated right?). I guess it would need to be in my custom module as I wouldn't be using my theme when the cache is actually cleared (as I use garland for administration) - but then how does a module know what css a theme is using? The hacky way would be to get the theme to write to the file if there's a GET variable something like ?css_rewrite or run a cron job every few hours, but I wondered if there was anything more elegant. --David Hart.

1 0

Front page with i18n sometimes not working
by Marolijo 22 Dec '09

22 Dec '09

Hello, on the site http://plats.polnetwork.biz I use i18n, so i have http://plats.polnetwork.biz/ca and http://plats.polnetwork.biz/es The front page is /inici on both cases, and the default language is /ca but from some machines the front (inici) is not working and appears an error "The required page could not be found" Any idea? Thank's for all Pol

1 0