URL to your eFiction: http://mtt.just-once.net/fanfictionbeta (this is just a test run for upgrade)
Version of eFiction: 2.0.6
Have you bridged eFiction, if so with what?: no
Version of PHP: 5 i think, but my admin panel won't load up for me at the moment to check.
Version of MySQL: 5.0.18-standard-log
Have you searched for your problem: yes
If so, what terms did you try: linkstyle
Have you looked at the FAQs: yes
State the nature of your problem: I had a few problems with the auto install of tables, so I did it manually, and then it wouldn't recognise the prefix. Anyway, I sorted that out by renaming the prefix to what the script was looking for, but now on the display settings step, I get this error stating that the linkstyle column is missing.
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_settings SET dateformat = 'd/m/y', timeformat = '- h:i a', extendcats = '0', displaycolumns = '3', itemsperpage = '20', displayindex = '0', defaultsort = '0', recentdays = '7', displayprofile = '1', linkstyle = '1', linkrange = '10' WHERE sitekey = '*****'
Error: (1054) Unknown column 'linkstyle' in 'field list'
I wasn't confident enough to just add this column into the database myself, and looking through the mysql code that came in the download, linkstyle is definitely not in there.
Yes it is.
--
-- Table structure for table `settingsfanfiction_settings`
--CREATE TABLE `fanfiction_settings` (
`sitekey` varchar(50) NOT NULL default '1',
`sitename` varchar(200) NOT NULL default 'Your Site',
`slogan` varchar(200) NOT NULL default 'It's a cool site!',
`url` varchar(200) NOT NULL default ' http://www.yoursite.com',
`siteemail` varchar(200) NOT NULL default 'you@yoursite.com',
`tableprefix` varchar(50) NOT NULL default '',
`skin` varchar(50) NOT NULL default 'default',
`hiddenskins` varchar(255) NULL default '',
`language` varchar(10) NOT NULL default 'en',
`submissionsoff` tinyint(1) NOT NULL default '0',
`storiespath` varchar(20) NOT NULL default 'stories',
`store` varchar(5) NOT NULL default 'files',
`autovalidate` tinyint(1) NOT NULL default '0',
`coauthallowed` int(1) NOT NULL default '0',
`maxwords` int(11) NOT NULL default '0',
`minwords` int(11) NOT NULL default '0',
`imageupload` tinyint(1) NOT NULL default '0',
`imageheight` int(11) NOT NULL default '200',
`imagewidth` int(11) NOT NULL default '200',
`roundrobins` tinyint(1) NOT NULL default '0',
`tinyMCE` tinyint(1) NOT NULL default '0',
`allowed_tags` varchar(200) NOT NULL default '<b><i><u><center><hr><p><br /><br><blockquote><ol><ul><li><img><strong><em>',
`favorites` tinyint(1) NOT NULL default '0',
`multiplecats` tinyint(1) NOT NULL default '0',
`newscomments` tinyint(1) NOT NULL default '0',
`logging` tinyint(1) NOT NULL default '0',
`maintenance` tinyint(1) NOT NULL default '0',
`debug` tinyint(1) NOT NULL default '0',
`captcha` tinyint(1) NOT NULL default '0',
`dateformat` varchar(20) NOT NULL default 'd/m/y',
`timeformat` varchar(20) NOT NULL default '- h:i a',
`recentdays` tinyint(2) NOT NULL default '7',
`displaycolumns` tinyint(1) NOT NULL default '1',
`itemsperpage` tinyint(2) NOT NULL default '25',
`extendcats` tinyint(1) NOT NULL default '0',
`displayindex` tinyint(1) NOT NULL default '0',
`defaultsort` tinyint(1) NOT NULL default '0',
`displayprofile` tinyint(1) NOT NULL default '0',
`linkstyle` tinyint(1) NOT NULL default '0',
`linkrange` tinyint(2) NOT NULL default '5',
`reviewsallowed` tinyint(1) NOT NULL default '0',
`ratings` tinyint(1) NOT NULL default '0',
`anonreviews` tinyint(1) NOT NULL default '0',
`revdelete` tinyint(1) NOT NULL default '0',
`rateonly` tinyint(1) NOT NULL default '0',
`pwdsetting` tinyint(1) NOT NULL default '0',
`alertson` tinyint(1) NOT NULL default '0',
`disablepopups` tinyint(1) NOT NULL default '0',
`agestatement` tinyint(1) NOT NULL default '0',
`words` text,
`version` varchar(10) NOT NULL default '3.0',
`smtp_host` varchar(200) default NULL,
`smtp_username` varchar(50) default NULL,
`smtp_password` varchar(50) default NULL,
PRIMARY KEY (`sitekey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Thanks Tammy.
Linkrange was missing as well from my file, but I put in the table you provided and installation went very smoothly!
I had the same problem as well - the script says to look in docs/tables.sql, which is missing both 'linkstyle' and 'linkrange'. However, the settingstable.sql file is the same as what is pasted above.
Okay thanks for pointing that out. I'll fix it with the next update.
This should be fixed now so I'm marking this thread closed.
