Final Filer Software

The complety free database management system for cemeteries & crematoria

Overview Overview Search Search Up Up
Download details
FF Register Search Update 3.22 FF Register Search Update 3.22 HOT UPDATED

This package contains only the files needed to update from 3.5 to 3.11. Use the full install if you want to update libraries and framework source code as well.

IMPORTANT: -Backup the existing installation directory before proceeding so you can restore it if this update breaks something! 

Updating:

If you are using Version 3.21 or later,click here for UPDATE instructions

If you are using an earlier version than 3.21 you MUST change the database schema.

Changes to the Database Schema:

 Open your database in client software. If using mySQL, phpmyadmin or PHP Workbench are recommended.

  • Create a new SQL script file.
  • Copy and paste the following into it:

#########################################

USE `your_database_name`;

ALTER TABLE `tblareas`
ADD COLUMN `hideallocview` TINYINT NOT NULL DEFAULT 0 AFTER `Name`;

DROP `view_registerdata`;

CREATE OR REPLACE VIEW `view_registerdata` AS
    SELECT
        `tblmaindata`.`IndexNumber` AS `IndexNumber`,
        `tblregisters`.`Code` AS `RegisterCode`,
        `tblregisters`.`Name` AS `RegisterName`,
        `tblmaindata`.`LastName` AS `LastName`,
        `tblmaindata`.`FirstName` AS `FirstName`,
        `tblmaindata`.`Died` AS `Died`,
        `tblmaindata`.`Aged` AS `Aged`,
        `tblmaindata`.`ServiceDate` AS `ServiceDate`,
        `tblmaindata`.`serviceTime` AS `Service_Time`,
        `tblmaindata`.`url_remembrance` AS `url_remembrance`,
        `tblmaindata`.`url_fnotice` AS `url_fnotice`,
        `tblmaindata`.`url_obit` AS `url_obit`,
        `tblareas`.`Code` AS `AreaCode`,
        `tblareas`.`Name` AS `AreaName`,
        `tblportions`.`Code` AS `PortionCode`,
        `tblportions`.`Name` AS `PortionName`,
        `tblrows`.`Code` AS `RowCode`,
        `tblrows`.`Name` AS `RowName`,
        `tblmaindata`.`Grave` AS `Plot_Number`,
        `tblmaindata`.`SubAlloc` AS `Sub_No`,
        `tblareas`.`hideallocview` AS `hideallocview`
    FROM
        ((((`tblmaindata`
        JOIN `tblregisters` ON ((`tblmaindata`.`Register` = `tblregisters`.`Code`)))
        LEFT JOIN `tblareas` ON ((`tblmaindata`.`AreaCode` = `tblareas`.`Code`)))
        LEFT JOIN `tblportions` ON ((`tblmaindata`.`PortionCode` = `tblportions`.`Code`)))
        LEFT JOIN `tblrows` ON ((`tblmaindata`.`RowCode` = `tblrows`.`Code`)))

#########################################

Exectute the script to add the new field and update or create the VIEW.


 Updating

 

 

  1. Download the file into the folder where the Register Search application is on your webserver (usually http://yourwebserver/regsearch) or similar)
  2. Unzip the contents of the zip file.

 

To avoid future confusion it is recommended that you delete the zipped files once the installation update is complete.

 

NOTE- If after installing this update the deployment directory contains a directory named 'submitok', it can be deleted.

 

 

 

 

Data

Version3.2.2
Size114 MB
Downloads304
Language
LicenseGNU/GPL external
Author
Website
Price
Created2016-01-22 01:15:58
Created bySuper User
Changed2017-09-14 23:53:41
Changed bySuper User

Download

Contribute!