Unable to Add a Series to a Series

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.

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

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

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`
)