-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
3.2.0
-
None
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
|
|
- is related to
-
PHPBB-15850 Use standard SQL cache for notification types
- Unverified Fix