I get the following error message when i submit a link:

user warning: Duplicate entry '30' for key 1 query: INSERT INTO drigg_node (dnid, promoted_on, killed, url, title_url, safe_section, content_type, trackback_ping_url, trackback_ping_successful) VALUES (30, 1233266890, 0, 'http://vilabuilt.com/new-york-city-design-build-firm-profile.html', 'Profile-R4443', 'Housing', 'text/html', '', 1) in /home/nycis/public_html/modules/drigg/drigg/drigg.module on line 1068.
user warning: Duplicate entry '30' for key 1 query: INSERT INTO drigg_node (dnid, promoted_on, killed, url, title_url, safe_section, content_type, trackback_ping_url, trackback_ping_successful) VALUES (30, 1233266890, 0, 'http://vilabuilt.com/new-york-city-design-build-firm-profile.html', 'Profile-R8523', 'Housing', 'text/html', '', 1) in /home/nycis/public_html/modules/drigg/drigg/drigg.module on line 1068.
user warning: Duplicate entry '30' for key 1 query: INSERT INTO drigg_node (dnid, promoted_on, killed, url, title_url, safe_section, content_type, trackback_ping_url, trackback_ping_successful) VALUES (30, 1233266890, 0, 'http://vilabuilt.com/new-york-city-design-build-firm-profile.html', 'Profile-R6999', 'Housing', 'text/html', '', 1) in /home/nycis/public_html/modules/drigg/drigg/drigg.module on line 1068.
user warning: Duplicate entry '30' for key 1 query: INSERT INTO drigg_node (dnid, promoted_on, killed, url, title_url, safe_section, content_type, trackback_ping_url, trackback_ping_successful) VALUES (30, 1233266890, 0, 'http://vilabuilt.com/new-york-city-design-build-firm-profile.html', 'Profile-R11091', 'Housing', 'text/html', '', 1) in /home/nycis/public_html/modules/drigg/drigg/drigg.module on line 1068.
user warning: Duplicate entry '30' for key 1 query: INSERT INTO drigg_node (dnid, promoted_on, killed, url, title_url, safe_section, content_type, trackback_ping_url, trackback_ping_successful) VALUES (30, 1233266890, 0, 'http://vilabuilt.com/new-york-city-design-build-firm-profile.html', 'Profile-R8813', 'Housing', 'text/html', '', 1) in /home/nycis/public_html/modules/drigg/drigg/drigg.module on line 1068.

Comments

mercmobily’s picture

mercmobily commented
Status: Active » Fixed

Hi,

You need to check the auto-increment value of your drigg_node table. For some reason, the auto-increment is set to 30, but you already have that primary key. Did you run the pligg importer? That could cause it...

Closing this, since I am 98.9% sure that's the problem...

Merc.

burn2149’s picture

burn2149 commented

Hey. I'm not so sure how to do that--could you give me a hint? thanks so much.

mercmobily’s picture

mercmobily commented

Hi,

Sorry... this is a general Drupal question really.
The best spot is the forums, or Google for tons of information on how reset the auto increment table in mysql. I don't mean to be difficult, but I really need to concentrate on supporting Drigg itself rather than Drupal in general -- which has a thriving community.

Bye,

Merc.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.