[Loadstone] Userid error and How to open osm file if larger than 2 mb

Shawn Kirkpatrick shawn at loadstone-gps.com
Fri Jan 29 08:16:10 GMT 2010

You mean you got this error when trying to upload to the point share 
exchange? It certainly wasn't from loadstone.
This error is probably because of an incorrect user id in the converted 

On Fri, 29 Jan 2010, Kennydog wrote:

> Hi,
> I was able to download the osm file and convert it to loadstone format. I was 
> able to open the converted file to see all the points in it. I saved it to my 
> phone and opened it in Loadstone. I received the following error.
>   Pear error occured
> 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: constraint violation
> debug info 	insert into point 
> (name,latlong,accuracy,satellites,priority,id,userid) values('city: 
> wellington',SetSRID(GeomFromText('POINT(174.7810335 -41.2870685)'), 
> 4326),'1','0','2','949375987','20790') [nativecode=ERROR: insert or update on 
> table "point" violates foreign key constraint "userid_fkey" DETAIL: Key 
> (userid)=(20790) is not present in table "webauth_users".]
> HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; 
> rv: Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)
> REQUEST_URI 	/import.php
> REQUEST_TIME 	1264740956
> If I wanted to upload it to Loadstone as points of interest, am I correct in 
> thinking that I will need to take the userid 20790 and change it to my user 
> id for it to work? Or is there a converted which automatically replaces the 
> old user id with the user id of the person editing the file? There are over 
> 1000 points and I am looking at how this can be uploaded for others to use in 
> the easiest way possible?
> Also, why is it that I can download points from other people who have 
> uploaded to the site, but I can't upload them for others to share? (Eg. I 
> could download the osm file and convert it from there, but not share it on 
> Loadstone as points. The same goes for when a mate creates a file. I can get 
> his loadstone points, and view them and even rename them, but cant re upload 
> them without changing the user id? Or is this more a security caution? If 
> there were more available osm files and they could be converted into 
> loadstone points then it would be good for others living in the area that 
> wanted those particular points. Just some thoughts.
> Thanks for your help
> Gene

More information about the Loadstone mailing list