Create a custom notification and add multiple content types as fields

Errors happened while subscribed to this custom type of notification

Here is the errors I get

* user warning: Duplicate entry '26-type' for key 1 query: INSERT INTO notifications_fields (sid, field, value, intval) VALUES(26, 'type', 'story', 0) in /web/apache/0319_010_normanwells/sites/all/modules/public/notifications/includes/notifications_subscription.class.inc on line 425.
* user warning: Duplicate entry '26-type' for key 1 query: INSERT INTO notifications_fields (sid, field, value, intval) VALUES(26, 'type', 'book', 0) in /web/apache/0319_010_normanwells/sites/all/modules/public/notifications/includes/notifications_subscription.class.inc on line 425.
* user warning: Duplicate entry '26-type' for key 1 query: INSERT INTO notifications_fields (sid, field, value, intval) VALUES(26, 'type', 'blog', 0) in /web/apache/0319_010_normanwells/sites/all/modules/public/notifications/includes/notifications_subscription.class.inc on line 425.

with my own research, error was causing by the duplicate values of primary key fields in table [notifications_fields]

Comments

keen_outcrop’s picture

keen_outcrop commented
Version: 6.x-4.0-beta5 » 6.x-4.x-dev
keen_outcrop’s picture

keen_outcrop commented
Project: Notifications Add-ons » Notifications
Version: 6.x-4.x-dev » 6.x-4.0-beta7
Component: Content Type extension » Custom subscriptions
keen_outcrop’s picture

keen_outcrop commented
Title: SQL insert errors happened for custom notifications with multiple contenty types » SQL insert errors in creation of custom subscriptions with multiple node content types
L8Night’s picture

L8Night commented

I'm also getting the same error. Is there any way to fix it even if its manual? I'm currently working on getting this module installed and working if there's anything you want me to try.

Running...
Drupal: 6.24
Notifications: 6.x-4.x-beta7

darora’s picture

darora commented

Any update on this issue. I am planning to use this version and need functionality to allow mulitple content types.