#1 October 14, 2022 11:53am

doon.mok
Member
Registered: May 6, 2015
Posts: 141

Upgrade Extension

Hello,

There is a new version of the form builder extension and we would like to upgrade through bigtree. When I go to View Extensions, form builder doesn't have the Ignore/Upgrade buttons. How often does bigtree check for newer versions and is there a way in bigtree to make it look for newer versions?

Thanks

Doon

Offline

#2 October 14, 2022 11:55am

timbuckingham
Administrator
From: Baltimore, MD
Registered: April 2, 2012
Posts: 974

Re: Upgrade Extension

It should check on every load of the extensions page. What version of Form Builder are you currently on? Can you drop your manifest.json file from the extension in here? Thanks!

Offline

#3 October 14, 2022 12:00pm

doon.mok
Member
Registered: May 6, 2015
Posts: 141

Re: Upgrade Extension

Version 2.5.4

{
    "type": "extension",
    "id": "com.fastspot.form-builder",
    "version": "2.5.4",
    "revision": 42,
    "compatibility": "4.2+",
    "title": "Form Builder",
    "description": "An easy to use form builder allowing the administrative users to easily add fields to a form that stores entries in the database and sends out emails. Also supports paid forms.",
    "keywords": [
        "forms",
        "emails",
        "submissions",
        "form"
    ],
    "author": {
        "name": "Tim Buckingham",
        "url": "http://www.fastspot.com",
        "email": "tim@fastspot.com"
    },
    "licenses": {
        "LGPL v3": "http://opensource.org/licenses/LGPL-3.0"
    },
    "components": {
        "module_groups": [],
        "modules": [
            {
                "name": "Form Builder",
                "route": "com.fastspot.form-builder*btx-form-builder",
                "class": "BTXFormBuilder",
                "icon": "form",
                "group": null,
                "gbp": {
                    "name": "",
                    "table": "",
                    "other_table": ""
                },
                "extension": "com.fastspot.form-builder",
                "id": "modules-15c9cf24c01f2e",
                "views": [
                    {
                        "title": "Forms",
                        "description": "",
                        "table": "btx_form_builder_forms",
                        "type": "searchable",
                        "settings": {
                            "sort_column": "title",
                            "sort_direction": "ASC",
                            "per_page": "15",
                            "filter": ""
                        },
                        "fields": {
                            "title": {
                                "title": "Title",
                                "parser": "",
                                "width": "222",
                                "numeric": ""
                            },
                            "entries": {
                                "title": "Entries",
                                "parser": "",
                                "width": "222",
                                "numeric": "1"
                            },
                            "last_entry": {
                                "title": "Last Entry",
                                "parser": "if ($value) { $value = date(\"F j @ g:ia\",strtotime($value)); }",
                                "width": "222",
                                "numeric": ""
                            }
                        },
                        "actions": {
                            "entries": "{\"name\":\"Entries\",\"class\":\"icon_view\",\"route\":\"entries\",\"function\":\"\"}",
                            "export": "{\"name\":\"Export\",\"class\":\"icon_export\",\"route\":\"export\",\"function\":\"\"}",
                            "edit": "on",
                            "delete": "on"
                        },
                        "related_form": null,
                        "preview_url": "",
                        "exclude_from_search": "",
                        "id": "views-15c9cf24c0c358"
                    }
                ],
                "actions": [
                    {
                        "route": "",
                        "in_nav": "on",
                        "class": "list",
                        "name": "View Forms",
                        "form": null,
                        "view": "views-15c9cf24c0c358",
                        "report": null,
                        "level": "0",
                        "position": "3",
                        "0": "route",
                        "id": "actions-15c9cf24c0f819",
                        "module": "modules-15c9cf24c01f2e"
                    },
                    {
                        "route": "add",
                        "in_nav": "on",
                        "class": "add",
                        "name": "Add Form",
                        "form": null,
                        "view": null,
                        "report": null,
                        "level": "0",
                        "position": "2",
                        "0": "route",
                        "id": "actions-15c9cf24c19adf",
                        "module": "modules-15c9cf24c01f2e"
                    },
                    {
                        "route": "settings",
                        "in_nav": "on",
                        "class": "server",
                        "name": "Settings",
                        "form": null,
                        "view": null,
                        "report": null,
                        "level": "2",
                        "position": "1",
                        "0": "route",
                        "id": "actions-15c9cf24c2d77a",
                        "module": "modules-15c9cf24c01f2e"
                    }
                ],
                "forms": [],
                "embeddable-forms": [],
                "reports": [],
                "embed_forms": []
            }
        ],
        "templates": [
            {
                "id": "com.fastspot.form-builder*btx-form-builder",
                "name": "Form Builder",
                "module": null,
                "resources": [
                    {
                        "id": "page_header",
                        "title": "Page Header",
                        "subtitle": "",
                        "type": "text",
                        "options": []
                    },
                    {
                        "id": "page_content",
                        "title": "Page Content",
                        "subtitle": "",
                        "type": "html",
                        "options": []
                    },
                    {
                        "id": "form",
                        "title": "Form",
                        "subtitle": "",
                        "type": "com.fastspot.form-builder*form-builder-picker",
                        "options": {
                            "list_type": "db",
                            "allow-empty": "No",
                            "pop-table": "btx_form_builder_forms",
                            "pop-description": "title",
                            "pop-sort": "`title` ASC"
                        }
                    },
                    {
                        "id": "emails",
                        "title": "Email Addresses",
                        "subtitle": "(to send submissions notifications to \u2014 separate with commas)",
                        "type": "textarea",
                        "options": []
                    },
                    {
                        "id": "thank_you_page_header",
                        "title": "Thank You Page Header",
                        "subtitle": "",
                        "type": "text",
                        "options": []
                    },
                    {
                        "id": "thank_you_page_content",
                        "title": "Thank You Page Content",
                        "subtitle": "",
                        "type": "html",
                        "options": []
                    }
                ],
                "level": "0",
                "routed": "on",
                "extension": "com.fastspot.form-builder",
                "position": "1"
            }
        ],
        "callouts": [],
        "settings": [],
        "feeds": [],
        "field_types": [
            {
                "id": "com.fastspot.form-builder*form-builder-picker",
                "name": "Form Builder Form",
                "use_cases": {
                    "templates": "on",
                    "modules": "on",
                    "callouts": "on",
                    "settings": "on"
                },
                "self_draw": "on",
                "extension": "com.fastspot.form-builder"
            }
        ],
        "tables": {
            "btx_form_builder_entries": "CREATE TABLE `btx_form_builder_entries` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `form` int(11) NOT NULL,   `data` longtext NOT NULL, `hash` varchar(255) NOT NULL DEFAUOLT '',  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`id`),   KEY `form` (`form`),    FOREIGN KEY (`form`) REFERENCES `btx_form_builder_forms` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8",
            "btx_form_builder_fields": "CREATE TABLE `btx_form_builder_fields` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `form` int(11) NOT NULL,   `column` int(11) NOT NULL,   `alignment` char(5) NOT NULL,   `type` varchar(255) NOT NULL DEFAULT '',   `data` longtext NOT NULL,   `position` int(11) NOT NULL,   PRIMARY KEY (`id`),   KEY `form` (`form`),   KEY `column` (`column`),   KEY `position` (`position`),    FOREIGN KEY (`form`) REFERENCES `btx_form_builder_forms` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8",
            "btx_form_builder_forms": "CREATE TABLE `btx_form_builder_forms` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `title` varchar(255) NOT NULL DEFAULT '',   `paid` char(2) NOT NULL DEFAULT '',   `base_price` float NOT NULL,   `early_bird_base_price` float NOT NULL,   `early_bird_date` datetime DEFAULT NULL,   `total_collected` float NOT NULL,   `entries` int(11) NOT NULL,   `limit_entries` char(2) NOT NULL DEFAULT '',   `max_entries` int(11) NOT NULL,   `scheduling` char(2) NOT NULL DEFAULT '',   `scheduling_open_date` datetime DEFAULT NULL,   `scheduling_close_date` datetime DEFAULT NULL,   `scheduling_before_message` longtext,   `scheduling_after_message` longtext,   `last_entry` datetime DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8"
        }
    },
    "sql_revisions": {
        "26": [
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling` char(2) NOT NULL AFTER `max_entries`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_open_date` datetime NULL DEFAULT NULL AFTER `scheduling`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_close_date` datetime NULL DEFAULT NULL AFTER `scheduling_open_date`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_before_message` longtext NULL AFTER `scheduling_close_date`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_after_message` longtext NULL AFTER `scheduling_before_message`"
        ],
        "35": [
            "ALTER TABLE `btx_form_builder_entries` ADD COLUMN `hash` varchar(255) NOT NULL AFTER `data`",
            "ALTER TABLE `btx_form_builder_entries` MODIFY COLUMN `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `hash`"
        ],
        "36": [
            "ALTER TABLE `btx_form_builder_entries` ADD COLUMN `ip` varchar(255) NOT NULL DEFAULT '' AFTER `created_at`"
        ],
        "39": [
            "ALTER TABLE `btx_form_builder_entries` MODIFY COLUMN `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `data`",
            "ALTER TABLE `btx_form_builder_entries` DROP COLUMN `hash`",
            "ALTER TABLE `btx_form_builder_entries` DROP COLUMN `ip`",
            "ALTER TABLE `btx_form_builder_forms` DROP COLUMN `scheduling`",
            "ALTER TABLE `btx_form_builder_forms` DROP COLUMN `scheduling_open_date`",
            "ALTER TABLE `btx_form_builder_forms` DROP COLUMN `scheduling_close_date`",
            "ALTER TABLE `btx_form_builder_forms` DROP COLUMN `scheduling_before_message`",
            "ALTER TABLE `btx_form_builder_forms` DROP COLUMN `scheduling_after_message`"
        ],
        "40": [
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling` char(2) NOT NULL DEFAULT '' AFTER `max_entries`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_open_date` datetime NULL DEFAULT NULL AFTER `scheduling`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_close_date` datetime NULL DEFAULT NULL AFTER `scheduling_open_date`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_before_message` longtext NULL AFTER `scheduling_close_date`",
            "ALTER TABLE `btx_form_builder_forms` ADD COLUMN `scheduling_after_message` longtext NULL AFTER `scheduling_before_message`"
        ],
        "42": [
            "ALTER TABLE `btx_form_builder_entries` ADD COLUMN `hash` varchar(255) NOT NULL DEFAULT '' AFTER `data`",
            "ALTER TABLE `btx_form_builder_entries` ADD COLUMN `ip` varchar(255) NOT NULL DEFAULT '' AFTER `created_at`"
        ]
    }
}

Offline

#4 October 14, 2022 12:04pm

timbuckingham
Administrator
From: Baltimore, MD
Registered: April 2, 2012
Posts: 974

Re: Upgrade Extension

Thanks, that cleared up the issue! It looks like the extension's manifest revision got out of whack at some point and went from 43 to 41 and then back up to 42. I've bumped it to 50 so you should now see the update load for you in BigTree.

Offline

#5 October 14, 2022 12:06pm

doon.mok
Member
Registered: May 6, 2015
Posts: 141

Re: Upgrade Extension

Thank you, Ignore/Upgrade button now showing up.

Offline

Board footer

Powered by FluxBB

The Discussion Forum is not available on displays of this size.