Jump to content

Server Overloaded?!? Account Suspended!?!


Thomas

Recommended Posts

  • Moderators

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-----

Link to comment
Share on other sites

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.

post-254-0-35571800-1330976528_thumb.jpg

post-254-0-21479000-1330976589_thumb.jpg

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

post-254-0-79904800-1331030249_thumb.jpg

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...