An error occurred (500 Error)

[Anders Svejgaard Østerø]

Dear fellow IP Board-users,

Does anybody know what is wrong here (see attached image).

It worked some days ago, but now when a member tries to access the forum this image comes.

Hope somebody can help me. This would be very appreciated 🙂 

Thanks! 

Best Anders

[Hatsu]

This seems to be an error with your database.

Are the database credentials correct?

[Anders Svejgaard Østerø]

Hi Hatsu.
Thanks for your response.
How do I check if the credentials are correct?
It worked fine before, but recently my hosting expired for a day due to failling payment. Could this be the cause?
Thanks!
Best Anders

[Jim M]

Your database connection details, including server, database user, and database password can be found in the conf_global.php file. However, to verify these credentials, please contact your hosting provider.

[Anders Svejgaard Østerø]

Thanks for your answer, Jim.
I checked this file. Could the reason for the error be due to the fact that I recently changed my wordpress password?
Or could it be because my hosting expired for one day due to failed payment?

[Jim M]

This would be your database password, not your WordPress software password. If you are unsure if these are correct or they are correct and you can't connect, you would need to contact your hosting provider, I'm afraid.

[Anders Svejgaard Østerø]

Jim, thanks. They should be correct and it worked before, but suddenly the error appears. So, I also tried to contact my hosting provider and they say that it is not something they provide support to as it is related to the configuration of script/theme/plugin or designing of website. So it was not of much help, unfortunately.

[Anders Svejgaard Østerø]

In the PHP error log it says: Backend fatal error: PHP Fatal error: Uncaught IPS\\Db\\Exception: Access denied for user 'xxxx@localhost' (using password: YES) in /xxxx/xxxx/public_html/community/system/Db/Db.php:266\nStacktrace:\n#0 /xxx/xxx/public_html/community/systemDb/Db.php(353): IPS \\_Db ->_establishConnection(false)\n#1 ... etc.
 

[Jim M]

Please provide them this specific error as the software stack trace is reporting database credentials or access issues:

Access denied for user 'xxxx@localhost' (using password: YES)

Replace the xxxx@localhost with what exactly is being reported there.

Unfortunately, this is a hosting issue (or at least a data entry issue), it is not a software issue as present there. Our software has no authority of your MySQL server and it's database users.

If your hosting provider continues to give you grief. You can try creating a new user on your own if your hosting panel supports it and update your conf_global.php file. I'm afraid, we do not provide hosting support so it would be up your hosting provider to verify your database user credentials or resolve the underlying error.

If this is an ongoing issue, have you considered our Cloud? We handle everything from our infrastructure to the software so there is no go-between or issues like these; leaving you to just focus on building your community 🙂 .

[Anders Svejgaard Østerø]

Thanks, Jim. I provided them with it. They say that my Wordpress site and the software might not be able to run on the same database (user/MySQL). However, I find this weird, since it used to work fine by using the same database. But they say that if one database is connected to 2 different wordpress, it will load the same site and not different (although they say it could be different for other software).

So they say ''you can tell the software company support that there were no changes from our side''.

All I can say is that I for sure have not changed anything. So I find it pretty disturbing that it suddenly does not work 😞 

Maybe it would help to install IP Board again and make a new user (MySQL) and database and attach these to the new installation. 

Can the Cloud-version be sync'ed with Wordpress (Memberpress) regarding role mapping and members / non-members and will it still be launched on my site xxx.xxxxxx.com/community?

[Jim M]

Long as you are using different prefixes in your database, while not advised, two different applications could run in the same database. Sounds like your hosting provider is not understanding the issue at hand, I'm afraid.

I would advise them to create a separate user for your Invision Community then if that is what they are stating here and then update your conf_global.php with those credentials.

 

14 minutes ago, Anders Svejgaard Østerø said:

Maybe it would help to install IP Board again and make a new user (MySQL) and database and attach these to the new installation. 

If your hosting provider wants to separate these out and move your Invision Community to a new database, that is fine. I would not recommend doing a new installation as you would lose all data.

15 minutes ago, Anders Svejgaard Østerø said:

Can the Cloud-version be sync'ed with Wordpress (Memberpress) regarding role mapping and members / non-members and will it still be launched on my site xxx.xxxxxx.com/community?

Are you using a plugin to manage this currently? If so, yes, the plugin would work for WordPress on our Cloud.

I'm afraid though, you would need to utilize a root domain or sub-domain on our cloud. It sounds like you have a WordPress website at your root so I would recommend something like community.example.com . If you're interested, I can move this to our Sales team who can help you in your migration to our Cloud?

[Anders Svejgaard Østerø]

3 minutes ago, Jim M said:

Long as you are using different prefixes in your database, while not advised, two different applications could run in the same database. Sounds like your hosting provider is not understanding the issue at hand, I'm afraid.

I would advise them to create a separate user for your Invision Community then if that is what they are stating here and then update your conf_global.php with those credentials.

I will try this.

4 minutes ago, Jim M said:

If your hosting provider wants to separate these out and move your Invision Community to a new database, that is fine. I would not recommend doing a new installation as you would lose all data.

Sure, I think it would be better not to do a new installation, but how do I link these new credentials (separate users / databases) to Invision Community because I only did it during the installation process.

6 minutes ago, Jim M said:

Are you using a plugin to manage this currently? If so, yes, the plugin would work for WordPress on our Cloud.

I'm afraid though, you would need to utilize a root domain or sub-domain on our cloud. It sounds like you have a WordPress website at your root so I would recommend something like community.example.com . If you're interested, I can move this to our Sales team who can help you in your migration to our Cloud?

Yes, I use Memberspress and installed the SSO-plugin to sync IP Board to Wordpress and did some role mapping.

I might be interested if it can match what I would need.

[Jim M]

4 minutes ago, Anders Svejgaard Østerø said:

Sure, I think it would be better not to do a new installation, but how do I link these new credentials (separate users / databases) to Invision Community because I only did it during the installation process.

You would modify the conf_global.php file.

 

4 minutes ago, Anders Svejgaard Østerø said:

Yes, I use Memberspress and installed the SSO-plugin to sync IP Board to Wordpress and did some role mapping.

That should work. Our sales team can work over specifics but if it's a plugin that's available in the Marketplace, there will be no difference running in our Cloud.

6 minutes ago, Anders Svejgaard Østerø said:

I might be interested if it can match what I would need.

Sounds good. I'll move this over to our Sales team who can help you with some specifics and answer any further questions.

[Anders Svejgaard Østerø]

17 minutes ago, Anders Svejgaard Østerø said:

11 minutes ago, Jim M said:

You would modify the conf_global.php file.

Thanks, Jim. So I tried together with the hosting company to make a new database and user (i.e. credentials) and then link these into the conf_global_php-file. 

This trick does not seem to help. However, it changes the error message to:

Table 'newdatabase_newdatabasecore_theme_settings_fields' doesn't exist

[Jim M]

4 minutes ago, Anders Svejgaard Østerø said:

Thanks, Jim. So I tried together with the hosting company to make a new database and user (i.e. credentials) and then link these into the conf_global_php-file. 

This trick does not seem to help. However, it changes the error message to:

Table 'newdatabase_newdatabasecore_theme_settings_fields' doesn't exist

If you create a new database, you would need to copy over your Invision Community tables in your existing one. Your hosting provider should be able to take the prefix in the conf_global.php and move only those tables. 
 

Sorry for any confusion, the previous instructions were only to setup a new user on the existing database. 

[Anders Svejgaard Østerø]

Thanks Jim. My hosting company was not allowed to do so and they said I should get a developer to do it.

Still, I find it very odd that it suddenly does not work as I have not changed anything, but it might be due to the fact that I should have used two databases from start (and it maybe only worked for a limited time).

Regarding the cloud option, would a sales rep. reach out to me?

 

 

[Marc]

13 hours ago, Anders Svejgaard Østerø said:

Thanks Jim. My hosting company was not allowed to do so and they said I should get a developer to do it.

Still, I find it very odd that it suddenly does not work as I have not changed anything, but it might be due to the fact that I should have used two databases from start (and it maybe only worked for a limited time).

Regarding the cloud option, would a sales rep. reach out to me?

 

 

I have created a ticket for you, for our sales team. We are unable to assist you with performing database moves unfortunately