URL to your eFiction: www.semperance.com/fanfiction
Version of eFiction:3.3 (new installation)
Have you bridged eFiction, if so with what?: I don't know
Version of PHP:5 can be
MySQL 4.1.11
Have you searched for your problem: yes.
If so, what terms did you try: I have looked through the threads to see if there was another issue like mine. I didn't see one.
State the nature of your problem:
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
Warning: Invalid argument supplied for foreach() in /home/www/semperance.com/fanfiction/header.php on line 86
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (fanfiction_authors as author, fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0 AND stories.featured = '1'
Error: (1146) Table 'chrsan84_db.fanfiction_authors' doesn't exist
Do you have a test account for us? no
Somehow the error changed. I haven't changed anything in my files. What the heck happened?
When I got to your website, there was an error message about the header.php and you haven't filled anything in yet. But for the most part it looks like the efiction took. You haven't set a default layout so nothing showed up until I added a "index.php?skin=Zenlike" in order to see the page and see the header php error. I suspect it's because you having logged in as Admin and set things yet.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
I am in the install part still. I got through everything until this part.
Install Tables
Install the database tables.
automatic or manual
I chose automatic and it goes to this 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`) ) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorfields' already exists
url: http://www.semperance.com/fanfiction/install/install.php?step=3&install=automatic
I know little about MySQL. I am trying to teach myself though.
ok I went back and reinstalled the files.
went back through and installed the site.
this is the code I am now getting when I go to this url http://www.semperance.com/fanfiction/install/install.php?step=3&install=automatic
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
-----------
this is the url where I get this error... http://www.semperance.com/fanfiction/
Warning: Invalid argument supplied for foreach() in /home/www/semperance.com/fanfiction/header.php on line 86
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (fanfiction_authors as author, fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0 AND stories.featured = '1'
Error: (1146) Table 'chrsan84_db.fanfiction_authors' doesn't exist
you are getting that error because you installed the tables in the database already when you installed the script before. So you are trying to create something that already exists, and it can't do that.
If this is a new install, empty your database completely and try again to install.
(You do not want to empty your database for upgrades, because you will loose all your information)
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
you are getting that error because you installed the tables in the database already when you installed the script before. So you are trying to create something that already exists, and it can't do that.
If this is a new install, empty your database completely and try again to install.
(You do not want to empty your database for upgrades, because you will loose all your information)
done. thank you
