I just upgraded to 3.2.1 and this is the LAST issue I have, I promise! 😉
I'm having this issue come up when I go to create a new series. I go to "Add new series" and fill out the page entirely. The next page that lists all of the author's stories comes up fine and I check off the ones that I want to add to the series. However, when I click "select" and the next page that's supposed to let me put the stories in the correct order doesn't load. Instead, I have this mySQL error come up:
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_series SET numstories = '3' WHERE seriesid = 71 LIMIT 1
Error: (1054) Unknown column 'numstories' in 'field list'
http://www.sinful-desire.org/archive is the URL and I have a test account - user name: test, password: test if that helps. I'm guessing this is an issue wth the fanfiction_series in my sql database but don't quite know what to do.
Thank you!
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
I looked at the upgrade script and this numstories field is added during the optimize. The thing is when you did the manual and followed my suggestion to edit the upgrade script so you could finish step 19 and the install, I failed to notice that this statement was not in the optimize.sql. Sorry about that /doh!
Go to you db via my phpAdmin
Click on the SQL tab
In the box paste the statement below
Edit able_prefix_ to your table prefix in front of the table name
Click Go
Statement:
ALTER TABLE `table_prefix_fanfiction_series` ADD `numstories` INT NOT NULL DEFAULT '0'
Then try to add a series and see if that fixes it. Hopefully that's correct syntax.
Awesome!! That worked! Thank you dear, you are the best with all my crazy issues!
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
Glad I could help out.
