User Tools

Site Tools


upg_loc_locreq

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
upg_loc_locreq [2014/03/18 17:05]
127.0.0.1 external edit
upg_loc_locreq [2015/03/29 00:20] (current)
admin
Line 1: Line 1:
 ====== Upgrading from regular Location Field to Required Location Field ====== ====== Upgrading from regular Location Field to Required Location Field ======
  
-If you purchased ​the Required Location ​Field and would like to change your current Location Field for all members ​without loosing ​the information they entered into that field then you need to run the following SQL statement against your database:\\+the 'Required Location' mod updates the existing profile field location ​and makes ALL location fields "​required"​ including country/​state/​city. If the database has no states or cities listed ​for a particular country then only the country is required because it only loads for selection what is found in the database. 
 + 
 +Installation is the same for any other addon.\\ 
 +1. Download the **field_loc_req-1.02.zip** package and upload it on your server into the tmp/​packages folder. DO NOT unzip it.\\ 
 +2. In your admin panel go to the "​Package Manager"​ page. You should see the addon listed there with an "​install"​ link next to it. \\ 
 +3. Click on install and follow the instructions on screen if any.\\ 
 + 
 +If you already have members ​and are upgrading the profile field location and don't want to lose the information they have already ​entered into that field then you should ​run the following SQL statement against your database:\\
 \\ \\
 ''​UPDATE `dsb_profile_fields2` SET `field_type`='​field_loc_req'​ WHERE `field_type`='​field_location'''​\\ ''​UPDATE `dsb_profile_fields2` SET `field_type`='​field_loc_req'​ WHERE `field_type`='​field_location'''​\\
 \\ \\
-Then in your admin panel - profile fields ​click on the top link to regenerate the profile fields cache.\\ +Then in your admin panel go to **Profile Fields** from the menu and click on the top link to regenerate the profile fields cache.\\ 
-\\ +{{:​regenerate_fields.jpg|}}\\ 
-Make sure you backup at least the ''​dsb_profile_fields''​ table if not the whole database before making any change.+ 
 +Make sure you **backup** at least the ''​**dsb_profile_fields**''​ table if not the whole database before making any change.\\ 
 You can run the SQL query with a database management tool like phpMyAdmin which should be available in your server control panel. You can run the SQL query with a database management tool like phpMyAdmin which should be available in your server control panel.
-We are available to do this for you if you don't feel comfortable with manually changing your database. 
upg_loc_locreq.1395162341.txt.gz · Last modified: 2014/03/18 17:19 (external edit)