Jump to content

Revision 878: fixed #191 fixed #198 fixed #202, refs #182

Nabeel

By Nabeel
in Build Log

 Share

Recommended Posts

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Administrators
Posted

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

  • Moderators
joeri Newbie

joeri

Posted
  • Moderators
Posted

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 :P;)

  • Moderators
joeri Newbie

joeri

Posted
  • Moderators
Posted

will test it in a few hours

now its famely time with the wife :P;)

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

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

I guess you're doing an update? You can ignore that. But installs won't work.. doh. I'll have that fixed tomo...

  • Moderators
joeri Newbie

joeri

Posted
  • Moderators
Posted

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

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

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.

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

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

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

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

  • Moderators
joeri Newbie

joeri

Posted
  • Moderators
Posted

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

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted 

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

TennShadow Newbie

TennShadow

Posted
Posted

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.

llju1 Newbie

llju1

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

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

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?

TennShadow Newbie

TennShadow

Posted
Posted

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

  • Moderators
mark1million Newbie

mark1million

Posted
  • Moderators
Posted

Wow, that sql import kills the server lol, good job i didnt hold my breath :lol: :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.

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

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

  • Moderators
mark1million Newbie

mark1million

Posted
  • Moderators
Posted

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.

  • Administrators
Nabeel Grand Master

Nabeel

Posted
  • Author
  • Administrators
Posted

Yeah, I couple things changed with that - can you PM it to me? I can take a look tonight if you send it

  • Moderators
mark1million Newbie

mark1million

Posted
  • Moderators
Posted

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

  • Moderators
mark1million Newbie

mark1million

Posted
  • Moderators
Posted

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

 Share
Go to topic listing
×
×
  • Create New...