XF 2.2 Install Error.

[secnam]

Hi Have just downloaded the Xenforo file (full) but when i go to the install i am getting this error:

An exception occurred: [mysqli_sql_exception] Access denied for user ''@'localhost' (using password: YES) in src/XF/Db/Mysqli/Adapter.php on line 159

mysqli->real_connect() in src/XF/Db/Mysqli/Adapter.php at line 159
XF\Db\Mysqli\Adapter->makeConnection() in src/XF/Db/Mysqli/Adapter.php at line 28
XF\Db\Mysqli\Adapter->getConnection() in src/XF/Db/AbstractAdapter.php at line 60
XF\Db\AbstractAdapter->connect() in src/XF/Db/Mysqli/Adapter.php at line 113
XF\Db\Mysqli\Adapter->escapeString() in src/XF/Db/AbstractAdapter.php at line 516
XF\Db\AbstractAdapter->quote() in src/XF/Db/AbstractAdapter.php at line 494
XF\Db\AbstractAdapter->quote() in src/XF/DataRegistry.php at line 138
XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
XF\DataRegistry->offsetGet() in src/XF/Install/App.php at line 74
XF\Install\App->XF\Install{closure}() in src/XF/Container.php at line 28
XF\Container->offsetGet() in src/XF/App.php at line 2317
XF\App->setupAddOnComposerAutoload() in src/XF/Install/App.php at line 160
XF\Install\App->setup() in src/XF.php at line 461
XF::setupApp() in src/XF.php at line 484
XF::runApp() in install/index.php at line 14

I have noticed in the download i cannot see a config for me to put the database parameters?

Any ideas much appreciated.

Thanks

Paul

 

[JohnLogar]

Please check the password of Mysql user is correct. It's seems that password or user is incorrect.

 

[secnam]

Hi John, What file would that be in?

 

[ENF]

Hi John, What file would that be in?

When you started the installer, it should have created a config.php in ./src/.
You need to make sure that the user name/password/connection data for your database is set correctly in that file.
If you're not sure what your DB password is, ask your host for help or lookup how to reset the password in MySQL.

The error as quoted, is simple matter of making sure your DB connection information is correct in config.php

 

[Paul B]

I have noticed in the download i cannot see a config for me to put the database parameters?

The MySQL details are entered during the installation steps.

The software then attempts to connect to the database.

If the credentials are not correct the installer won't proceed and the config.php file won't be created.

If the src/config.php file has already been created somehow then the details need to match what you have set in your hosting account for the database name, user, and password.

 

[secnam]

Hi, When i started the installer it didnt create the config file so i have gone back to the host incase it is a file permission issue.

 

[secnam]

@Brogan ah thank you i didnt know it was in there.

 

[secnam]

I added the database items and still get this error:

An exception occurred: [mysqli_sql_exception] Table '*******_xehrth4yhsgh465hsgh.xf_data_registry' doesn't exist in src/XF/Db/Mysqli/Statement.php on line 35

1. mysqli->prepare() in src/XF/Db/Mysqli/Statement.php at line 35
2. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
5. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 135
6. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
7. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
8. XF\DataRegistry->offsetGet() in src/XF/Install/App.php at line 74
9. XF\Install\App->XF\Install\{closure}() in src/XF/Container.php at line 28
10. XF\Container->offsetGet() in src/XF/App.php at line 2317
11. XF\App->setupAddOnComposerAutoload() in src/XF/Install/App.php at line 160
12. XF\Install\App->setup() in src/XF.php at line 461
13. XF::setupApp() in src/XF.php at line 484
14. XF::runApp() in install/index.php at line 14

 

[Paul B]

Delete the internal_data/install-lock.php file and start the installation again.

 

[secnam]

That file isnt there.

 

[R0mainMK]

That file isnt there.

Did you tried to go back to /install to see if you can redo the installation process?

 

[secnam]

Yes tried thank, i have rasied a ticket with my host incase its a permissions issue.

 

[secnam]

Update: It turned out it was a server permissions issue.

Thank you all above for taking the time to reply.