Forum

Unable to Add a Ser...
 
Notifications
Clear all

Unable to Add a Series to a Series

fikgirl
(@fikgirl)
Eminent Member

I was trying to add a series within a series and got the following error:

A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_inseries (seriesid, subseriesid, inorder) VALUES('6', '11', '10')
Error: (1062) Duplicate entry '0-6' for key 1

I should note that I already added one series to this series, and it won't let me add a second one.

Quote
Topic starter Posted : 29/01/2008 5:17 am
Tammy
(@tammy)
Member Moderator

Looks like you're missing a seriesid.  If you want further help you need to fill out the support template.  Generally, if we can't go to your site and look at the problem we're likely to be of much help.

ReplyQuote
Posted : 29/01/2008 11:59 pm
fikgirl
(@fikgirl)
Eminent Member

URL to your eFiction: http://server4.alwayswebhosting.com/~altreal/efiction
Version of eFiction: 3.x
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2.4
Version of MySQL:
Have you searched for your problem: Yes
If so, what terms did you try: add series, nested series
State the nature of your problem: Unable to add a series to a series (nested series)
Error message

A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_inseries (seriesid, subseriesid, inorder) VALUES('6', '11', '10')
Error: (1062) Duplicate entry '0-6' for key 1

Do you have a test account for us? altrealtest, password: test1234

ReplyQuote
Topic starter Posted : 30/01/2008 12:21 am
mickinell
(@mickinell)
Trusted Member

We are having the same problem...

A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_inseries (seriesid, subseriesid, inorder) VALUES('1', '6', '10')
Error: (1062) Duplicate entry '0-1' for key 1

URL:  http://www.mickiclark.com/efiction33/
Version of eFiction: 3.3.1
Bridged with SMF

URL to your eFiction:  http://www.mickiclark.com/efiction33
Version of eFiction:  3.3.1
Have you bridged eFiction, if so with what?:  SMF
Version of PHP:
Version of MySQL: MySQL 4.1.14

ReplyQuote
Posted : 28/03/2008 10:42 pm
cleothemuse
(@cleothemuse)
Active Member

Ran into this problem last night... it looks like the "inseries" table is using seriesid & sid as the primary key, rather than seriesid, sid AND subseriesid.  The following code fixed it:

ALTER TABLE `fanfiction_inseries` DROP PRIMARY KEY ,
ADD UNIQUE (
`sid` ,
`seriesid` ,
`subseriesid`
)

ReplyQuote
Posted : 06/04/2008 1:33 pm
Share: