September 2012 - support - lists.drupal.org

D6 Imagecache / Apache weirdness
by Jeff Greenberg 14 Sep '12

14 Sep '12

I'm posting this here rather than the imagecache queue, because it appears to be more of an Apache issue than a problem with imagecache. Lots of hair pulling boiled down to this: 1. If a request is made for an image that exists in the imagecache directory, it is served up 2. If a request is made for an image that is Not in the directory (i.e. default/files/myfile.jpg, the request being default/files/imagecache/100x27/myfile.jpg), Apache returns a 500 error 3. The 500 error is returned WITHOUT hitting index.php 4. default/files has the correct ownership and, for now, 777 permissions

2 1

extremely simple php snippet with unknown error
by Anthony 14 Sep '12

14 Sep '12

Why am I getting this output Bob's Auto Parts Order Results Order processed DW " ; ?> from this code <html> <head> <title>Bob's Auto Parts - Order Results</title> </head> <body> <h1>Bob's Auto Parts</h1> <h2>Order Results</h2> <?php echo "<p>Order processed DW </p>" ; ?> </body> </html> Tearing my hair out. -- *Anthony Stefan Maciejowski* -- *Anthony Stefan Maciejowski*

5 4

SOLVED D6 - Odd AJAX behavior
by Jeff Greenberg 13 Sep '12

13 Sep '12

Ah, never mind. Turns out there WAS a difference in the apache config...a bad rewrite rule.

1 0

D6 - Odd AJAX behavior
by Jeff Greenberg 13 Sep '12

13 Sep '12

Have a fairly straight-forward D6 site except that it's set up to have an admin. which has it's own settings file, for the purposes of using https, not using memcache, and having a separate cookie...everything else including the db is set the same. Created a new module with a menu callback of api/mymodule/ajax which returns html that is used to add another row of teasers to a display. Calling it in .click() via .ajax() On my local system, it all works fine, whether www. or admin. When it's moved to qa servers, admin. works fine but www. returns a 301 and redirects to the front page. Can't think of anything (other than something deliberate) that would have the new callback (whether via the link or entering it in the browser) result in a 301 in one case but not the other. -- --- drupal.org/user/367108 linkedin.com/in/jeffrgreenberg accidentalcoder.com / ayendesigns.com @accidentalcoder

1 0

Views2: Integrate custom table using two key identifiers
by Hadubard 12 Sep '12

12 Sep '12

Hi, is it possible to integrate a custom table into the views2 world that needs a two column match for the join? The code I have right now (in a hook_views_data implementation) is this: $data['custom_table']['table']['join'] = array( 'users' => array( 'left_table' => 'other_custom_table', 'left_field' => 'field_1', 'field' => 'field_1', ), ); This is working for the moment, but I need to bind in another join criterion on another field, in pseudo-code that would be something along these lines: $data['custom_table']['table']['join'] = array( 'users' => array( array( 'left_table' => 'other_custom_table', 'left_field' => 'field_1', 'field' => 'field_1', ), array( 'left_table' => 'other_custom_table', 'left_field' => 'field_2', 'field' => 'field_2', ), ), ); The resulting query would resemble this: SELECT ... FROM cutomer_table c1 LEFT JOIN other_custom_table c2 ON (c1.field_1 = c2.field_1 AND c1.field_2 = c2.field_2) Is this possible with views2? Thanks for any thoughts, best regards, berliner

1 0

Config issue on my site.
by Anthony 11 Sep '12

11 Sep '12

On my remote site tony-mac.com I tried to install media module but got an error when I tried to enable it (in drush) about not enough memory. So i deleted the single line php.ini file, whose 1 line command was saying increase memory to 128m, in the root of the drupal install and then went and changed the memory setting in php.ini file in the root of the site - dir above public_html. Then added 128 memory line to settings.php. (and as I still have not figured out how to get site aliases to work I can not connect and sync to local site, which I know I should have one before messing with the remote). Still getting: *PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'to nymacc_drp2.dr_media_type' doesn't exist: SELECT mt.* FROM {media_type} mt ORDER BY weight ASC; Array ( ) in media_type_get_types() (line 134 of /home3/tonymacc/public_html/drupal/sites /all/modules/media/includes/media.types.inc). Drush command terminated abnormally due to an unrecoverable error. [error] Drush was not able to start (bootstrap) Drupal. [error] Hint: This error can only occur once the database connection has already been successfully initiated, therefore this error generally points to a site configuration issue, and not a problem connecting to the database. Drush was attempting to connect to : Drupal version : 7.14 Site URI : http://default Database driver : mysql Database hostname : localhost Database username : tonymacc_drp2 Database name : tonymacc_drp2 Database : Connected Default theme : omega_html5_tony Administration theme: seven PHP configuration : /etc/php.ini Drush version : 5.4 Drush configuration: Drupal root : /home3/tonymacc/public_html/drupal Site path : sites/default Modules path : sites/all/modules Themes path : sites/all/themes File directory path: sites/default/files Private file directory path: temp : /home3/tonymacc/public_html/drupal/tempdir %paths : Array You can select another site with a working database setup by specifying the URI to use with the --uri parameter on the command line or $options['uri'] in your drushrc.php file. * How can I get a backup restored? How can I fix? Bluehost backup has f^%&ed me up in the past. Thanks Tony -- *Anthony Stefan Maciejowski*

2 6

Drupal 7 AHAH/AJAX issue
by Kamal Palei 11 Sep '12

11 Sep '12

Hi List I am trying to learn ajax stuff in Drupal 7. I want to have a simple questionnaire form. Where I will have a single textfield. In that text field one will type a question category, and if he wants to type more question categories, user need to click a button "Add More Categories". Please see link http://www.netcloudsystems.com/?q=questionnaire/form/manage The whole source code is at the end of this email. When ajax callback fires, I want to remember how many textfields I need to add, so that when a section of form is updated in _form() hook, I can according add those many textfields. I am trying to manage that using a variable "$all_categories" and form element $form['all_categories'] (of type value). I tried many options, always I find $all_categories value is 1. So I am unable to add more textfields. My observation is whatever I set in ajax callback, in _form hook api, I find value is lost. Kindly guide me what I am missing. Best Regards Kamal *NECS, Bangalore* *<?php* *function questionnaire_menu() { $items = array(); $items['questionnaire/form/manage'] = array( 'title' => t('Manage questions'), 'page callback' => 'questionnaire_form', 'access arguments' => array('question manage'), 'type' => MENU_SUGGESTED_ITEM, );* * return $items; }* *function questionnaire_permission() { return array( 'question manage' => array( 'title' => t('Question management'), 'description' => t('Provides question management capability'), ), ); }* ** ** *function questionnaire_form() { return drupal_get_form('questionnaire_my_form'); }* ** ** *function questionnaire_my_form($form, &$form_state) { $form_state['cache'] = TRUE; $all_categories = !empty($form_state['values']['all_categories']) ? $form_state['values']['all_categories'] : 1; * ** * $form['all_categories'] = array( '#type' => 'value', '#default_value' => $all_categories, '#value' => $all_categories);* ** * // The prefix/suffix provide the div that we're replacing, named by // #ajax['wrapper'] above. $form['category_fieldset'] = array( '#title' => t("Questions Categories"), '#prefix' => '<div id="category-div">', '#suffix' => '</div>', '#type' => 'fieldset', '#description' => t('Please enter the question categories'), );* * for ($i=1; $i<= $all_categories ; $i++) { $key = 'ctg' . $i; $form['category_fieldset']['category'][$key] = array( '#type' => 'textfield', '#title' => "Question category $i", ); } * * $form['category_fieldset']['add_more_category'] = array( '#type' => 'submit', '#value' => t('Add More Categories'), '#ajax' => array( 'callback' => 'questionnaire_category_callback', 'wrapper' => 'category-div', 'method' => 'replace', 'effect' => 'fade', ), ); $form['submit'] = array( '#type' => 'submit', '#value' => t('Submit'), ); return $form; } * ** *function questionnaire_category_callback($form, &$form_state) { $form_state['values']['all_categories'] = $form_state['values']['all_categories'] + 1; return $form['category_fieldset']; }* ** *?>*

2 2

changing dtabase password question
by Katie Legere 11 Sep '12

11 Sep '12

I want to change that main connection password to our drupal database (we've had a potential security breach) without effecting the user experience in a bad way. I know the connection is in settings.php and how to use phpMyAdmin, mysql etc. My question is... can I just create a new user and password in phpMyAdmin for my drupal database and then flip to that in my settings.php (during a time I don't expect anyone using it) and expect that all will be well or is there a better / safer process to follow? Has anyone done this? Katie

3 3

development copy of site fails
by Bert Van Kets 10 Sep '12

10 Sep '12

Hi people, I have been asked to make changes to a Drupal 6 site that was _not_ developed by me. To make sure the changes don't break anything I want to set up a local copy of the site. The first thing I need to do is remove a Google Maps install. This is done using modules and not in the theme files. When starting the local copy the Google Maps script tells me I need a new key and then throws me to the home page. I can log in as admin, but the message for the Google maps key keeps popping up and throwing me to the home page. I disabled every module containing gmaps in the name directly in the database, but that didn't change a thing. I assumed the key was linked to the domain name, but even setting the URLs in the hosts file and creating new virtual hosts in Apache didn't solve the problem. No matter what page I request I still get only the home page and can't get into the admin pages. I then pointed maps.google.com to the 127.0.0.1. That got rid of the request for a new key, but nothing else changed. :-( I even removed the theme directories. That only remove the styling, but not the problem of the stuck home page. I am totally stuck. I really need to get this site totally functioning to be able to do the changes. Any tips are appreciated. Bert

5 8

Re: [support] blocks do not display
by Roger 10 Sep '12

10 Sep '12

On 09/10/2012 10:13 AM, support-request(a)drupal.org wrote: > <1347211403.55137.YahooMailNeo(a)web181606.mail.ne1.yahoo.com> > Content-Type: text/plain; charset="iso-8859-1" > > My advice, which most will, I am sure, agree with is to not mess with a core install. Don't second guess which tables are needed. Most tables are created only when a feature/module is enabled. Therefore, they are all needed. If you don't want certain tables, don't install the module that creates them. > > The cache tables are required even if you have caching disabled. Regardless of that setting, your system is caching. Likewise, the registries (more than one) are required and cannot be missing. > > > Backup and Migrate doesn't create tables, AFAIK, it just makes backup files. > > Who told you that OG does not play well with Panels? The fact is that OG would prefer to create panels for you. > > ? > Nancy > > Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. Thank you Nancy. I'll try og with panels, on your recommendation, it may solve a problem. However nat and workbench are two that I do not want in the new sandpit and neither can be removed just by switching off and deleting the modules. Workbench in particular once initiated, seems very difficult to eliminate. I'm not messing with or second guessing core. I understand that most tables are created when a module is installed but the problem is that these are difficult to remove as are the fields placed in other tables which reference those modules. I was not clear on what I've done and what I propose to work on for the next development step. I have an installed fresh drupal 7 sandpit installation with all of the modules core modules and modules we use in the live system. I have not installed Workbench and nat in the sandpit. I intend to use panels to build displays, and as panels also provides for isolating users and displays I may not even need og. I have 20+ taxonomy vocabs with associated terms most referenced in some way or with relationships to other taxonomy or content types. 50 users with permissions and 30+ roles. I have 14 content types and plenty of content in each. I have 25 rules. Nat and workbench seem to have fields in most of the content types and taxonomy tables and this causes error messages and other problems when nat and wb are not installed. I need to have just the field structure and data for content types, content, taxonomy, users, roles, rules and permissions in the sandpit and have tried backup-migrate and mysql to create and populate just those tables. As an aside, if I do a mysql install of backup-migrate of the database and do not have the live site Mayo theme, but instead have the Adaptive sub theme, nothing works. I hope my explanation goes some way to understanding the problem and why I am asking for assistance. thanks Roger

1 1