November 2006 - support - lists.drupal.org

Theming forms
by Juan Carlos Vallejo 18 Nov '06

18 Nov '06

Hello I am trying to insert a form in a table. I have read some topics in drupal home page like: - http://drupal.org/node/82916 - http://drupal.org/node/97361 - http://drupal.org/node/47582 (the last comment is very clear) I have got to insert the form but when I click in the button (submit) in form_id_sumbmit function I do not receive this element values. What am I doing wrong?

2 1

watchdog log files slowing admin page
by Chris McKeever 17 Nov '06

17 Nov '06

Running a test system of drupal for a new site that we are wolrking on, and noticed that the watchdog log table grew to about 250,000 records. This made the main admin (and log) pages just move to a screeching halt. I deleted the watchdog table and everything seemed to come back to life - Could this be some sort of configuration issue? Either drupal or mysql? has anyone else run into this, and did they come up with a solution (like possibly purging the log file) - Thanks -- ---------------------------------- please respond to the list .. if you need to contact me direct cgmckeever is the account prupref.com is the domain <A href="http://www.prupref.com">Simply Chicago Real Estate</A>

2 1

is it possible to use Drupal to send emails to users with an attached file, i.e. Word doc?
by Paul Rooney 15 Nov '06

15 Nov '06

Hi, Does anyone know of a module (or combination) that would support including an attachment with an email sent to users via a Drupal site? I have recommended sending out a plain text email with a link to the node where the file is attached but the client insists that the attachment be sent out with the email :( . Any suggestions would be appreciated! Thanks, Paul

1 0

Error in user.module
by Paul W 15 Nov '06

15 Nov '06

Using 4.7.3, I get this error even when just going to the site without any login involved: * warning: array_keys() [function.array-keys]: The first argument should be an array in /var/www/html/modules/user.module on line 351. * warning: implode() [function.implode]: Bad arguments. in /var/www/html/modules/user.module on line 351. * 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: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/www/html/includes/database.mysql.inc on line 120. Everything worked yesterday and I have changed nothing! This is very strange. Can anyone help? Paul W

1 0

.httaccess: convert empty spaces in URLs into "-"
by marcob 15 Nov '06

15 Nov '06

Noticed that URLs generated by Views that make use of arguments, transform empty spaces (derived from a $node->name used as an arg) into "%20" and then manage to get happily to the right final destination. Core Drupal unfortunately does not handle that, so for example if i look for www.mysite.com/natural%20places , i get a PageNotFound error. To prevent this, would it be possible to transform any empty space in any URL into a " - " (minus symbol) via .httaccess or other means? Example: "www.mysite.com/Natural sites" --> "www.mysite.com/Natural-sites" Cheers! Marco

1 0

Re: [support] Change to home page location
by Halter, Shari 13 Nov '06

13 Nov '06

Larry, Thanks for your advice, and especially for feeling my pain. Shari Shari L. Halter Web Programmer, Corporate Services Thornton Tomasetti 51 Madison Avenue New York, NY 10010 T 917.661.7800 F 917.661.7801 D 917.661.7970 SHalter(a)ThorntonTomasetti.com -----Original Message----- From: Larry Garfield [mailto:larry@garfieldtech.com] Sent: Saturday, November 11, 2006 2:22 AM To: support(a)drupal.org Subject: Re: [support] Change to home page location Let me make sure I understand. Your sysadmin insists that http://mysite.com/ be nothing, and that http://mysite.com/home be what everything thinks is the home page? Step one, get a new sysadmin because this one is dumb. :-) When that fails, alias your front page (whatever it is) to the path "home". Yes, all <front> links (such as breadcrumbs) will still point to an empty path, because that's the way it's supposed to work. You could probably write a module to auto-forward path '' to path "home" fairly easily (hook_init(), probably?). I don't know of an existing way to do that, but that's probably how I'd go about it given silly constraints like that (unless it's because you have some sort of flash ad at your web root, in which case the sysadmin should be shot for wanting a flash ad as a front page for a site in the first place). On Friday 10 November 2006 21:56, Greg SBC wrote: > I thought of this too, but wouldn't all the home links in breadcrumb > and such still point to www.mysite.com, which is not what is wanted. > Want home link to link to /home. Without mod_rewrite to change > www.mysite.com requests into www.mysite.com/home requests (presumably > because something else resides there), this is a tough situation to handle. > > Greg > > _____ > > From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] > On Behalf Of Benjamin Melançon > Sent: Friday, November 10, 2006 4:23 PM > To: support(a)drupal.org > Subject: Re: [support] Change to home page location > > > unfortunately, no the rest of the site should only appear under > mysite.com <http://mysite.com/> , not mysite.com/home. > > > In that case roll everything back, if you can, to before you started > copying things (if the original is working, maybe you can just delete > the home directory). > > Then enable the path module and edit the page you use as your home > page, and give it the URL alias "home" > > If you have a blog-style front page, a URL alias home for <front> > might be possible... > > - ben > > member, Agaric Design Collective > http://AgaricDesign.com - "Open Source Web Development" > > person, People Who Give a Damn > http://pwgd.org - "building the infrastructure for a network of everyone" > > On 11/10/06, Halter, Shari <SHalter(a)thorntontomasetti.com > <mailto:SHalter@thorntontomasetti.com> > wrote: > > unfortunately, no the rest of the site should only appear under > mysite.com, not mysite.com/home. > > crazy, I know. -- Larry Garfield AIM: LOLG42 larry(a)garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson -- [ Drupal support list | http://lists.drupal.org/ ] <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> The information in this email and any attachments may contain confidential information that is intended solely for the attention and use of the named addressee(s). This message or any part thereof must not be disclosed, copied, distributed or retained by any person without authorization from the addressee. If you are not the intended addressee, please notify the sender immediately, and delete this message. <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

1 0

Re: [support] Change to home page location
by Halter, Shari 12 Nov '06

12 Nov '06

unfortunately, no the rest of the site should only appear under mysite.com, not mysite.com/home. crazy, I know. (I think this affects the second post on this, as well) Shari L. Halter Web Programmer, Corporate Services Thornton Tomasetti 51 Madison Avenue New York, NY 10010 T 917.661.7800 F 917.661.7801 D 917.661.7970 SHalter(a)ThorntonTomasetti.com _____ From: Metzler, David [mailto:metzlerd@evergreen.edu] Sent: Friday, November 10, 2006 4:26 PM To: support(a)drupal.org Subject: Re: [support] Change to home page location Are all the pages in the drupal site going to have /home in front of them or was the idea that only the entry page of drupal needed a to be at /home? You shouldn't need (nor would I recommend) two copies of the drupal distro files. The /files permissions problem is probably because it's root and it's looking for mysite.com/files when you want it to find mysite.com/home/files or the other way around. The permisssions error may just be indicating that the file doesn't exist? If all drupal content needs to be accessed from mysite.com/home then I'd recommend that you only keep the copy there. Also, this may be slightly different depending on whether clean urls are enalbed or no.... Dave _____ From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Halter, Shari Sent: Friday, November 10, 2006 11:21 AM To: support(a)drupal.org Subject: [support] Change to home page location I have a site, call it mysite.com. My site lives in the following directory on a Debian linux server: /export/devhome/mysite.com/htdocs. Drupal was installed here. It ran fine. Administration deemed, after the site was in place, that site home page needed to be changed to <http://mysite.com/home> http://mysite.com/home, rather than <http://mysite.com> http://mysite.com. (The URL MUST appear exactly this way) So I made a directory, /home, under htdocs. [I've been told by our sysadmin that Apache mod_rewrite, symbolic linking and other server redirect methods wouldn't work]. My home page would initially not run here (complained first about includes, then modules) so I had to make a separate copy of mostly everything (includes, modules, misc, etc. everything except for database) in htdocs and duplicate it in /home. It now works fine, from both locations. The $base_url was left, in sites/mysite.com/settings.php, as <http://mysite.com> http://mysite.com. Questions/issues: 1. Is it really necessary to have those Drupal files in both locations (htdocs and htdocs/home)? 2. My "Administer" -> "Settings" page in Drupal is complaining that it no longer has access or permissions in the /file directory, despite my having used chmod 755 . to adjust permissions on the directory and the files within. Thanks, Shari Shari L. Halter Web Programmer, Corporate Services Thornton Tomasetti 51 Madison Avenue New York, NY 10010 T 917.661.7800 F 917.661.7801 D 917.661.7970 SHalter(a)ThorntonTomasetti.com <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> The information in this email and any attachments may contain confidential information that is intended solely for the attention and use of the named addressee(s). This message or any part thereof must not be disclosed, copied, distributed or retained by any person without authorization from the addressee. If you are not the intended addressee, please notify the sender immediately, and delete this message. <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> The information in this email and any attachments may contain confidential information that is intended solely for the attention and use of the named addressee(s). This message or any part thereof must not be disclosed, copied, distributed or retained by any person without authorization from the addressee. If you are not the intended addressee, please notify the sender immediately, and delete this message. <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

5 4

Want to make a book list for a library - best practice?
by Jody Cleveland 11 Nov '06

11 Nov '06

Hello, I'm designing a website for a public library using drupal. One thing they'd like to have is a set of book lists. I found this one: http://www.hclib.org/kid/frame.cfm?frame=kids_read.cfm which is exactly what I want to do. Is there a module that would allow me to do this? If so, which one? If not, any ideas on the best way to do this? I tried doing it as having each book be a separate page, and then using taxonomy to view all of a book list, but that's been pretty time consuming. Thanks in advance for any help you can provide. - jody

2 2

CK-ERP (Open Source ERP / CRM / MRP) v.0.21.1 released
by C K Wu 11 Nov '06

11 Nov '06

A new release, v.0.21.1, of CK-ERP, has been posted at SourceForge.Net, http://sourceforge.net/projects/ck-erp . This release features connectors for Joomla, Mambo and Drupal. Improvement had also been provided to the TikiWiki and CRELoaded connectors. CK-ERP is an open source accounting/MRP/ERP/CRM system that runs on top of eGroupWare / XOOPS / Joomla / Mambo / Drupal / Zencart / CRELoaded / osCommerce / Xaraya / Horde / TikiWiki / phpBB. It comprises 22 modules - Administration, i18n, Contact Management, Customer Relationship, Customer Self Service, Vendor Relationship, Ledger, Bank Reconciliation, MRP, Warehouse, Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager, HR, Staff Self Service and Payroll. Operating platform can either be LAMP or LAPP. It provides accounting and back office functionalities to SMEs and utilizes the underlying middleware to administer accounts/groups. Please report error and suggestion to the discussion group / mailing list, CK-ERP-en(at)googlegroups.com or CK-ERP-zh_CN(at)googlegroups.com . General history and expected development is available at the discussion group's Archive. Information Website, http://ck-erp.net Download is available from, http://sourceforge.net/projects/ck-erp http://gforge.oss.org.cn/projects/ck-erp http://gf.cs.hit.edu.cn/projects/ck-erp http://www.cnforge.org/modules/xfmod/project/?ck-erp http://gro.clinux.org/projects/ck-ledger

1 0

Change to home page location
by Halter, Shari 10 Nov '06

10 Nov '06

I have a site, call it mysite.com. My site lives in the following directory on a Debian linux server: /export/devhome/mysite.com/htdocs. Drupal was installed here. It ran fine. Administration deemed, after the site was in place, that site home page needed to be changed to http://mysite.com/home <http://mysite.com/home> , rather than http://mysite.com <http://mysite.com> . (The URL MUST appear exactly this way) So I made a directory, /home, under htdocs. [I've been told by our sysadmin that Apache mod_rewrite, symbolic linking and other server redirect methods wouldn't work]. My home page would initially not run here (complained first about includes, then modules) so I had to make a separate copy of mostly everything (includes, modules, misc, etc. everything except for database) in htdocs and duplicate it in /home. It now works fine, from both locations. The $base_url was left, in sites/mysite.com/settings.php, as http://mysite.com <http://mysite.com> . Questions/issues: 1. Is it really necessary to have those Drupal files in both locations (htdocs and htdocs/home)? 2. My "Administer" -> "Settings" page in Drupal is complaining that it no longer has access or permissions in the /file directory, despite my having used chmod 755 . to adjust permissions on the directory and the files within. Thanks, Shari Shari L. Halter Web Programmer, Corporate Services Thornton Tomasetti 51 Madison Avenue New York, NY 10010 T 917.661.7800 F 917.661.7801 D 917.661.7970 SHalter(a)ThorntonTomasetti.com <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> The information in this email and any attachments may contain confidential information that is intended solely for the attention and use of the named addressee(s). This message or any part thereof must not be disclosed, copied, distributed or retained by any person without authorization from the addressee. If you are not the intended addressee, please notify the sender immediately, and delete this message. <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

2 1