Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-15105

mcp report: sql error duplicate entry 'report_post' for key 'type'

    Details

      Description

      mcp.php?i=reports&start=0&mode=report_details&f=125&r=3923

      SQL ERROR [ mysqli ]
       
      Duplicate entry 'report_post' for key 'type' [1062]
       
      SQL
       
      INSERT INTO portal_notification_types (notification_type_name, notification_type_enabled) VALUES ('report_post', 1)
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 999
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 193
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/phpbb/notification/manager.php
      LINE: 933
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/phpbb/notification/manager.php
      LINE: 167
      CALL: phpbb\notification\manager->get_notification_type_id()
       
      FILE: [ROOT]/includes/mcp/mcp_reports.php
      LINE: 145
      CALL: phpbb\notification\manager->mark_notifications()
       
      FILE: [ROOT]/includes/functions_module.php
      LINE: 676
      CALL: mcp_reports->main()
       
      FILE: [ROOT]/mcp.php
      LINE: 312
      CALL: p_master->load_active()
      
      

      table portal_notification_types looks like this:

      notification_type_id	notification_type_name	notification_type_enabled
      1	notification.type.admin_activate_user	1
      2	notification.type.topic	1
      3	notification.type.approve_topic	1
      4	notification.type.quote	1
      5	notification.type.bookmark	1
      6	notification.type.post	1
      7	notification.type.approve_post	1
      8	notification.type.disapprove_post	1
      9	notification.type.disapprove_topic	1
      10	notification.type.group_request	1
      11	notification.type.group_request_approved	1
      12	notification.type.pm	1
      13	notification.type.post_in_queue	1
      14	notification.type.report_pm	1
      15	notification.type.report_pm_closed	1
      16	notification.type.report_post	1
      17	notification.type.report_post_closed	1
      18	notification.type.topic_in_queue	1
      19	report_post	1
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                suxo suxo
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: