Hello.
I got the following error when filing a PIREP manually:
Error! There was an error adding your PIREP : Schedule does not exist. Please update this manually.
Before, I filed a PIREP via smartCARS, which said that the PIREP had filed, so when I went to the admin page to check the list of PIREPs, there was none added. So I tried the manual way and received the aforementioned error. Currently using phpvms version 5.5.2.72 simpilot/php7.2
Any help would be appreciated.
Thanks,
Conor.
Be aware that this is a v5 issue not v7 - your post has been moved to the v5 Support section.
What MySQL or MariaDB version are you using?
17 hours ago, ProAvia said:
Be aware that this is a v5 issue not v7 - your post has been moved to the v5 Support section.
What MySQL or MariaDB version are you using?
I am using MySQL 5.7.33
Is error reporting on? Any errors showing in error_log file? Any errors showing in the console?
4 hours ago, ProAvia said:
Is error reporting on? Any errors showing in error_log file? Any errors showing in the console?
Yes, and there are no new errors in the error_log file.
Look in the console (F12) using Chrome.
Chances are your host has Strict Mode on in MySQL 5.7 - ask them to turn it off.
15 hours ago, ProAvia said:
Look in the console (F12) using Chrome.
Chances are your host has Strict Mode on in MySQL 5.7 - ask them to turn it off.
index-0.js:3 Uncaught TypeError: Cannot read property ‘getContext’ of null
at index-0.js:3
(anonymous) @ index-0.js:3
phpvms.js:27 Uncaught TypeError: $(…).ajaxForm is not a function
at HTMLDocument.<anonymous> (phpvms.js:27)
at j (jquery.min.js:2)
at Object.fireWith [as resolveWith] (jquery.min.js:2)
at Function.ready (jquery.min.js:2)
at HTMLDocument.I (jquery.min.js:2)
And I’ll contact the host about that - thanks
Just disabled strict mode, still no difference.
24 minutes ago, crazyconzie said:
Just disabled strict mode, still no difference.
Did you try filing a new manual PIREP and one thru smartCARS? Be sure that you enter data in each field.
Also, switch back to the default crystal skin and try there too.
On 1/24/2021 at 3:01 PM, ProAvia said:
Did you try filing a new manual PIREP and one thru smartCARS? Be sure that you enter data in each field.
Also, switch back to the default crystal skin and try there too.
That’s strange; I get the PIREP sent message in the website admin email “A PIREP has been submitted by x” and it says to approve it at a certain link. But when you go to the pending PIREPs page in the admin panel, there are no reports showing..,
This happened to me last year, I got the pirep has been filed but nothing there. Do any of the forms that insert data work? Try putting in the INSERT code INSERT IGNORE try see if that works, as that is how I fixed my problem.
On 1/24/2021 at 8:01 AM, ProAvia said:
Did you try filing a new manual PIREP and one thru smartCARS? Be sure that you enter data in each field.
Also, switch back to the default crystal skin and try there too.
2 hours ago, crazyconzie said:
That’s strange; I get the PIREP sent message in the website admin email “A PIREP has been submitted by x” and it says to approve it at a certain link. But when you go to the pending PIREPs page in the admin panel, there are no reports showing..,
Did you try what I suggested above? It is unclear from your response.
17 hours ago, Strider said:
This happened to me last year, I got the pirep has been filed but nothing there. Do any of the forms that insert data work? Try putting in the INSERT code INSERT IGNORE try see if that works, as that is how I fixed my problem.
Sorry, don’t mean to be annoying but I’m not quite sure where the INSERT comes from?
17 hours ago, ProAvia said:
Did you try what I suggested above? It is unclear from your response.
Yes, I tried default skin, smartCARS, manual, etc
6 hours ago, crazyconzie said:
Sorry, don’t mean to be annoying but I’m not quite sure where the INSERT comes from?
So switching to default skin didn’t work either…
You will need to dig into the code for PIREP filing.
Once you locate that code, look for INSERT and replace with INSERT IGNORE
2 hours ago, ProAvia said:
So switching to default skin didn’t work either…
You will need to dig into the code for PIREP filing.
Once you locate that code, look for INSERT and replace with INSERT IGNORE
I found the line in;
public static function addBid($pilotid, $routeid) {
$pilotid = DB::escape($pilotid);
$routeid = DB::escape($routeid);
if (DB::get_row(‘SELECT bidid FROM ’ . TABLE_PREFIX . ‘bids
WHERE pilotid=’ . $pilotid . ’ AND routeid=’ . $routeid)) {
return false;
}
$pilotid = DB::escape($pilotid);
$routeid = DB::escape($routeid);
$sql = ’ INSERT IGNORE’ . TABLE_PREFIX . ‘bids (pilotid, routeid, dateadded)
VALUES (’ . $pilotid . ', ’ . $routeid . ‘, NOW())’;
DB::query($sql);
self::setBidOnSchedule($routeid, DB::$insert_id);
if (DB::errno() != 0) return false;
return true;
}
which was located in SchedulesData.class.php
Previously it was 'INSERT INTO ’ (space after O intended)
Is that it, or am I just reading something else?
Otherwise, it made no difference.
That is addBid - and has nothing to do with PIREP filing
On 2/19/2021 at 4:18 AM, ProAvia said:
That is addBid - and has nothing to do with PIREP filing
Found 1 other files but it was unrelated to filing… does anyone have any idea on where to look? Trying to find it is like a needle in a haystack.
Thanks.
Maybe can assist in where to place the INSERT IGNORE
On 2/24/2021 at 6:45 PM, ProAvia said:
Maybe can assist in where to place the INSERT IGNORE
Still no update?