URL to your eFiction: http://fanfiction.mugglenet.com
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: n/a
Version of PHP: 5.2.5
Version of MySQL: ---
Have you searched for your problem: yes
If so, what terms did you try: "read count"
State the nature of your problem:
We are unable to read stories, add a story, or manage our own stories because this is the error that comes up each time:
A fatal MySQL error was encountered.
Query: UPDATE efictionfanfiction_stories SET count = count + 1 WHERE sid = '76819' LIMIT 1
Error: (1054) Unknown column 'count' in 'field list'
I looked in our SQL, and there is indeed no count field in our stories table. Would it be sufficient to just add the table in? And if so, what are the settings for it? Or is it more complex?
Thanks 🙂
Count should be kept in the stories table.
Did you have a read count mod for 2.0? Maybe that could have made the upgrade hiccup.
If you are missing a count in your stories table, then something went wrong with the install/upgrade. You can try fixing it by fixing the small things that come up as you notice, but it might be hiding a bigger problem.
fanfiction_stories` (
`sid` int(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`summary` text,
`storynotes` text,
`catid` varchar(100) NOT NULL default '0',
`classes` varchar(200) default NULL,
`charid` varchar(250) NOT NULL default '0',
`rid` varchar(25) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`uid` int(11) NOT NULL default '0',
`coauthors` varchar(200) default NULL,
`featured` char(1) NOT NULL default '0',
`validated` char(1) NOT NULL default '0',
`completed` tinyint(4) NOT NULL default '0',
`rr` char(1) NOT NULL default '0',
`wordcount` int(11) NOT NULL default '0',
`reviews` smallint(6) NOT NULL default '0',
`oldcount` int(11) NOT NULL default '0',
`rating` tinyint(4) NOT NULL default '0',
`challenges` varchar(25) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Actually, that was it. All I did was inserted it into the table. Thanks for your help!
