- support - lists.drupal.org

Re: [support] support Digest, Vol 97, Issue 32 Drupal server ccopy
by Roger 14 Jan '11

14 Jan '11

> Did your new installation server support MySQLi ? If not then change > settings.php. Make it like this : > $db_url = 'mysql://username:password@localhost/databasename'; > > On Fri, Jan 14, 2011 at 2:09 PM, Roger <arelem(a)bigpond.com> wrote: > Yes that the first thing I tried. I tried with the original settings.php and then the copied settings.php which was $db_url = mysql on the copy and on my pd mysqli so I changed that. I also tried changing password and user name, nothing helped It's got to be something I've overlooked! Roger

1 0

Move site from Web server to local on MAMP
by prothero 13 Jan '11

13 Jan '11

Folks: Drupal 6.19 I want to move my existing web site from my web server (it works fine) to my local MAMP installation. I'm doing this because I want to learn how to use ubercart without messing up my working web site. I have several working MAMP installations, but can't get the downloaded one to work. I've exported the web version and imported the database into the MAMP version. No problem. I've copied all of the files from the web site to the MAMP site. No problem. I've modified the setups.php folder to account for the MAMP port for the db and base URL port (8889 and 8888), I've run update.php with free access set to true. The front page shows up fine, BUT: Here's the problem: When I click on any of the menu buttons, I get a "The requested URL /node/51 was not found on this server." error. BUT: if I use http://baseURL/?q=node/4 address (for example), I get the page. But I have clean urls set to true and addresses like: http://baseURL/node/4 give me the "page not found" error. I also get this error with URL's like: http://baseURL/admin/settings/clean-urls I DO have cleanURL's turned on, but obviously there is something I need to change that I don't know about. What might be the problem? Thanks, for any help, Bill William A. Prothero http://earthednet.org/

2 2

Weird authentication popup coming up on my Drupal 6 site
by Victor Kane 13 Jan '11

13 Jan '11

Hi everyone, When I go to my Drupal 6 professional blog, http://awebfactory.com.ar , I get a popup (whether logged in or not) that says: "Authentication required" A username and password are being requested by http://dc2009.drupalcon.org. The site says: "drupalcon security lockdown" When I hit cancel, everything is OK, until I access another page and the same thing happens. It's Drupal 6, and I have just upgraded Drupal and all modules to latest release with no exceptions. I deleted the .htaccess and replaced it with a new one from the Drupal 6 release. But the weird popup continues. HEEEELLLLLPPPPP! Thanks, Victor Kane http://awebfactory.com.ar

4 5

Paypal Authorization & Capture API
by Denis Lafont-Trevisan 12 Jan '11

12 Jan '11

Hi, Any chance someone already integrated the Authorization & Capture API from Paypal? I need a behavior close to group buying (price change for everyone depending on que quantity purchased in a few days by everyone) and I'm stuck doing it simply. Cheers, Denis

1 0

Appointment module
by Mayur pimple 12 Jan '11

12 Jan '11

Hi user can select place add time slot in calendar and enter personal details after all information goes in to admin mail. how to do this process or is it available any module. please help me! -- Thanks & Warm Regards, *Mayur Pimple** | Raintek Solution * Skype: mayur.pimple Mobile: 9270367824 www.mayurpimple.blogspot.com We are the Representatives of the Modern World of Evolution.

2 1

How to set up an image gallery in drupal 7
by N Larsen 12 Jan '11

12 Jan '11

I am new to drupal 7 How to insert an image gallery in drupal 7? Please explain the whole procedure from which modules to install, how to upload the images, how to setup content type and how to insert the gallery in drupal 7 (please give details so other newbies can learn from this). PS: I am using the linux pan newsreader for several other mailing lists which I find more easy to use, I check pan several times a day and learn a lot :-) I have made a small minihowto about how to use pan: http://minihowto.org/pan-minihowto.txt I am already following "gmane.comp.php.drupal.support" on pan but this list is probably more about php which I do not know much about *smile*

1 0

Backup and Migrate
by Roger 12 Jan '11

12 Jan '11

I'm confused. I wish to recreate our drupal 6.19 server web site on my home pc. I used Backup and Migrate on our server drupal web site and downloaded a copy to my home pc. I read the Backup and Migrate drupal pages before proceeding. I did a fresh install on my home pc of drupal 6.19 with a database named the same as the server database. I used the same password and username. Used Backup and migrate to put the data into the home pc installation. Nothing worked, it was blank. I logged out as administrator and find that Log in fails because it does not recognise the password. What am I doing wrong? How can I recreate an exact copy of everything, including themes, changes to themes, images and everything else on the server to my home pc? Help much appreciated Thanks Roger

5 4

I want have pop ups
by pavithra m 12 Jan '11

12 Jan '11

" I have a button ADD ... when I click on the button I want to get a popup/modal window in which I will be having a form with 4 form fields. In the pop up/modal window I will be having 2 buttons --one SAVE and other CANCEL.... After I click on the SAVE in the popup/modal window I want to display the form entries as a table and I dont want that data to be saved into my database...I just want the data in the popup to be passed on to my screen where I had the ADD button so that I can just display it... I am having one more button together with ADD called DONE..on clicking the DONE i want to save the data to database..... I dont want to save from pop up because the ADD button can be clicked many times to add data... final DONE has to store the entire thing.." Is this possible? I know about LIGHTBOX2 module... but is this possible with this module..? Or shall I write a jquery for this... as a separate function/file? -- *Cheers* * *

3 2

creating pop-up window for delete and edit actions in table in module file
by mahesh gajabar 12 Jan '11

12 Jan '11

I have written a custome module table for showing some information which is fetched from database and every row is having edit and delete actions. Both are working fine. But whenever I click on on edit or delete action action it opens in other window leaving current page. I want these actions to be taken place in pop-up window. My table on drupal screen is as follows *SlNo* *Doctor Name* *Gender* *Status* *Action* 2 Jayaram Srinivasan male inactive Edit <http://localhost/fr/doctor/edit/2> | Delete<http://localhost/fr/doctor/delete/2> 3 Pavithra M female active Edit <http://localhost/fr/doctor/edit/3> | Delete<http://localhost/fr/doctor/delete/3> 4 Ravi Mandayam male active Edit <http://localhost/fr/doctor/edit/4> | Delete<http://localhost/fr/doctor/delete/4> when i click delete button i should get pop-up window with the dialogue like this; Are You Sure You Want To Delete This Doctor? This action cannot be undone. Cancel <http://localhost/fr/doctor> When I click edit button I should get my edit form, First Name: Last Name: Gender: male female Status: active inactive Cancel <http://localhost/fr/doctor> complete code of my module file is as follows: *<?php function doctor_menu() { $items = array(); $items['doctor'] = array( 'title' => t('Doctors'), 'page callback' =>'doctors_list', 'access arguments' => array('access doctor'), 'type' => MENU_NORMAL_ITEM, ); $items['doctor/delete/%doctor_user'] = array( 'title' => t('Delete doctor'), 'page callback' => 'drupal_get_form', 'page arguments' => array('doctor_delete_confirm', 2), 'access arguments' => array('access doctor'), 'type' => MENU_CALLBACK, ); $items['doctor/edit/%doctor_user'] = array( 'title' => t('Edit Form'), 'page callback' => 'drupal_get_form', 'page arguments' => array('doctor_edit_confirm', 2), 'access arguments' => array('access doctor'), 'type' => MENU_NORMAL_ITEM, ); return $items; } function doctors_list() { $header = array(t(Sl.No),t('Doctor Name'), t('Gender'), t('Status'), t('Action')); $query = "SELECT * FROM {doctor}"; $rs = db_query($query); $row = array(); if ($rs) { while ($data = db_fetch_object($rs)) { $doctorid = $data->doctorid; $gender = $data->gender; $status = $data->status ; $row[] = array($doctorid,stripslashes(ucwords($data->firstname)) . ' ' . stripslashes(ucwords($data->lastname)), $gender, $status, "<a href='doctor/edit/{$data->doctorid}'>" . t('Edit') . "</a> |<a href='doctor/delete/{$data->doctorid}'> ". t('Delete')."</a>" ); } } $str .= theme_table($header, $row); return $str; } function doctor_user_load($doctorid) { $query = "SELECT * FROM {doctor} WHERE doctorid = %d"; $rs = db_query($query, $doctorid); if ($rs) { while ($data = db_fetch_object($rs)) { return $data; } } return FALSE; } function popup() { window.confirm(); return false; } function doctor_delete_confirm(&$form_state, $doctor) { $form['_doctor'] = array( '#type' => 'value', '#value' => $doctor, ); return confirm_form($form, t('Are you sure you want to delete this doctor?'), isset($_GET['destination']) ? $_GET['destination'] : "doctor", t('This action cannot be undone.'), t('Delete'), t('Cancel')); } function doctor_delete_confirm_submit($form, &$form_state) { $form_values = $form_state['values']; if ($form_state['values']['confirm']) { $doctor = $form_state['values']['_doctor']; $query = "DELETE FROM {doctor} where doctorid= $doctor->doctorid"; $rs = db_query($query); drupal_set_message(t('Doctor has been deleted successfully.')); } drupal_goto("doctor"); } function doctor_edit_confirm(&$form_state,$doctor){ $form = array(); $form['_doctors'] = array( '#type' => 'value', '#value' => $doctor, ); $query = "SELECT * FROM {doctor} where doctorid=%d"; $rs = db_query($query,$doctor->doctorid); $data=db_fetch_object($rs); $firstname=$data->firstname; $lastname=$data->lastname; $gender1 = $data->gender; $gender = $gender1 ? 0: 1; $status1 = $data->status ; $status = $status1 ? 1: 0; $form['firstname']=array( '#title'=>t('First Name'), '#type'=>'textfield', '#default_value'=>$data->firstname, ); $form['lastname']=array( '#title'=>t('Last Name'), '#type'=>'textfield', '#default_value' => $lastname, ); $form['gender']=array( '#title'=>t('Gender'), '#type'=>'radios', '#options' => array(t('male'), t('female')), '#default_value' => variable_get('gender',$gender), ); $form['status']=array( '#title'=>t('Status'), '#type'=>'radios', '#options' => array(t('active'), t('inactive')), '#default_value' => variable_get('status',$status), ); return confirm_form($form,t(''), isset($_GET['destination']) ? $_GET['destination'] : "doctor", t(''), t('Save'), t('Cancel')); } function doctor_edit_confirm_submit($form, &$form_state) { if ($form_state['values']['confirm']) { $doctor = $form_state['values']['_doctors']; $form_state['values']['doctorid'] = $doctor->doctorid; $firstname = $form_state['values']['firstname']; $lastname = $form_state['values']['lastname']; $gender1= $form_state['values']['gender']; $gender = $gender1 ? t('female') : t('male'); $status1 = $form_state['values']['status']; $status = $status1 ? t('inactive') : t('active'); $query = "UPDATE {doctor} SET firstname = '$firstname', lastname= '$lastname', gender = '$gender', status = '$status' WHERE doctorid=%d"; $rs = db_query($query,$doctor->doctorid); } drupal_goto("doctor"); } *Any help appreciated.* * *Regards,* Mahesh Gajabar

1 0

Path Redirect or Custom URLs
by Shai Gluskin 12 Jan '11

12 Jan '11

Hi Folks, A site I'm taking over has had content migrated from another CMS. The old URLs are important and need to be preserved. There is an admin assistant available to do the grunt work. My question: Which method is better from an SEO perspective (is there an another perspective???, if so do share): - Drupal core's path module; paste in the old urls as the path alias - use http://drupal.org/project/path_redirect to redirect the old paths to new ones created with the pathauto module. I don't know if it makes a difference or not... but all the old paths end in "shtml". Other suggestions? The site is running 6.20 and clean URLs. Thanks in advance, Shai

3 2