Genre set to none after upgrade

To give you a hint, the structure of each table lists what each part of the 'string of numbers' corresponds to. Use phpmyadmin to explore it. Looking at raw data in a text file will probably be too complicated and difficult to sort through. You can upload the 2.7 back ups under a different table name, or in a different database, and then using phpmyadmin will make it easier to use.

So for example, in version 3.0, the classes structure of the fanfiction_classes table says (using phpmyadmin):

class_id class_type class_name

and when you click "Browse" (next to structure) it lists them across the top, and under that is the list of data. So for mine, it looks like this:

class_id class_type class_name
1 1 Action/Adventure
2 1 Angst
3 1 Drama
4 1 Fantasy
5  1  General

So in the data that you get, you know that the second number of every row means a "class type". In this case the class_type number 1 means that it is a genre. So all the examples above have class_type 1, so they are all genres.

I know that class_type number 1 is "genre" by looking at the fanfiction_class_types table in phpmyadmin.

classtype_id classtype_name classtype_title
1 genres  Genres
2 warnings Warnings
3 time         Takes Place

See? Class types id is 1 for Genres.

In the story table of 3.0, it says something like:

sid title summary storynotes catid classes .... wordcount reviews oldcount rating challenges count

So when you look at the string of numbers for a story, you know that the first number will always be the story id number, and the last number will be a count, probably a hitcount.

So when you look at some story info like this:

56  Some Things Never Change  He meant to hit Ron with the snowball, honest!    8  30,1,5  269  1  2005-01-19 12:19:01  2005-01-19 12:19:01  34    0  1  1  0  850  6  0  8  1  384

You know that its story id number is 56, and its hit count is 384. Get it?

Working backwards, or forwards, you can figure out what the other numbers mean. So the number second to last is supposed to be "challenges" based on the structure. In this story, the information for challenges is 1.

Classifications are saved under "classes" in story info, which is listed after story notes, and the category id. SO in my example above, the classes are:

30,1,5

because this author didn't leave any story notes (its blank) and the category id is 8.

If we go to the classes table in phpmyadmin, we can look up what 30, 1 and 5 mean. The "1" class id means "Action/Adventure" and "5" is "General". If I had listed all of my classifications in this post, you would be able to go all the way down to "30", and see that it means "PreGoF", which is a "Takes Place" classification, otherwise known as 'time'.

What you need to do, is explore your database until you understand what all the numbers mean. Figure out what was saved, and under what. Then you will be in a much better position to be able to fix this, and understand the help.

it may be helpful to view a single story info in phpmyadmin. The structure is listed right above the info, so it's easy to compare and see what the numbers mean. Just open the fanfiction_stories table, and search for the story id (sid). If you want to find the story YOU listed, search for sid 2872. You should then be able to figure out what all the numbers mean on your own, easily.

Thank you for your help and patience!

Hugs,
Princess Destiny