2 personman Dec 30, 2005 15:08

Please see here and help debug it, I could not reproduce it on the demo site (with the most recents antispam blacklist update).. http://forums.b2evolution.net//viewtopic.php?p=31175#31175
I can't find $debug in that file.
I have other people that have me linked on their blog. If they try to access my blog through the link they get the error.
Right now I know its happening on my second blog
www.foreverpurple.com/blog/crab_blog.php
That one actually gets more traffic.
personman wrote:
I don't think that's the b2evo antispam thing because your main blog is still working, right? Are you sure you haven't renamed the thehub folder? Check your server error logs.
I have renamed the hub folder but that's my forum and not the blog.
The blog is at www.foreverpurple.com/blog but I have www.foreverpurple.com set to redirect to the blog.
The forum is at www.foreverpurple.com/bb
Daethian2, $debug is in /conf/_advanced.php.
I'd recommend to use something like the following in /conf/_config_TEST.php:
<?php
if( $_SERVER['REMOTE_ADDR'] == 'xxx' ) $debug = 1;
?>
where you have to replace 'xxx' with your own IP address. You can lookup this one at http://hackscheibe.de/my_ip.php for example. This will only enable debugging when you access the blog.
Okay I found it this is what happens when I follow a link to my blog from another blog:
Debug info
Page processing time: 0.007 seconds.
SQL processing time: 0.002 seconds, 28.57%.
Debug messages
Starting timer main
Getting ReqURI from 'REQUEST_URI'
Request URI: /blog/crab_blog.php
Request Path: /blog/crab_blog.php
Starting timer sql_queries
Starting timer query
DB
Old style queries:
DB queries: 1
Query: Advanced check for referer spam
SELECT aspm_ID, aspm_string
FROM evo_antispam
WHERE 'http://www.crabbytalk.com/' LIKE CONCAT('%',aspm_string,'%')
LIMIT 0, 1
Rows: 1 - Time: 0.002s (100.00%)
Well now I can't do anything with my blogs. When I try to get in the backend I get a 404.
This 404 has to be something else..
Have you access to phpmyadmin or something similar?
What's the result of this query:
SELECT aspm_ID, aspm_string
FROM evo_antispam
WHERE 'http://www.crabbytalk.com/' LIKE CONCAT('%',aspm_string,'%')
LIMIT 0, 1
It seems like you have something in your evo_antispam table that always returns a row for this query.
You seem to have missed the "r" in your $baseurl..
The skins' base is currently:
http://forevepurple.com/blogs/skins/mine/
I have access to phpmyadmin
blueyed wrote:
You seem to have missed the "r" in your $baseurl..
The skins' base is currently:
http://forevepurple.com/blogs/skins/mine/
In the config.php file?
it should be blog not blogs... I went in and fixed it but still nothing.
blueyed wrote:
This 404 has to be something else..
Have you access to phpmyadmin or something similar?
What's the result of this query:
SELECT aspm_ID, aspm_string FROM evo_antispam WHERE 'http://www.crabbytalk.com/' LIKE CONCAT('%',aspm_string,'%') LIMIT 0, 1
It seems like you have something in your evo_antispam table that always returns a row for this query.
I ran that in a query window and I see nothing.
Are you on the right DB?
You could also add
$EvoConfig->DB['debug_dump_rows'] = 100;
to your _config_TEST.php file. That should dump the results for the queries into the Debuglog.
Yes I'm in the b2 db....
Where do I find the debuglog?
debuglog is what you get at the bottom of the page if $debug is >= 1.
The 'r' is missing with your domain name "foreveRpurple.com".. either you've messed up $baseurl or some derivate of it (search for $baseurl in /conf/_advanced.php).
Okay fixed that...
I still can't access the backend admin stuff.
Now the main blog is visible again but when I click the link from the main blog to the crab blog:
Debug info
Page processing time: 0.009 seconds.
SQL processing time: 0.002 seconds, 22.22%.
Debug messages
Starting timer main
Getting ReqURI from 'REQUEST_URI'
Request URI: /blog/crab_blog.php
Request Path: /blog/crab_blog.php
Starting timer sql_queries
Starting timer query
DB
Old style queries:
DB queries: 1
Query: Advanced check for referer spam
SELECT aspm_ID, aspm_string
FROM evo_antispam
WHERE 'http://www.foreverpurple.com/blog/' LIKE CONCAT('%',aspm_string,'%')
LIMIT 0, 1
Rows: 1 - Time: 0.002s (100.00%)[/code]
Daethian2, I NEED the results of the query. Either try reproducing it in phpmyadmin/mysql client or set the $EvoConfig directive I've asked you to above. This will print out the first 100 rows also to the debuglog.
Okay last night I remembered that I renamed my htsrv folder. This morning I named it back and once I bypass the spammer message I can access the backend.
I DID add that code to the config test file.
I ran the query on the db and I'm still not getting anything on that screen.
Am I doing something wrong??
Daethian2, please look closely at what phpmyadmin gives you:
You have a row (aspm_ID 3018) that contains nothing and matches the antispam-check query, because "%XXX%" (anything) is always LIKE "%%".
Before removing this wrong blacklist entry, please paste the results of
SELECT * FROM evo_antispam
WHERE "" LIKE CONCAT( "%", aspm_string, "%" )
This should give all those wrong entries, with the additional info where it came from (aspm_source).
Then (after pasting the info here), simply remove these rows (check them in phpmyadmin and click "remove selected").
i put what you send to me in the myadminphp file evo anti spam
and it show this,
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0060 sec)
SQL query:
SELECT *
FROM evo_antispam
WHERE "" LIKE CONCAT( "%", aspm_string, "%" )
LIMIT 0 , 30
and i put $debug = 1; at the end of the page before
$debug_no_register_shutdown= 0;
// ----- CHANGE THE FOLLOWING ONLY IF YOU KNOW WHAT YOU'RE DOING! -----
$evonetsrv_host = 'b2evolution.net';
$evonetsrv_port = 80;
$evonetsrv_uri = '/evonetsrv/xmlrpc.php';
$debug = 1;
?>
i couldn't enter the site
makarios, so you probably have another problem.
What does the debuglog output?
What does "could not enter the site" mean?
I ran the second query you gave me, here is a screen shot:
you, send me the code $debug = 1; i put it where you told me, and i try
the site www.rss-dubai.com/blogs the site is open but if you clicck on next on the right the page show error, i cant enter to my admin all is block
the site is every 2 days is suspended for the spam.
the problem is there is something who block to my admin and the page
and the second things the site is suspended every 2 day because of the spam ( i update the antispam everyday)
Makarios
Daethian2, so simply remove this one entry.
I don't know though how it may have been added to your local list (as the Antispam menu should prevent to short entries).
Thanks for your patience!
Hopefully this will fix the problem.
makarios,
after I have enabled $debug in your /conf/_advanced.php file (in the directory, that gets used by your domains, not /conf/_advanced.php in your FTP root!) I got this in the debuglog:
detect_referer(): Url refused. Debug info: blacklisted word: [http:]
So, remove this keyword from your antispam database table.
$debug is still enabled for rss-dubai.com, you can set it to 0 (in /rss-dubai.com/blogs/conf/_advanced.php).
I believe it's the same/similar problem with your other domain.
I go to the database and i search i couldn't found it
Mak
makarios,
SELECT *
FROM `evo_antispam`
WHERE `aspm_string` LIKE 'http:'
gave me aspm_ID 4077, which I have now deleted for you.
It's another issue with rss-lebanon, as there are no invalid local aspm_strings.
I cannot verify, if it works, as both domains just give a 403 Forbidden error on / and /blogs/.
I don't think that's the b2evo antispam thing because your main blog is still working, right? Are you sure you haven't renamed the thehub folder? Check your server error logs.