[Loadstone] point share exchange

Ari Moisio arimo at iki.fi
Fri Jul 19 00:27:49 BST 2013


Hi

Here the selection works but when donwloading data i got only message like 
this as an exported  data:

    #!lsdb #Downloaded from pse.loadstone-gps.com on July 18 2013 23:18:45 GMT #Point share points

                                                       LoadStone PointShare

Error

    An unexpected error has occured while processing your request. The information below may help us debug the problem.
    Please include it in any bug reports.

    error class pear
    message DB Error: syntax error
    debug info declare point cursor for select name, cast(Y(latlong)*10000000 as integer) as latitude,
    cast(X(latlong)*10000000 as integer) as longitude, accuracy,satellites,priority,userid,id from point where latlong &&
    '0106000020E61000000200000001030000000100000035000000100000C0ADCB394000000020A9134F401000000076CB3940000000C016134F4030
    0000E0E9CD3940080000E009134F4040000080B1CD39400000002077124F403000004025D03940080000006A124F4030000000EDCF394000000080D
    7114F40300000C0B4CF39400000002045114F404000002027D239400800000038114F4030000020F0D1394000000080A5104F40100000A0B7D13940
    2800000013104F401000008044CF3940100000C01F104F4050000060D1CC3940200000E02C104F40100000409ACC3940100000209A0F4F405000006
    061CC394010000040070F4F40500000A029CC3940F8FFFF1F750E4F40F0FFFF3FF1CB394008000060E20D4F4030000080B9CB3940180000E04F0D4F
    40300000C081CB394008000060BD0C4F403000008049CB3940000000A02A0C4F40F0FFFFFFD6C83940100000C0370C4F403000006064C6394010000
    080440C4F40300000209CC6394000000040D70C4F40F0FFFF9F29C4394010000020E40C4F4030000000B7C13940100000E0F00C4F40300000E043BF
    3940100000A0FD0C4F40000000807BBF394020000060900D4F404000006008BD3940F8FFFF3F9D0D4F40100000C095BA3940F8FFFFFFA90D4F40500
    000E0CCBA3940080000C03C0E4F40100000A004BB394010000040CF0E4F40200000C03BBB3940200000C0610F4F400000004073BB394010000080F4
    0F4F4040000060AABB39400000000087104F4040000020E2BB39402800008019114F40100000606EB939401000004026114F4020000000A6B939401
    0000020B9114F404000002032B73940100000E0C5114F4040000000BFB43940100000A0D2114F4010000020F6B439400000002065124F4010000040
    69B739400000006058124F4010000000A1B7394028000020EB124F4020000000D8B73940000000A07D134F40400000E04BBA3940000000E070134F4
    0300000A0BFBC3940080000C063134F40300000E087BC394018000040D1124F40100000C0FBBE394018000080C4124F40300000A06FC13940080000
    A0B7124F4030000060A7C13940100000204A134F40500000201BC43940100000603D134F40500000408EC63940100000A030134F4010000000C6C63
    94000000020C3134F40F0FFFF7F3AC9394028000040B6134F40100000C0ADCB394000000020A9134F4001030000000100000081000000000000C07F
    D239400000002069254F405000004047D23940280000A0D6244F40000000C0BDD4394000000080C9244F40200000A084D439402800000037244F40F
    0FFFFDF0ED239400000002044244F40400000E0D5D1394010000060B1234F40500000809DD13940100000401F234F40F0FFFF1F65D1394010000060
    8C224F4010000000DBD33940100000607F224F400000006051D639400000004072224F405000006018D63940100000C0DF214F40200000A0A2D3394
    010000080EC214F40000000206AD33940200000005A214F401000004031D33940080000A0C7204F40F0FFFFBFF8D239401800002035204F40000000
    E0BFD2394018000040A21F4F400000002088D23940000000E00F1F4F40100000204FD23940280000607D1E4F4010000000DACF3940280000208A1E4
    F40200000A0A1CF3940000000A0F71D4F403000004069CF394010000020651D4F403000000031CF394010000000D21C4F4040000000A6D139400000
    00A0C51C4F40000000401BD4394028000080B81C4F40500000C0E2D3394000000000261C4F4050000080AAD3394010000080931B4F402000004035D
    1394020000060A01B4F4020000000FDD03940F8FFFFDF0D1B4F40300000A0C4D03940080000607B1A4F40000000408CD03940180000A0E8194F4040
    00008054D03940180000C055194F4000000060DFCD3940080000E062194F4010000000A7CD3940100000C0D0184F40500000A06ECD3940000000003
    E184F4050000000FACA3940200000004B184F4000000080C2CA394010000040B8174F40F0FFFFFF4DC8394010000000C5174F40F0FFFFBF15C83940
    0800008032174F40200000A0DEC7394008000020A0164F40F0FFFF5F69C53940080000E0AC164F40000000A0F5C23940080000A0B9164F401000004
    02DC33940080000804C174F40400000A0B8C039402800004059174F40F0FFFF1F81C03940000000C0C6164F40500000A00CBE394000000080D3164F
    40500000E0D4BD3940100000C040164F40200000209DBD394020000040AE154F403000006029BB394020000000BB154F4010000080B5B83940F8FFF
    F1FC8154F400000000041B6394008000040D5154F401000002078B639400800006067164F40F0FFFF3F04B439400800002074164F40500000C08FB1
    3940080000A080164F40300000C0C6B13940F8FFFF5F13174F401000006052AF39400800004020174F405000008089AF3940080000A0B2174F40500
    000E014AD394018000080BF174F40300000E04BAD3940F8FFFFDF51184F4020000060D7AA3940080000C05E184F40000000600EAB394008000020F1
    184F404000008045AB39400800000084194F40500000007CAB394010000080161A4F405000006007A93940200000E0221A4F4000000060D0A839400
    80000C090194F40500000805AA63940080000409D194F40100000E024A63940180000C00A194F4040000060B0A339401800004017194F4000000040
    3BA13940080000A023194F40F0FFFFBF04A139401800002091184F4010000040909E3940180000A09D184F40300000E0599E3940080000200B184F4
    0F0FFFFBFE49B3940080000A017184F40F0FFFF1F709939402800006024184F40000000E0FB963940280000E030184F404000006031973940080000
    40C3184F40200000E067973940180000C055194F40000000609E973940180000A0E8194F4000000000D4973940080000607B1A4F40500000A05F953
    940080000E0871A4F40F0FFFF9F94953940080000401A1B4F40300000C0CB95394008000020AD1B4F402000008001963940100000A03F1C4F401000
    00E03796394010000000D21C4F40400000A0AD983940000000A0C51C4F4000000060E398394010000060581D4F4030000020599B3940100000A04B1
    D4F40400000A08F9B394000000060DE1D4F40000000E0C59B3940280000E0701E4F4010000060FC9B3940280000C0031F4F4010000020729E394028
    000040F71E4F40200000A0A89E3940000000C0891F4F40500000E0DE9E3940080000801C204F4030000000699C39400800000029204F40400000809
    F9C394018000080BB204F4050000000D69C3940080000404E214F40400000604C9F39401800002042214F40200000E0829F3940F8FFFF3FD4214F40
    10000040F9A1394020000020C7214F40400000006FA4394010000000BB214F4020000080E5A6394010000040AE214F40100000C01BA739402000000
    041224F402000006092A939400000004034224F40000000E008AC3940100000E027224F40500000E03FAC394010000040BA224F40100000A0B5AE39
    4028000080AD224F4010000060EDAE3940100000A040234F404000002063B139400000008033234F4010000040DAB33940000000C026234F4020000
    06011B4394008000040B9234F40100000C087B63940080000C0AC234F40500000E0FEB8394008000000A0234F402000000036B93940F8FFFF7F3224
    4F4010000060ACBB3940100000C025244F40F0FFFFDF22BE3940200000E018244F4030000020EBBD39401000002086234F4020000080B3BD3940080
    000A0F3224F405000004029C03940200000E0E6224F40000000C09FC23940100000C0D9224F4040000060D7C23940000000806C234F40300000C00F
    C3394028000000FF234F401000004086C5394028000040F2234F4010000080BEC539400000000085244F4010000040F6C539400800008017254F405
    00000606DC83940F8FFFF1F0A254F4040000040E3CA3940F8FFFF9FFD244F40000000A01BCB3940100000C08F254F40400000C092CD394010000000
    83254F400000000009D039401000004076254F40000000C07FD239400000002069254F40' and priority & 1 != 1 and ((priority & 2) !=
    2 or can_export_point(1674,userid)) and limit 150000 [nativecode=ERROR: syntax error at or near "limit" LINE 9:
    can_export_point(1674,userid)) and limit 150000 ^]
    HTTP_USER_AGENT Lynx/2.8.8dev.5 libwww-FM/2.14 SSL-MM/1.4.1 GNUTLS/2.8.6
    REMOTE_ADDR 193.185.8.218
    REQUEST_URI /export.php?_qf__export=&loclist=53812&submit%5Bdownload%5D=Download&datasource=both&osmdata=both&username=
    REQUEST_TIME 2013-07-18 16:18:45

      * [1]Home
      * [2]Share your points
      * [3]Get data near a point
      * [4]Get data by civic location
      * [5]Manage phone users
      * [6]Manage QuickPoints
      * [7]Erase your data
      * [8]Account changes
      * [9]Log out
      * [10]LoadStone Home

References

    1. file://localhost/tmp/
    2. file://localhost/tmp/import.php
    3. file://localhost/tmp/export.php
    4. file://localhost/tmp/export3.php
    5. file://localhost/tmp/user.php
    6. file://localhost/tmp/quickpoint.php
    7. file://localhost/tmp/purge.php
    8. file://localhost/tmp/account.php
    9. file://localhost/tmp/logout.php
   10. http://www.loadstone-gps.com/




-- 
mr. M01510 & guide Loadstone-GPS
Lat: 62.38718, lon: 25.64672
hkp://wwwkeys.pgp.net B784D020
0C1F 6A76 DC9D DD58 3383 8B5D 0E76 9600  B784 D02


  Shawn Kirkpatrick kirjoitti
> Subject: Re: [Loadstone] point share exchange
> Date: Thu, 18 Jul 2013 15:54:31 -0700 (PDT)
> From: Shawn Kirkpatrick <shawn at loadstone-gps.com>
> To: loadstone at loadstone-gps.com
> 
> Then you're skipping the other combo box selections. When you make a 
> selection of the country other combo boxes will appear depending on the 
> country. The same will apply to these combo boxes. When there are no more 
> subregions for a country a list of checkboxes will appear letting you select 
> one or more locations.
>
> On Thu, 18 Jul 2013, Milos Przic wrote:
>
>> Hello Shawn,
>> I do exactly as I should
>> 1. I log in.
>> 2. I click the link "get data by cyvic location"
>> 3. I find the combo box and select the country (I tried with Poland, Serbia 
>> and US and then click next
>> Then a page appears and it is titled "get data near a point". On that page 
>> I can select whether I want pointshare, osm or boath, to enter latitude and 
>> longitude, to restrict the radius etc. So it just switches me to the wrong 
>> page.
>> Best!
>>         Milo? Pr?ic
>> twitter: MilosPrzic
>> skype: Milosh-hs
>> ----- Original Message ----- From: "Shawn Kirkpatrick" 
>> <shawn at loadstone-gps.com>
>> To: <loadstone at loadstone-gps.com>
>> Sent: Thursday, July 18, 2013 3:08 AM
>> Subject: Re: [Loadstone] point share exchange
>> 
>> 
>> What are you doing that does this? If you go to the get data by civic
>> location link you should end up at a page with instructions and below that
>> the first thing you'll see is a selection box for country. The only way you
>> end up at the page where you can enter coordinates is if you don't select
>> anything and just click export.
>> A step by step of what you're doing would help to solve this problem.
>> 
>> On Thu, 18 Jul 2013, Milos Przic wrote:
>> 
>>> Hello Shawn,
>>> No, it doesn't work. It takes me to the section where one can get data 
>>> near a
>>> point. So Itere are no further divisions of a country but edit fields with
>>> the stars for entering latitude and longitude.
>>> That's not how it should work when getting data by cyvic location, right?
>>> Thanks for your efforts!
>>> Best,
>>>         Milo? Pr?ic
>>> twitter: MilosPrzic
>>> skype: Milosh-hs
>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>> <shawn at loadstone-gps.com>
>>> To: <loadstone at loadstone-gps.com>
>>> Sent: Thursday, July 18, 2013 1:40 AM
>>> Subject: Re: [Loadstone] point share exchange
>>> 
>>> 
>>> This problem should now be fixed so give it another try and see what
>>> happens.
>>> 
>>> On Wed, 17 Jul 2013, Ondrej Rosik wrote:
>>> 
>>>> Hi,
>>>> It doesn't work here:
>>>> I click Get Points By Civic Location. The url is
>>>> http://pse.loadstone-gps.com/export2.php
>>>> But here are just instructions, no form fields.
>>>> 
>>>> 
>>>> D?a 7/17/2013 7:34 AM Jacob Kruger  wrote / napísal(a):
>>>>> Ok, sorry, found page on normal loadstone site now:
>>>>> http://www.loadstone-gps.com/pointshare/
>>>>> 
>>>>> I had looked for it under other list of tools, on the tools page.
>>>>> 
>>>>> Stay well
>>>>> 
>>>>> Jacob Kruger
>>>>> Blind Biker
>>>>> Skype: BlindZA
>>>>> '...fate had broken his body, but not his spirit...'
>>>>> 
>>>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>>>> <shawn at loadstone-gps.com>
>>>>> To: <loadstone at loadstone-gps.com>
>>>>> Sent: Wednesday, July 17, 2013 3:21 AM
>>>>> Subject: Re: [Loadstone] point share exchange
>>>>> 
>>>>> 
>>>>>> The point share has always had an export points by civic location
>>>>>> function. The previous version didn't always work propperly thoe and
>>>>>> the location data was rather lacking.
>>>>>> 
>>>>>> On Tue, 16 Jul 2013, Jacob Kruger wrote:
>>>>>> 
>>>>>>> Sorry, but, where do we test/try this out?
>>>>>>> 
>>>>>>> TIA
>>>>>>> 
>>>>>>> Jacob Kruger
>>>>>>> Blind Biker
>>>>>>> Skype: BlindZA
>>>>>>> '...fate had broken his body, but not his spirit...'
>>>>>>> 
>>>>>>> ----- Original Message ----- From: "Shawn Kirkpatrick"
>>>>>>> <shawn at loadstone-gps.com>
>>>>>>> To: <loadstone at loadstone-gps.com>
>>>>>>> Sent: Tuesday, July 16, 2013 3:22 AM
>>>>>>> Subject: [Loadstone] point share exchange
>>>>>>> 
>>>>>>> 
>>>>>>>> Hello list.
>>>>>>>> The export points by civic location function of the point share
>>>>>>>> exchange has been rewritten and is now back online. All countries
>>>>>>>> should now be included and be broken down by at least one region.
>>>>>>>> The java version should now work propperly in all versions of
>>>>>>>> internet explorer and firefox. The text version should work in all
>>>>>>>> browsers.
>>>>>>>> These exporters are quite new and will need some testing so please
>>>>>>>> report any problems you may have.
>>>>>>>> 
>>>>>>>> _______________________________________________
>>>>>>>> Loadstone mailing list
>>>>>>>> Loadstone at loadstone-gps.com
>>>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>>> 
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>> Loadstone mailing list
>>>>>>> Loadstone at loadstone-gps.com
>>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>>> 
>>>>>> _______________________________________________
>>>>>> Loadstone mailing list
>>>>>> Loadstone at loadstone-gps.com
>>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> Loadstone mailing list
>>>>> Loadstone at loadstone-gps.com
>>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>>> 
>>>> _______________________________________________
>>>> Loadstone mailing list
>>>> Loadstone at loadstone-gps.com
>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>> 
>>>> 
>>> 
>>> 
>>> __________ Information from ESET NOD32 Antivirus, version of virus 
>>> signature
>>> database 8454 (20130616) __________
>>> 
>>> The message was checked by ESET NOD32 Antivirus.
>>> 
>>> http://www.eset.com
>>> 
>>> 
>>> 
>>> 
>>>
>>> 
>>> --------------------------------------------------------------------------------
>>> 
>>> 
>>>> _______________________________________________
>>>> Loadstone mailing list
>>>> Loadstone at loadstone-gps.com
>>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>>> 
>>>> 
>>>> 
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature database 8454 (20130616) __________
>>>> 
>>>> The message was checked by ESET NOD32 Antivirus.
>>>> 
>>>> http://www.eset.com
>>>> 
>>>> 
>>> 
>>> 
>>> __________ Information from ESET NOD32 Antivirus, version of virus 
>>> signature
>>> database 8454 (20130616) __________
>>> 
>>> The message was checked by ESET NOD32 Antivirus.
>>> 
>>> http://www.eset.com
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> Loadstone mailing list
>>> Loadstone at loadstone-gps.com
>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>> 
>>> 
>> 
>> 
>> __________ Information from ESET NOD32 Antivirus, version of virus 
>> signature database 8454 (20130616) __________
>> 
>> The message was checked by ESET NOD32 Antivirus.
>> 
>> http://www.eset.com
>> 
>> 
>> 
>>
>> 
>> --------------------------------------------------------------------------------
>> 
>> 
>>> _______________________________________________
>>> Loadstone mailing list
>>> Loadstone at loadstone-gps.com
>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>> 
>>> 
>>> 
>>> __________ Information from ESET NOD32 Antivirus, version of virus 
>>> signature database 8454 (20130616) __________
>>> 
>>> The message was checked by ESET NOD32 Antivirus.
>>> 
>>> http://www.eset.com
>>> 
>>> 
>> 
>> 
>> __________ Information from ESET NOD32 Antivirus, version of virus 
>> signature database 8454 (20130616) __________
>> 
>> The message was checked by ESET NOD32 Antivirus.
>> 
>> http://www.eset.com
>> 
>> 
>> 
>> _______________________________________________
>> Loadstone mailing list
>> Loadstone at loadstone-gps.com
>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>> 
>



More information about the Loadstone mailing list