[BETA] CodeCrush Log System (v.0.4.2alpha) (Dec-07)

[3Di]

I would like to give it a try..

[3Di]

got this error after the installation of 3.0, on a 2.0.17 board.
thanks in advance

Code: Select all

Could not get browser count

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND logged <= AND browser LIKE '%turnitinbot%'' at line 2

SELECT count(*) AS browser_count FROM phpbb_cc_ip_log WHERE logged >= AND logged <= AND browser LIKE '%turnitinbot%'

Line : 266
File : admin_ip_stats.php

[badboy4ever]

Dose anyone know how long untill a new version will come out thats a bit more stable?

[Riamus]

3Di:

Look at the first post here:
http://www.phpbb.com/phpBB/viewtopic.ph ... &start=465

The fix at the top will fix your stats page error and another problem as well.

[3Di]

3Di:

Look at the first post here:
http://www.phpbb.com/phpBB/viewtopic.ph ... &start=465

The fix at the top will fix your stats page error and another problem as well.

Thanks a bunch Riamus, i was just reading the Topic from the start looking for that, now everything seems to be working. I have now to learn some more about this MOD.

[Riamus]

Btw, the best way to find answers to a specific error message is to use the Search feature and select to view results as POSTS rather than TOPICS. Then, when you find one you think is right, click the subject link and you'll be taken right to it rather than trying to read through dozens of pages.

[n1pj]

config_name varchar(255) not null primary key default ''

what am I supposed to use for default, am I just supposed to use (") in the default column. or do I have to add my own information there.


thanks

[deny]

3Di:

Look at the first post here:
http://www.phpbb.com/phpBB/viewtopic.ph ... &start=465

The fix at the top will fix your stats page error and another problem as well.

Thanks a bunch Riamus, i was just reading the Topic from the start looking for that, now everything seems to be working. I have now to learn some more about this MOD.

Are the all users and all ip's listed on admin_ip.log by default or everything is empty??

[Darlantan]

config_name varchar(255) not null primary key default ''

what am I supposed to use for default, am I just supposed to use (") in the default column. or do I have to add my own information there.

off the top of my head, just use the blank ('') as default.

deny:
it's supposed to list all on initial load / default. That it doesn't for some is a bug.

I'm working on a minor update release to fix the aforementioned bugs. Which will also include a semi-automatic pruning option - hopefully something like what Riamus suggested earlier on.

[n1pj]

What have I done wrong here. My board won't come up and this list of errors come up


Critical Error!
message_die() was called multiple times.
Error #1
Couldn't get IP Log Excludes information

Line : 126
File : /home/techniqu/public_html/bulletin/includes/cc_mod.php
SQL : SELECT * FROM cc_ip_exc WHERE (username = 'removed' AND ip IN ('***.***.***.*','***.***.***.*','209.113.*.*','209.*.*.*','*.*.*.*')) OR (username = '*' AND ip IN ('***.***.***.2','***.***.159.*','***.113.*.*','***.*.*.*','*.*.*.*')) LIMIT 1
Error #2
Couldn't get IP Log Excludes information

Line : 126
File : /home/techniqu/public_html/bulletin/includes/cc_mod.php
SQL : SELECT * FROM cc_ip_exc WHERE (username = 'removed' AND ip IN ('***.***.***.*','***.***.***.*','***.113.*.*','***.*.*.*','*.*.*.*')) OR (username = '*' AND ip IN ('***.113.***.*','***.113.***.*','209.***.*.*','209.*.*.*','*.*.*.*')) LIMIT 1
Please, contact the webmaster. Thank you.


any help would be greatly apreciated thanks

Okay I fixed that problem but I have a new one

Could not get browser count

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND logged <= AND browser LIKE '%inktomi%'' at line 2

SELECT count(*) AS browser_count FROM cc_ip_log WHERE logged >= AND logged <= AND browser LIKE '%inktomi%'

Line : 266
File : admin_ip_stats.php



What the heck does that mean.

I am running MySQL 4.0.16

thanks

[badboy4ever]

okay i aint great at mysql but when it says you have a error in your syntax it normaly means that you missed out a . or somthing

[n1pj]

okay i aint great at mysql but when it says you have a error in your syntax it normaly means that you missed out a . or somthing

I know a lot less than you do, I am just learing SQL now.

I didn't edit this file. It is still the fresh file from installing the ip program. Unless it is looking at another file somewhere else and logging it under this file at line 266

[badboy4ever]

So you did a fresh install of the mod?

[n1pj]

So you did a fresh install of the mod?

Yes, but now I have a new problem, under the mod config that points to the mssql database it says do not change this. Default it blank. I tried changing it to phpbb like in my database thinking that would work and now all those screens don't work. Do you know how I can change that field back to normal (blank) again.


thanks

This is the new error I get

Could not get config

DEBUG MODE

SQL Error : 1146 Table 'techniqu_p_bb1.phpbbcc_ip_config' doesn't exist

SELECT config_name, config_value FROM phpbbcc_ip_config

Line : 83
File : functions_ccip.php

Ok I was able to reset the database and fix that problem. Now I just have this error remaining.

General Error
Could not get browser count

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND logged <= AND browser LIKE '%turnitinbot%'' at line 2

SELECT count(*) AS browser_count FROM phpbbcc_ip_log WHERE logged >= AND logged <= AND browser LIKE '%turnitinbot%'

Line : 266
File : admin_ip_stats.php


The program also doesn't capture ip adresses yet. I think it has something to do with this error but I don't know.

Any help would be appreciated

Thanks

[Darlantan]

hehe, it says "do not change" cause it means trouble if you get it wrong. ;)

as for the browser count error, it's a bug that affects some users. Will be fixed in the upcoming minor version. Could verywell be the same bug causing it not to log anything.