New accepted pilots do not see any flight

[aarbee]

I really what causses the issue, described in the title.

Maybe I am doing something wrong.

This happens:

A pilot signs up. I get an email and login to the admin part of PHPVMS.

There I accept the pilot.

Then the pilot says that he has been accepted, but cannot see any schedules when he is logged in.

My workaround is: add the pilot to a different airline and/or hub, save that and place it back.

Can somebody hint me to the cause of the issue, and how to solve it?

Greetings,

RobB

[simpilot]

Do they get the search form the first visit?

Have you modified the schedules template to hide certain schedules for various reasons?

Before you start editing the pilot, are all the fields filled in?

Have you set the debug to true and reviewed the logs related to registration and login?

[aarbee]

Thank you looking into my issue.

Yep, everything is filled in. Tested it myself a few minutes ago.

I have the debug, but it does not show a thing regarding my issue.

The only things I see in the logging is this:

Time: 01.22.14 22:53:35
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='11.11.11.11.1' WHERE `pilotid`=(sometimes I see a number here)
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====

But I do not really know what to do about it.

Greetings,

RobB

[simpilot]

Tough to tell with that error without being able to see the context. I can say that by the error it looks to be that there is no pilotid parameter being passed to the query or there is some odd characters that are being filtered out, but as to where that is being dropped is going to take some investigating on your part to go back through the functions and see where it is being lost, or it is not being found. Are the pilots using email addresses, pilot id's, or just their pilot number to login? Do you get the same issue if they login with a different item?

[aarbee]

I am not sure how the others login, but I login with the pilotnumber. Also from the testaccounts.

I can send you the whole logging via email or pm.

And everything is oke, after I have changed the hub, or airline, for the pilot, and place it back.

Maybe it is an idea to create a new pilot, look into the database and see what is filled.

And then see what is filled after I have changed it?

Greetings,

RobB

[simpilot]

Maybe it is an idea to create a new pilot, look into the database and see what is filled.

And then see what is filled after I have changed it?

That would be a good place to start.

[aarbee]

So well, I did.

And it is remarkable what happens.

If neede I will add a txt file with the changes. Ofcourse I have changed the critical items in something more proper.

What I saw was that the pilot did not get a rank ID after signup. Eventhough you would see the rank if logged in.

Logging in with pilotnumber or emailaddress did not mean a difference.

Well back to facts.

I signed up and looked into the file. The pilot had no rankid.

I accepted the pilot and he still had no rankid.

The rank of New Hire was visable though.

I editted the pilot, changed nothing and saved it.

Strange, but the pilot had a rankid, and could see the schedules.

So somehow, does the rankid, tell the pilotid, what schedules he should see.

So by adding and accepting, the rankid, did not appear.

Only by saving the items of the pilot.

I hope this is sufficient for you, to help me further.

But I have a better workaround.

Thanks again,

RobB

[Vangelis]

DId you put any modules or tampered any of the core files ?

If the answer is no i would upload all the files again in case anything went wrong during the upload

[aarbee]

I did change some files. But none of the once regarding the admin part, or regarding the signup part.

Only display files are changed.

I still do have the original skin. Maybe if I activate that one for a brief moment, I can test it out.

[aarbee]

Tried to use the original template. But that did not help at all.

RobB

[alblua]

Can everyone else see your routes?

Maybe you all the routes on a certain day when you didn't try it out...

Sorry if it's a dumb answer... I'm no PHP programmer.