BPA1

Moving on now to another issue since the bid issue is fixed. The Admin page is really slow....the rest of the web site loads quickly. The test site loads fine. Pireps take forever to file and show a time out although they are in fact filed, even the kaCARS program (client) takes a while to load the first time, but the data transfers quickly. I have read many of the posted solutions, but they are fairly old and nothing suggested there seems to work. I have commented out the connection to VA Central as suggested, nada. I hope I just missed the solution as I searched and that someone can point me in the right direction....Thanks

I hope it helps someone.....now I will start a new thread as some time ago the Admin page and kaCARS have slowed to a crawl.

Fixed! I am not 100% sure if the errors were the cause or the effect, but the solution probably would have worked either way. My first efforts were copying the database files to the test site where the problem continued. I then tried an export from the phpvms site and found that there is error checking when importing. Not having all of the aircraft, airports and schedules produced a pile of errors. So starting over again, I imported in the order of reference....aircraft, airports and then schedules. Again, more errors but the good news is that the new file is void of the errors. So now I have each imported into a fresh install structure and it worked on the test site. To fix the problem in the live site was a simple matter of going into the database and deleting the aircraft, airports, schedules and bid line files and importing the test sites files and renaming them. Everything is working. I know that this was a convoluted solution, and perhaps if I had more knowledge of the program itself, the solution would have been more obvious, but I hope if someone else has a similar issue, this solution might help. Thanks to all who chimed in to help....

Ok some news.... first, phpvms version 5.5.x PHP 5.6 ( on the server) PHP 7.2.7 database PHP myAdmin 4.9.3 MySql ext MySqli As suggested, I connected the live database to the development site....no joy. I then Copied it to a new data base and connected that database to the test sight, no joy. I went back and did the same thing with just the schedules and found that I could not bid from the schedules either. Here is the strange part.....with the live schedule data base brought into the test site you can't bid, but if you create a NEW schedule that entry can be bid which suggests that there is something wrong with the phpvms_schedule in the existing database BUT.....on the live site, a new entry will not bid. On the second live site that has remained untouched, all of the parts are working just fine including Tour Center. The test site is, as you suggested, bare bones. I guess this just saying that there is something in the _schedules that is screwing up the bid....but what? The confusing part is that while the database was copied into the test site didn't work but new entries do, and the original live site, nothing works. So.....I suppose you could just say....rebuild the 60+ pages or about 1500 schedules, but if there was a way to avoid that chore it sure would be nice. Tour Center is another issue but it works on the other live site and it isn't installed on the test site and doesn't work on the prime site. At this point, it's one step at a time. I Hope this makes sense. Oh....one more thing.....Is it possible to re-install some or part of the program and then the obvious question...which ones?

OK, installed another copy on a development site on the same host and it works fine. Granted this is a two airport, one schedule one airplane kind of site, but bid spot on. So, we now know it will work on the host. What is your recommended "next step"? try redirecting to the fully populated data base? Bring in the database in sections Ie: pilots, schedules, airports etc? Add the modules? Over write the program to the existing files? I need to figure out the path that will eventually restore things with the existing data....if possible.

Same issue, you can bid, the bid is accepted (verified it IS in the database) check bid in pilot profile returns no bids found. Verified in both the admin panel and the kaCARS program. Just doesn't happen.

Interesting you would mention this as I forgot to. When the search by flight # IS checked, you can populate the form after putting in a valid flight number, fly the route and file the Pirep. Uncheck the box and nada. Tour Center Module allows us to create "tours", a series of flight bundled together. When the "bid" in made a big green check mark says that the bid is created and when checking the appropriate line in the database, the bid is there. But that's when it stops. As I said before, we had to upgrade the web site due to server limitations and now have more memory and a static IP address. Initially we had problems even getting the site up before realizing that they had forced us to PHP 7.+ , once fixed we were up and running. We did have to remove htaccess for things to return to normal. Ran fine for about a week and now this. I have re installed the Tour Center Module....nothing changed, but I didn't really think that was the issue. It has run fine for two years. I realized that when you could not see the "bid" in the pilot profile nor in the admin section, the problem was outside the kaCARS program, I just don't know where and I don't know what to try next.....Thanks so much for helping!

Having sort of the same issue. The flight leg is created in Tour Center, and shows up in the Database, but no schedule is listed in the admin panel or the pilot profile when selecting "Pilot Bid". PHP 5.6 server PHP: 7.2.7 Database client version: libmysql - 5.1.73 PHP extension: mysqli I really need help/advice Tnx

No Joy. Cleared the database, so there were zero bids, went to the tour center and bid a new flight, nada. Checked the database, the bid is there...but not showing up in the pilot profile nor in kaCARS and not in the administration section.

Hello, After a very frustrating server migration our bids no longer work. While we can make the bid in the Module "Tour Center", and the Big Check mark appears telling us the bid has been made, looking at the pilot record say "You have not bid on any flights". A quick check of the database clearly shows the bid has been made. So obviously something broke during the migration. I have re installed all the modules and bits of Tour Center with no improvement. Equally obvious is that the connection to the database is working. The result of all of this is that the flight is not available in kaCARS although pilots can gain access by loading the flight by flight number, which works well. Any help would be greatly appreciated.