Frank S. Hagan

Thanks to both of you! I really appreciate the help. The advice definitely helped me focus. It looks like running through everything again, permissions, password, etc. solved the issue! Not sure which change actually corrected it. The only changes I made to conf_global.php were to remove the prefix from both the 'sql_database' and 'sql_user'. And I thought I tried using both 'sql_database' and 'sql_user' without prefixes before, but maybe not? Anyway, thanks!

Thanks for the response! I have tried it several different ways. For WordPress sites on this server the database name is used without the account name for the connection to work. But using 'frank_invisioncommunity' and 'invisioncommunity' both generate the error. That's combined with trying the username alone and the username with the account prefix. In a terminal session I can log into the MariaDB system with the username and password and "show databases" and see the ones I've created and tried. PHP is also not throwing any errors now (that was a permission problem on a file). My conf_global.php file does show 'mysql' as the sql driver, but it's MariaDB. Same as on the prior server, so I don't think that matters. I'm sure it's something I've overlooked. If you see anything in the image that looks off let me know.

I'm moving my Invision Community to a new server and getting some database errors I can't seem to resolve. I get a 500 error: Access denied for user 'database-user'@'localhost' (using password: YES) I cannot access the /admin account either. My PHP log errors show this: Any ideas on this? I have tried editing the config_global.php file to reflect the database name and username, and haven't had any luck (other than the database username changing in the error messages).

Check the owner / group of the files as well. Sometimes when you move a site the owner of the files is the root of the server instead of the user for that domain (something like that - the important part I remember is the owner). In a terminal window (if you have root access) you should see the owner information in a ls -l directory listing.

Sounds like you're getting pretty good support from your host. Are you hosting on a VPS there?

I've been using the software for 12 years, since January 2011, so I've been around a while too. Removing the ticket system for self hosted folks, but not for cloud customers, is obviously a reduction of support. At least in my opinion, having spent 40 years in support myself. Thanks for letting me know that 5.0 will be for self hosted folks. That was helpful.

Thanks, that finally worked. I think I'll wait a week or two to upgrade in the future. I see a lot of posts that this recent upgrade broke people's forums. I'm not sure you're testing as well as you used to for the self-hosted software. You have reduced the support for it already. Can you comment on if you plan to completely deprecate it in the future?

Any word on this? I've updated the connect details so you have full SFTP / root access to my server.

Sorry, I locked myself out. I have updated the FTP connection details so you should be able to log in now.

I'm having my host look into it. The server is down right now. Will respond here again when it is back up.

I'm getting an error message during upgrade that I can't get past - "Truncated decimal value" in ../upg_107640/upgrade.php::50 My site is down. I cannot restart the upgrade, and when I go to /admin/upgrade it only gives me the option to continue the upgrade.

After the update to v 4.7.1 my secondary groups are not showing. Do I need to edit the templates with the code above?

Yes, thank you! One of the tables was crashed so a database repair fixed it. I will truncate away!

A bit ashamed to say I'm not familiar with the logs in IPB, but noticed that the "uncaught_exception.php" log is 29G in size. Can I reduce it's size? In Admin > System Logs I edited the prune settings to 10 days from 30 days. Should I just wait for a background process to reduce the size of this log? Can I safely use the linux truncate command to reduce this log (worried that it has a .php extension and may need to be handled by the system)? Thanks for any help you can provide!

You misunderstand. He wants them all set to "unread", not "read". Thanks, that makes sense. I was hoping maybe a single forum pointer in the database, but I see how it could be more complex than that now that you mention it.