Administrators Nabeel Posted August 18, 2010 Author Administrators Report Posted August 18, 2010 It's in my signature
TAV1702 Posted August 18, 2010 Report Posted August 18, 2010 Thanks Nabeel. I forgot all about setting that to debug in the config file. Now on with the situation. I looked at my debug and this is what it said. =====Time: 08.18.10 15:32:39 ===== Time: 08.18.10 15:32:39 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > PilotAdmin->viewpilots > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `code`='STR', `firstname`='Ray', `lastname`='Browell', `email`='TAV0001@thunderva.com', `location`='US', `hub`='KMCI', `retired`=0, `totalhours`='40.07', `totalflights`='17', `totalpay`='2314.94', `transferhours`='100', `comment`='', `payadjust`=100 WHERE `pilotid`=1 Error: (1054) - Unknown column 'comment' in 'field list' ===== Notice the comment section above in red? Well, I removed the comment code from the pilot admin and now my entire pilot admin works a treat. Apparently, the little section in the admin panel you can add a comment on the pilots details, well according to my database, there is no comment field at all. So like I said, I removed all code related to comment and all is well now.
Administrators Nabeel Posted August 19, 2010 Author Administrators Report Posted August 19, 2010 Ah crap. That's because the update.sql script wasn't run. There's a bug with that which I need to fix... but ifyou run the /install/update.sql file manually does that resolve it?
TAV1702 Posted August 19, 2010 Report Posted August 19, 2010 Nabeel to be honest, I already ditched the code in the tpl to get things up to speed with me and my whole other 5 pilots. I do however, have a test install on a WAMP server. It is the latest stable. I will go upgrade it to this beta version and try it out and see if I can duplicate the problem. If so, I will run them querys and see what happens. Give me about 30 minutes or so and I will have some results for you.
Administrators Nabeel Posted August 19, 2010 Author Administrators Report Posted August 19, 2010 No problem, take your time. I think I know what the issue is, just confirming it. Just have to find the time to fix it up
TAV1702 Posted August 19, 2010 Report Posted August 19, 2010 Ok that's cool. I'll get back to you in a few.
TAV1702 Posted August 20, 2010 Report Posted August 20, 2010 Nabeel, you are correct. That is a bug that needs fixed. I tried to run the update.sql by hand in pph my admin but kept getting duplicate collum name errors. After weeding through it all and getting what worked and what did not, the comments finally worked in the admin section for pilot details. Now that being said, I tried this on my local WAMP server and when I did a check install, i got LOADS of errors. So any info obtained from my local server I am not taking for anything reliable. BUT the initial problem did occur as well on a host server.
Administrators Nabeel Posted August 20, 2010 Author Administrators Report Posted August 20, 2010 Nabeel, you are correct. That is a bug that needs fixed. I tried to run the update.sql by hand in pph my admin but kept getting duplicate collum name errors. After weeding through it all and getting what worked and what did not, the comments finally worked in the admin section for pilot details. Now that being said, I tried this on my local WAMP server and when I did a check install, i got LOADS of errors. So any info obtained from my local server I am not taking for anything reliable. BUT the initial problem did occur as well on a host server. Yeah it will give those dupe column errors and whatnot, but I just ignore those. Anything that hasn't been applied will apply anyway. It's less work for me to just throw the entire changeset at it and say "you figure it out. Thanks though, I'll hopefully get some time soon to have it fixed for the next beta
TAV1702 Posted August 20, 2010 Report Posted August 20, 2010 No probs Nabeel. I'm sure you will get it sooner or later. I have no fear. Ever get any news from airnav about live fuel prices?
Administrators Nabeel Posted August 21, 2010 Author Administrators Report Posted August 21, 2010 No probs Nabeel. I'm sure you will get it sooner or later. I have no fear. Ever get any news from airnav about live fuel prices? Yeah, they said no way. Bastards.
TAV1702 Posted August 22, 2010 Report Posted August 22, 2010 That kind of sux a little bit. No other site has anything like it that can be used? It's all good by me. I'm still using that last update that you put back on the server. So far the only live fuel prices I have is with anything NOT in the USA. For some reason, all my fuel prices are coming back as 0. I have been manually updating them as the problem comes up.
Administrators Nabeel Posted August 23, 2010 Author Administrators Report Posted August 23, 2010 Nope, no sites. But I'm thinking of letting people update the prices I have, haven't had the time yet. Might do it and have it tied to a forum ID or something
Artjom Posted September 29, 2010 Report Posted September 29, 2010 please re-upload phpvms 943, but 944 have some bugs! Thanks!
Recommended Posts