Instagram bot add-on database pre-requirements

 xeroneitbd  14th Aug 2021 ChatPion

Hello XeorChatters,

As you already know Instagram bot add-on for ChatPion is on the way to be released. This add-on needed us a lot of things to be changed in code-base and we will release an update for ChatPion before we release the add-on. That update will be a large one. We will update many files as well as database.

You can see there is a table in database called "messenger_bot_subscriber" and it is the largest table with records. Updating this table through auto-update may fail because of the large amount of data. So, we are suggesting to update this table manually and make your system ready to welcome the upcoming Instagram bot add-on. This could be technical enough for a standard software user, but hats off to you guys for not being just a standard user. You guys are pro! I will be showing two ways to do the job.

Process : 1 (Easier but too slow and may fail due to huge data records)

Screenshot : https://ibb.co/XzpsWmj

1) Login to Cpanel

2) Go to phpMyAdmin

3) Select ChatPion database

4) Go to SQL menu and paste the following SQL and hit GO:

LOCK TABLE messenger_bot_subscriber WRITE;

ALTER TABLE `messenger_bot_subscriber` ADD `social_media` ENUM('fb','ig') NOT NULL DEFAULT 'fb' AFTER `store_id`;

UNLOCK TABLES;

Process :2 (But advanced but the best way)

Screenshot : https://ibb.co/LQghYXy

1) Login to Cpanel

2) Go to "Terminal" (if you cant find in your Cpanel then login to your WHM panel)

3) mysql -u databse_username -p

4) Enter your database password

5) use your_database_name;

6)

LOCK TABLE messenger_bot_subscriber WRITE;

ALTER TABLE `messenger_bot_subscriber` ADD `social_media` ENUM('fb','ig') NOT NULL DEFAULT 'fb' AFTER `store_id`;

UNLOCK TABLES;

7) Press Enter key

You are done !

Thanks for reading this doc.

Xerone IT Team