I'm back again...
So. I moved the upgraded site to replace the old one and the sermons aren't showing up and In the backend when I save/modify a sermon I get this error:
Code:
Error
Save failed with the following error: Unknown column 'modified' in 'field list' SQL=UPDATE `j33_sermon_sermons` SET `speaker_id`='10000',`series_id`='0',`audiofile`='/podcast/2009-01-19_20090118.mp3',`title`='Antidotes for Fear',`alias`='antidotes-for-fear',`sermon_number`='0',`custom1`='',`custom2`='',`sermon_date`='2009-01-18 00:00:00',`sermon_time`='00:27:39',`play`='0',`notes`='
Based on a sermon my Martin Luther King, Jr. in which he points to God\'s answers to fear.
',`download`='0',`state`='1',`ordering`='0',`hits`='533',`created_by`='62',`created`='2009-01-18 00:00:00',`podcast`='1',`addfile`='',`addfileDesc`='',`catid`='120',`metakey`='',`metadesc`='',`audiofilesize`='145008',`videofilesize`='0',`videofile`='',`picture`='',`checked_out`='62',`checked_out_time`='2014-06-14 16:38:59',`language`='*',`metadata`='{\"robots\":\"\",\"rights\":\"\"}',`version`='2',`modified`='2014-06-14 16:39:03',`modified_by`='62' WHERE `id`='10000'
I can create a sermon and save it, everything is fine, but anytime i try to re-save a sermon I get that error and it doesn't save it. Also, none of the sermons are showing up on the front end except for any new ones that I make.
I did try uninstalling sermon speaker and resinstalling using the migrate methode. starting with 4.5.4 than adding the old database, then installing again over top then upgrading it to the latest version of sermon speaker.
