Print Page - AD LITE problem

Title: AD LITE problem
Post by: Magic440 on September 27, 2012, 12:13:20 PM

I have been having problems just lately,running AD LITE.
Have uninstalled/re-installed,but still getting the same problem.
It doesn't populate Basestation,until i close the error message!
Running 1.2.3.168,with firmware 306.
As a few of you know,i'm clueless with computers.
This is the message i keep getting.

Occurred : 11:52:34.868 2012/09/27

Error : EDatabaseError - unable to open database file

Last Command : SELECT ModeS, Registration, AircraftID, CurrentRegDate, PreviousID, FirstRegDate, Status, DeRegDate, Manufacturer, Type, SerialNo, PopularName, GenericName, AircraftClass, Engines, OwnershipStatus, RegisteredOwners, MTOW, TotalHours, YearBuilt, CofACategory, CofAExpiry, ICAOTypeCode, Interested, UserTag, InfoURL, PictureURL1, PictureURL2, PictureURL3, UserBool1, UserBool2, UserBool3, UserBool4, UserBool5, UserString1, UserString2, UserString3, UserString4, UserString5, UserInt1, UserInt2, UserInt3, UserInt4, UserInt5, UserNotes, OperatorFlagCode FROM Aircraft WHERE ModeS = '400935'

Last Aircraft : 400935

System Status : 16973824 | 0 | 16973824 | 14105516 | 1527436 | 3.5.4 | 107318808576

Previous : O-WriteToDebugMemo | I-WriteToDebugMemo | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues | I-ReadDBValues | O-ReadDBValues

Any help,greatly appreciated.

Title: Re: AD LITE problem
Post by: Anmer on September 27, 2012, 01:03:03 PM

I assume that's a Basestation error message?

Do you get it if AD Lite isn't running? Have you tried closing Basestation, restarting it and then AD Lite?

Title: Re: AD LITE problem
Post by: Magic440 on September 27, 2012, 01:16:50 PM

Yes,Mike.The Basestation pops a warning up.
I just had a Tornado trigger the message.
That was already in my database!
I used to get the same message,whilst running SBS Populate.
Also getting a look-up error on PP.

Title: Re: AD LITE problem
Post by: Anmer on September 27, 2012, 04:38:49 PM

It may be that your database has some corrupt data. You could run some tets to check the integrity of the Basestation.sqb file.

Title: Re: AD LITE problem
Post by: Magic440 on September 28, 2012, 01:14:08 AM

Thanks Mike.
How would i run the test? Is it a simple procedure?
Would i have to download anything?
Sorry for all the questions.

Title: Re: AD LITE problem
Post by: Anmer on September 28, 2012, 06:59:00 AM

Just rushing off to the Hamfest. Will reply more fully tomorrow.

Title: Re: AD LITE problem
Post by: Magic440 on October 01, 2012, 12:58:02 PM

Would it help,if i sent you a copy of the sqb.file?

Title: Re: AD LITE problem
Post by: Anmer on October 01, 2012, 01:50:53 PM

How big is the file?

Title: Re: AD LITE problem
Post by: Magic440 on October 01, 2012, 02:35:09 PM

It's 23.8Mb.

Title: Re: AD LITE problem
Post by: Anmer on October 01, 2012, 03:56:21 PM

You can try sending it as attachment to:

Info@radarspotting.com

Otherwise you'll need to use Yousend IT or DropBox.

Title: Re: AD LITE problem
Post by: Magic440 on October 01, 2012, 04:07:30 PM

File sent Mike.Off to work now. :(

Title: Re: AD LITE problem
Post by: Anmer on October 01, 2012, 04:54:11 PM

File received. I'll take a look later this evening.

Title: Re: AD LITE problem
Post by: Magic440 on October 14, 2012, 11:55:20 AM

Managed to get ADLite working,the path to the default location was c:Program Files,but should of been C:Program Files.Ihave now installed the full version on a trial period,all is running smoothly,but struggling to get any photos to show.I tried editing the xsl file,but not sure if i have done it right.
This is what i have at the moment.
<?xml version="1.0" encoding="iso8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<head>
<link rel="stylesheet" href="basestation.css" type="text/css"/>
</head>

<body>
<xsl:variable name="AirlineICAO" select="substring(//currentflight/callsign,1,3)"/>
<meta http-equiv="refresh" content="5"/>

<table>
<tr>
<td>
<div class="entrybox">
<table width="410">
<tr>
<td width="200" height="150">
<img src="C:\Program Files\Kinetic\BaseStation\JPGPhotos\{//regdata/registration}.jpg" width="200" height="133" border="0" />
</td>
<td width="200" >
<img src="C:\Program Files\Kinetic\BaseStation\JPGPhotos{//regdata/registration}_A.jpg" width="200" height="133" border="0" />
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>

<table>
<tr>
<td>
<div class="entrybox">
<table width="410">
<tr>
<td width="200">
<span class="entrycaption">ModeS Code : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//transmission/modes"/></font></span>
</td>

<td width="200">
<span class="entrycaption">Callsign : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//currentflight/callsign"/></font></span>
</td>
</tr>

<tr>
<td width="300">
<span class="entrycaption">Registration : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//regdata/registration"/></font></span>
</td>

<td width="200">
<span class="entrycaption">Type : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//regdata/type"/></font></span>
</td>
</tr>

<tr>
<td width="200">
<span class="entrycaption">Serial No : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//regdata/serialno"/></font></span>
</td>

<td width="200">
<span class="entrycaption">ICAO : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//regdata/ICAOTypeCode"/></font></span>
</td>
</tr>

<tr>
<td width="200">
<span class="entrycaption">Country : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//transmission/country"/></font></span>
</td>

<td width="200">
<span class="entrycaption">Operator : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//regdata/registeredowners"/></font></span>
</td>
</tr>

<tr>
<td width="200" height="20"></td><td>
<img src="C:\Program Files\Kinetic\basestation\OperatorFlags\{$AirlineICAO}.bmp" width="90" height="20" border="0" />
</td>
</tr>
</table>

<table>
<tr>
<td width="400">
<span class="entrycaption">Route : </span>
<span class="entrydata"><font color="Blue"><xsl:apply-templates select="//currentflight/Route"/></font></span>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>

<table>
<tr>
<td>
<div class="entrybox">
<table width="410">
<tr>
<td width="200">
<a href="http://dm.airliners.net/search/photo.search?sort_order=photo_id%20DESC&first_this_page=0&page_limit=30&&regsearch={//regdata/registration}&thumbnails=noinfo" target="new">
<span class="entrycaption">Airliners.net search : <xsl:apply-templates select="//regdata/registration"/></span></a>
</td>

<td width="200">
<a href="http://www.planepictures.net/netsearch4.cgi?stype=reg&srng=2&srch={//regdata/registration}&offset=0&range=10" target="new">
<span class="entrycaption">Planepictures.net search : <xsl:apply-templates select="//regdata/registration"/></span></a>
</td>
</tr>

<tr>
<td width="200">
<a href="http://www.jetphotos.net/showphotos.php?offset=0&where=search|-2|-2|-2|-2|{//regdata/registration}|15|1|||||||-2|-2|-2|-2|||15|1||-2|-2||||reg|1||||||-2|||1|||||||&newdisplay=8" target="new">
<span class="entrycaption">Jetphotos.net search: <xsl:apply-templates select="//regdata/registration"/></span></a>
</td>

<td width="200">
<a href="http://www.airframes.org/reg/{translate(//regdata/registration,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz')}" target="new">
<span class="entrycaption">Airframes.org Search : <xsl:apply-templates select="//regdata/registration"/></span></a>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>

<table>
<tr>
<td>
<div class="entrybox">
<table width="410">
<tr>
<td>
<span class="entrycaption"><font color="Maroon">Note : </font></span>
<span class="entrydata"><font color="maroon"><B><xsl:apply-templates select="//user/notes"/></B></font></span>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

Title: Re: AD LITE problem
Post by: Anmer on October 14, 2012, 11:58:50 AM

Do you have image files in the folder that the XSL is looking for and named using the correct naming convention?

Title: Re: AD LITE problem
Post by: Magic440 on October 14, 2012, 04:53:41 PM

Not sure what i'm looking for Mike.
The photo's are named G-MAPS_A etc

Title: Re: AD LITE problem
Post by: Anmer on October 14, 2012, 05:00:55 PM

AD Lite has no photo display feature. Flight Display can "push" images into the popup Aircraft Display window as long as FD is running and configured to do so.

But the Basestation.xsl file needs editing to display either locally stored images or dynamic ones from the Internet. I do both.

Your xsl line:

<img src="C:\Program Files\Kinetic\BaseStation\JPGPhotos\{//regdata/registration}.jpg" width="200" height="133" border="0" />

Is looking for jpeg images in the JPGPhotos folder such as G-AAAA.jpg.

If you have these, run FD and make sure it's configured to display stored images and the Options (1) has "Write FD data to .xml file" checked.

F1 opens the FD online Help.

Title: Re: AD LITE problem
Post by: Magic440 on October 14, 2012, 05:07:42 PM

Thanks Mike,will have a go Tuesday.

Title: Re: AD LITE problem
Post by: Magic440 on October 17, 2012, 09:18:45 PM

All running smoothly.Thanks for all the help.

Radarspotting

Mode-S Software => Active Display => Topic started by: Magic440 on September 27, 2012, 12:13:20 PM