Bug missing table

[AluminumPints]

never got this error before


XF\Db\Exception: MySQL statement prepare error [1146]: Table 'admin_vq37_forum.xf_dbtech_security_bad_behavior' doesn't exist in src/XF/Db/AbstractStatement.php at line 228

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
6. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
7. XF\Mvc\Entity\Finder->total() in src/addons/DBTech/Security/Admin/Controller/Log.php at line 634
8. DBTech\Security\Admin\Controller\Log->actionBadBehavior() in src/XF/Mvc/Dispatcher.php at line 350
9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
13. XF\App->run() in src/XF.php at line 391
14. XF::runApp() in admin.php at line 13

 

[Fillip H.]

Can you check your database to see if perhaps you have the old table name xf_dbtech_security_badbehavior instead?

 

[AluminumPints]

that table is not in the db

 

[Fillip H.]

CREATE TABLE `xf_dbtech_security_bad_behavior` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `request_method` text NOT NULL,
  `request_uri` text NOT NULL,
  `server_protocol` text NOT NULL,
  `http_headers` text NOT NULL,
  `user_agent` text NOT NULL,
  `request_entity` text NOT NULL,
  `key` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ip` (`ip`(15)),
  KEY `user_agent` (`user_agent`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Remove DEFAULT CHARSET=utf8mb4 if you have not configured your forum to use utf8mb4.

 

[AluminumPints]

#1067 - Invalid default value for 'date'

 

[Fillip H.]

What version of MySQL are you using?

Try removing the DEFAULT '0000-00-00 00:00:00' part.

 

[AluminumPints]

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_dbtech_security_bad_behavior.date' in 'order clause' in src/XF/Db/AbstractStatement.php at line 228

 

[Fillip H.]

What version of MySQL are you using?

 

[Fillip H.]

Also, you appear to have removed the entire date column instead of just the section I pointed out. You will need to delete the table and try again.

 

[AluminumPints]

that fixed it ... thanks !

 

[DragonByte Technologies]

Hello @sixpax12,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @sixpax12,

As we have not heard back from you, your ticket regarding DragonByte Security has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.