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!
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
I updated from a version previous to 2.0…
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
I checked everything, and I even re-updated, still have the same problem
And if I make a new install and I keep the same database, will my fleet and routes and pilots still be there?
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?
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?
Did you run the install/update.php? Click ‘force’ to well, force it to run
I did! Doesn’t change anything…
Then do a fresh DB install, export your data then import it back in
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?
It will fill in all the columns which aren’t missing with blanks so you should be ok
All right I manually added the missing rows in my database and everything seems to be back to normal Thanks Nabeel!
Yeah, I didn’t think of that, that works as well. Glad it’s working now