[support] showing last 4 news

Sat Jun 17 02:29:56 UTC 2006

Hi,

I am assuming that this is to be displayed in a block.

If you are using CCK to create the content then I feel the easiest 
method of creating a block for this is to use the views module 
(http://drupal.org/project/views) which will allow you to create this 
block and so much more.

Gordon.

bunset at dconsultia.es wrote:
> Hi!
> I have created a new content type with CCK called "news", I am trying show
> in home page last 4 news but I don't get the correct snippet for it.
> Anybody can guided me please?
> Regards,
> 
> David from dconsultia.es (Spain)
> 
> 
> 
> -----Mensaje original-----
> De: support-bounces at drupal.org [mailto:support-bounces at drupal.org] En nombre
> de support-request at drupal.org
> Enviado el: viernes, 16 de junio de 2006 14:00
> Para: support at drupal.org
> Asunto: support Digest, Vol 42, Issue 21
> 
> Send support mailing list submissions to
> 	support at drupal.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.drupal.org/listinfo/support
> or, via email, send a message with subject or body 'help' to
> 	support-request at drupal.org
> 
> You can reach the person managing the list at
> 	support-owner at drupal.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of support digest..."
> 
> 
> Today's Topics:
> 
>    1. Drupal-Postgres-LDAP-FreeBSD (David King)
>    2. Re: theme search box button next to field (Franz Iberl)
>    3. Re: Menus (Pherowze)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 15 Jun 2006 19:27:59 -0700
> From: David King <dking at ketralnis.com>
> Subject: [support] Drupal-Postgres-LDAP-FreeBSD
> To: support at drupal.org
> Message-ID: <D1FCD04C-F3B3-43FB-88E8-E120F65147CF at ketralnis.com>
> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
> 
> My name is David King, I am having trouble with LDAP users logging on
> 
> I have a very vanilla Drupal (v4.6.6) install, except that it is  
> installed on Postgres, I have the LDAP authentication module  
> installed, and it is installed on FreeBSD (all three are installed  
> via the FreeBSD Ports system).
> 
> When I try to have an LDAP user log in, the user is created in the  
> database, and looks like this:
> 
> $ psql drupal
> drupal=# select uid,name,data from users;
> uid | name   
> |                                                             data
> -----+------- 
> +----------------------------------------------------------------------- 
> --------------------------------------------------------
>     0 |       |
>     1 | admin | a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}}
>     2 | dking | a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 
> 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=DN>";}
> (3 rows)
> 
> But the user is presented with a blank page after several seconds. In  
> the log are dumped many (a hundred or so) Postgres errors of the  
> following forms:
> 
> pg_query(): Query failed: ERROR: multiple assignments to same column  
> "changed" in /usr/local/www/drupal/includes/database.pgsql.inc on  
> line 45.
> 
> query: UPDATE users SET uid = '2', name = 'dking', pass =  
> '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>',  
> mode = '0', sort = '0', threshold = '0', theme = '', signature = '',  
> created = '1150424378', changed = '1150424378', status = '1',  
> timezone = '', language = '', picture = '', init = '', data = 'a:3:{s: 
> 5:"roles";a:1:{i:0;s:1:"2";}s:17:"ldap_authentified";b:1;s: 
> 7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i: 
> 0;s:1:"2";}s:17:"ldap_authentified";b:1;s:7:"ldap_dn";s: 
> 38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/ 
> local/www/drupal/includes/database.pgsql.inc on line 62.
> 
> The errors seem to alternate between those two.
> 
> I can't delete the user in the database, because if I go to  
> Administer > Users > dking (the username) > Edit, I get the browser  
> error that the server has closed the connection.
> 
> How can I go about troubleshooting/debugging this? Does anyone have  
> any ideas?
> 
> Some more potentially useful information:
> 
> ~% uname -a
> FreeBSD <> 5.3-RELEASE-p20 FreeBSD 5.3-RELEASE-p20 #2: Fri Sep  9  
> 14:11:12 PDT 2005     root@<>:/usr/obj/usr/src/sys/ROUTERKERNEL  i386
> 
> ~% pkg_info | grep drupal
> drupal-4.6.6_2006031700 CMS that supports pgsql and mysql
> drupal-ldap_integration-4.6.0_20060117 LDAP user authentication for  
> the Drupal CMS
> 
> ~% psql --version
> psql (PostgreSQL) 8.0.8
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Fri, 16 Jun 2006 08:37:13 +0200
> From: Franz Iberl <f.iberl at amazonas-box.de>
> Subject: Re: [support] theme search box button next to field
> To: support at drupal.org
> Message-ID: <d56558947547037902b3c5585a99fb38 at amazonas-box.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Hello again,
> 
>>  I know the code is correct.  It displays correctly in this node:
>> http://www.animecards.org/node/74
> 
> ok, the button 'submit' which fits in the node obiously does not fit in 
> the orange box at the left side.
> 
>>  #search .form-text {
>>      width: 8em;
>>  float: left
>>  }
> 
> try e.g. 5em ?
> 
> in a hurry
>    Franz
> 
> 