A Fatal MySQL error...
 
Notifications
Clear all

A Fatal MySQL error?

12 Posts
6 Users
0 Reactions
8,104 Views
(@guest6627)
Posts: 0
 

I've been monkeying with the install for a few days now but today I received this error just as I thought I had finally gotten a breakthrough. What to do, anyone?

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`) ) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorfields' already exists


 
Posted : 04/05/2010 12:37 am
(@tammy)
Posts: 2577
Member Moderator
 

You already completed that step in the install.  You're trying to install that table twice.


 
Posted : 04/05/2010 1:28 am
(@guest6627)
Posts: 0
 

That's what I thought but how would I get pass this page? It doesn't give me any options. (Thanks for the prompt reply btw)

--ooh, nevermind, I see! THANKS!


 
Posted : 04/05/2010 1:29 am
(@wolfiejinn)
Posts: 19
Active Member
 

How'd you get passed it?  I'm having the same issues.....installing 3.5.3 on another domain & install ran spiffy until I installed the tables, then it blew out with this error.  I've tried backtracking, everything.  Checked my CHMODs, the whole schmear. I've even uninstalled and reinstalled twice....to no avail.

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`) ) TYPE=MyISAM;
Error: ()

 
Posted : 03/05/2011 1:49 am
(@tammy)
Posts: 2577
Member Moderator
 

Change the step in the url.  step=1 to step=2 for example.


 
Posted : 03/05/2011 3:52 pm
(@wolfiejinn)
Posts: 19
Active Member
 

What does that mean?


 
Posted : 05/05/2011 10:55 pm
(@babaca)
Posts: 722
Member Moderator
 

She means when you are the page where you start having problems in the install on your browser it will say something like

http://www.yourdomain.com/install/install.php?step=3

to get past that page of the install change the step number in the url to

http://www.yourdomail.com/install/install.php?step=<b>4</b>

it will move on in the install process.


******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3

 
Posted : 06/05/2011 3:15 pm
(@wolfiejinn)
Posts: 19
Active Member
 

And tada! It worked!  Ya'll are awesomesauce.  ๐Ÿ˜ฎ


 
Posted : 11/05/2011 2:57 am
ShiKahr
(@shikahr)
Posts: 60
Trusted Member
 

I have also an Error starts with A fatal MySQL error was encountered.

My installed tools:
Apache 2.2.11 is running
PHP 5.3.5 works
MySql 5.5.8 is running
ImageMagick 4.2.9 is available and works

And here step by step what I did and where the error occured.

Step1

Step2

Step3 I chose automatic

Step4

Edit: I tried the manual way too, but it stucks in a circle asking

Manually install the settings table from the tables.sql file found in the docs/ folder now. 

Continue

And that brings me back to the page where I am asked if I want to install automatically or manually.


Get your Arsch out of the couch." Gayle Tufts

 
Posted : 11/05/2011 2:30 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Did you actually set up the table manually? If not, you need to do it or it will do that kind of a loop. It looks to me like the default HTML in the allowed_tags column is screwing it up somehow. I don't have 3.5.3 on this computer at the moment, let me download it.

ETA: It looks right. It might be something particular to your server setup. In any case, I'd use PHPMyAdmin or whatever you have to make sure it's not already installed, then add it manually, and then you will be able to move on.


 
Posted : 11/05/2011 10:25 pm
ShiKahr
(@shikahr)
Posts: 60
Trusted Member
 

I tried both automatic and manually. The result you can see in the screenshots.
I went back to an older php, mysql and even apache release and that works fine.


Get your Arsch out of the couch." Gayle Tufts

 
Posted : 29/05/2011 6:49 pm
ShiKahr
(@shikahr)
Posts: 60
Trusted Member
 

Wanted to try the update again, but again ... the same errors if not even more.
A list of errors before I even came to the point to fill the form for connecting to the Database or creating the tables anyway if manually or automatically.
When I go back to the "theoretically" installed fiction-archive, I get the following error.


Get your Arsch out of the couch." Gayle Tufts

 
Posted : 13/10/2011 7:26 am
Share: