XF 2.2 I don't seem to be getting any help on my installation issue...

[Jwrbloom]

Clean install isn't accessing the install module (or whatever it's called). I just get the following errors:

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

1. mysqli->real_connect() in src/XF/Db/Mysqli/Adapter.php at line 159
2. XF\Db\Mysqli\Adapter->makeConnection() in src/XF/Db/Mysqli/Adapter.php at line 28
3. XF\Db\Mysqli\Adapter->getConnection() in src/XF/Db/AbstractAdapter.php at line 60
4. XF\Db\AbstractAdapter->connect() in src/XF/Db/Mysqli/Adapter.php at line 113
5. XF\Db\Mysqli\Adapter->escapeString() in src/XF/Db/AbstractAdapter.php at line 516
6. XF\Db\AbstractAdapter->quote() in src/XF/Db/AbstractAdapter.php at line 494
7. XF\Db\AbstractAdapter->quote() in src/XF/DataRegistry.php at line 138
8. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
9. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
10. XF\DataRegistry->offsetGet() in src/XF/Install/App.php at line 74
11. XF\Install\App->XF\Install\{closure}() in src/XF/Container.php at line 28
12. XF\Container->offsetGet() in src/XF/App.php at line 2280
13. XF\App->setupAddOnComposerAutoload() in src/XF/Install/App.php at line 160
14. XF\Install\App->setup() in src/XF.php at line 437
15. XF::setupApp() in src/XF.php at line 460
16. XF::runApp() in install/index.php at line 14

Host says it's not their issue. I've been with them for 16 years, give or take, and I have a Xenforo install on another site. IIRC, I type in the URL/forum/install, and it opens up prompts to fill in database credentials.

Now, I can go in populate the config.php file, but all that does is reduce the errors by one line.

 

[ENF]

The error message as written:
An exception occurred: [mysqli_sql_exception][B] Access denied for user ''@'localhost' (using password: NO) [/B]in src/XF/Db/Mysqli/Adapter.php on line 159
Indicates a couple of different possible issues:

1) Your database connection information is wrong in ../src/config.php.
2) Your database credentials are wrong (wrong combination of username/password stored in ../src/config.php.

Step #1 - Verify that the database credentials are correct (this is the database username/password that is set by you or your host)
Step #2 - Verify that the information in ../src/config.php is complete and accurate, matching the db username and password configured by you or your host. (the error points to a configuration error in ../src/config.php OR your database is not properly setup)

 

[Jwrbloom]

OK...what I'm not following is this...

Shouldn't an install module show up to ask for those credentials?

That hasn't happened yet, or do I have to manually update via FTP? I don't remember having to update config.php via FTP just to install.

 

[Jwrbloom]

OK...so now I update the config.php file, and like I said above, all it does is get rid of one line of errors.

An exception occurred: [mysqli_sql_exception] Table 'nitoaute_xenforo.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 2280
11. XF\App->setupAddOnComposerAutoload() in src/XF/Install/App.php at line 160
12. XF\Install\App->setup() in src/XF.php at line 437
13. XF::setupApp() in src/XF.php at line 460
14. XF::runApp() in install/index.php at line 14

The installer is supposed to take my credentials then populate the database with its tables.

It's not doing that.

 

[ENF]

Yes, in a typical installation, the install script starts with asking for those credentials.
It may be possible that you have a install-lock.php file present at ../internal_data/ which could block the setup routine.

Check the internal_data folder to see if there is a install-lock.php file there. (if there is, delete it and start over again)

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

This tells me that XF thinks it's already installed.

(you might as well delete the config.php too if you are starting over from scratch)

 

[Jwrbloom]

I don't have the install-lock.php file. Nothing has been installed yet.

Deleting the config.php file is just going to bring me back to the beginning where it says my credentials aren't accurate.

 

[Jwrbloom]

I'm not the only one who has presented this issue, and there doesn't seem to be a fix.

 

[ENF]

I don't have the install-lock.php file. Nothing has been installed yet.

Deleting the config.php file is just going to bring me back to the beginning where it says my credentials aren't accurate.

Ok, then I'm not sure what's going on. Something you have done is attempting to bypass the install routine where it asks for the setup credentials.
The install-lock.php would make sense, but if it's not there then I'm not sure.

I'm not the only one who has presented this issue, and there doesn't seem to be a fix.

Ok, I haven't seen those posts... I've done a few different installs this week and haven't run into this.
(And yes I have, just forgot... the two cases I could locate were related to PHP version and another for caching.)

My next step here would be to completely erase the install and upload a fresh set of XF files and try again.
I would also flush any cache to prevent issues that a cache could trigger...

Edit: When I say cache, this means your local cache AND any caching on the server. (Flush it or disable it to install)

 

[ENF]

Could you also post your specs? Which server type (apache/nginx, etc) and the PHP version?

 

[Jwrbloom]

I'm not trying to be argumentative, but it's nothing I have done. I uploaded the software and created the database.

I'll get the information here shortly...

 

[ENF]

I'm not trying to be argumentative, but it's nothing I have done. I uploaded the software and created the database

Never said that (like blaming you), I'm just stepping through a typical troubleshooting checklist. (It's usually the most simplest of answers, sometimes it's not... but going through the list helps eliminate errors and missteps.)

 

[Jwrbloom]

PHP version is 8.3

MySQL version is 8.0.41-32

Not sure where to find server type, but I believe it's apache.

 

[ENF]

PHP version is 8.3

MySQL version is 8.0.41-32

Not sure where to find server type, but I believe it's apache.

Oh... what exact version of xf2.2 are you trying to install here?

 

[Jwrbloom]

Oh... what exact version of xf2.2 are you trying to install here?

2.2.0 is what I have access to download.

 

[ENF]

2.2.0 is what I have access to download.

So, I think you may want to back down your PHP version in this case.
I don't recall 2.2.0 being overly compatible with PHP 8.3.x -- I think you can use 8.2.26 safely.

 

[Jwrbloom]

Edit: When I say cache, this means your local cache AND any caching on the server. (Flush it or disable it to install)

I've flushed the local cache. What caching on the server?

I did see one instance of this where there was something about disabling cache extensions. I don't have access to do that.

So, I think you may want to back down your PHP version in this case.
I don't recall 2.2.0 being overly compatible with PHP 8.3.x -- I think you can use 8.2.26 safely.

Okk...let me check. I can change my PHP level.

 

[Jwrbloom]

I backed it down to 8.2, but I'm getting the same errors. Would it take time?

 

[ENF]

I backed it down to 8.2, but I'm getting the same errors. Would take time?

No, it should be fairly instant...

I don't have an active XF2.2.0 test site open, but in reading other comments, the maximum PHP version may be 8.0.
Officially, I think 7.4 was the recommended version for this release. The release notes say PHP 7.0 or newer.

 

[Jwrbloom]

No, it should be fairly instant...

I don't have an active XF2.2.0 test site open, but in reading other comments, the maximum PHP version may be 8.0.
Officially, I think 7.4 was the recommended version for this release. The release notes say PHP 7.0 or newer.

Pulled it back to 7.4. Errors is still there.

(I'm also talking to my host support -- Host Gator.)

 

[Jwrbloom]