Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-8594

SQL error when configuring Q&A CAPTCHA

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • 3.0.6
    • 3.0.x
    • ACP
    • None
    • PHP Environment:
      Database: postgres 8.4

      Configuring the Q&A CAPTCHA within the ACP fails with an SQL error when clicking the "configure" button:

      General Error
      SQL ERROR [ postgres ]

      ERROR: argument of WHERE must be type boolean, not type integer LINE 1: SELECT * FROM phpbb_captcha_questions WHERE 1 ^ []

      SQL

      SELECT * FROM phpbb_captcha_questions WHERE 1

      BACKTRACE

      FILE: includes/db/postgres.php
      LINE: 177
      CALL: dbal->sql_error()

      FILE: includes/captcha/plugins/phpbb_captcha_qa_plugin.php
      LINE: 680
      CALL: dbal_postgres->sql_query()

      FILE: includes/captcha/plugins/phpbb_captcha_qa_plugin.php
      LINE: 573
      CALL: phpbb_captcha_qa->acp_question_list()

      FILE: includes/acp/acp_captcha.php
      LINE: 47
      CALL: phpbb_captcha_qa->acp_page()

      FILE: includes/functions_module.php
      LINE: 507
      CALL: acp_captcha->main()

      FILE: adm/index.php
      LINE: 74
      CALL: p_master->load_active()

            Kellanved Kellanved [X] (Inactive)
            Schumi Schumi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: