Can't Install EFiction 5

Yep, the databases exist and I can access them. So not quite sure why I'm getting the error.

Yeah. I think that's the issue. Do you have any suggestions on how to fix it?

This is what I put in, and I still get an error, I am installing it wrong? I'm not very good with this type of code.

Server:localhost
Socket/port: 3306
Username: cl60rilesluc
Password: ••••••
Database: cl60rilesluc
Settings prefix:
Sitekey:NHKpDZ8daT

Failed to connect to database Server.
Last error was: SQLSTATE[HY000] [1045] Access denied for user 'cl60rilesluc'@'10.0.230.53' (using password: YES)
Destination (eFiction 5.x) database settings
Server:localhost
Socket/port:3306
Username:cl60rilesluz04
Password:••••••

Username: cl60rilesluz04
Prefix:fanfiction

Failed to open eFiction 5.x database.
Last error was: SQLSTATE[HY000] [1045] Access denied for user 'cl60rilesluz04'@'10.0.230.53' (using password: YES)

I also installed it another way;

Server:127001
Socket/port: 3306
Username:cl60rilesluc
Password:••••••
Database: cl60rilesluc
Settings prefix:
Sitekey: NHKpDZ8daT

Failed to connect to database Server.
Last error was: SQLSTATE[HY000] [2002] Invalid argument

Destination (eFiction 5.x) database settings
DB driver: Database: cl60rilesluz04
Prefix:fanfics

Failed to open eFiction 5.x database.
Last error was: SQLSTATE[HY000] [2002] Invalid argument

The first try looks promising, make sure you got the right Username, Password and Database. You can usualy look up the data in your providers webinterface or ask for some support.

The second try though has a basic mistake. You provided the Server as "127001" which would indeed be a loobback to the same computer, if entered correctly. It would be "127.0.0.1" actually but would in 99% end up with the same result when using "localhost" as server.

Ok so my database name and username are the same. With the info I provided what database should go in the efiction 5? As it doesn't seem to work for me.

That helped, however now I'm getting a different error;

Server:

176.32.230.53
(localhost when using socket, otherwise use hostname or IP)
Socket/port:

3306
(Empty for default)

Username:

cl60-rilesluc

Password:

•••••••••

Database:

cl60-rilesluc
 
Settings prefix:

(if your settings table is "fanfiction_settings", then this field should be empty)
Sitekey:

NHKpDZ8daT
Below is just some technical information, mainly for troubleshooting:
Character set:
(auto detect)
UTF8MB4
DSN string:
(auto built)
mysql:dbname=cl60-rilesluc;host=127.0.0.1;port=3306;charset=UTF8MB4
Server OK
Failed to open eFiction 3.5.x database.

Internal Server Error

Undefined index: error

[install/lib/base.php:2015] Base->error()
[install/tmp/1juqfkhmrwycy.1w8ambhzc4ia.php:36] Base->{closure}()
[install/lib/base.php:2487] require()
[install/lib/base.php:2657] View->sandbox()
[install/inc/upgrade.php:53] Preview->render()
[install/lib/base.php:1486] Base->call()
[install/index.php:44] Base->run()

I think it's because I don't seem to have the right admin privileges. I've contacted my hosting provider, however they haven't gotten back to me yet. 

I still get the same error I did before. I feel like I inputed data wrong.

The EFiction 3 database still won't work, also I haven't mentioned this but the error I'm getting is 500 Internal Service Error. I'm also still getting these errors at the config page;

Internal Server Error

Undefined index: error

[install/lib/base.php:2015] Base->error()
[install/tmp/1juqfkhmrwycy.1w8ambhzc4ia.php:39] Base->{closure}()
[install/lib/base.php:2487] require()
[install/lib/base.php:2657] View->sandbox()
[install/inc/upgrade.php:66] Preview->render()
[install/lib/base.php:1486] Base->call()
[install/index.php:43] Base->run()

The errors are gone, but the EFiction 3 database won't open.

So putting fan fiction_settings worked and I started the install, however I get this error when creating tables;

ERROR (Array ( [0] => 00000 [1] => [2] => ) )DROP TABLE IF EXISTS `cl60-rileslu-z04`.`fanfictioncategories`; CREATE TABLE `cl60-rileslu-z04`.`fanfictioncategories` ( `cid` int(11) NOT NULL AUTO_INCREMENT, `parent_cid` int(11) NOT NULL DEFAULT '0', `category` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '', `description` text NOT NULL, `image` varchar(100) NOT NULL DEFAULT '', `locked` tinyint(1) NOT NULL DEFAULT '0', `leveldown` tinyint(2) unsigned NOT NULL DEFAULT '0', `inorder` int(11) NOT NULL DEFAULT '0', `counter` int(11) NOT NULL DEFAULT '0', -- can drop this ? `stats` text NOT NULL, PRIMARY KEY (`cid`), KEY `byparent` (`parent_cid`,`inorder`) ) ENGINE=MyISAM DEFAULT CHARSET=UTF8MB4 COMMENT='(eFI5): derived from _categories';

Everything else is fine.

I'm trying to do the upgrade and get this error:

Internal Server Error

Undefined variable: chaptertext

[restricted/lib/base.php:2015] Base->error()
[restricted/inc/sql/upgrade_3_5_x/job_chapters.php:94] Base->{closure}()
[restricted/inc/upgradetools.php:530] chapters_copy()
[restricted/inc/upgradetools.php:279] jobStart()
[restricted/inc/upgrade.php:124] upgradetools::processJobs()
[restricted/lib/base.php:1486] Base->call()
[restricted/index.php:43] Base->run()

I'll look into it tonight when Im home from work. The archive only has one story and chapter in it so I can also try a clean install.

The installer works fine now, no errors 🙂

Ok thanks for the update guys. I'm going to see if the upgrade works, as I'm about to create a new fanfiction site. (deleted the other one.)