I'm going to say the same thing here than I said on the DBFL: I have no idea how to fix this. While there is an update to the script, I'm afraid to use it because they tend to create even more problems.

Getting an SQL error after adding a new chapter seems to create no real problems, but getting one after editing story information might. If it does, feel free to contact me.

The entire process is going to take awhile. I asked customer support how long it would take since they have to do it instead of me, and I didn't receive definite answer. So, I'm going to re-open submissions. I make weekly backups of everything so, in the event of a data loss, it won't be too bad.

This is pretty much a plea for you NOT to add or change anything on the site until February 16th. I have to change over to a new server and it might take awhile for the URLs to switch over to it. This means that whatever you add/change might be lost after my domain is pointing to the new server. Actually, it's probably better for everyone to wait until I give the "all clear."

The archive's running a new version of eFiction finally. I'm a few months behind on the updates.

New Features:

1. You can now easily find beta readers. There is a link on the left under "Institution Services" as well as a link on the "Registered Otaku" page. I'm trying to find a way to display what they're willing to beta.
2. There is an option to save an addiction (both short and long ones) as a Microsoft Word document for offline reading.
3. Registered otaku can now recommend fanfics that aren't in this archive using a URL. They still must fit the theme of OISA, however. Yes, you can recommend something that you, yourself, have written and just don't feel like uploading. Only choose this option for a multi-part if it has an index/table of contents page or if it's in an automated archive like this one.
   

I want everyone to know that the submission rules for this site are not identical to the ones found on The Dragon Ball Fanfiction Library and The Otaku Institute even though the three sites do share some of the same rules. Each site has rules that are specific to that particular archive since they all have different focuses. So you need to read the rules on each site in their entirety so that you won't accidentally break any of them.

Here is a list of the universal archive rules:

1. You can add fanfics, songs, lists, etc. to an archive as long as they match the theme of the archive. You can't add incomplete chapters, author's notes as separate entries, advertisements, etc. Also, your authors notes must be less than 5% of the total text of your submission.
   
   
2. You can submit fanfics that don't match the theme of the archive but they have to be e-mailed to me with via attachment (HTML or plain text) with all of the submission's information.
   
   
3. It is recommended that you have your work edited by someone else as you may miss mistakes. Spellcheck is also recommended.
   
   
4. Plagiarism is very serious and is not allowed. Those who are found to be plagiarists will be deleted and banned from the site.
   
   
5. Fanfics that contain sexual content must be marked with an M (R) or AO (NC-17) rating depending on the level of detail.
   
   
6. Story titles and summaries must be no higher than PT (PG) level.
   
   
7. You are not allowed to submit part of your fanfic and then link to the rest on another site.
   
   

I added the new categories and deleted the old genre-based ones. All of the existing stories are now in their respective fandom divisions. I also corrected all of Shinigami Baby's Gundam Wing fanfics (at least ten + the accompanying chapters) that one of the upgrades had wreaked havoc on. No more missing linebreaks. Also, every fanfic that was missing (i.e. chapters: 0) has been re-added.

Phase II (site conversion part 2 and skin editing) will commence someday soon.