Step 3 Installation...
 
Notifications
Clear all

Step 3 Installation process MySQL fatal error

3 Posts
3 Users
0 Reactions
2,750 Views
(@guest12280)
Posts: 0
 

I've seen this same error asked about before, but the answers given didn't make sense to me and it hadn't been touched in a while.
I'm honestly just about ready to give up on this whole process and remove everything from the computer. It's taken days just to get here, and now I'm thoroughly stumped. Here's the error message:

A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) ENGINE=MyISAM;
Error: ()

I'm doing a new installation, not an update. I'm also rather new to this as well, working on learning php, and this'll be my first website (if it ever actually happens). So please, could any responders give detailed directions about what to do to get past this?

Thanks in advance! πŸ˜•


 
Posted : 09/01/2013 2:00 am
(@hobert)
Posts: 61
Trusted Member
 

Edit the install.php file in the install folder and replace all mentions of TYPE=MyISAM with ENGINE=MyISAM.

The newer versions of PHP on some servers and hosts no longer use the TYPE command.


efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/

 
Posted : 10/01/2013 3:51 pm
(@sheepcontrol)
Posts: 332
Reputable Member
 

Has been updated in 3.5.4

-> Topic locked


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