Server Overloaded?!? Account Suspended!?!

[mark1million]

The beta has a place for week and repeat, your database structure should be,

-- phpMyAdmin SQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `Development`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpvms_schedules`
--

CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `code` char(3) NOT NULL DEFAULT '',
 `flightnum` varchar(10) NOT NULL DEFAULT '0',
 `depicao` varchar(4) NOT NULL DEFAULT '',
 `arricao` varchar(4) NOT NULL DEFAULT '',
 `route` text NOT NULL,
 `route_details` text NOT NULL,
 `aircraft` text NOT NULL,
 `flightlevel` varchar(6) NOT NULL,
 `distance` float NOT NULL DEFAULT '0',
 `deptime` varchar(15) NOT NULL DEFAULT '',
 `arrtime` varchar(15) NOT NULL DEFAULT '',
 `flighttime` float NOT NULL DEFAULT '0',
 `daysofweek` varchar(7) NOT NULL DEFAULT '0123456',
 `week1` varchar(7) NOT NULL DEFAULT '0123456',
 `week2` varchar(7) NOT NULL DEFAULT '0123456',
 `week3` varchar(7) NOT NULL DEFAULT '0123456',
 `week4` varchar(7) NOT NULL DEFAULT '0123456',
 `price` float NOT NULL,
 `payforflight` float NOT NULL DEFAULT '0',
 `flighttype` varchar(1) NOT NULL DEFAULT 'P',
 `timesflown` int(11) NOT NULL DEFAULT '0',
 `notes` text NOT NULL,
 `enabled` int(11) NOT NULL DEFAULT '1',
 `bidid` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `depicao` (`depicao`),
 KEY `flightnum` (`flightnum`),
 KEY `depicao_arricao` (`depicao`,`arricao`),
 KEY `code` (`code`),
 KEY `idx_code_flightnum` (`code`,`flightnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `phpvms_schedules`
--


--
-- Constraints for dumped tables
--

--
-- Constraints for table `phpvms_schedules`
--
ALTER TABLE `phpvms_schedules`
 ADD CONSTRAINT `phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;

Just run that and it will alter your phpvms schedules table and you should be able to import.

----Make sure you do a Backup first-----

[Nabeel]

If you run the upgrade script, it will calculate the diff and changes between what your database is and what it should be

[Thomas]

Hi Nabeel,

Seem to of fixed the Schedules error. Still have a couple though:

1) When I click on a pilot in the admin panel then go to Pilot Groups > Add To Group > It takes me directly to the script? (img1 attached)

2) When I go to change the 'Default User Group' in the admin panel - general options, I select the different group, click save and it gives me confirmation that my settings have been changed but they are still getting added to Active Pilots when I changed the default group to Inactive Pilots

3) On the front page, the BFL Statistics section, the total hours seems to be in time mode? (img3 attached)

I did notice too that once I do the checkinstall.php I get these errors...

[Checksum failed] /core/common/ActivityData.class.php did not match, possibly corrupt or out of date

[Checksum failed] /core/templates/activity_list.tpl did not match, possibly corrupt or out of date

[Checksum failed] /core/templates/pireps_airportdropdown.tpl did not match, possibly corrupt or out of date

[Checksum failed] /core/modules/Activity/Activity.php did not match, possibly corrupt or out of date

[Checksum failed] /core/vendors/orm/paris.php did not match, possibly corrupt or out of date

Appreciate the help guys.

[Jeff]

I did notice too that once I do the checkinstall.php I get these errors...

[Checksum failed] /core/common/ActivityData.class.php did not match, possibly corrupt or out of date

[Checksum failed] /core/templates/activity_list.tpl did not match, possibly corrupt or out of date

[Checksum failed] /core/templates/pireps_airportdropdown.tpl did not match, possibly corrupt or out of date

[Checksum failed] /core/modules/Activity/Activity.php did not match, possibly corrupt or out of date

[Checksum failed] /core/vendors/orm/paris.php did not match, possibly corrupt or out of date

Appreciate the help guys.

Re-upload those files to your site, as it seems that maybe they weren't fully uploaded the first time.

[Nabeel]

Also for those errors, open the FF/Chrome error console and see if you're getting any errors there

[Thomas]

Re-upload those files to your site, as it seems that maybe they weren't fully uploaded the first time.

Already done this Jeff, still get the errors.

Also for those errors, open the FF/Chrome error console and see if you're getting any errors there

Have done, image attached.

[Sava]

Thomas.

I also have those two errors in the pilot center. I fixed the default pilot group by changing the actual value in the database if I can recall correctly. It made all pilots administrators on registration. Got used to the other error though. Running the last stable version.

[Nabeel]

Already done this Jeff, still get the errors.

Have done, image attached.

If you read the errors, you see there's a problem in your menu.js file which is causing your problems.

[piuozorio]

Thank you for the replies.

[Thomas]

If you read the errors, you see there's a problem in your menu.js file which is causing your problems.

Have read them Nabeel. Never got any errors during the previous (stable) version of phpvms.

Any fixes for the other 2 errors? http://forum.phpvms.net/topic/6970-server-overloaded-account-suspended/page__view__findpost__p__46550

[Nabeel]

Have read them Nabeel. Never got any errors during the previous (stable) version of phpvms.

Any fixes for the other 2 errors? http://forum.phpvms....dpost__p__46550

You need to fix the menu.js errors, those aren't phpvms files.

[Thomas]

You need to fix the menu.js errors, those aren't phpvms files.

Will have another look but like I say, there is no errors being picked up anywhere else, only by the beta version of phpvms.

Something else I noticed on the cron job...

php -f /var/www/vhosts/buffaloairwaysvirtual.com/httpdocs/admin/maintenance.php

Why is it pointing to the httpdocs folder? Is there anywhere I can change this as the link should be:

php -f /var/www/vhosts/buffaloairwaysvirtual.com/admin/maintenance.php

[Thomas]

Something else I've noticed, all pilots are showing 0 flights? http://buffaloairwaysvirtual.com/index.php/pilots

[Strider]

This is why you dont use a beta release as your main site, only use beta's to test, and use the full stable release for your main site.

[Thomas]

This is why you dont use a beta release as your main site, only use beta's to test, and use the full stable release for your main site.

See this post Daniel; http://forum.phpvms.net/topic/6970-server-overloaded-account-suspended/page__view__findpost__p__46403

[Nabeel]

Will have another look but like I say, there is no errors being picked up anywhere else, only by the beta version of phpvms.

Something else I noticed on the cron job...

php -f /var/www/vhosts/buffaloairwaysvirtual.com/httpdocs/admin/maintenance.php

Why is it pointing to the httpdocs folder? Is there anywhere I can change this as the link should be:

php -f /var/www/vhosts/buffaloairwaysvirtual.com/admin/maintenance.php

That's wherever you setup the cron job, probably in cPanel.

And that other error isn't from phpvms, that's external, and that error will cause errors in everything else. That should be the first thing to look at

[Strider]

See this post Daniel; http://forum.phpvms....dpost__p__46403

I wasn't refering to the first topic, as that has been fixed.

[mark1million]

Something else I've noticed, all pilots are showing 0 flights? http://buffaloairway...ndex.php/pilots

Do a search in the beta releases, there is already a fix in the files for that its just a few changes.