Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 06:45 am EST

Geeklog Forums

SQL Error After Installing Bad Behavior


Status: offline

rkgermano

Forum User
Newbie
Registered: 12/30/04
Posts: 5
Hello,

I followed the instructions and instaleld Bad Behavior plugin on my site. Something either went wrong or the installation failed and now my site is giving me now a SQL Error has Occurred ....see logs for details. I cannot get any where on my site with out seeing this error and thus cannot turn off or uninstall the plugin. In my logs it says:

Sat Dec 24 23:54:33 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sat Dec 24 23:54:40 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sat Dec 24 23:54:45 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sat Dec 24 23:55:34 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sat Dec 24 23:55:36 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 00:19:41 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 00:19:43 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 00:19:44 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 00:19:46 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 00:19:48 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:02:22 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:02:28 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:02:32 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:02:33 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:03:34 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:04:11 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:04:17 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG
Sun Dec 25 09:04:49 2005 - 1146: Table 'csdhnet_gklg1.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG

1) Is there a manual way to disable or uninstall this plugin not through the plugin scree (since I can't get to it)?

2) What is causing this install to fail or these errors?

Thanks

Rich
 Quote

Status: offline

rkgermano

Forum User
Newbie
Registered: 12/30/04
Posts: 5
Just an update:

I have gone into the MySql database (which I don't like to do) via PHPMyAdmin and found the GL_plugins table and found the plugins_enabled structure for bad_behavior. I have tried to reset pi_enabled from 1 to 0 in hopes that would turn it off. It will not save the change and stays at 1, which I am assuming means I cannot turn it off for some reason.


*****Update****

I was finally able to manually edit the mysql database and turn off the bad_behavior plugin. Yay! My site is back up. Still not sure what caused the mysql error to begin with.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by rkgermano: I followed the instructions

No, you didn't. There's an extra line that has to be added to your lib-common.php and it seems you skipped that step.

bye, Dirk
 Quote

All times are EST. The time is now 06:45 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