aarbee Posted January 21, 2014 Report Share Posted January 21, 2014 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 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted January 22, 2014 Administrators Report Share Posted January 22, 2014 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? Quote Link to comment Share on other sites More sharing options...
aarbee Posted January 22, 2014 Author Report Share Posted January 22, 2014 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 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted January 23, 2014 Administrators Report Share Posted January 23, 2014 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? Quote Link to comment Share on other sites More sharing options...
aarbee Posted January 23, 2014 Author Report Share Posted January 23, 2014 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 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted January 23, 2014 Administrators Report Share Posted January 23, 2014 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. Quote Link to comment Share on other sites More sharing options...
aarbee Posted January 23, 2014 Author Report Share Posted January 23, 2014 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 Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted January 24, 2014 Members Report Share Posted January 24, 2014 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 Quote Link to comment Share on other sites More sharing options...
aarbee Posted January 24, 2014 Author Report Share Posted January 24, 2014 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. Quote Link to comment Share on other sites More sharing options...
aarbee Posted January 25, 2014 Author Report Share Posted January 25, 2014 Tried to use the original template. But that did not help at all. RobB Quote Link to comment Share on other sites More sharing options...
alblua Posted February 1, 2014 Report Share Posted February 1, 2014 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.