Jim M

You can find the correct database in conf_global.php What you showed here is different than above screenshot. Is this just a snippet or are you getting new/different queries after each run? If just a snippet, please provide us access: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.

When running these manually are you running them on the correct database? Does each query run and complete without error? Have you tried running the queries through the ACP?

What specifically are the database problems that you are running to fix?

There are some issues with the registration process and subscriptions which has been fixed in 4.7: "Fixed some issues that can occur when requiring a subscription or product to be purchased during registration." I am unable to reproduce this on 4.7.

The user would need to login via Google and supply a Display Name before continuing. This would be intended per your configuration of it.

Please keep in mind, we cannot advise you on how to do things in another platform, in this case Google Adsenses. It would be up to yourself to understand the platform you choose or reach out to them for assistance if you do not understand it.

ACP -> Members -> Members -> view a member -> on "Posts", click the down arrow -> Recount.

You can adjust the content count manually in the ACP on the member profile. I cannot tell you how to do this manually in the database or via code as that is outside our scope of support. The system will continue to count from the artificial count you supply in the ACP. Just ensure an administrator does not rebuild the count as that will reset it back to only content that is available in the database. Keep in mind though, there may be scenarios in the future that we need to rebuild the content count like we have needed to going from version 3 to version 4 so it may get set back sometime in the future.

As you recently upgraded from version 3, the counts are of actual content (not just forum posts, if you use the full suite of software) in the database at time of upgrade. This would be an accurate count of all the content for a user.

You would need to disable Automatic Advertisements in Google AdSense's dashboard. You would need to contact AdSense for assistance in doing so as this would be outside our scope of support.

You're very welcome. Glad we could be of assistance.

You have automatic ads still enabled on Google AdSense, this is what is breaking your community:

"No background tasks running" under "Background Processes" in the ACP -> System -> Dashboard, would be expected if you have no background tasks in your queue. This will happen at times and is not indication of an issue. If there is an error with background tasks, you would receive a warning in the ACP notification system.

I would recommend checking to ensure that these items are available to Guests. A 403 is a permissions error so if it is just these few URLs, it could simply be Guests don't have access to view them.

Did you disable all third party items, including advertisements, as mentioned above?

Glad to hear you found the issue at least 🙂

It is resolving for myself off the VPN now. However, it may take a while, depending on your ISP obtaining your changed nameserver values.

This would be on your server. If you have a hosting provider or server administrator they will know how to access or perform what my colleague explained.

Please disable your advertisements and all things third party. Unfortunately, there is a lot getting injected into the page which is likely causing this.

Thank you for trying that. I have transferred this to a ticket so that we can investigate this further for you. Please watch out for further correspondence via email.

Are you stating that you have made space available? If so, then you would need to see if these issues crop up again. If so, you would need to add more space to your server.

As this is just a test community, I would suggest performing a re-install as it looks like something did not go well on your previous install.

What version of MySQL are you currently using?

Unfortunately, I am unable to reproduce this on 4.7 Beta 9 on a test install. Do you have an example URL which we can investigate this further and validate your settings?

Custom items are included in the .htaccess, please remove that. Also, your server permissions are all 777 for all folders/files which can create problems. Please ensure all folders and files have proper permissions for your server.