June 2006 - support - lists.drupal.org

Script to change collation on all mysql tables?
by Anisa 07 Dec '06

07 Dec '06

A lot of people, upgrading from 4.6 to 4.7, or having phpmyadmin issues, are interested in a script or some sort of file that will change the collation to utf8_general_ci on all tables. Anyone have any ideas? I want to add it to the handbook. I think it would be pretty easy to make a sql thingy for default tables, how do you deal with prefixes? Anisa. OOO! How about a list of tablenames in the handbook... -- ********************************* www.AnimeCards.Org 16,000 scans and counting! *********************************

4 4

Re: [support] Drupal vs. Mambo/Joomla
by Kobus Myburgh 29 Aug '06

29 Aug '06

Hi, What looks good to some is not necessarily good for others, and what looks bland to you, may be actually quite nice. If the sites listed here [1] and here [2] and here [3] and here[4] are bland in your opinion, then perhaps you'd be better off making your own. Note that not all these theme are available for download, some of them are only sites spotted that looked good in the submitter/site owner's opinion. [1] http://blog.photos2view.com/taxonomy/term/84/ [2] http://www.drupalshowcase.com/ [3] http://drupal.org/image/tid/41 [4] http://www.drupalsites.net Regards, Kobus >>> pherowze(a)gmail.com 6/13/2006 4:04 PM >>> Hello, Now I am designing a school site... The specifics are the following... I need a forum and a customisable registration form/login and also an easy to use GUI. However the most important part of all of this is that I have to be able to make templates easily...... Now what I needed to know is whethere there are any good looking Drupal sites out there.. the ones I have come across look bland... I have used drupal and have to admit it is superior in handling of information in terms of management e.t.c. however I have found that in terms of appearance and useablitity Joomla/Mambo tend to look better... Is there any way around this?

6 5

Menus and Snippets
by Pherowze 15 Aug '06

15 Aug '06

I am currently working on a website and I want a frontpage snippet and a small image like the site http://www.falanx.hu/ Is there a module I can use to achieve this? -- Warmest Regards, Pherowze

4 7

Re: [support] Moving to a new host
by Kobus Myburgh 11 Aug '06

11 Aug '06

Gordon and all, Thanks for all your help. The host has found some issue on the server thanks to your troubleshooting, and is investigating a possible solution. In the meantime he asked if I could ask the list if it is possible to put a port number in the $db_url for the database server? in other words, something like: $db_url = 'mysql://drupaluser:mypassword@111.111.111.111:3307/drupaldb'; where 111.111.111.111 is the MySQL database server? My gut feeling is that the string will not get parsed correctly, because of the fact that there is a : already in the $db_url after the drupaluser. Any ideas on this, please? Thanks! Kobus >>> gordon(a)heydon.com.au 5/19/2006 2:33:06 PM >>> Hi, How far through the init is it getting? If you want contact me in #drupal-ecommerce, and I will give you a hand Gordon. Kobus Myburgh wrote: > Hi, > > I have moved one site from a temporary domain located on my US host to > a local South African host, and the site won't work on the new host - > just displays a blank screen. At first I thought I did something wrong, > but then I did a blank install of the latest Drupal and that won't work > either. My conclusion is that my web host has something wrong on the > server. > > I have added a phpinfo.php file on the US account where the site is > currently (temporarily) hosted and also one on the new hosting space > (final host), and both show the PHP info correctly, in other words, PHP > is running on the new host, but there still is something wrong. There > are many differences between the outputs of the PHP info in the > different instances, but I don't know the significance thereof. > > The SA host, for example, uses PHP 5.1.4 and the US host PHP 4.4.x. I > doubt that should be an issue, but that is unfortunately the only thing > there that is significant for a person with my skillset, and therefore > am wondering if someone is willing to look at the different phpinfo() > outputs and perhaps tell me where the problem lies (if the problem is > hidden in there somewhere)? > > If so, please let me know so I can send you the URLs for the > phpinfo.php file, as I am not sure how sensible it is to send that info > over to a public mailing list. > > Hope someone can help, as the person I am doing the site for is getting > somewhat peeved off with me being unable to get the site up and running > :-( > > Thanks in advance! > > Kobus > -- [ Drupal support list | http://lists.drupal.org/ ]

4 4

create company website using drupal
by Adrian Mak 03 Jul '06

03 Jul '06

I'm new on drupal. I want to use it to create a normal company website which with a navigation bar including links like for example about us services products solutions contact us All contents of the about is only administrate and create by company's web adminisatrator therefore it's not necessary to show a "user login" for people to registeration. Then I first create a "About us" but every time I access the site e.g. http://www.mycompany.com It will display a "user login" block if browser session is not logged in. How do I configure such that anonymous people just browse the website's contents I created without showing the "user login"block I found some show cases developed using drupal, they don't present with a user login block http://www.latuk.com/ http://www.tacticaltech.org/ how they did it ? ps. the layout something like http://images.templatemonster.com/screenshots/11300/11346-b.jpg you can see that this type of website is not necessary to provide user registration function

3 2

Drupal Homepage
by Phares Kariuki 30 Jun '06

30 Jun '06

Does anyone know how the custom header in the drupal homepage was achieved...? The section where they announce that drupal 4.7 is out... and also next to it requesting that someone views their webcast on what is different in drupal 4.7..... Thanks... Phares K. Kariuki

3 3

Providing ownerships of a subset of the site to user/group
by Fran Fabrizio 30 Jun '06

30 Jun '06

We are investigating Drupal for our department web site. Right now there is a person or group of persons responsible for each part of the site. When we convert to Drupal, what's the easiest way to give a user or role permission to "own" (i.e. the only ones who can edit that section) a set of pages without giving them permission to edit all pages or to publish pages outside of that area? Is there a module that is set up to handle this sort of "sandbox" model? Concrete example (we are a department in a university). One of our faculty members is in charge of all the pages dealing with the graduate program. In our current site, this translates to all pages in the /graduate area. He owns all of the files in that folder, and can only publish new content to that folder. Another person is in charge of the undergraduate program (/undergrad), a third person is in charge of the continuing education program (/conted), and so on. How best to model this in Drupal? Is this something that Drupal is well-suited to handle? Thanks! -- Fran Fabrizio Senior Systems Analyst Department of Computer and Information Sciences University of Alabama at Birmingham http://www.cis.uab.edu/ 205.934.0653

2 3

RE: [support] Providing ownerships of a subset of the siteto user/group
by Metzler, David 30 Jun '06

30 Jun '06

Correct, just a separate database and a separate "files" directory for uploading of images, documents etc. http://www2.evergreen.edu/dave http://www2.evergreen.edu/itch http://www2.evergreen.edu/ITTrainingRoom Are three sites hosted from the instance of drupal (same php, themes, modules, etc) against different databases. I'm running on linux, apache, mysql. Technically each of these directories are just symbolic links to the one drupal code base. To make it really easy to manage, I've developed some shell scripts to create sites by cloning mysql databases, making a few symbolic links, directories, and building a custom settings.php file. -----Original Message----- From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fran Fabrizio Sent: Friday, June 30, 2006 4:49 AM To: support(a)drupal.org Subject: Re: [support] Providing ownerships of a subset of the siteto user/group By separate database, do you mean separate instance of drupal? Or does it use all the same PHP/CSS/themes/etc... install but just have a diff. mysql db? Metzler, David wrote: > The way we are using this is that we actually create a separate > database for each site section. The look and feel is controlled > centrally as all sites have the same "theme" applied, but each site > has its own separate database. Then you establish different roles for each site, but all are > using the same "code base". > > You can also set a similar thing up in the same database, but you need > to do the multi-site install. I find that to be more complicated than > it's worth, but others find it quite valuable. > > David Metzler > The Evergreen State College > > -----Original Message----- > From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] > On Behalf Of Fran Fabrizio > Sent: Thursday, June 29, 2006 3:45 PM > To: support(a)drupal.org > Subject: [support] Providing ownerships of a subset of the site to > user/group > > > We are investigating Drupal for our department web site. Right now > there is a person or group of persons responsible for each part of the site. > When we convert to Drupal, what's the easiest way to give a user or > role permission to "own" (i.e. the only ones who can edit that > section) a set of pages without giving them permission to edit all > pages or to publish pages outside of that area? Is there a module that > is set up to handle this sort of "sandbox" model? > > Concrete example (we are a department in a university). One of our > faculty members is in charge of all the pages dealing with the > graduate program. In our current site, this translates to all pages in > the /graduate area. He owns all of the files in that folder, and can > only publish new content to that folder. Another person is in charge > of the undergraduate program (/undergrad), a third person is in charge > of the continuing education program (/conted), and so on. > > How best to model this in Drupal? Is this something that Drupal is > well-suited to handle? > > Thanks! > > > -- > Fran Fabrizio > Senior Systems Analyst > Department of Computer and Information Sciences University of Alabama > at Birmingham http://www.cis.uab.edu/ > 205.934.0653 > -- > [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]

2 1

RE: [support] Providing ownerships of a subset of the site to user/group
by Metzler, David 30 Jun '06

30 Jun '06

The way we are using this is that we actually create a separate database for each site section. The look and feel is controlled centrally as all sites have the same "theme" applied, but each site has its own separate database. Then you establish different roles for each site, but all are using the same "code base". You can also set a similar thing up in the same database, but you need to do the multi-site install. I find that to be more complicated than it's worth, but others find it quite valuable. David Metzler The Evergreen State College -----Original Message----- From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Fran Fabrizio Sent: Thursday, June 29, 2006 3:45 PM To: support(a)drupal.org Subject: [support] Providing ownerships of a subset of the site to user/group We are investigating Drupal for our department web site. Right now there is a person or group of persons responsible for each part of the site. When we convert to Drupal, what's the easiest way to give a user or role permission to "own" (i.e. the only ones who can edit that section) a set of pages without giving them permission to edit all pages or to publish pages outside of that area? Is there a module that is set up to handle this sort of "sandbox" model? Concrete example (we are a department in a university). One of our faculty members is in charge of all the pages dealing with the graduate program. In our current site, this translates to all pages in the /graduate area. He owns all of the files in that folder, and can only publish new content to that folder. Another person is in charge of the undergraduate program (/undergrad), a third person is in charge of the continuing education program (/conted), and so on. How best to model this in Drupal? Is this something that Drupal is well-suited to handle? Thanks! -- Fran Fabrizio Senior Systems Analyst Department of Computer and Information Sciences University of Alabama at Birmingham http://www.cis.uab.edu/ 205.934.0653 -- [ Drupal support list | http://lists.drupal.org/ ]

2 1

RE: [support] mailing error in general
by Metzler, David 29 Jun '06

29 Jun '06

The answer depends on whether your server is linux or windows. There are PHP specific settings in the php.ini file that control this behavior. The linux ones rely on a properly installed and configured sendmail, the windows ones just require you to provide the server that you're sending mail to. Here's what the php.ini settings look like. [mail function] ; For Win32 only. SMTP = localhost ; For Win32 only. sendmail_from = me(a)localhost.com ; For Unix only. You may supply arguments as well (default: "sendmail -t -i"). sendmail_path = /usr/sbin/sendmail -t -i -----Original Message----- From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Liktor Tibor Sent: Thursday, June 29, 2006 7:44 AM To: support(a)drupal.org Subject: [support] mailing error in general Hi all, I experienced funny things on my newly installed site: Drupal can't send emails, like I can't send newsletters with Simplenews, and I assume that the contact forms also don't work. This server uses PHP 4.4.1 which I wouldn't touch due to various reasons. My question is: what PHP configuration Drupal needs exactly to send mails? It is quite important for me, so any help will be more that appreciated. Best regards, Tibor -- [ Drupal support list | http://lists.drupal.org/ ]

1 0