support August 2007

support@drupal.org

74 participants
81 discussions

Problems installing drupal
by Sauro Cesaretti 22 Aug '07

22 Aug '07

Hello, I'm trying to install drupal 5.2 in netsons host one free host with php and mysql. While I was configuring drupal with the db parameters, I received these following messages: The following error must be resolved before you can continue the installation process: We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user ' userid'@'%' to database 'dbname'. How can I solve this kind of problem? In the worst case that I can't solve it, can you give me some indications about Free hosts with php and mysql where I can try to Install drupal? Thanks in advance for all information Best regards, Sauro

4 4

Google analytics tracking script
by The Janitor 22 Aug '07

22 Aug '07

22 August 2007 - 06:55 (where I live) support(a)drupal.org Hello list members, Ive just set up a Google analytics account for my first Drupal site using the abac template. I have to include a tracking script on pages that I want 'tracked' but Google says to place the script just above the closing 'body' tag. I'm at a loss to translate this instruction when dealing with PHP - can somebody point me in the right direction, please. Many thanks. -- Best regards, The Janitor mailto:thejanitor@fastmail.fm Flying with The Bat! Professional version 3.99.3 Privileged and/or confidential information and/or copyright material may be contained in this e-mail.If you are not the intended recipient or the person responsible for delivering it to the intended recipient you must not copy it,deliver it to anyone else or use it in anyway whatsoever.To do so is prohibited and may be unlawful. Instead, kindly destroy this message and notify the sender by reply e-mail. Fe all fod gwybodaeth freiniol a/neu gyfrinachol a/neu ddeunydd dan amodau hawlfraint y neges e-bost yma. Os nad y chi sydd i fod gael y neges, neu'r un sy'n gyfrifol am ei throsglwyddo, rhaid i chi beidio a'i chopio na'i throsglwyddo i neb un arall na'i defnyddio mewn unrhyw fodd o gwbl. Mae gwaharddiad ar i chi wneud hynny ac efallai y byddech chi'n torri'r gyfraith trwy wneud hynny. Dinistriwch y neges yma ac anfonwch neges e-bost at y sawl a'i hanfonodd i roi gwybod iddo fe. The author recommends NOD32 (www.eset.com) as the most effective and efficient anti-virus software.

3 2

Content Editing, no Display problem
by sander-martijn 22 Aug '07

22 Aug '07

tinyMCE has intelligently populated my styles menu and the class menu in insert/edit link with a few of my classes. That would be great if it worked, but whether I select Class>arrow in the insert link popup or whether I select the link and select style>arrow it doesn't apply the class to the link. At first I thought this was a tinyMCE problem, but then I clicked "disable rich text" and manually wrote in the class into the html and it still stripped it. So I finally dug into the database, discovered the content is held in the node_revisions table and saw that indeed it IS saving my class with the link, which means it's stripping it on display. I'm set to Full HTML, so why is it doing this? More importantly, how do I get it to pass this info through? .s

1 1

Change home page from story to page?
by sander-martijn 21 Aug '07

21 Aug '07

When I first set up my site, I added a story to the home page which now appears there but isn't editable from the home page. Can this be changed? I do want the home page to have other elements such as news stories that have been promoted to the home page, so maybe this is the only or best way to do it. but i think the best case would be for an editor to be able to edit the main home page content from there rather than to have to go looking for it.

7 16

The quest for a fully Bi-Lingual site
by Neil: esl-lounge.com 21 Aug '07

21 Aug '07

Well, tri-lingual to be precise but you get the idea. I am trying to put together an Italian/English/Spanish site and I'm about 95% there. But there seem to be some real problems and I thought I would come to the all-wise Drupal mailing list to see if I could get some help with at least a few of them. I have put together a short list of the strings that are still causing me problems - things I don't know how to translate. I've also added a few possible solutions, ideas I've had for each. Any help given on this subject will be much appreciated. 1. Logo in English: we have a logo with an English tagline. Solution: Drop the tagline from the logo Solution: work out how to do conditional statements with the main site logo in drupal. Solution: leave at it is. It's only a tagline, afterall! 2. Pre-fill "enter keyword here" in search box. In our search box, we have this entered by default in the text box using Javascript: <input type="text" id="indexsearch_box" name="search" value="enter keyword here" onFocus="this.className='active'; if(this.value=='enter keyword here')this.value='';" onblur="if(this.value=='')this.value='enter keyword here';this.className='passive';"> Solution: drop it completely. How important is it? Solution: Try to find a way of doing php conditional statements with the javascript that is producing this. Not optimistic about that. Solution: Leave as it is. 3. Contact form dropdown. We use the site-wide contact form and on that page, there is a Category dropdown for people to specify what they are writing about. These are not translatable, it seems. Solution: lose the category dropdown. How important is it really? We could theoretically select to have different categories of mail go to different addresses but are we really going to do that? We already have the subject text field. That suffices, I think. Solution: different contact forms for different languages. This is a realistic possibility. Others have done it. It requires making new forms from cck, but the problem is that you need to make a submittable form, which is not as simple as making a static content type. How hard is this to do? I have seen others suggesting using ONE other type of contact form for another language...we may end up with 5-6 other languages so we need an expandable solution. Solution: Leave as it is - I think this is a little bit too much English for an Spanish/Italian user though and looks "ugly". Solution: send Italian users, for example, who click the footer link to an Italian contact page (simple enough, we already use conditional php for our menus to alter link text and URL destinations) where you just have a simple mailto link. Cheap and cheerful. It's the cheap version of solution 2. 4. CCK dropdowns. Most of our CCK fields are location-based dropdowns (in profile) or empty fields for text to be submitted in. The labels are translatable....Nationality, Address, Age, etc. The problems come from fields where we have entered "Allowed Values" which can't be translated. For example, we have a CCK field in our nodeprofile "Hobbies" where we have a dropdown list with 20 hobbies that users can select multiple items from. What solutions exist for CCK field allowed values? We could turn them all into free form text fields but then we lose control over the imputted values totally. 5. Forum descriptions and container names. We have a container called "Regions" which we can't translate. We have other regions called "Site Information" and "Site Help" which seem again untranslatable. Worse, we have forums whose descriptions read something like "Post here to ask questions relating to Central America". How can this be translated? Solution: drop the descriptions. Forum titles make it obvious what goes where. This is not really true and there'll be confusion. Solution: put short, succint descriptions. Trim down the fat from sentences. "Central America Forum" is better. But what about descriptions of other general forums such as "Requests for help. Unsure how to do something? Ask your questions here." They can't be simplified. Solution: the forum link for Spanish and Italian speakers can be changed. They could be sent directly to their own forums, which will exist. They would still have the breadcrumb links to be able to navigate up to the top level but it's a better solution. Even more, we can give them their own sub-forums for Help, Suggestions, etc just as there are for English speakers. Italians and Spanish speakers would quickly learn that the main Forum link brought them to "their" forum area even though English speaking forums existed. Solution: is there any way to hack forum.module to get forum descriptions wrapped in t strings or is this a big no no? Once again, thanks for any assistance that you can give me on these issues. Neil

2 1

PHP error "Duplicate entry" (problem with themes)
by Paul West 21 Aug '07

21 Aug '07

Hi all please help, In my log I am getting hundreds of duplicate entry php errors I will paste a few of them they are all related to the theme engine. I am running a custom theme called redwood. all other default themes are not enabled. The site has been up and fine for a while this is a new problem but I haven't changed anything major recently. I'm running Drupal 4.7.4 with PHP templates. Duplicate entry 'themes/engines/theme_editor/theme_editor_engine.engine' for key 1 query: INSERT INTO system (name, type, filename, status, throttle, bootstrap) VALUES ('theme_editor_engine', 'theme_engine', 'themes/engines/theme_editor/theme_editor_engine.engine', 1, 0, 0) in /usr/local/drupal/drupal/includes/database.mysql.inc on line 121. Duplicate entry 'themes/bluemarine/page.tpl.php' for key 1 query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('bluemarine', 'themes/engines/phptemplate/phptemplate.engine', 'theme', 'themes/bluemarine/page.tpl.php', 0, 0, 0) in /usr/local/drupal/drupal/includes/database.mysql.inc on line 121. Duplicate entry 'themes/chameleon/marvin/style.css' for key 1 query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('marvin', 'themes/chameleon/chameleon.theme', 'theme', 'themes/chameleon/marvin/style.css', 0, 0, 0) in /usr/local/drupal/drupal/includes/database.mysql.inc on line 121. Duplicate entry 'themes/chameleon/marvin/style.css' for key 1 query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('marvin', 'themes/chameleon/chameleon.theme', 'theme', 'themes/chameleon/marvin/style.css', 0, 0, 0) in /usr/local/drupal/drupal/includes/database.mysql.inc on line 121. One option I am looking at is if I can hardcode path_to_theme() in the tpl files? Would this help? Please help, Paul West Web Developer Redwood Software

1 0

counting nodes
by Fred Jones 20 Aug '07

20 Aug '07

I have a new site with a custom node type--each node is also a product for the ecommerce. Each node is assigned a taxonomy term. We want to monitor the number of nodes of each taxonomy term which are not sold. The site owner wants to receive an email if the number of available 'products' falls below 25 so that he can make more. This is not an inventory issue--each product only has a quantity of one--this is a 'catalog' issue. I figured the only solution is a little custom module that checks that number of products available in each category and if it's < 25, send an email. Is that the right way? If so, are there any nice API calls I can use to make this check? I am not a real Drupal expert so my first thought of course it just to write the raw SQL, but I imagine there is a far more elegant approach. Thanks, Fred

1 0

Image questions
by sander-martijn 20 Aug '07

20 Aug '07

I'm having some trouble getting a grasp on what to use when and where for images. There are so many modules available but from my explorations so far I can't figure out which one to use in which case. I've been spending a good amount of time searching through the forums, reading through HOW TOs, and downloading in installing some modules to test them out. My question: Is there a good place that discusses various approaches to images in drupal in a clear way? The image requirements for this site are fairly complex, so outlining all of them and asking how to do each one is probably not the best way - so I'm hoping there's already some good info out there somewhere that I've missed. A list of the routes I've taken so far that seem to half solve some of the problems but definitely not all of them: Upload Image (plus Image Attach, Image Gallery, Image Import) IMCE Node Images An example of half solving: random image only displays a thumbnail and it's random across all images. I can't imagine to whom that would be useful to be honest. What is useful is to randomly display an image at a specified size (or at least choose between thumbnail and full size), to select a directory to choose the images from and to have a straight forward way for an end user to upload, delete etc those images.

3 2

different TinyMCE problems
by Jean Gazis 20 Aug '07

20 Aug '07

I installed it, set up roles etc. It seemed to work fine with the first custom content type. A few days later, it does not. In between I installed Views and Viewfield, and created a new content type. What I'm getting is, instead of formatted text, e.g. bulleted list, it just puts <br> or <div> between the items and removes the line breaks, like this: "vegetable<br /> fruit<br /> vegetable<br /> fruit<br /> fruit<br /> vegetable<br /> veggie<br /> fruit <br /> veg" I'm sure this is some stupid thing I could figure out somehow, but I can't figure out where to start. -- Jean Gazis www.jeangazis.com www.boxofrain.us "Believe those who are seeking the truth; doubt those who find it." - André Gide

5 12

Menu question
by sander-martijn 17 Aug '07

17 Aug '07

I want to customize my menus, but since I want it to work with the html/css/javascript code I've already written and tested I want to get the system to output the menu in html as I want it. Actually what I need is quite simple. I don't really want to try to customize someone else's module and I'd rather not build one. After some digging around I figured out that I could override the theme_menu_links method in my template.php file. Now that's exactly what I need... I got really excited but I must have some things missing/misunderstood. what I have in the menu system under primary links: primary links - menu item 1 - menu 1 subitem 1 - menu 1 subitem 2 - menu item 2 - menu 2 subitem 1 etc - fairly standard What I need to output is the following: <ul id="nav1" class="nav"> <li><a href="#">menu item 1</a> <ul> <li><a href="#">menu 1 subitem 1</a></li> <li><a href="#">menu 1 subitem 2</a></li> </ul> </li> </ul> <ul id="nav2" class="nav"> <li>menu item 2 <ul> <li><a href="#">menu 2 subitem 1</a></li> </ul> </li> </ul> etc. - also pretty straight forward. SO - I put in page.tpl.php the following: <?php print theme('menu_links', $primary_links); ?> and put in template.php the following: function tpg_menu_links($links){ if (!count($links)) { return ''; } $level_tmp = explode('-', key($links)); $level = $level_tmp[0]; $output = "<ul id=\"nav\" class=\"nav\">\n"; foreach ($links as $index => $link) { $output .= "<li>". l($link['title'], $link['href'], $link['attributes'], $link['query'], $link['fragment']) ."</li>\n"; } $output .= '</ul>'; return $output; } ?> Which is basically a modified version of theme_menu_links in menu.inc It works as a start, but there are a couple of issues. 1. even though my class attribute in $output is hard coded, it's still being replaced by class="active" when you're on the page. Not a disaster, i can always modify my css to do the same thing for class="active" as class="nav". 2. this is the bigger issue. It's not outputting the subitems. I'd be happy to add in the proper call in the foreach loop to either call another function that i also override or to load them directly in here if anyone can point me in the direction of what i need to call in order to load them.

3 10

← Newer
1
2
3
4
5
6
7
8
9
Older →

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

support August 2007