Jump to content

Recommended Posts

@Jack_mcs

3 hours ago, Jack_mcs said:

It's created when the script is ran.

For some reason, the table honeypot_track was NOT created when I installed HoneyPot on my site. I had to create the table manually. That's why I asked.

Malcolm


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites
21 minutes ago, ArtcoInc said:

@Jack_mcs

For some reason, the table honeypot_track was NOT created when I installed HoneyPot on my site. I had to create the table manually. That's why I asked.

Malcolm

So is there any sql table creation file ? to do it myself? do you believe that this is the fault on my case?

Share this post


Link to post
Share on other sites
43 minutes ago, ArtcoInc said:

For some reason, the table honeypot_track was NOT created when I installed HoneyPot on my site. I had to create the table manually.

I can't imagine why it wouldn't be created and I've never had it happen. But I just realized that there isn't any notice made in case it does fail. I will add that to the next version. Thanks for mentioning it.

Share this post


Link to post
Share on other sites
23 minutes ago, danil0 said:

So is there any sql table creation file ? to do it myself? do you believe that this is the fault on my case?

If the table doesn't get created, then an IP that breaks the rules is not recorded. You would still see an entry in the log. But if you don't enable the setting, as mentioned previously, it will never block anything because you are telling it not to.

Share this post


Link to post
Share on other sites

@Jack_mcs

I copied my live site down to my in-house WAMP server, installed HoneyPot, tested it, and uploaded it all back to my host's server. Once uploaded, I did un-install and re-install the header_tag module, but that did not create the table on my host's server. That's where I had to create it manually.

HTH

Malcolm


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites
2 minutes ago, ArtcoInc said:

I did un-install and re-install the header_tag module, but that did not create the table on my host's server.

Ahh, that's because it is not created in the Header Tags module. It is created in the functions file on the shop side. So the table won't be created until tracking needs to be performed. If you install the addon and it never catches an offender, then the table will never be created.

Share this post


Link to post
Share on other sites

@Jack_mcs

I may be missing some proper SQL punctuation, but to manually create the table, I think it's *something* like this?

CREATE TABLE IF NOT EXISTS honeypot_track (ip_number INT( 64 ) UNSIGNED NOT NULL,
                                           count int (11) DEFAULT 0,
                                           last_date datetime NOT NULL,
                                           PRIMARY KEY(ip_number) ) ENGINE=InnoDB 

Corrections, please 😀

Malcolm

PS: do you really need to define the engine type, especially if the shop may be using a different engine?


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites
Posted (edited)
41 minutes ago, Jack_mcs said:

I can't imagine why it wouldn't be created and I've never had it happen. But I just realized that there isn't any notice made in case it does fail. I will add that to the next version. Thanks for mentioning it.

The log file created it has blocked many ips allready... thank you 

but the database table is not created should I use the code of Artcolnc?

CREATE TABLE IF NOT EXISTS honeypot_track (ip_number INT( 64 ) UNSIGNED NOT NULL,
                                           count int (11) DEFAULT 0,
                                           last_date datetime NOT NULL,
                                           PRIMARY KEY(ip_number) ) ENGINE=InnoDB 
Edited by danil0

Share this post


Link to post
Share on other sites

@ArtcoIncThat database statement is correct, unless I am missing a small mistake in it. The storage engine is not required. I will remove it in the next version. Thanks for pointing it out .

Share this post


Link to post
Share on other sites
19 minutes ago, danil0 said:

but the database table is not created should I use the code of Artcolnc?

Yes, that should work.

Share this post


Link to post
Share on other sites
Posted (edited)
26 minutes ago, Jack_mcs said:

Yes, that should work.

OK table is working great.. and it has blocked some ips

but I dont undersntand 

1. why capcha is not loading

2. why I see inside and beside fields strings like FORM_REQUIRED_INPUT

 

Sorry I forget to mention that I m using Megastore theme
MY VERSION IS 
osCommerce Online Merchant v2.3.4

Edited by danil0

Share this post


Link to post
Share on other sites
11 minutes ago, danil0 said:

1. why capcha is not loading

Please post your Honey Pot settings.

 

11 minutes ago, danil0 said:

2. why I see inside and beside fields strings like FORM_REQUIRED_INPUT

Please see my previous post about using the wrong file. FORM_REQUIRED_INPUT is only included once in the current version of Honey Pot and you said you removed it. The others have not been added by this addon.

Share this post


Link to post
Share on other sites

@danil0

7 minutes ago, danil0 said:

1. why capcha is not loading

In Admin-> Modules -> Header Tags -> Honey Pot, click Edit, then change Show Captcha (near the bottom) from none to either image or numbers (your choice).

As @Jack_mcs pointed out earlier, you had most of this configured wrong (you had most things turned off!).

10 minutes ago, danil0 said:

2. why I see inside and beside fields strings like FORM_REQUIRED_INPUT

I don't know. Something is altering the generated HTML code. Usually, it is a mistake you made when editing the file (create_account.php or contact_us.php). I once again suggest that you double and triple check your edits on these pages.

Malcolm


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites
Posted (edited)
6 minutes ago, Jack_mcs said:

Please post your Honey Pot settings

Enable Honey Pot
True

Pages
contact_us.php
create_account.php

Sort Order
10

Email Addresses Allowed
False

Email Addresses Show Message
True

URL's Allowed
False

URL Show Message
True

Create Account Check
True

Create Account Count
1

Create Account Period
55

Block Names with Numbers
True

Block Phone with Letters
True

Name Length - First
2

Name Length - Last
1

Verify Postal Code
Both

Verify Domain Referer Match
True

Verify State and Country match
True

Verify Time to Submit
10

Show Captcha
Numbers

Use IP List
IPList

Block IP Automatically


Bad Words

sex, viagra



Exclude IP's


Log Tracker
File

 

Edited by danil0

Share this post


Link to post
Share on other sites

@danil0If captcha is the only thing not working, then it is probably the GD Library is missing or an old version. Only your host can address that.

Share this post


Link to post
Share on other sites
Posted (edited)

thanxs Malcolm but I m using the edited files from cotribution to avoid mistyping... anyway the fields and labels I can fix them by adding a translation or removing them .. but why the captcha is not loading ...??

Edited by danil0

Share this post


Link to post
Share on other sites
1 minute ago, Jack_mcs said:

@danil0If captcha is the only thing not working, then it is probably the GD Library is missing or an old version. Only your host can address that.

no it is not that .. see here https://sportndog.gr/gd.php I checked it the first time you said it

Share this post


Link to post
Share on other sites

If it is an older version it will show in a test like that but won't work with  Honey Pot.  But you need to fix the file problem or troubleshooting might give false results. Your contact us page is not only showing the missing FORM_REQUIRED defines, it is also missing other defines, like the placeholder text. Once you fix those problems, you can get back to this one, assuming it still exists.

Share this post


Link to post
Share on other sites

@danil0

13 minutes ago, danil0 said:

thanxs Malcolm but I m using the edited files from cotribution to avoid mistyping... anyway the fields and labels I can fix them by adding a translation or removing them .. but why the captcha is not loading ...??

For the shits and giggles of it, try changing the captcha from numbers to images?

M


Get the latest Responsive osCommerce CE (community edition) here .

Share this post


Link to post
Share on other sites
3 minutes ago, Jack_mcs said:

If it is an older version it will show in a test like that but won't work with  Honey Pot.  But you need to fix the file problem or troubleshooting might give false results. Your contact us page is not only showing the missing FORM_REQUIRED defines, it is also missing other defines, like the placeholder text. Once you fix those problems, you can get back to this one, assuming it still exists.

Jack the contact_us.php file I use is the cotribution edited file from the 2.3.4 version folder to avoid mistyping. The defines how can I define them ...I followed all instractions I will go crazyy..

Share this post


Link to post
Share on other sites
1 minute ago, ArtcoInc said:

@danil0

For the shits and giggles of it, try changing the captcha from numbers to images?

M

haha thanxs this was the first I did

Share this post


Link to post
Share on other sites
6 hours ago, danil0 said:

Jack the contact_us.php file I use is the cotribution edited file from the 2.3.4 version folder to avoid mistyping. The defines how can I define them ...I followed all instractions I will go crazyy..

You don't have a 2.3.4 shop so that file won't work. Trying to force it to work is the wrong approach. The correct way to fix it is to add the original file(s) back and make the changes to them manually. Or, if you want to try the included files in the MS2 directory, they may work, though that is not the recommended way to install an addon.

Share this post


Link to post
Share on other sites
7 hours ago, Jack_mcs said:

You don't have a 2.3.4 shop so that file won't work. Trying to force it to work is the wrong approach. The correct way to fix it is to add the original file(s) back and make the changes to them manually. Or, if you want to try the included files in the MS2 directory, they may work, though that is not the recommended way to install an addon.

I m confused I dont have a 2.3.4 Shop ? How do you know that? on the version it sais osCommerce Online Merchant v2.3.4

Share this post


Link to post
Share on other sites
3 hours ago, danil0 said:

I m confused I dont have a 2.3.4 Shop ?

I'm even more confused at this point. In your original post in another thread you said you have an MS2 shop. But in this post you said you have a 2.3.4 shop. You need to straighten out your files and only use the ones meant for your shop. I can't help until you do that.

Share this post


Link to post
Share on other sites
12 minutes ago, Jack_mcs said:

I'm even more confused at this point. In your original post in another thread you said you have an MS2 shop. But in this post you said you have a 2.3.4 shop. You need to straighten out your files and only use the ones meant for your shop. I can't help until you do that.

ok maybe I was wrong on the other thread ..or maybe was my first quick question and I did not checked well. Is there a safe way to know ecxacly what version is my shop? On my admin/server_info.php I see these 2 lines 

osCommerce Online Merchant v2.3.4

image.png.d1495989e339cbc755e3b609cf01dfb3.png

PHP Version 5.6.40

 

* I have tested 7.3 php version to see if this the reason captcha not loading 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×