dragomano/Optimus

Database Error: Field 'id_term' doesn't have a default value

Closed this issue · 0 comments

Describe the bug
You'll get database error when search something!

To Reproduce
Steps to reproduce the behavior:

  1. Install the latest SMF2.1 and Optimus mod
  2. Go to Optimus settings --> Enable logging of search terms
  3. Go to Search page and search anything
  4. See error:

Type of error: Database
Database Error: Field 'id_term' doesn't have a default value
http://127.0.0.1/SMF21/index.php?action=search2
C:/Program Files/Ampps/www/SMF21/Sources/Optimus/Subs.php (Line 740)

Environment

  • Database Type: MySQL
  • Database Version: MySQL 8.0
  • PHP Version: 7.3
  • SMF Version: 2.1 RC2

P/S: I've changed manually in phpmyadmin to fix this problem (add value AUTO_INCREMENT NOT NULL to id_term in smf_optimus_search_terms)