Fix EPG not loading due to mysql execution limit
When you EPG is not updated, and when you go to the panel_log and see the above error, you know there is a limit to mysql. That limit is max_execution_limits. There are 2 things you can do to fix the problem
Fix 1: Edit mysql configuration file
Go to your server, using WINSCP client. Log in and edit the file
/etc/mysql/mysql.cnf
Add the following code in it
max_execution_time=30000
Look at the picture below
Now restart mysql service with the command
sudo service mysql restart
Step 2: Update the Patch for EPG with command:
sudo wget “https://realpanel.io/releases/epg_fixed.zip” -O /tmp/update.zip -o /dev/null && sudo unzip /tmp/update.zip -d /tmp/update/ && sudo cp -rf /tmp/update/* /home/xtreamcodes/iptv_xtream_codes/ && sudo rm -rf /tmp/update && sudo rm /tmp/update.zip && sudo rm -rf /tmp/update && sudo chown -R xtreamcodes:xtreamcodes /home/xtreamcodes/
Step 3: Run EPG command to see if it works
/home/xtreamcodes/iptv_xtream_codes/php/bin/php /home/xtreamcodes/iptv_xtream_codes/crons/epg.php
Step 4: Check if it is updated in in PANEL with the current time you run.
You must wait until it is finished running. Then check in your panel to see the time stampe show up like this
If the timestamp is the current time, it means EPG has just run. Your EPG has been fixed.