pasqua200

Thank you for your feedback 🙂 Can we add it from the plugin? Thanks again for your help and patience.

Hello,

Thank you for your response. However, I believe the issue is directly related to AI Engine Pro, and I’d like to clarify with specific details. Here’s the context and errors encountered:

• Errors observed:
  • JavaScript error: “Uncaught ReferenceError: data is not defined” in /wp-content/plugins/ai-engine-pro/assets/js/chatbot.js:2.
  • HTTP error: POST https://www.yiaho.com/wp-json/mwai-ui/v1/chats/submit 500 (Internal Server Error).
  • MySQL error: #2006 – MySQL server has gone away when attempting TRUNCATE wpf3_mwai_chats via phpMyAdmin.
  • Current error: “Unable to select database mhkx7964_wp637”, making my site inaccessible.
• Context:
  • The errors occur when testing the chatbot in AI Engine > Chatbots or Discussions, with approximately 300,000 chats in the wpf3_mwai_chats table. My host (o2switch) reported SQL saturation due to slow queries like SELECT COUNT(*) FROM wpf3_mwai_chats WHERE userId = 0, running in parallel (up to 15 queries, lasting 34–42 seconds).
  • The wpf3_mwai_chats table is managed by AI Engine Pro, and the /wp-json/mwai-ui/v1/chats/submit endpoint is part of your plugin. The table’s overload likely causes the HTTP 500 error, which leads to the JavaScript error (the script expects a data variable that isn’t returned).
• Configuration:
  • WordPress: 6.8.2
  • PHP: 8.1.32
  • Theme: Neve 4.1.2
  • Host: o2switch
  • Plugin: AI Engine Pro (recently reinstalled)
  • Database: mhkx7964_wp637, table wpf3_mwai_chats (~300,000 entries)
• Actions taken:
  • Reinstalled WordPress and AI Engine Pro.
  • Verified permissions (644 for files, 755 for directories).
  • Attempted TRUNCATE wpf3_mwai_chats, which failed with error #2006. Now trying to delete chats in batches (DELETE … LIMIT 5000).
  • Contacted o2switch to restore database access and adjust MySQL settings (wait_timeout, innodb_buffer_pool_size).
  • Enabled debug mode, but cannot access the site to check /wp-content/debug.log yet.
• Observations:
  • The SQL saturation is tied to wpf3_mwai_chats, suggesting AI Engine Pro struggles with large chat volumes.
  • The HTTP 500 on /wp-json/mwai-ui/v1/chats/submit and JavaScript error in chatbot.js directly point to your plugin.
  • The #2006 error and database inaccessibility are likely consequences of the SQL overload caused by slow queries.

Questions:

1. Is there a known bug in AI Engine Pro for handling large tables like wpf3_mwai_chats (~300,000 entries)?
2. Can the /wp-json/mwai-ui/v1/chats/submit endpoint fail (HTTP 500) due to high chat volumes? If so, what optimizations do you recommend?
3. Is there a fixed version or settings to limit the impact of archived chats (e.g., pagination or automatic cleanup)?
4. Can you suggest a method to clean wpf3_mwai_chats without triggering error #2006?

I’m working with o2switch to restore database access and reduce SQL load. Can you confirm if AI Engine Pro is involved and provide specific recommendations? I’ve attached the console details and o2switch SQL logs for reference.Thank you for your help!

For info, the plugin seems to be causing issues with my WordPress site (Neve theme). Sometimes I get this message: Error establishing a database connection. my website : http://www.yiaho.com

Last message to get all the information:
I deactivated the plugin from my cPanel (otherwise my site crashes).
I reactivated the plugin, reset a chatbot, and got this error message:”data is not defined”

• This reply was modified 10 months, 2 weeks ago by pasqua200.

for information, the format is set up well below an article, but not on the main page. exemple : https://freelanceinfos.fr/pourquoi-les-streamers-vont-sur-kick-twitch-peut-sinquieter/

is it possible to activate Author Box even on the author page?

Hi @tigroumeow , like that :
[mwai_chat context=”” ai_name=”FMC” casually_fined_tuned=”true”]

I inserted the code on my website to test, at the bottom before the footer : wwww.grodt.fr to watch