5SA CEO Posted September 12, 2011 Report Posted September 12, 2011 Hi guys, I have just updated phpvms today (v2.1.934-157-g7ca06a3) and went to the admin page and have a couple of issue. once there on the front page I get the following Open Flash Chart JSON Parse Error [syntax Error] Error at character 0, line 1: 0: <br /> solved when it try's to load the pilot reports for the week. Then when I go to 'view all pilots' under the pilots & groups tab it does not display any details of the pilots at all and sometimes the site crashes. solved Then on the user groups I can no longer edit them? and when checking the balance sheet for the last 3 months it shows nothing and the open flash error as well. solved I am sure it will be something simple but I have been looking all day and not getting anywhere. Anyone got any ideas? Thanks Deano so I re uploaded the admin files and that seems to have solved the main issue, but now all the VA data is gone so will now work on that part. thanks Quote
Administrators simpilot Posted September 13, 2011 Administrators Report Posted September 13, 2011 After you uploaded all the new files to the site did you run the update script? Seems to me that the database did not get updated if you are not seeing chunks of information from it. Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 I have did a complete re download and install of the latest version and run the update and all seems fine now just waiting for the guys to submit a pirep, I cannot see any old pireps though but I will see what happens. Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 Ok so one of the guys has submitted a pirep via xacars and I have had the e-mail but not the pirep in the admin page or view recent pireps. odd me thinks. I'll keep on looking. Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 I appear to have lost all of the va's old pireps and none of the new ones are showing to be approved since I have updated pvpvms. I am getting the e-mail saying they have been submitted 'A PIREP has been submitted by 5SA001 (Dean Lawrence) 5SA101: EGKK to LXGB Aircraft: 19 Flight Time: 02.50 Landing Rate: -78 Filed using: kACARS Comment: Click to approve this pirep (admin must be signed in): http://5starvirtualaviation.com/phpvms/admin/index.php/pirepadmin/approvepirep/ ' but when you go to approve them, nothing.. click on the link and I get this: Warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'PIREPAdmin::approvepirep' was given in /home2/fivstar6/public_html/phpvms/core/classes/MainController.class.php on line 218 218 $ret = call_user_func_array(array($$ModuleName, $call_function), CodonRewrite::$params); Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 another small issue has popped up now. I ran the install database checker and here are the results Checking phpvms_acarsdata...OK Checking phpvms_activityfeed...OK Checking phpvms_adminlog...OK Checking phpvms_aircraft...OK Checking phpvms_airlines...OK Checking phpvms_airports...OK Checking phpvms_awards...OK Checking phpvms_awardsgranted...OK Checking phpvms_bids...OK Checking phpvms_customfields...OK Checking phpvms_downloads...OK Checking phpvms_expenselog...OK Checking phpvms_expenses...OK Checking phpvms_fieldvalues...OK Checking phpvms_financedata...OK Checking phpvms_fuelprices...OK Checking phpvms_groupmembers...OK Checking phpvms_groups... [ERROR] The column core is missing! Checking phpvms_ledger...OK Checking phpvms_navdata...OK Checking phpvms_news...OK Checking phpvms_pages...OK Checking phpvms_pilots... [ERROR] The column payadjust is missing! [ERROR] The column comment is missing! Checking phpvms_pirepcomments...OK Checking phpvms_pirepfields...OK Checking phpvms_pireps... [ERROR] The column modifieddate is missing! [ERROR] The column paytype is missing! Checking phpvms_pirepvalues...OK Checking phpvms_ranks...OK Checking phpvms_schedules... [ERROR] The column week1 is missing! [ERROR] The column week2 is missing! [ERROR] The column week3 is missing! [ERROR] The column week4 is missing! [ERROR] The column payforflight is missing! Checking phpvms_sessions...OK Checking phpvms_settings...OK Checking phpvms_updates...OK so I am missing a few bits then, stupid question time now, how do I solve it? Quote
Administrators simpilot Posted September 13, 2011 Administrators Report Posted September 13, 2011 When you ran the update.php file did you get any errors, all those fields get updated within the database when the update runs. Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 Hi simpilot, No I did'nt get any error messages. it might be time to do yet another complete update install I am checking mysql databases right now and they are all there, all the filed pireps from today are there as well, they are just not diplaying within the admin panel. Quote
Administrators simpilot Posted September 13, 2011 Administrators Report Posted September 13, 2011 Yes, the tables are there, but are the new columns existing? Probably not, that is why it is not showing correctly I would guess. Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 do another install then I guess, eh. Quote
Administrators simpilot Posted September 13, 2011 Administrators Report Posted September 13, 2011 Are you using install.php or update.php? Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 install.php guess I should have run update.php Quote
Administrators simpilot Posted September 13, 2011 Administrators Report Posted September 13, 2011 That is the problem, if you are updating an existing install you should be using http://www.yoursite.com/install/update.php Quote
5SA CEO Posted September 13, 2011 Author Report Posted September 13, 2011 Thanks, I will try that andsee what happens. Quote
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.