Forum

Install Problem
 
Notifications
Clear all

Install Problem

Anonymous
 Anonymous
(@Anonymous)
Guest

URL to your eFiction:  station51kmg365.com
Version of eFiction:  3.5.3
Have you bridged eFiction, if so with what?:  N/A
Version of PHP:  5.2.17
Version of MySQL: 5.5.37-log
Have you searched for your problem: Tried to
If so, what terms did you try:  SQL Database Error
State the nature of your problem:   A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`Table1fanfiction_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) 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', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '

', `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.5.3', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) TYPE=MyISAM;
Error: ()
Do you have a test account for us?  No.  Can't set up any accounts.  Install fails at:  How do you want to install the settings table? automatic or manual.  I selected automatic.  Got the above error messages.

Quote
Posted : 03/06/2014 7:23 am
Anonymous
 Anonymous
(@Anonymous)
Guest

I must apologize.  I went back and did a better search this time.  I found the solution to my problem here:  http://forums.efiction.org/index.php?topic=8558.msg44248#msg44248

And even though my knowledge of programming is basic at best, I can find and replace with my eyes closed in Word so this was simple in Notepad.  Saved the file, uploaded.  Install worked.

ReplyQuote
Posted : 03/06/2014 7:43 am
Lyndsie
(@lyndsie)
Member Moderator

Admins, can we consider official release of a version that takes care of these bugs that have come up due to the advancement of PHP/MySQL since the last release? Or even just releasing the corrected install.php?

ReplyQuote
Posted : 05/06/2014 8:57 pm
Sheepcontrol
(@sheepcontrol)
Member Admin

Sure, hoping to get to it this weekend, was thinking about it last week, found another issue with the installer (never de-select co-authors, broke the install on a test).

ReplyQuote
Posted : 05/06/2014 10:01 pm
Sheepcontrol
(@sheepcontrol)
Member Admin

Has been updated in 3.5.4

-> Topic locked

ReplyQuote
Posted : 08/06/2014 1:56 pm
Share: