December 2007 - support - lists.drupal.org

List of Drupal Sites?
by ian＠corpwatch.org 21 Feb '08

21 Feb '08

Googled it but didn't find the most desirable results. Anyone know of a list of really good drupal sites? I am trying to get my users to look at other Drupal sites to brainstorm feature requests, instead of just making them up. I found a few, like MTV UK and The Onion, anyone know other popular/famous ones?

15 22

Module to create a form to subscribe to pdf newsletter
by Walter Garcia-Fontes 04 Jan '08

04 Jan '08

I've been looking in the available modules for Drupal 5 for the following simple functionality. I post a newsletter in pdf format in my site, and I want to have next to it a "subscribe" link, which if clicked will open a form where the registered or anonymous user can enter his subscription information to receive new issues by email. If submitted the user will get an email to confirm his subscription (to avoid submitting someone else's email) and once confirmed the email address will be added to a mailing list, which the admin can use to send the newsletter in the future. I've been looking at different existing modules, the closest I found is "simplenews" but it seems to only send a "html" newsletter. So: 1) is there a module to do this in Drupal 5? 2) do I need an external mailing list handling system to do this, or can I do it all within drupal (create the table with emails addresses, let user's add themselves through the subscription link, let the admin mass-email the pdf file to the email addresses in the table) I will also need options for users to auto opt-out from the subscription, also for anonymous users if I let them subscribe. -- Walter Garcia-Fontes Barcelona

2 2

How to remove story desc from front page?
by Hardik Shah 01 Jan '08

01 Jan '08

Hi All, I would like to remove the story description from frontpage.I mean on my site http://newskicks.com i only want to display the story title on frontpage(like http://reddit.com) i am using story linkn module.can any one tell me how can i achive this? Thanks for your help in advance. Thanks & Regards, Hardik Shah -------------------------------- Hardik Shah mobile:- 9827634991 phone:- +91-0731-2570516 --------------------------------- Did you know? You can CHAT without downloading messenger. Click here

4 6

Custom search page for specific category
by Jody Cleveland 01 Jan '08

01 Jan '08

Hello, Is there any way to code an html page to have a search box that defaults to search a specific category? - jody

4 5

SQL syntax problems
by Tenant 31 Dec '07

31 Dec '07

I'm having a big problem with Drupal clean install. (I've done other sites before and now they also have this problem) I uploaded the Drupal 5.5 tarball. In phpMyAdmin I created the MySQL database drupal-domainname and associated with it a pre-existing SQL user with global privileges. I then did the install script and create the admin account as per the instructions. Here's the problem: I initially added two modules: the Available Updates module and also System info module. No other modules (yet). But I did run cron. So in the System Info, I get: user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SHOW GRANTS in /home/domainname/public_html/includes/database.mysql.inc on line 172. user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SHOW GRANTS in /home/domainname/public_html/includes/database.mysql.inc on line 172. The identical line is repeated twice on the System info page as I quoted above. So this is odd enough. I generally use phpMyAdmin to create the databases, but when I try it from the terminal using the install instructions, I get a similar message: mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE -> TEMPORARY TABLES, LOCK TABLES -> ON drupal-domainname.* -> TO 'root'@'localhost' IDENTIFIED BY 'password'; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-domainname.* Given that the install is as clean as possible (and I've had no similar problems with other Drupal installs on the same server until now) and that it's happening when I use both phpMyAdmin or mysqladmin, I'm thinking this might be a MySQL problem and not a Drupal problem. Any advice and help are really appreciated. Thanks.

2 1

looking for talented and experienced theme developer
by Xavier Bestel 28 Dec '07

28 Dec '07

Hi, I maintain a website for a paragliding club, and while I can find my way through a drupal install (I even wrote my own module, can you believe that ?), I'm not an artist - I lost that dream loong ago. But I need that site to be beautiful, original, usable and clean. So, where do I turn to have that job (well) done by someone else, and more importantly how much would that cost ? The site is drupal 5.5 + a big bunch of modules. Thanks for your hints, Xav PS: please Cc me on reply, I don't always read mails on the list.

1 0

Views export CSV not working with images
by Marolijo - Pol maresma 28 Dec '07

28 Dec '07

Hello, I have an image field that isn't showin' on the CSV exported file. I need to place the link to the file on the CSV, is it possible? thank's for all!

1 1

Block Styles
by Tom Holmes Jr. 27 Dec '07

27 Dec '07

Thanks for the help with login page. I am working on that now, and that seems to be going ok. Now, I am working on the Menu System, and I have created some new menus. This is probably a very easy question ... but for different menus, I'd like to have different styles for different menu names. Along that line ... I'd like to have different styles for different blocks. I am going through on how to make themes, and I am looking online and through my book "Pro Drupal Development" I may find my answer soon, but if anyone wants to point me to the right direction, that would be great! Thanks! Tom

4 8

Synchronous Wiki Page Editing
by ian＠corpwatch.org 27 Dec '07

27 Dec '07

I am using Pearwiki and wikitools to create pages on my site. Anyone can create a login or edit pages. If two people click "edit" at the same time, one persons work is lost. The second person to click "submit" gets an error message: This content has been modified by another user, changes cannot be saved. This is obviously a version control issue. This problem has been solved before in computer programming. Is there a solution for Drupal? Does this happen anytime two users hit "edit"? I guess it would make more sense to block the second user from clicking "Edit", that would be the "checking out" of the particular article. Then when it is checked back in, the other users could edit it, but only after. Currently, the configuration forks the content every time two people click "edit." Is there a workaround? I checked all of my settings, but didn't see a solution. --ian--

3 2

Move Login Form
by Tom Holmes Jr. 26 Dec '07

26 Dec '07

I've seen this done before, and so I know it is definitely possible. I want to move the Login form from the main page to another page. So when I go the main page, I don't get any login form. I'd have a small link to this new page that has only the login information. Can someone point me to a link to do this, or let me know how to do this? Thanks.

3 4