Jump to:
| Project: | E-Publish |
| Version: | 6.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I used the Quotes module to post a number of nodes simultaneously. The following errors displayed:
user warning: Duplicate entry '155' for key 1 query:
INSERT INTO epublish_abstract (nid, epublish_abstract)
VALUES ('155','First attempt to import a group...')
in ... epublish.module on line 502.
user warning: Duplicate entry '155' for key 1 query:
INSERT INTO event
(nid, event_start, event_end, timezone, start_in_dst, end_in_dst, has_time, has_end_date)
VALUES (155,'2008-06-24 0:28:00','2008-06-24 0:28:00',484, 0, 0, 0, 0)
in ...event.module on line 2288.
This is a heads-up to anyone else who may be using Event and/or Epublish.
I'm starting to wonder if the rapid publishing of several nodes in Quotes is causing some kind of lock contention in MySQL that random nodes are tripping on. Here's a cross-reference back to my report on the Quotes module. Maybe someone else can see a pattern: #274154: SQL errors from other modules on import
We have a fairly new but fully patched v6.2 here (as you can see) with lots of modules in test mode and with E-Publish beta2. I've installed this module but know very little about it yet as I haven't had time to play with it. I'll be happy to alpha test patches.
TIA
Comments
#1
Whoops, I see this is a FAQ. Please close. Thanks.
http://drupal.org/node/69722
#2
Actually, please keep this open for a bit. I'm told "D6 doesn't use the sequences table any more." so that FAQ may not apply. We disabled Event handling for Quotes and even with a small data creation in Quotes the same issue displays for E-Publish. I'm looking into it as time permits.
#3
I believe this issue is obsolete with the current epublish code. Please reopen if it is not.