I hope Criss will fix his site soon and i can't wait to see more of this mod.corduroy73 wrote:Hello, the link to download this mod seems to have an error. Anyone else?
If your site is on shared hosting It should be something likelinnysue wrote:Sorry if this is a repeat question. I searched this thread and nothing similar came up for the csv file question.
I installed v.0.4.1 of the CodeCrush MOD the other day. Everything seemed to go well and all seems to work, except I get this error message:
**** CodeCrush DB Interface ****
File /var/www/phpBB2/ip-to-country.csv does not exist!
I uploaded the ip-to-country.csv file, but it's not recognized. I set permissions to 777. The file is saved as: UTF-8
Line break type: convert to Windows style
The path is httpdocs/forum/ip-to-country.csv
I checked with my server host and there are no restrictions on csv files or file limitations.
I'm a newbie at installing MODS so I don't understand database edits at all. I did click on install buttons in the logs_install.php browser page. Said all was ok on all files.
Not sure where to go from here. Help!
P.S. - I just discovered that in the "page" feature, I am only able to use the probe feature, not any of the javascript links.
Code: Select all
/home/yourloginame/public_html/yourforum/ip-to-country.csv
Code: Select all
/home/yourloginame/public_html/ip-to-country.csv
Code: Select all
/home/linnysue/public_html/ip-to-country.csv
Code: Select all
/home/linnysue/public_html/phpBB2/ip-to-country.csv
Could not prune entries
DEBUG MODE
SQL Error : 1016 Can't open file: 'morgellonssanctum_ip_log1.MYI' (errno: 145)
DELETE FROM morgellonssanctum_ip_log1 WHERE logged < 20070905000000
Line : 180
File : admin_logs_system.php
Please see exactly same error and the way how i solved it a couple pages a go (page 49):linnysue wrote:This is the error message I get when I click on the "Visits Log." It used to work. Now the visits log is useless.
Could not prune entries
DEBUG MODE
SQL Error : 1016 Can't open file: 'morgellonssanctum_ip_log1.MYI' (errno: 145)
DELETE FROM morgellonssanctum_ip_log1 WHERE logged < 20070905000000
Line : 180
File : admin_logs_system.php
Code: Select all
CREATE TABLE phpbb_ip_config (
config_name VARCHAR(255) NOT NULL DEFAULT (''),
config_value VARCHAR(255) NOT NULL DEFAULT (''),
config_type CHAR(1) NULL,
config_desc VARCHAR(255) NOT NULL DEFAULT (''),
CONSTRAINT phpbb_ip_config_pk PRIMARY KEY (config_name) ON [PRIMARY]
) ON [PRIMARY];
CREATE TABLE phpbb_ip_exc (
exc_id INTEGER NOT NULL IDENTITY(1, 1),
username VARCHAR(128) NOT NULL DEFAULT (''),
browser VARCHAR(128) NOT NULL DEFAULT (''),
ip VARCHAR(128) NOT NULL DEFAULT (''),
log_code VARCHAR(32) NOT NULL DEFAULT (''),
CONSTRAINT phpbb_ip_exc_pk PRIMARY KEY (exc_id) ON [PRIMARY],
CHECK (exc_id>=0)
) ON [PRIMARY];
CREATE TABLE phpbb_ip_country (
ip1 BIGINT NOT NULL DEFAULT (0),
ip2 BIGINT NOT NULL DEFAULT (0),
iso2 CHAR(2) NOT NULL DEFAULT (''),
iso3 CHAR(3) NOT NULL DEFAULT (''),
country VARCHAR(255) NOT NULL DEFAULT ('')
) ON [PRIMARY];
CREATE TABLE phpbb_ip_sessions (
md5_sum CHAR(32) NOT NULL DEFAULT (''),
session_start BIGINT NULL,
CONSTRAINT phpbb_ip_sessions_pk PRIMARY KEY (md5_sum) ON [PRIMARY]
) ON [PRIMARY];
CREATE TABLE phpbb_ip_log1 (
log_id INTEGER NOT NULL IDENTITY(1, 1),
logged BIGINT NOT NULL DEFAULT (0),
username VARCHAR(25) NULL,
user_id INTEGER NULL,
user_ip VARCHAR(40) NULL,
user_sid CHAR(32) NULL,
ip_resolved VARCHAR(255) NULL,
ip_domain VARCHAR(255) NULL,
ip_country VARCHAR(3) NULL,
env_agent VARCHAR(255) NULL,
env_x_forwarded_for VARCHAR(255) NULL,
env_remote_ip VARCHAR(24) NULL,
env_via VARCHAR(255) NULL,
env_proxy_connection VARCHAR(255) NULL,
env_referer VARCHAR(255) NULL,
req_method VARCHAR(1) NULL,
page_name VARCHAR(32) NULL,
page_dir VARCHAR(64) NULL,
page_query_str VARCHAR(255) NULL,
generic_id1 INTEGER NULL DEFAULT (0),
generic_id2 INTEGER NULL DEFAULT (0),
log_code VARCHAR(32) NULL,
error_code SMALLINT NULL DEFAULT (0),
error_log INTEGER NULL DEFAULT (0),
log_msg TEXT NULL,
log_data TEXT NULL,
CONSTRAINT phpbb_ip_log1_pk PRIMARY KEY (log_id) ON [PRIMARY],
CHECK (log_id>=0),
CHECK (logged>=0),
CHECK (error_log>=0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];
CREATE TABLE phpbb_ip_log2 (
log_id INTEGER NOT NULL IDENTITY(1, 1),
logged BIGINT NOT NULL DEFAULT (0),
username VARCHAR(25) NULL,
user_id INTEGER NULL,
user_ip VARCHAR(40) NULL,
user_sid CHAR(32) NULL,
ip_resolved VARCHAR(255) NULL,
ip_domain VARCHAR(255) NULL,
ip_country VARCHAR(3) NULL,
env_agent VARCHAR(255) NULL,
env_x_forwarded_for VARCHAR(255) NULL,
env_remote_ip VARCHAR(24) NULL,
env_via VARCHAR(255) NULL,
env_proxy_connection VARCHAR(255) NULL,
env_referer VARCHAR(255) NULL,
req_method VARCHAR(1) NULL,
page_name VARCHAR(32) NULL,
page_dir VARCHAR(64) NULL,
page_query_str VARCHAR(255) NULL,
generic_id1 INTEGER NULL DEFAULT (0),
generic_id2 INTEGER NULL DEFAULT (0),
log_code VARCHAR(32) NULL,
log_msg TEXT NULL,
log_data TEXT NULL,
CONSTRAINT phpbb_ip_log2_pk PRIMARY KEY (log_id) ON [PRIMARY],
CHECK (log_id>=0),
CHECK (logged>=0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];
CREATE TABLE phpbb_ip_log3 (
log_id INTEGER NOT NULL IDENTITY(1, 1),
logged BIGINT NOT NULL DEFAULT (0),
username VARCHAR(25) NULL,
user_id INTEGER NULL,
user_ip VARCHAR(40) NULL,
user_sid CHAR(32) NULL,
ip_resolved VARCHAR(255) NULL,
ip_domain VARCHAR(255) NULL,
ip_country VARCHAR(3) NULL,
env_agent VARCHAR(255) NULL,
env_x_forwarded_for VARCHAR(255) NULL,
env_remote_ip VARCHAR(24) NULL,
env_via VARCHAR(255) NULL,
env_proxy_connection VARCHAR(255) NULL,
env_referer VARCHAR(255) NULL,
req_method VARCHAR(1) NULL,
page_name VARCHAR(32) NULL,
page_dir VARCHAR(64) NULL,
page_query_str VARCHAR(255) NULL,
generic_id1 INTEGER NULL DEFAULT (0),
generic_id2 INTEGER NULL DEFAULT (0),
log_code VARCHAR(32) NULL,
log_msg TEXT NULL,
log_data TEXT NULL,
CONSTRAINT phpbb_ip_log3_pk PRIMARY KEY (log_id) ON [PRIMARY],
CHECK (log_id>=0),
CHECK (logged>=0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];
CREATE TABLE phpbb_ip_log4 (
log_id INTEGER NOT NULL IDENTITY(1, 1),
logged BIGINT NOT NULL DEFAULT (0),
username VARCHAR(25) NULL,
user_id INTEGER NULL,
user_ip VARCHAR(40) NULL,
user_sid CHAR(32) NULL,
ip_resolved VARCHAR(255) NULL,
ip_domain VARCHAR(255) NULL,
ip_country VARCHAR(3) NULL,
env_agent VARCHAR(255) NULL,
env_x_forwarded_for VARCHAR(255) NULL,
env_remote_ip VARCHAR(24) NULL,
env_via VARCHAR(255) NULL,
env_proxy_connection VARCHAR(255) NULL,
env_referer VARCHAR(255) NULL,
req_method VARCHAR(1) NULL,
page_name VARCHAR(32) NULL,
page_dir VARCHAR(64) NULL,
page_query_str VARCHAR(255) NULL,
generic_id1 INTEGER NULL DEFAULT (0),
generic_id2 INTEGER NULL DEFAULT (0),
log_code VARCHAR(32) NULL,
error_code SMALLINT NULL DEFAULT (0),
error_log INTEGER NULL DEFAULT (0),
log_msg TEXT NULL,
log_data TEXT NULL,
CONSTRAINT phpbb_ip_log4_pk PRIMARY KEY (log_id) ON [PRIMARY],
CHECK (log_id>=0),
CHECK (logged>=0),
CHECK (error_log>=0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];
CREATE TABLE phpbb_ip_log5 (
log_id INTEGER NOT NULL IDENTITY(1, 1),
logged BIGINT NOT NULL DEFAULT (0),
username VARCHAR(25) NULL,
user_id INTEGER NULL,
user_ip VARCHAR(40) NULL,
user_sid CHAR(32) NULL,
ip_resolved VARCHAR(255) NULL,
ip_domain VARCHAR(255) NULL,
ip_country VARCHAR(3) NULL,
env_agent VARCHAR(255) NULL,
env_x_forwarded_for VARCHAR(255) NULL,
env_remote_ip VARCHAR(24) NULL,
env_via VARCHAR(255) NULL,
env_proxy_connection VARCHAR(255) NULL,
env_referer VARCHAR(255) NULL,
req_method VARCHAR(1) NULL,
page_name VARCHAR(32) NULL,
page_dir VARCHAR(64) NULL,
page_query_str VARCHAR(255) NULL,
generic_id1 INTEGER NULL DEFAULT (0),
generic_id2 INTEGER NULL DEFAULT (0),
log_code VARCHAR(32) NULL,
error_code SMALLINT NULL DEFAULT (0),
error_log INTEGER NULL DEFAULT (0),
log_msg TEXT NULL,
log_data TEXT NULL,
CONSTRAINT phpbb_ip_log5_pk PRIMARY KEY (log_id) ON [PRIMARY],
CHECK (log_id>=0),
CHECK (logged>=0),
CHECK (error_log>=0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];
# Config options - originally in phpbb_config - moved to log_config!
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('major_version','0','Log Major Version','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('minor_version','4','Log Minor Version','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('revision','1','Log Revision','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_filepath','/var/www/phpBB2/ip-to-country.csv','Country csv-file (path)','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_delim',',','Country csv delimiter','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_fields','ip1,ip2,iso2,iso3,country','Country csv fields','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('countries_updated','0','Last Update (Country db)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('ip_lookup_url','http://samspade.org/whois/','URL used to lookup IPs (ex: http://samspade.org/whois/)','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_bbsession','1','Use experimental phpBB session check','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_time','3600','Visit-Log session duration in seconds','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('log_dateformat','Y M d H:i','Log timestamps Format','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('per_page','50','Number of log entries listed per page','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('auto_prune','1','Automatic pruning of logs when viewed','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('auto_prune_age','60','Pruning threshold in days','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_proxy_url','http://codecrush.com/prox.php','Proxy Probe URL','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_proxy_ports','80,2301,3128,6588,8000,8080','List of Proxy Ports to probe','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('use_gethostbyaddr','0','Calling gethostbyaddr() can be very slow','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_anon','1','Log Anonymous Users','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_visits','1','Log Visits On/Off (1/0)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_actions','1','Log Actions On/Off (1/0)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_admins','','Comma delimited list of user_ids allowed to Configure/Delete logs (Anyone if empty)','s');
Yay, very happy to hear that! It has been in demand for a few months now for PHPBB3.Darlantan wrote: One of the projects I currently work on will need something like this at a later stage, which probably means I'll take the time to port/rewrite it for phpBB3.