Welcome to Geeklog Monday, October 25 2021 @ 12:08 am EDT

Geeklog Forums

Bad Behavior


Status: offline

Nightdude

Forum User
Chatty
Registered: 15/09/04
Posts: 61
ok...I installed this plug-in after watching my over night traffic having as many as 20 guest users at a time in the wee hours of the morning.

So now I can't get back into my site, giving me a Precondition Failed message...

So whats the work around to get back in??

Thanks..
John Banging your head

After thought - attempted with multiple computers and various browsers..
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
disable the plugin manually, via the database. look for the table gl_plugins.
 Quote

Status: offline

Nightdude

Forum User
Chatty
Registered: 15/09/04
Posts: 61
Assuming that 1 is enabled and 0 is disabled, I still get the same error of Precondition Failed...

Sigh...... Giving it a try


Seems to me --looking at my database something is missing. I have a gl_bad_behavior_log, but no other bad behavior references other than inside the gl_plugins -- is this correct?? Or did something not go right? Further Investigation finds no Bad Behavior in the gl-blocks - there should be?? yes?? The only other reference to bad behavior is in the gl-vars

I thought I had this plug-in stuff down pretty good - even got the line needed to add in the lib-common file.

Short of re-loading my database from a back up (fortunately only six hours old) - I'm sure this can be worked out.....
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Did you make the change in lib-common.php? Or, if you want to get your site back up, did you remove it again?

bye, Dirk
 Quote

Nightdude

Anonymous
I fixed it by deleting my database and installling the backup, now the site is back up.

So I felt daring (ok - maybe stupid) and this time got a sql error when attempting to install Bad Behavior. The error log shows:
Fri Jul 8 14:54:23 2005 - 1146: Table 'scimatdata.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Fri Jul 8 14:54:38 2005 - 1146: Table 'scimatdata.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
and then off cousre, said the site was down showing sql error.

So again, I deleted database, and reinstalled backup.

I need to look at this some more, anyway, I am back up without Bad Behavior
 Quote

Status: offline

Nightdude

Forum User
Chatty
Registered: 15/09/04
Posts: 61
I fixed it by deleting my database and installling the backup, now the site is back up.

So I felt daring (ok - maybe stupid) and this time got a sql error when attempting to install Bad Behavior. The error log shows:
Fri Jul 8 14:54:23 2005 - 1146: Table 'scimatdata.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Fri Jul 8 14:54:38 2005 - 1146: Table 'scimatdata.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
and then off cousre, said the site was down showing sql error.

So again, I deleted database, and reinstalled backup.

I need to look at this some more, anyway, I am back up without Bad Behavior

Hmmmm...Do i dare, is the third time a charm??

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Nightdude: Hmmmm...Do i dare, is the third time a charm??

Nah, I think I know what the problem is. Fresh installs probably don't work at the moment (I've only done updates recently ...).

I'll have to do a bugfix release anyway. Will look into it over the weekend ...

bye, Dirk
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Try Bad Behavior 1.1.4.

bye, Dirk
 Quote

New User

Anonymous
Can someone help me
I tried installing ver 1.2 i created the folders and move the flles to the new folders as suggested.
when i added the required line to the lib-common my site never came backup up (i get a blank page) no errors. are the file(s) /folder(s) suppose to have certain permissions?
Should i leave the required line out, go to to admin and install anyway?

Giving it a try
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by New User: when i added the required line to the lib-common my site never came backup up (i get a blank page) no errors.

See the FAQ: Blank page

bye, Dirk
 Quote

New User

Anonymous
Thank Dirk,
I see the error - PHP Fatal error: Call to undefined function DB_query() in /path/to /public_html/bad_behavior/bad-behavior-geeklog.php on line 75
I looked at the line(s) it reads:
line 74function wp_bb_db_query($query) {
line 75 $result = DB_query ($query);
line 76 if ($result === false) {
line 77 return false;

Question any idea Question
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, did you add the extra line to lib-common.php? Make sure that you do that before you hit "install" for the plugin (just as it says in the installation instructions).

bye, Dirk
 Quote

New User

Anonymous
this is the error i get if I have the line in lib-common.php. when the line is remove the site comes up.
here is what the file lib-common states
require_once( '/path.../geeklog/config.php' );
require_once( $_CONF['path_html'] . '/bad_behavior/bad-behavior-geeklog.php' );

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, config.php? I think you have that line in the wrong place. It should be after the require_once for lib-database.php (line 189 in the lib-common.php for 1.3.11sr1).

bye, Dirk
 Quote

New User

Anonymous
Embarassed you're right it was in the wrong place
now i get this error:
PM PDT - 1146: Table 'geeklog.gl_bad_behavior_log' doesn't exist. SQL in question: DESCRIBE `gl_bad_behavior_log` `denied_reason`; Doh! - that was a mistake
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Okay, it's obviously been a while since I did a fresh install of that plugin ...

This appears to be a bug in Bad Behavior itself, i.e. Michael's part. It checks if the table includes the 'denied_reason' field before the table has even been created.

Open public_html/bad-behavior-database.php and find this piece of code (starts at line 15):
PHP Formatted Code
    // Determine if we can skip all this
    // If this exists, table structure is presumed up to date
    $query = "DESCRIBE `" . WP_BB_LOG . "` `denied_reason`;";
    if (wp_bb_db_query($query) != 0) return;
 


Then move it down before the line that reads
PHP Formatted Code
// Upgrades from 1.0
 


You should end up with this:
PHP Formatted Code
    // Determine if we can skip all this
    // If this exists, table structure is presumed up to date
    $query = "DESCRIBE `" . WP_BB_LOG . "` `denied_reason`;";
    if (wp_bb_db_query($query) != 0) return;

    // Upgrades from 1.0
    $query = "DESCRIBE `" . WP_BB_LOG . "` `request_entity`;";
 


And then it really works.

Sorry about that. I'm going to send Michael a bug report and update the tarball.

bye, Dirk
 Quote

Status: offline

den

Forum User
Newbie
Registered: 19/08/05
Posts: 9
Big Celebration Ssssweeeet! It worked... (it installed with out further errors)
Wow this is great support!
Thanks Dirk

 Quote

Status: offline

wheelsofterror

Forum User
Regular Poster
Registered: 02/09/06
Posts: 78
I tried to install BB 1.2.4 on GL 1.4.1 and upon hitting install, I got the Precondition Failed message error page. I take it thinks I'm a spammer. I uploaded everything and edited the lib-common file. Why is it doing this?
 Quote

All times are EDT. The time is now 12:08 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content