Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/191" title="enhancement: Expand Admin Email Section (closed: fixed)">#191</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/198" title="bug: TOTAL_HOURS missing from settings (closed: fixed)">#198</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/202" title="bug: Pirep charts noticed #34;min#34;: 1, #34;max#34;: 1, (closed: fixed)">#202</a>, refs <a class="accepted ticket" href="http://bugs.phpvms.net/ticket/182" title="enhancement: draw routes on database on pireps/schedules/acars (accepted)">#182</a> View more details, download from here Notes You can drop these two tables: phpvms_navdb phpvms_airways The install/navdata.sql file has to be manually imported as well. Mouse over the links above to see which bugs have been fixes. Routes aren't cached anymore except for PIREPs. Re-wrote the route parsing mechanism - only uses 2 queries flat, instead of the (n+n) queries (where n = number of segments in the route). The new table format helps with this. The file is almost smaller with fewer entries, but does cover nearly everything. Let me know if something huge is missing. Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs. Note 2 Fresh install won't work with this - the update will complete but throws an error. Just create an "airways.sql" file which is blank in the /install directory Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/191" title="enhancement: Expand Admin Email Section (closed: fixed)">#191</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/198" title="bug: TOTAL_HOURS missing from settings (closed: fixed)">#198</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/202" title="bug: Pirep charts noticed #34;min#34;: 1, #34;max#34;: 1, (closed: fixed)">#202</a>, refs <a class="accepted ticket" href="http://bugs.phpvms.net/ticket/182" title="enhancement: draw routes on database on pireps/schedules/acars (accepted)">#182</a> View more details, download from here Notes You can drop these two tables: phpvms_navdb phpvms_airways The install/navdata.sql file has to be manually imported as well. Mouse over the links above to see which bugs have been fixes. Routes aren't cached anymore except for PIREPs. Re-wrote the route parsing mechanism - only uses 2 queries flat, instead of the (n+n) queries (where n = number of segments in the route). The new table format helps with this. The file is almost smaller with fewer entries, but does cover nearly everything. Let me know if something huge is missing. Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs. will test it in a few hours now its famely time with the wife Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 will test it in a few hours now its famely time with the wife got this error Warning: file_get_contents(/home/tntvirtua/domains/tnt-virtual.be/public_html//install/airways.sql) [function.file-get-contents]: failed to open stream: No such file or directory in /home/tntvirtua/domains/tnt-virtual.be/public_html/install/Installer.class.php on line 306 Link to comment Share on other sites More sharing options...
sean212 Posted February 27, 2010 Report Share Posted February 27, 2010 Oh man! That navadata is one large a*s query! I think I can feel my dev server choking right now! Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Author Administrators Report Share Posted February 27, 2010 I guess you're doing an update? You can ignore that. But installs won't work.. doh. I'll have that fixed tomo... Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 I guess you're doing an update? You can ignore that. But installs won't work.. doh. I'll have that fixed tomo... yep doing the update yeah sean i can feel my server choking also Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 also the is no airways table annymore correct ? Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Author Administrators Report Share Posted February 27, 2010 Nope, it's all one table now. It's pretty large, though the insert is split up. I have to see if there's a way to export it into smaller chunks. Link to comment Share on other sites More sharing options...
sean212 Posted February 27, 2010 Report Share Posted February 27, 2010 Maybe a GZipped Export? Please! I'm splitting it up but my memory keeps busting. Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Author Administrators Report Share Posted February 27, 2010 If you're on the command line you can gzip it there, and then import. I attached a gzipd version. I think you can also tar it locally and use that. Are you using phpMyAdmin? Edit: Scroll down to get the other one Link to comment Share on other sites More sharing options...
sean212 Posted February 27, 2010 Report Share Posted February 27, 2010 Well I just finished and I just exported the table from phpMyAdmin. http://double-designs.com/phpvms_navdata.sql.gz Didn't want to go through CLI today. 1 Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Author Administrators Report Share Posted February 27, 2010 Yeah it looks like mysqldump does one huge insert, which kinda sucks. But I'm checking the options for that, I think I can break it up. I have scripts which run and generate all the data from the nav files (which take about 45 minutes by itself), and then finally do a dump, so it just uses the CLI. I'm too lazy to go through phpmyadmin/download/reupload, etc etc lol Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 Yeah it looks like mysqldump does one huge insert, which kinda sucks. But I'm checking the options for that, I think I can break it up. I have scripts which run and generate all the data from the nav files (which take about 45 minutes by itself), and then finally do a dump, so it just uses the CLI. I'm too lazy to go through phpmyadmin/download/reupload, etc etc lol LAZY BOY Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Author Administrators Report Share Posted February 27, 2010 LAZY BOY Here's the proper gzip'd on with extended inserts. This should go better. navdata.sql.gz Link to comment Share on other sites More sharing options...
sean212 Posted February 28, 2010 Report Share Posted February 28, 2010 Does the navdata table have VORs in it? Link to comment Share on other sites More sharing options...
sean212 Posted February 28, 2010 Report Share Posted February 28, 2010 And for the type col., what do the values represent? Like 3 = NBDs? Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 28, 2010 Author Administrators Report Share Posted February 28, 2010 define('NAV_NDB', 2); define('NAV_VOR', 3); define('NAV_DME', 4); define('NAV_FIX', 5); define('NAV_TRACK', 6); Those constants are in the app.config so you can use those directly if you need to Link to comment Share on other sites More sharing options...
TennShadow Posted February 28, 2010 Report Share Posted February 28, 2010 Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs. Thanks for adding this Nabeel! While testing this feature I found that half of it works. The e-mail for submitted PIREPS worked correctly and went to the e-mail I stated. The e-mail for the registered users did not work right. It sent an e-mail to the address I had set for the PIREPS but not the one defined in the config file. I'm still getting the "Invalid address: You must provide at least one recipient email address." after someone registers. Link to comment Share on other sites More sharing options...
llju1 Posted February 28, 2010 Report Share Posted February 28, 2010 Checking PHP version [OK] PHP version is 5.2.x Checking connectivity... [OK] Can contact outside servers Checking for SimpleXML module... [OK] SimpleXML module exists! Checking file hashes for corrupt or mismatched files -- Checked 166 files, found 0 errors Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 28, 2010 Author Administrators Report Share Posted February 28, 2010 Thanks for adding this Nabeel! While testing this feature I found that half of it works. The e-mail for submitted PIREPS worked correctly and went to the e-mail I stated. The e-mail for the registered users did not work right. It sent an e-mail to the address I had set for the PIREPS but not the one defined in the config file. I'm still getting the "Invalid address: You must provide at least one recipient email address." after someone registers. Seems like I copy/pasted and didn't change which setting it looked at =\ I'm trying to duplicate the second one - what's the email address you're entering? And what PHP version are you on? Link to comment Share on other sites More sharing options...
TennShadow Posted February 28, 2010 Report Share Posted February 28, 2010 Seems like I copy/pasted and didn't change which setting it looked at =\ I'm trying to duplicate the second one - what's the email address you're entering? And what PHP version are you on? I used different e-mail addresses from @gmail.com and I'm running PHP Version: 5.2.5 Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 1, 2010 Moderators Report Share Posted March 1, 2010 Wow, that sql import kills the server lol, good job i didnt hold my breath :lol: All ok though, Still get that error above that Keith is reporting Cant seem to get rid of it, i have even tried using my smtp server, still the same. Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted March 1, 2010 Author Administrators Report Share Posted March 1, 2010 Would one of you be able to give me access to your server tomorrow (ftp, urls) so I can poke around and test? I can't duplicate it on my server Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 1, 2010 Moderators Report Share Posted March 1, 2010 Sure no problem, im just about to copy and paste on my windows box to see if i can duplicate it on there with my settings. Its only come about since the last update just before this one. Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted March 2, 2010 Author Administrators Report Share Posted March 2, 2010 Yeah, I couple things changed with that - can you PM it to me? I can take a look tonight if you send it Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 2, 2010 Moderators Report Share Posted March 2, 2010 Nabeel, In 878 i have found the draw line on map for schedules or pireps for the routes no longer displays in IE, works OK in FF and Chrome though. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 2, 2010 Moderators Report Share Posted March 2, 2010 These are the errors im getting with IE on the Live map, Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0) Timestamp: Tue, 2 Mar 2010 14:28:16 UTC Message: Expected identifier Line: 89 Char: 5 Code: 0 URI: http://www.easyjetva.com/lib/js/phpvms.js Message: Object doesn't support this property or method Line: 95 Char: 3 Code: 0 URI: http://www.easyjetva.com/lib/js/acarsmap.js Message: Unspecified error. Line: 32 Char: 37 Code: 0 And these when viewing a pirep map, Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0) Timestamp: Tue, 2 Mar 2010 14:31:13 UTC Message: Unspecified error. Line: 13 Char: 458 Code: 0 URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js Message: Unspecified error. Line: 32 Char: 37 Code: 0 URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js URI: http://maps.gstatic.com/intl/en_gb/mapfiles/api-3/30/main.js Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted March 2, 2010 Author Administrators Report Share Posted March 2, 2010 Can you PM me your FTP info so I can check out the registration thing? Along with the email address you used I'm not seeing those errors in IE8... http://dev.phpvms.net/index.php/acars Are you templates upto date? Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 2, 2010 Moderators Report Share Posted March 2, 2010 OK on my dev site i have just gone back to the default skin to eliminate any thing i have done and i still get the following error for viewing the pireps map, Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0) Timestamp: Tue, 2 Mar 2010 17:12:35 UTC Message: Expected identifier, string or number Line: 145 Char: 3 Code: 0 URI: bladebla/index.php/pireps/view/30 Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted March 2, 2010 Author Administrators Report Share Posted March 2, 2010 Do you have any custom templates/makes ure the core_htmlhead.tpl is stock Link to comment Share on other sites More sharing options...
Recommended Posts