AD LITE problem

Magic440 · 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.

Anmer · 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?

Magic440 · 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.

Anmer · 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.

Magic440 · 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.

Anmer · September 28, 2012, 06:59:00 AM

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

Magic440 · October 01, 2012, 12:58:02 PM

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

Anmer · October 01, 2012, 01:50:53 PM

How big is the file?

Magic440 · October 01, 2012, 02:35:09 PM

It's 23.8Mb.

Anmer · 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.

Magic440 · October 01, 2012, 04:07:30 PM

File sent Mike.Off to work now.

Anmer · October 01, 2012, 04:54:11 PM

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

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

Anmer · 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?

Magic440 · October 14, 2012, 04:53:41 PM

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

Log in or Sign Up

New Members

AD LITE problem

Magic440

Anmer

Magic440

Anmer

Magic440

Anmer

Magic440

Anmer

Magic440

Anmer

Magic440

Anmer

Magic440

Anmer

Magic440