No access to Admin Panel

Hello-

So I have been an admin and web developer for my VA for years now. I tried to login over the past few days and every time I click Admin or go to the admin center I get the error “Error was occured. Please log in first” I tried logging out and re-logging in with no luck. Went into the database and I am showing as part of group 1 - Administrators. I had the only other admin login and he said I show I am part of the admin group in my profile. Not sure what happened…any ideas? I was editing routes a few days ago and I went in to do more editing and it seems like the admin center wont let me in anymore. Any suggestions to the fix would be helpful so I can get some pireps approved.

Thank you!

What OS (Mac, Linux, Windows?) and what browser are you using? Reason I ask is because lately I’ve had some Mac users tell me that Safari isn’t remembering the session and they constantly have to log back in. Just trying to eliminate that as a potential problem. 

Are you sure nothing else has changed in the database or on your files? Does anyone else have access to either the SQL database, or directory access on the web server?

Windows 10 and Ive tried chrome, edge, and IE with no luck…same error.

I am the only one with the password to the sql database and server. I have nt been in the server in over 4 months. Its just weird because one day im editing schedules and the next day it wont let me in the admin panel. Ive seen the “unauthorized user” several years ago and resolved that but never the “Please login” when clicking it. The other admin when in and removed me from the admin group and added me back in and still no luck. I just opened the sql database and it shows my Id in the admin group…

I also just logged into another pilot’s account after bumping them up to admin status for testing (done through sql) and all the admin links popped up that a normal admin would see…but go figure they cannot log in either…same error message I get. Attached a pic of the exact message I get. Any help is great at this point. I have tried 3 different pcs and none will let me back into the acmin center…

error1.zip

Anyone have suggestions for a fix?

Have you recently cleaned your cookies on your Browser? What version of phpvms are you running also?

On 3/9/2019 at 7:10 AM, Heritage1 said:

Have you recently cleaned your cookies on your Browser? What version of phpvms are you running also?

I am running Chrome and I have cleaned up my browsers on all computer…still not working.

Still says “An error was encountered. Please login first.” Now none of the admins can access the admin center. I double checked the sql database and all the admins are in the administrator group. I tried adding them to the hub manager group, which also has access to the admin center…still no joy. I have tons of pireps stacking up and no way to get to them for approvals.

We are running phpvms 5.5.2.

Any help at all is great. I’m running against a brick wall.

Did you try to log in again? What happens when you do that?

What version of PHP are you running?

You have a few limited options at this point, it almost sounds like some of the Original Admin Files somehow might have been corrupted, the key files are in following areas that you most definately can overwrite and replace without affecting anything else, be very careful on doing so, and take your time on this also, double check your work, and always rename your original files for example;

layout.php.default  etc… make sure you always rename your files just incase, the ones you would be overwriting of course. Thus, lets start, in your file structure you will have the following folder structures to be overwritten…/admin/lib . go there first. there are 3 default files there you can overwrite, airport_template.csv and phpvmsadmin.js and template.csv those are safe to overwrite.

Next, go to ; /admin/lib/layout . … overwrite layout.php, style.css and header.php files. Thats it, nothing else, and again, make sure you rename ANYTHING your overwriting so you have a backup to go back to, and don’t say I didn’t warn you on that. On that note, make sure you pull those files I’ve mentioned out of the install you have for phpvms, make a copy and upload the copys to the mentioned areas. What your doing is overwriting just the default files back to where it was on your Install. This should solve your problem, if your unsure, then by all means do not do it, and poke me a message first, I’m always around the boards. Hope this helps you, and again be very careful, Always Back things Up !

Jim

1 hour ago, ProAvia said:

Did you try to log in again? What happens when you do that?

What version of PHP are you running?

When I logout and log back in, there is no change. I even used another admin account and no luck. It is phpvms 5 5.2 running on php 7.3 server. I know they updated about 2 months ago if that makes any difference.

25 minutes ago, Heritage1 said:

You have a few limited options at this point, it almost sounds like some of the Original Admin Files somehow might have been corrupted, the key files are in following areas that you most definately can overwrite and replace without affecting anything else, be very careful on doing so, and take your time on this also, double check your work, and always rename your original files for example;

layout.php.default  etc… make sure you always rename your files just incase, the ones you would be overwriting of course. Thus, lets start, in your file structure you will have the following folder structures to be overwritten…/admin/lib . go there first. there are 3 default files there you can overwrite, airport_template.csv and phpvmsadmin.js and template.csv those are safe to overwrite.

Next, go to ; /admin/lib/layout . … overwrite layout.php, style.css and header.php files. Thats it, nothing else, and again, make sure you rename ANYTHING your overwriting so you have a backup to go back to, and don’t say I didn’t warn you on that. On that note, make sure you pull those files I’ve mentioned out of the install you have for phpvms, make a copy and upload the copys to the mentioned areas. What your doing is overwriting just the default files back to where it was on your Install. This should solve your problem, if your unsure, then by all means do not do it, and poke me a message first, I’m always around the boards. Hope this helps you, and again be very careful, Always Back things Up !

Jim

I thought about doing that…I will see if I can find the default files for 5.5.2 and give that a whirl. Thanks for the advice. I’ll let you know how it goes.

If you are running PHP 7.3 - that may well be your issue. Can you downgrade the PHP version to 5.6 (or as low as 5.3)? If you can’t go back to php 5.x, what PHP versions are available to you?

What is your site URL?

 

18 minutes ago, ProAvia said:

If you are running PHP 7.3 - that may well be your issue. Can you downgrade the PHP version to 5.6 (or as low as 5.3)? If you can’t go back to php 5.x, what PHP versions are available to you?

What is your site URL?

 

Justhost has me on 7.3 despite my complaining. I dont see any way of downgrading back to where we were.

Our site is: fly.ravnalaskavirtual.com 

The mobile version is pretty useless so you may want to make sure you view it through a PC browser.

 

Edit: Just host assistant allowed me to bump back down to 5.6 but still having issues…

I don’t see any errors showing when loading the site and looking around as a guest…

In /core/local.config.php - around line 25 - what is the ERROR_LEVEL set to?

Are you using cPanel when accessing your host? Do you have an option for “MultiPHP Manager” - and can you set your VA domain to anything but 7.3 there? 

Also - in the DB groups table - what is the permissions number shown for Admins?

 

1 hour ago, ProAvia said:

I don’t see any errors showing when loading the site and looking around as a guest…

In /core/local.config.php - around line 25 - what is the ERROR_LEVEL set to?

Are you using cPanel when accessing your host? Do you have an option for “MultiPHP Manager” - and can you set your VA domain to anything but 7.3 there? 

it shows server is on 7.3 but my fly.ravnalaskavirtual.com is 5.6.

I attached the config file so you can see the settings

and yes we use the cpanel with justhost.

 

Edit your post above and delete the zip file as it contains a password.

As a test, change all 3 for PHP 5.6 . The error level set is okay.

From a couple posts up… Also - in the DB groups table - what is the permissions number shown for Admins?

10 minutes ago, ProAvia said:

Edit your post above and delete the zip file as it contains a password.

As a test, change all 3 for PHP 5.6 . The error level set is okay.

From a couple posts up… Also - in the DB groups table - what is the permissions number shown for Admins?

thanks for catching that wit the password…missed that.

also I changed the files with the ones from the original files…still no change.

Permission number is 536870911

Justhost wont let me downgrade the domains below 7.0…somehow my fly.ravnalaska domain is remaining at 5.6

The permission number is correct for Admin on phpVMS 5.5.2

I’m not sure the other 2 are causing any issues - just thought it might be good to try downgrading their PHP version.

I’m at a loss.

1 minute ago, ProAvia said:

The permission number is correct for Admin on phpVMS 5.5.2

I’m not sure the other 2 are causing any issues - just thought it might be good to try downgrading their PHP version.

I’m at a loss.

i know its crazy. Not sure what could be causing this. it worked fine 2 months ago and now it wont play nice with us. I might have to find a new skin and start fresh…should i be looking into upgrading to the phpvms7.0 version or stick with my 5.5.2? 

Aside from that my site is a dud right now as i cant get into the admin panel…