Renew the bot on airogram + sqlalchemy
14 USD - sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '109.94.200.00'"), and pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 0.- And on the telnet the sadness root@vps:~/hugme-bot# telnet 109.94.00.00 3306 Trying 109.94.200.000...Connected to 109.94.00.00Escape character is '^]'.kHost '78.140.000000' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.Also in logs more than 200k errors.- ERROR - tgbot.services.scheduler - TRY SEND NOTIFICATION ERROR: Forbidden: user is deactivated Every 5 seconds the bot tried to send a message to the person that the bot banned.“Tri send notification error”
Per in the bot code you need to add a check on the blocked user, you need to write a couple of keys.By the way, the programmer left himself.But the error processing (e.g., removing the message from the cycle) has not been left.I so guess that it may be in the code something wrong is done (for example, those millions of logs), because now open 6 sessions, and the call-to error (from 15:45) increased from: Aborted clients 248.1 k Aborted connects 265.5 k to Aborted clients 248.9 k Aborted connects 275.3 k
Finally, two of these problems must be solved.1 .Fix the source of the problem so that the bot doesn’t swim and it starts.Maybe the IPB is changed.
2ndRemove the source of errors
-
2 days34 USD
283 10 0 2 days34 USD
Hi, I have great experience in developing tg to solve problems and solve causes.
-
1 day14 USD
122 3 0 1 day14 USD
The task was done partially, but you need to look at the code and the setup of the BD.
Let’s write and talk.
-
2 days45 USD
94026 1265 1 10 2 days45 USD
Hi.There is a great experience in developing tg bots.Can you see the bots code?
Current freelance projects in the category Bot Development
AI agent in Telegram for online store
451 USD
Task: creating an AI agent in Telegram for live communication with customers and processing orders in the online store on OpenCart. It is also necessary to implement customer notifications regarding order statuses, store operating hours, working conditions, delivery times, and… AI & Machine Learning, Bot Development ∙ 1 hour 38 minutes back ∙ 28 proposals |
Link UA Telegram botA Telegram bot needs to be developed that connects clients and performers of physical labor (movers, cleaning, repairs, laborers) across cities in Ukraine. Functionality: Two roles — client and performer. The client creates a request, selects a category, specifies the address… Bot Development ∙ 4 hours 17 minutes back ∙ 44 proposals |
Automation of creating advertising creatives.There is a solution in the form of Higgsfield AI + nodes that generate quite close to the idea based on the prompt, paired with almost frame-by-frame editing, everything works well, except for one thing, which is the censorship on the use of celebrity faces and such. An… AI & Machine Learning, Bot Development ∙ 14 hours 41 minutes back ∙ 8 proposals |
Futures botA futures trading bot needs to be created. Under defined conditions, it should automatically set take profit, hedge, lock in profits, and automatically restart trading. Bot Development ∙ 1 day 1 hour back ∙ 37 proposals |
Telegram automation of message distribution in chatsNeed to send messages to Telegram chats. To avoid bans. There are several hundred chats. To configure the frequency and variability of texts. Python, Bot Development ∙ 1 day 3 hours back ∙ 30 proposals |
Kharkiv