Database - Integrity Check issues

I am using Jamroom 4.3.1 with Maestro Skin/Theme 2.0.4 and I get the following error constantly:-
Your Database is not current! Your Database needs to be validated to ensure it is configured correctly for version 4.3.1. Press the "Run Integrity Check" button to run the Integrity Check.

I run the Integrity Check, but get the same error within seconds, when I want to do a server check to see if all versions are the same. it will not fully load and stops on the 'Core'
updated by @ukdenny: 12/29/14 09:14:37AM

Probably not a skin problem, seams like the something is causing it to get stuck on the core. are there any errors in the logs or javascript errors on screen?

That would be where I would focus my attention, on getting that integrity check fully done as the most likely cause of the issue.

First thing that comes to mind is a corrupt file in the FTP upload. Try uploading the core files again to see if that gets it.

I have uploaded the core again but still have the same problem. The integrity check appears to complete but then I get the error about running an integrity check. The Server check still sticks on Features and Versions > Core
Anything else I could try? getting quite frustrated with it all.

Yeah - it sounds like something is causing an error during the integrity check, which in turn prevents it from completing successfully (which is when the core then updates the DB with the latest version so you no longer get the prompt to run the integrity check).

Do you see any errors in your activity log or is there a php error log in your logs directory?

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

The error in the php shows:-
[14-Nov-2013 21:57:01] PHP Warning: ini_restore() has been disabled for security reasons in /home/mydreams/public_html/soundblitzrecords.com/include/jamroom-misc.inc.php on line 7528

This shows from time to time but has never affected to Server Check.
I have my hosting company looking into everything but so far they say nothing with the server is causing the problem.
I would post a screen shot of the server check when it stops, but cannot see how to add it on here.
Getting very frustrated with it all now.
Thanks

Best to wait for brian to see if that function is the cause of the issue, but if it is, here's how to fix it:

http://www.2by2host.com/articles/php-errors-faq/disabled_ini_restore/

it reads "for security reasons" but that reason seams to be invalidated from php 5.2.9 according to this:
https://drupal.org/node/572108

I'm sorry for the frustration - send me your admin login and password, and FTP login info to brian [at] jamroom [dot] net and I will check it out.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Brian, I have now pointed the DNS to another Host to see if it was a server issue. But I cannot install because of this error:-

ERROR - the PHP function fsockopen() is not working properly, and is reporting the following error: (111) Connection refused. PHP fsockopen() is needed for Jamroom to work properly - contact your hosting provider and have them ensure the PHP fsockopen() function is working on your server.

I reported this to the new host who replied:-
The server is fine, it appears to be an error with the installer, so you may need to seek advices from the softwares forum, the engineer provided the following

It seems like the script may be trying to run a loopback connection which means it's trying to look for a URL on itself. So if the installer is located at http://yourdomain.com/installer.php and then it tries to open the file http://yourdomain.com/requiredfile.php this is a loopback connection since it's doing it over http however it it called the file from he server so at /home/sites/whitedovemusic.info/public_html/requiredfile.php then it would work fine.

Should I point the DNS back to the original server and then give you the login details?

regards
Denis

Yes - that would be best - JR4 does require fsockopen() to work properly, so it is not going to work on the new host (regardless of what your provider tells you).

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

I have tried different skins/themes and still get the same issue:
Your Database is not current! Your Database needs to be validated to ensure it is configured correctly for version 4.3.1. Press the "Run Integrity Check" button to run the Integrity Check.

This appears just after I have run an integrity check, all the modules are the same 4.3.1
Does anyone know what would cause this? because I think it's causing other issues also,

I already fixed this for you previously and emailed you the root cause - are you seeing this again?

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Yes, It appears this wasn't fixed. What was fixed when you did it Brian was the Integrity check was stopping half way through it's cycle, this no longer happens. There are other issues which could be part of the current problem such as sometimes some of the menu items are not clickable.
I hope I have explained this so that you are able to understand.
Thanks.
updated by @ukdenny: 11/25/13 01:02:23PM

Then those items are unrelated. The root cause of this issue was that the "version" check got corrupted in your system cache when we moved to the new jamroom.net domain.

This can be ignored, although I know that's not a solution, but it has nothing to do with any other issues you might be seeing in your Jamroom (since the version check is completely self contained in the server check area).

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

So do I presume that you do not know the cause or have a solution?

I had a few issues running the integrity check, after the new jamroom.net was initiated, with my JR4 installs as well. I set the following to "no" in my Admin Options > System Config > System Settings

Show Support
Show Version
Show Run Times
Check for Updates

and things seem to be working, including the integrity check.

Hope this helps,
Douglas


--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos

Hi Douglas,
Thanks, I have now changed the settings but the regen profiles, although shows successfully processed will not allow the 'Continue' to be presses and I have to goback on the browser. I will see if the other errors still appear.
Thanks
Denis

I don't believe I posted anything that said that? Sorry if you were led to believe I had no idea what I was talking about.

If you see a button that is "grayed out" it means it is not valid (or able to run) - try running through your site with your javascript console enabled and look for errors that could be the root cause.

I also want to be sure you know that the forum here is not our "high priority support" option - while we answer almost all posts pretty quickly, please don't expect answers and help within minutes of your followup posts - we're a small team and do our best to help.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Brian, I was not led to believe you had no idea what you where talking about and I never said that either.
But you did not offer any solution to try (Like you now have)for which I thank you.
I am not expecting an answer within minutes, in fact I wasn't sure if this was a skin problem and I asked the developer last Friday and still await a reply.
I have paid for JR5 and the Import of JR4 to it but have now reverted back to JR4 until a Paypal module is developed. I only want this to work correctly till then. But because of the frustration I am looking at other software that may replace JR.
Regarding the Javascript Consol, because I don't know what to look for regarding errors I am at a loss. .

Thanks
Denis
updated by @ukdenny: 11/26/13 07:13:21AM

Why don't you send me your login info again and I will check it out again for you. That would be quicker than me trying to explain how to do it.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Okay, thanks.