Anti spam plugin installation error

[satbeer]

Anti spam plugin installation error
showing this message please help to resolve the error.
Plugin couldn't be installed because of: Error importSQL::spam_prot
/home/swapoqvy/public_html/oc-content/plugins/spamprotection/assets/create_table.sql

[Aficionado]

Search here for "Error importSQL::spam_prot" and you will find a lot of information about it.

[satbeer]

Sir i have searched but i m unable to get the correct and simple solution for it.

[Aficionado]

Is it the first time you install the plugin or there are already datatables in the sql db ?

[satbeer]

Sir i have uninstalled the plugin and again installing it so it is showing this error.
Please help.

[Aficionado]

Sir i have uninstalled the plugin and again installing it so it is showing this error.
Please help.

You must (somehow) manually delete all Database tables of THAT PLUGIN.

[satbeer]

i have deleted still it is showing that error.And when i have imported this create.sql table it shows this.

[Aficionado]

Why IMPORT the SQL. Sorry don't follow.

Also something is missing, see:

[Aficionado]

https://forums.osclass.org/plugins/(plugin)-spam-protection/885/

https://forums.osclass.org/plugins/(plugin)-spam-protection/855/

Solution for your db problem.

[satbeer]

there is also tables of this.

[satbeer]

Sir i have deleted te tables manually ans again tried installing it but still it is showing this error.
Plugin couldn't be installed because of: Error importSQL::spam_prot
/home/swapoqvy/public_html/oc-content/plugins/spamprotection/assets/create_table.sql

[Aficionado]

Sir i have deleted te tables manually ans again tried installing it but still it is showing this error.
Plugin couldn't be installed because of: Error importSQL::spam_prot
/home/swapoqvy/public_html/oc-content/plugins/spamprotection/assets/create_table.sql

i have posted two links above for your problem.

I'm sorry, i have no idea what else could be wrong, probably your mysql version. Again, read the two links above. Or post in the Plugins topic, so the author could help.

[satbeer]

Sir i have change datetime to timestamp, in the create table .sql but when i m installing it it is still showing error to me.

[Aficionado]

Sir i have change datetime to timestamp, in the create table .sql but when i m installing it it is still showing error to me.

Then, i'm sorry but i have no other ideas.

[satbeer]

Sir Lastly i installed the old version correctly 1.7.1 of it with the available details in the forum message u provided.
Thanks for your help sir.