Always the same id (8388607) ?
If yes, try to check the table. And fix it if necessary.
You can do it with PHPmysql.
Thread Starter
Michael
(@michael8888)
Yes, always the same id. Should I delete the corresponding database entry?
Probably this table have some issue.
Try to Analise and fix it with phpMyAdmin or similar.
Thread Starter
Michael
(@michael8888)
I verified that the table is ok with mysqlcheck. The entry with the id 8388607 does indeed exist in the table and it is the only entry in that table.
So it seems you have a bug in your plugin?
The id should begin with number 1
Try to remove this record and keep an eye on this table and database.
Thread Starter
Michael
(@michael8888)
I deleted the entry and StopBadBots immediately recreated the entry and the error persists. By the way, the url column contains “/feed/” Maybe that helps to find the bug.
You can’t see the error message with Query Monitor?
No error message here.
Please, try in another site. (you told me you have many sites)
Check if you have the last version of the plugin installed.
Check also the WordPress version.
Then, please, let me know.
Thread Starter
Michael
(@michael8888)
I tried it on another site. No plugins, standard WordPress theme. WordPress and plugin have the latest version. Error persists.
I deleted the table and Query Monitor reports another error: Table does not exist. So you don’t even check if the table exists before you write into it.
I also deleted all tables and then reinstalled the plugin. Error persists.
My guess is that you don’t see the error because work with an upgraded installation. If you make a clean new install, you should be able to see the error.
I just ran a test. Deleted the plugin and installed it again.
The plugin created the table. No problems found.
Every time the plugin is updated or activated, the plugin check for all the tables. Then, you can also deactivate and activate it again to run the test.
It is not good idea to check for the table each time we will access it. That can overload the server.
Early, you told me the table exist and is in good shape.Then, the plugin created it.
Anyway, this plugin take around half minute more or less while is installing to create and fill out all the tables. Depends of the server speed. Maybe your PHP configuration don’t let the plugin complete the job and create and fill out all the tables. Check also for the script max execution time (max_execution_time directive).
Check also our troubleshooting page:
http://siterightaway.net/troubleshooting/
The plugin is installed around almost 20.000 sites and nobody complain about this issue, only you.
I think anything is wrong with your database server, MySql version/configuration or server/PHP configuration.
Thread Starter
Michael
(@michael8888)
I deleted the plugin now and then reinstalled. That worked on both servers with the error. Not sure why it didn’t work when I manually deleted the tables. The error is gone now. Really weird. I never had such case. Maybe something went wrong during an upgrade.
Anyway, thanks a lot for your help!
You are welcome.
I’m glad hear it is working now.
Happy new year!