Install Problem
 
Notifications
Clear all

Install Problem

5 Posts
3 Users
0 Likes
3,130 Views
(@guest12694)
Posts: 0
New Member 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.

 
Posted : 03/06/2014 1:23 am
(@guest12694)
Posts: 0
New Member 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.

 
Posted : 03/06/2014 1:43 am
(@lyndsie)
Posts: 1262
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?

 
Posted : 05/06/2014 2:57 pm
(@sheepcontrol)
Posts: 332
Reputable Member
 

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).

 
Posted : 05/06/2014 4:01 pm
(@sheepcontrol)
Posts: 332
Reputable Member
 

Has been updated in 3.5.4

-> Topic locked

 
Posted : 08/06/2014 7:56 am
Share: