Moderators Parkho Posted November 24, 2015 Moderators Report Share Posted November 24, 2015 Good day every one, PilotManager_V2.2 is now available at Github at the link below: PilotManager_V2.2 Changes: -A table has been added to keep records of what has been done. -The template has been changed showing more data. -The functions have been updated to match phpVMS 5.5x by Simpilot. Quote Link to comment Share on other sites More sharing options...
smokey68 Posted November 24, 2015 Report Share Posted November 24, 2015 you forgot to add images Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 24, 2015 Author Moderators Report Share Posted November 24, 2015 Thanks for noticing. Images added. Quote Link to comment Share on other sites More sharing options...
shaun105 Posted November 24, 2015 Report Share Posted November 24, 2015 Notice: The template file "/home/aerlingu/public_html//admin/templates//pm/pilot_manager.php.tpl" doesn't exist in /home/aerlingu/public_html/core/classes/TemplateSet.class.php on line 248 Is it something wrong i have done ? Quote Link to comment Share on other sites More sharing options...
Iraklis Posted November 24, 2015 Report Share Posted November 24, 2015 phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result set (i.e. zero rows). SET time_zone = "+00:00";# MySQL returned an empty result set (i.e. zero rows). /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows). /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows). /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows). /*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows). -- -- Database: `iranskya_sky` -- -- -------------------------------------------------------- -- -- Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXI[...] any solution with the .sql file....???? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 24, 2015 Author Moderators Report Share Posted November 24, 2015 What's the error? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 24, 2015 Author Moderators Report Share Posted November 24, 2015 Notice: The template file "/home/aerlingu/public_html//admin/templates//pm/pilot_manager.php.tpl" doesn't exist in /home/aerlingu/public_html/core/classes/TemplateSet.class.php on line 248 Is it something wrong i have done ? pilot_manager.php.tpl is wrong. It shoyd be pilot_manager.php Quote Link to comment Share on other sites More sharing options...
shaun105 Posted November 24, 2015 Report Share Posted November 24, 2015 Thats weird just checked all files and its showing correct .php even reinstalled again still the same. The file the error is pointing to is php not php.tpl file any ideas? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 24, 2015 Author Moderators Report Share Posted November 24, 2015 What version of phpVMS are you using? Quote Link to comment Share on other sites More sharing options...
HighFlyerPL185 Posted November 25, 2015 Report Share Posted November 25, 2015 Is this module still compatible with phpVMS 2.1.935? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 25, 2015 Author Moderators Report Share Posted November 25, 2015 Is this module still compatible with phpVMS 2.1.935? Have you not upgraded to 5.5x by simpilot? If not do the following: 1.Open admin/modules/pilotmanager and change all .php extensions to .tpl 2.Open admin/templates/pm and change all file extensions from .php to .tpl 3.Open core/common/PManagerData.class.php and change all "public static function" to "public function". Keep in mind that eventually you'll need to upgrade to the latest version. The reason your site is still up and running is that maybe your Host hasn't upgraded their server to php 5.5 once they do that all errors will come up at the same time, so I suggest you upgrade as soon as possible. Quote Link to comment Share on other sites More sharing options...
shaun105 Posted November 25, 2015 Report Share Posted November 25, 2015 Many thanks for your help in installing the PM. I will look at updating phpvms soon once i pluck up the courage. On the pilot manager interface it states that = Pilot has not filed any reports in 3 days. If my memory serves me right I had my cfg set to 42 days and on checking it is still 42. I thought that was where you change it for this mod ? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 26, 2015 Author Moderators Report Share Posted November 26, 2015 There is no dependency on that part in the module. If you wish to change those settings, it has to be done directly inside it. Actually, now that you mention it I think I will look into it in the next update. Thanks Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted November 27, 2015 Author Moderators Report Share Posted November 27, 2015 I decided to change the look to tab version. Those of you who wants this please get the new files from Github. Also, I removed the images so they're no longer necessary. Changed File(s): -pilot_manager.php Added File(s): -pilot_information.php -edit_pilots.php -send_email.php Install: -Overwrite "pilot_manager.php" with the new one. -Add new files to "pm" folder. Screen Shots: Quote Link to comment Share on other sites More sharing options...
cesarhc130 Posted November 27, 2015 Report Share Posted November 27, 2015 hello excellent work, but I have a little problem there is no information that says: Warning, Welcome, General. Could you help me please. hi just updated installation files: -overwrite "Pilot manager.php" with the new one. -Add New files to "pm" folder. but continues the same problem does not show the information of the emails sent. Quote Link to comment Share on other sites More sharing options...
cesarhc130 Posted November 28, 2015 Report Share Posted November 28, 2015 Please forget it solved editing core / common / PManager Data.class.php adding phpvms_ in SELECT * FROM pilot_manager Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted December 1, 2015 Author Moderators Report Share Posted December 1, 2015 There's been an update. Please download "pilot_information.php" at Github and replace it with the existing one. Quote Link to comment Share on other sites More sharing options...
HighFlyerPL185 Posted December 3, 2015 Report Share Posted December 3, 2015 Have you not upgraded to 5.5x by simpilot? If not do the following: 1. Open admin/templates/pm and change all file extensions from .php to .tpl 2. Open core/common/PManagerData.class.php and change all "public static function" to "public function". 3. Open admin/templates/pm/pilot_manager.tpl and change .php links to .tpl (Lines 28, 29 and 30). Keep in mind that eventually you'll need to upgrade to the latest version. The reason your site is still up and running is that maybe your Host hasn't upgraded their server to php 5.5 once they do that all errors will come up at the same time, so I suggest you upgrade as soon as possible. Edited your guidelines for anyone who might have the same issue. My changes are in bold. The problem with that is my site is heavily reliant on custom code. Upgrading it would take a while, and my host still offers PHP 5.2 - 5.5. Do you know if the recent upgrade breaks any addons? What is the blank email feature designed for? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted December 4, 2015 Author Moderators Report Share Posted December 4, 2015 Edited your guidelines for anyone who might have the same issue. My changes are in bold. The problem with that is my site is heavily reliant on custom code. Upgrading it would take a while, and my host still offers PHP 5.2 - 5.5. Do you know if the recent upgrade breaks any addons? What is the blank email feature designed for? The new 5.5 will give you some issues for sure but it won't be major and you'll have to get rid of them one by one. The blank email is for the time that you need to write something to them not using the templates. Quote Link to comment Share on other sites More sharing options...
gio1961 Posted December 20, 2015 Report Share Posted December 20, 2015 Hello I have this problem... Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted December 20, 2015 Author Moderators Report Share Posted December 20, 2015 If you have previously installed V2's table you need to drop that table first before importing the new one. Quote Link to comment Share on other sites More sharing options...
gio1961 Posted December 20, 2015 Report Share Posted December 20, 2015 thanks for your response, these are the tables in the database... Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted December 20, 2015 Author Moderators Report Share Posted December 20, 2015 I have updated the SQL file provided although I'm pretty sure that file didn't have any issues but just in case. Please re download SQL file at Github. Quote Link to comment Share on other sites More sharing options...
gio1961 Posted December 20, 2015 Report Share Posted December 20, 2015 Thanks .. now it works perfectly ... Sincerely Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 20, 2016 Author Moderators Report Share Posted January 20, 2016 I have added a new module for older versions of phpVMS. You can now download and install at the following link: PilotManager_V2.2_TPL Quote Link to comment Share on other sites More sharing options...
Longhaul444 Posted February 1, 2016 Report Share Posted February 1, 2016 Ran into a problem when importing the SQL file into the database, this is the TPL version (see below): Error SQL query: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 --Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilot_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(12) NOT NULL, `pfname` varchar(50) NOT NULL DEFAULT '', `plname` varchar(50) NOT NULL, `blank` int(12) NOT NULL DEFAULT '0', `warning` int(12) NOT NULL, `welcome` int(12) NOT NULL, `message` text NOT NULL, `datesent` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilo' at line 10 Any idea on how to correct this? I'm reading up on SQL and currently am not at the point where I could try to attempt a fix (comfortably). Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted February 1, 2016 Author Moderators Report Share Posted February 1, 2016 Open the SQL file and delete the following lines: -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 1 Quote Link to comment Share on other sites More sharing options...
Longhaul444 Posted February 1, 2016 Report Share Posted February 1, 2016 Will do, Thanks for the quick response. Will post how it goes Quote Link to comment Share on other sites More sharing options...
Longhaul444 Posted February 1, 2016 Report Share Posted February 1, 2016 Ok that didn't work. I did find a minor spacing error and corrected it (line 10 had no space) along with a little touch up at the end (in bold) and it worked beautifully for me. Nice looking module I hope this helps someone else with the same problem I had. Here is the SQL file with my changes: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 -- Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilot_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(12) NOT NULL, `pfname` varchar(50) NOT NULL DEFAULT '', `plname` varchar(50) NOT NULL, `blank` int(12) NOT NULL DEFAULT '0', `warning` int(12) NOT NULL, `welcome` int(12) NOT NULL, `message` text NOT NULL, `datesent` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; /*!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 */; Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted March 1, 2016 Author Moderators Report Share Posted March 1, 2016 Ok that didn't work. I did find a minor spacing error and corrected it (line 10 had no space) along with a little touch up at the end (in bold) and it worked beautifully for me. Nice looking module I hope this helps someone else with the same problem I had. Here is the SQL file with my changes: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 -- Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilot_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(12) NOT NULL, `pfname` varchar(50) NOT NULL DEFAULT '', `plname` varchar(50) NOT NULL, `blank` int(12) NOT NULL DEFAULT '0', `warning` int(12) NOT NULL, `welcome` int(12) NOT NULL, `message` text NOT NULL, `datesent` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; /*!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 */; Your php version is "4.0.10.7" the SQL file you're trying to import into your server is higher version(5.4.31) and that's why you get the error. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.