Advertisement:

Author Topic: Anti spam plugin installation error  (Read 314 times)

satbeer

  • Newbie
  • *
  • Posts: 36
Anti spam plugin installation error
« on: September 04, 2018, 12:49:32 pm »
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

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #1 on: September 04, 2018, 01:21:47 pm »
Search here for "Error importSQL::spam_prot" and you will find a lot of information about it.

satbeer

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #2 on: September 04, 2018, 08:44:57 pm »
Sir i have searched but i m unable to get the correct and simple solution for it.

Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #3 on: September 04, 2018, 09:01:53 pm »
Is it the first time you install the plugin or there are already datatables in the sql db ?

satbeer

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #4 on: September 04, 2018, 09:06:15 pm »
Sir i have uninstalled the plugin and again installing it so it is showing this error.
Please help.

Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #5 on: September 04, 2018, 09:11:57 pm »
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

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #6 on: September 04, 2018, 09:37:55 pm »
i have deleted still it is showing that error.And when i have imported this create.sql table it shows this.

Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #7 on: September 04, 2018, 09:49:01 pm »
Why IMPORT the SQL. Sorry don't follow.

Also something is missing, see:


Aficionado

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner

satbeer

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #9 on: September 04, 2018, 10:20:18 pm »
there is also tables of this.

satbeer

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #10 on: September 05, 2018, 01:09:23 pm »
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

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #11 on: September 05, 2018, 01:12:47 pm »
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

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #12 on: September 09, 2018, 03:25:57 pm »
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

  • issues
  • Hero Member
  • *
  • Posts: 6207
  • Hardliner
Re: Anti spam plugin installation error
« Reply #13 on: September 09, 2018, 04:44:20 pm »
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

  • Newbie
  • *
  • Posts: 36
Re: Anti spam plugin installation error
« Reply #14 on: September 10, 2018, 09:03:01 pm »
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.