From v1.1 to v1.3
The following upgrade procedure is for roverCRM which have not been customized
Make sure that you do have a back up of your files and and database before upgrade
STEP-1
To upgrade to the latest version of roverCRM, first, log in to your cPanel.
-
Then, go to File Manager->public_html or the Subdomain where your script located at.
-
Select all the files and folders except .env file .htaccess & uploads folder(uploads folder is in your public folder) and then delete the selected files.
-
Now select all the files and folders from the upgraded version folder except .env .htaccess & uploads folder(uploads folder is in public folder) and paste it in the cPanel Project root.
STEP-2
As each upgrade has its installer enabled by default, to disable the installer, go to the config folder then open app.php file after that remove this below line Infoamin\Installer\LaravelInstallerServiceProvider::class, from config/app.php
You need to update your database. To update, follow the steps below:-
-
Now, login to PHPMyAdmin or your SQLServer from your browser & select the project database name.
-
Now select/open SQL option where query will be executed
-
After that, execute this below sql step by step,
ALTER TABLE users ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `canned_links` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_by` int(10) unsigned NOT NULL,
`created_type` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `canned_links_title_index` (`title`),
KEY `canned_links_link_index` (`link`),
KEY `canned_links_created_by_foreign_idx` (`created_by`),
KEY `canned_links_created_type_index` (`created_type`),
CONSTRAINT `canned_links_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `canned_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_by` int(10) unsigned NOT NULL,
`created_type` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `canned_messages_title_index` (`title`),
KEY `canned_messages_created_by_foreign_idx` (`created_by`),
KEY `canned_messages_created_type_index` (`created_type`),
CONSTRAINT `canned_messages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `captcha_configurations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`site_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`site_verify_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`plugin_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `currency_converter_configurations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`api_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`status` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `groups_name_index` (`name`),
KEY `groups_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `knowledge_bases` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(10) unsigned NOT NULL,
`subject` varchar(290) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(290) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`status` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
`comments` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
`publish_date` date DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `knowledge_bases_slug_unique` (`slug`),
KEY `knowledge_bases_group_id_foreign_idx` (`group_id`),
KEY `knowledge_bases_subject_index` (`subject`),
KEY `knowledge_bases_status_index` (`status`),
KEY `knowledge_bases_comments_index` (`comments`),
KEY `knowledge_bases_publish_date_index` (`publish_date`),
CONSTRAINT `knowledge_bases_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `captcha_configurations` (`id`, `site_key`, `secret_key`, `site_verify_url`, `plugin_url`) VALUES (1, 'fill witvh your site key', 'fill with your secret key', 'https://www.google.com/recaptcha/api/siteverify', 'https://www.google.com/recaptcha/api.js');
INSERT INTO `preferences` (`id`, `category`, `field`, `value`) VALUES
(NULL, 'preference', 'captcha', 'disable'),
(NULL, 'preference', 'facebook_comments', 'disable');
INSERT INTO `languages` (`id`, `name`, `short_name`, `flag`, `status`, `is_default`, `direction`) VALUES
(NULL, 'Spanish', 'es', NULL, 'Active', '0', 'ltr'),
(NULL, 'Russian', 'ru', NULL, 'Active', '0', 'ltr'),
(NULL, 'Turkish', 'tr', NULL, 'Active', '0', 'ltr'),
(NULL, 'Chinese', 'zh', NULL, 'Active', '0', 'ltr'),
(NULL, 'Portuguese', 'pt', NULL, 'Active', '0', 'ltr');
INSERT INTO `email_templates` (`id`, `template_id`, `subject`, `body`, `language_short_name`, `template_type`, `language_id`) VALUES (NULL, 25, '{company_name} - Activate your account', '<!DOCTYPE html>\r\n <html>\r\n <head>\r\n <meta charset="utf-8">\r\n <meta http-equiv="x-ua-compatible" content="ie=edge">\r\n <title>Activation Link</title>\r\n <meta name="viewport" content="width=device-width, initial-scale=1">\r\n <style type="text/css">\r\n /**\r\n * Google webfonts. Recommended to include the .woff version for cross-client compatibility.\r\n */\r\n @media screen {\r\n @font-face {\r\n font-family: Source Sans Pro;\r\n font-style: normal;\r\n font-weight: 400;\r\n src: local("Source Sans Pro Regular"), local("SourceSansPro-Regular"), url(https://fonts.gstatic.com/s/sourcesanspro/v10/ODelI1aHBYDBqgeIAH2zlBM0YzuT7MdOe03otPbuUS0.woff) format("woff");\r\n }\r\n @font-face {\r\n font-family: Source Sans Pro;\r\n font-style: normal;\r\n font-weight: 700;\r\n src: local("Source Sans Pro Bold"), local("SourceSansPro-Bold"), url(https://fonts.gstatic.com/s/sourcesanspro/v10/toadOcfmlt9b38dHJxOBGFkQc6VGVFSmCnC_l7QZG60.woff) format("woff");\r\n }\r\n }\r\n /**\r\n * Avoid browser level font resizing.\r\n * 1. Windows Mobile\r\n * 2. iOS / OSX\r\n */\r\n body,\r\n table,\r\n td,\r\n a {\r\n -ms-text-size-adjust: 100%; /* 1 */\r\n -webkit-text-size-adjust: 100%; /* 2 */\r\n }\r\n /**\r\n * Remove extra space added to tables and cells in Outlook.\r\n */\r\n table,\r\n td {\r\n mso-table-rspace: 0pt;\r\n mso-table-lspace: 0pt;\r\n }\r\n /**\r\n * Better fluid images in Internet Explorer.\r\n */\r\n img {\r\n -ms-interpolation-mode: bicubic;\r\n }\r\n /**\r\n * Remove blue links for iOS devices.\r\n */\r\n a[x-apple-data-detectors] {\r\n font-family: inherit !important;\r\n font-size: inherit !important;\r\n font-weight: inherit !important;\r\n line-height: inherit !important;\r\n color: inherit !important;\r\n text-decoration: none !important;\r\n }\r\n /**\r\n * Fix centering issues in Android 4.4.\r\n */\r\n div[style*="margin: 16px 0;"] {\r\n margin: 0 !important;\r\n }\r\n body {\r\n width: 100% !important;\r\n height: 100% !important;\r\n padding: 0 !important;\r\n margin: 0 !important;\r\n }\r\n /**\r\n * Collapse table borders to avoid space between cells.\r\n */\r\n table {\r\n border-collapse: collapse !important;\r\n }\r\n a {\r\n color: #1a82e2;\r\n }\r\n img {\r\n height: auto;\r\n line-height: 100%;\r\n text-decoration: none;\r\n border: 0;\r\n outline: none;\r\n }\r\n </style>\r\n </head>\r\n <body style="background-color: #e9ecef;">\r\n <div class="preheader" style="display: none; color:black; max-width: 0; max-height: 0; overflow: hidden; font-size: 1px; line-height: 1px; color: #fff; opacity: 0;">\r\n A preheader is the short summary text that follows the subject line when an email is viewed in the inbox.\r\n </div>\r\n <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n <tr>\r\n <td align="center" bgcolor="#e9ecef">\r\n <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">\r\n <tr>\r\n <td align="center" valign="top" style="padding: 36px 24px;">\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="center" bgcolor="#e9ecef">\r\n <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">\r\n <tr>\r\n <td align="left" bgcolor="#ffffff" style="padding: 36px 24px 0; font-family: Source Sans Pro, Helvetica, Arial, sans-serif; border-top: 3px solid #d4dadf;">\r\n <h1 style="margin: 0; font-size: 32px; font-weight: 700; letter-spacing: -1px; line-height: 48px; text-align: center; color: cornflowerblue;">Activate Your Account</h1>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="center" bgcolor="#e9ecef">\r\n <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 600px;">\r\n <tr>\r\n <td align="left" bgcolor="#ffffff" style="padding: 24px; font-family: Source Sans Pro, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;">\r\n <p style="margin: 0; color:black;">Dear {customer_name},</p>\r\n <p style=" color:black;">To activate your account, go to the following the button: </p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="left" bgcolor="#ffffff">\r\n <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n <tr>\r\n <td align="center" bgcolor="#ffffff" style="padding: 12px;">\r\n <table border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n <td align="center" bgcolor="#1a82e2" style="border-radius: 6px;">\r\n <a href="{activation_link}" target="_blank" style="display: inline-block; padding: 16px 36px; font-family: Source Sans Pro, Helvetica, Arial, sans-serif; font-size: 16px; color: #ffffff; text-decoration: none; border-radius: 6px;">Click here</a>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="left" bgcolor="#ffffff" style="padding: 24px; font-family: Source Sans Pro, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px;">\r\n <p style="margin: 0; color:black;">If that does not work, click on the following link in your browser:</p>\r\n <p style="margin: 0;"><a href="{activation_link}" target="_blank">{activation_link}</a></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align="left" bgcolor="#ffffff" style="padding: 24px; font-family: Source Sans Pro, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 24px; border-bottom: 3px solid #d4dadf">\r\n <p style="margin: 0; color:black;">Thanks & Regards,<br> {company_name}</p>\r\n <p style=" color:black;">\r\n From : {company_name}<br />\r\n Email: {company_email}<br />\r\n Phone: {company_phone}<br />\r\n Address: {company_street}, {company_city}, {company_state}\r\n </p>\r\n <br />\r\n <hr>\r\n <p style="text-align: center;font-size:12px">©{company_name}, all rights reserved</p>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n </html>', 'en', 'email', 1);
INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `permission_group`, `created_at`, `updated_at`) VALUES
(NULL, 'manage_captcha_setup', 'Manage Captcha Setup', 'Manage Captcha Setup', 'Captcha Setup', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'manage_currency_converter_setup', 'Manage Currency Converter Setup', 'Manage Currency Converter Setup', 'Currency Converter Setup', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'manage_canned_message', 'Manage Canned Message', 'Manage Canned Message', 'Canned Messages', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'add_canned_message', 'Add Canned Message', 'Add Canned Message', 'Canned Messages', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'edit_canned_message', 'Edit Canned Message', 'Edit Canned Message', 'Canned Messages', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'delete_canned_message', 'Delete Canned Message', 'Delete Canned Message', 'Canned Messages', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'manage_canned_link', 'Manage Canned Link', 'Manage Canned Link', 'Canned Links', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'add_canned_link', 'Add Canned Link', 'Add Canned Link', 'Canned Links', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'edit_canned_link', 'Edit Canned Link', 'Edit Canned Link', 'Canned Links', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'delete_canned_link', 'Delete Canned Link', 'Delete Canned Link', 'Canned Links', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'manage_group', 'Manage Group', 'Manage Group', 'Groups', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'add_group', 'Add Group', 'Add Group', 'Groups', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'edit_group', 'Edit Group', 'Edit Group', 'Groups', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'delete_group', 'Delete Group', 'Delete Group', 'Groups', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'manage_knowledge_base', 'Manage Knowledge Base', 'Manage Knowledge Base', 'Knowledge Base', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'add_knowledge_base', 'Add Knowledge Base', 'Add Knowledge Base', 'Knowledge Base', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'edit_knowledge_base', 'Edit Knowledge Base', 'Edit Knowledge Base', 'Knowledge Base', '2021-07-17 11:18:33', '2021-07-17 11:18:33'),
(NULL, 'delete_knowledge_base', 'Delete Knowledge Base', 'Delete Knowledge Base', 'Knowledge Base', '2021-07-17 11:18:33', '2021-07-17 11:18:33');
We don't know value of 'id' from your permissions table. So, please follow this steps carefully
- Need to update permission_roles table for giving all new permission for super admin.
- See all of new value of permissions table.
- Take this new value from permissions table 'id' column & execute this query.
STEP-3
If you don’t see changes in your project, you must clear your project cache. The steps are mentioned below:-
-
Go to your project directory.
-
Login to your SSH account. Go to the directory where the roverCRM project exists.
-
Run the following commands as shown in the screenshot below.
STEP-4
{your url} means application root URL.
- Now please go to http://{your url}/clear-cache.