I have two questions I would like to address. The first one is the most recent, and of importance:
URL to your eFiction: http://manorfiction.monkeemanor.net/index.php
Version of eFiction: 3.4.2
Have you bridged eFiction, if so with what?: I don't think so, haven't quite figured out what bridging is
Version of PHP: latest version
Version of MySQL: latest version
Have you searched for your problem: yes
If so, what terms did you try: Error 1054
State the nature of your problem: When I try to post a new chapter to an existing story, I get the following error:
-------
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_stats set wordcount = '57170', chapters = '64', authors = '3'
Error: (1054) Unknown column 'wordcount' in 'field list'
-------
Do you have a test account for us?
Member: admin
Password: test
My second question is in regards to restoring the site info database to the index page. I have tried to read similar posts regarding this issue, but I still cannot make heads or tails of what I'm supposed to do. I am a novice when it comes to using eFiction, so any assistance would be greatly appreciated.
Thank you in advance,
~ Lexi
You're missing the stats table it looks like. Find the relevant section in the docs files (sorry not at my own computer so I can't give you exact info) and use phpMyAdmin to add it.
Okay, I'm looking at the fanfiction_stats tables on my phpMyAdmin and I have a no index defined error. I would like to fix this, but I would need to have step by step instructions, so I don't mess up my tables even further.
Nevermind, found the error. Thank you for the assistance.
~ Lexi
