EricThePanic Posted June 11, 2010 Report Posted June 11, 2010 Hi! I need some help. I updated to version 2.1.934 and now when I submit a PIREP, I get redirected to my flights page as usual, but the pirep I just submitted is doesn't appear anywhere, not even in the admin center... Except that I receive the notification email... Any Idea? Thanks! Quote
Administrators Nabeel Posted June 11, 2010 Administrators Report Posted June 11, 2010 Hi! I need some help. I updated to version 2.1.934 and now when I submit a PIREP, I get redirected to my flights page as usual, but the pirep I just submitted is doesn't appear anywhere, not even in the admin center... Except that I receive the notification email... Any Idea? Thanks! Did you update from 2.0? Read the changelog, there were updated templates Quote
EricThePanic Posted June 11, 2010 Author Report Posted June 11, 2010 I updated from a version previous to 2.0... Quote
Administrators Nabeel Posted June 11, 2010 Administrators Report Posted June 11, 2010 Then from 2.0 to 2.1 I'm assuming. Well, check the changelog, there were template changes which have to be made. Also, run the install/checkinstall.php script to make sure there's no corrupted or missing files Quote
EricThePanic Posted June 11, 2010 Author Report Posted June 11, 2010 I checked everything, and I even re-updated, still have the same problem Quote
EricThePanic Posted June 11, 2010 Author Report Posted June 11, 2010 And if I make a new install and I keep the same database, will my fleet and routes and pilots still be there? Quote
Administrators Nabeel Posted June 11, 2010 Administrators Report Posted June 11, 2010 And if I make a new install and I keep the same database, will my fleet and routes and pilots still be there? If you copy everything sure. Can you paste the output from running install/checkinstall.php and install/checkdb.php? Quote
EricThePanic Posted June 12, 2010 Author Report Posted June 12, 2010 Ohh I just did the DB check... it found a few errors there.. Database Check Checking phpvms_acarsdata...OK Checking phpvms_adminlog... [ERROR] The table phpvms_adminlog is missing! 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... [ERROR] The column value is missing! 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...OK Checking phpvms_navdata...OK Checking phpvms_news...OK Checking phpvms_pages...OK Checking phpvms_pilots...OK Checking phpvms_pirepcomments...OK Checking phpvms_pirepfields...OK Checking phpvms_pireps... [ERROR] The column landingrate is missing! [ERROR] The column rawdata is missing! Checking phpvms_pirepvalues...OK Checking phpvms_ranks...OK Checking phpvms_schedules... [ERROR] The column flightlevel is missing! Checking phpvms_sessions...OK Checking phpvms_settings...OK Checking phpvms_updates...OK Would that be the problem? How do I fix that? Quote
Administrators Nabeel Posted June 12, 2010 Administrators Report Posted June 12, 2010 Did you run the install/update.php? Click 'force' to well, force it to run Quote
EricThePanic Posted June 12, 2010 Author Report Posted June 12, 2010 I did! Doesn't change anything... Quote
Administrators Nabeel Posted June 12, 2010 Administrators Report Posted June 12, 2010 Then do a fresh DB install, export your data then import it back in Quote
EricThePanic Posted June 12, 2010 Author Report Posted June 12, 2010 If I import my database back, it still has a few columns missing. Is there a way to add the missing columns in the current database? Quote
Administrators Nabeel Posted June 13, 2010 Administrators Report Posted June 13, 2010 It will fill in all the columns which aren't missing with blanks so you should be ok Quote
EricThePanic Posted June 16, 2010 Author Report Posted June 16, 2010 All right I manually added the missing rows in my database and everything seems to be back to normal Thanks Nabeel! Quote
Administrators Nabeel Posted June 16, 2010 Administrators Report Posted June 16, 2010 Yeah, I didn't think of that, that works as well. Glad it's working now 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.