Hi, I've tried to do a clean install of 3.3 but keep getting a SQL error when setting up the database:
- Uploaded files to server
- Created database
- Moved through to Point 4 (How do you want to install the settings table?) and chose "Automatic" & get the following error:
A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`settingsfanfiction_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 collate utf8_unicode_ci, `version` varchar(10) NOT NULL default '3.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: (1064) You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci, `version` varchar(10) NOT NULL defau
Manually, I get:
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `fanfiction_log`
--
CREATE TABLE `fanfiction_log` (
`log_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`log_action` varchar( 255 ) default NULL ,
`log_uid` int( 11 ) NOT NULL default '0',
`log_ip` int( 11 ) default NULL ,
`log_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`log_type` char( 2 ) NOT NULL default '',
PRIMARY KEY ( `log_id` )
) TYPE = MYISAM ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`log_type` ch
Suggestions would be very welcome.
thanks!
What version of mysql do you have? - it looks like it may be to old to be compatible with efiction as it doesn't understand the CURRENT_TIMESTAMP keyword.
This feature was introduced in mysql version 4.1.2 (which is over 3 years old). I''m not sure its publicly documented anywhere what the oldest supported of mysql is, but I suspect it is a lot newer than 4.1.2.
You can probably get away with changing that line to:
log_timestamp` timestamp ,
Hello, I had this problem when installing eFiction 3.3 on my locahost too ' ' I tried to run the sql files in "docs" folder in phpMyAdmin, and had error with the queries again T_T
Just wanna ask, what version of PHP and mySQL did the coder tested eFiction 3.3 with ? :")
I'm using:
PHP: 4.4.1
mySQL: 5.0.16
Which of the two errors did you get? I didn't notice before that the automatic error Sue got was different to the manual one.
It should be safe to remove "collate utf_unicode_ci" from the query that creates the settings table although I don't know why that would be an issue - that has also been supported for some time.
