Joomla 6 Notice

We are pleased to announce that all our Joomla extensions have been compatible with Joomla 6 since October 14th, 2025.

For those currently upgrading from Joomla 3 to 4: Instructions for Joomla 4 migration can be found here:

There are standalone documentations Visforms Joomla 4, Visforms Joomla 5 and Visforms Joomla 6.

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

Can I manually delete rows from the database?

More
9 years 10 months ago #3001 by sabrinaweb71
Can I manually delete rows from the database? was created by sabrinaweb71
Dear staff,
I have installed your plugin, but spammers can still register at my site. The cause might be another plugin I use for registration, but this isn't my most urgent problem at the moment.
The point is that, having set the option "log to db", now the spambotcheck tables are taking more than 1GB in space.
This means that I have run out of database space and nobody can visit the site anymore, since Joomla! can't save their data in the session table.
This also means that I can't access the control panel to verify what options are or aren't set. I can only access to phpmyadmin to do maintenance.
Is it safe for me to run a query such as "delete * from __user_spambotcheck", so I can at least free some space from the database and have my site visible again? Or will anything stop working?
I have other questions, but if I don't free some space nothing else could help.
I hope you can help me,
SabrinaWeb

More
9 years 10 months ago #3002 by Administrator AV
Replied by Administrator AV on topic Can I manually delete rows from the database?
Hi,

the "log spambots to db" option logs all blocked spambot attempts in the table #__spambot_attempts.
I think it is this table that causes your troubles and not the #__user_spambotcheck.
The #__user_spambotcheck table contains only one record with only 5 fields for each registered user of your website. This is much less than for example the Joomla! core #__users table itself, so I think, this table would not be the problem.

You can remove all record sets from the #__spambot_attempts table manually, savely.
But do not remove record sets form the #__user_spambotcheck table because this table is "linked" to the #__users table. For each user in the users table there must be a record set in the #__user_spambotcheck table, too. So you have to delete users via administration, in order to make this tables (plural) smaller.

Regards,
Aicha

:idea: I recommend you the new and up-to-date documentation for Joomla 6:
docs.joomla-6.visforms.vi-solutions.de/en/docs/
Please ask only 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation fĂĽr Joomla 6:
docs.joomla-6.visforms.vi-solutions.de/docs/
Bitte immer nur 1 Frage pro Thema stellen :-).

Moderators: Administrator AVAdministrator IV
Powered by Kunena Forum