[Loadstone] Error report Trying to see area exporter points

Kennydog hurrikenny at slingshot.co.nz
Tue Jan 27 05:43:58 GMT 2009


Hi. Well I am getting there slowly! I have now (with Shawn's help - 
thanks mate) managed to solve the permission denied problem. I manually 
went into each of the other two databases and went find... (the 4 digit 
userid) and replace (with the new 5 digit user id). It has now allowed 
me to upload all three databases to Loadstone! (Finally...). I went to 
purge them, and it deleted them (so they were definately uploaded and 
now that I have re-uploaded them all, it tells me the amounts of points 
- which are correct).  Now all I need to know is, when I go to area 
exporter and try to view the co-ordinates that I uploaded, it still 
comes up with a pear error. I entered the co-ordinates for one of the 
uploaded points but it didn't find them. This is what it said:


    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: unknown error
debug info 	select makecircle(GeomFromEWKT('SRID=4326;POINT(1741140433 
-390467566)'),20000) [nativecode=ERROR: AddToPROJ4SRSCache: Cannot find 
SRID (290222703) in spatial_ref_sys CONTEXT: SQL function "makecircle" 
statement 1]
HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; 
rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
REMOTE_ADDR 	124.197.37.198
REQUEST_URI 
/~shane/gps/export.php?_qf__export=&focal%5By%5D=-390467566&focal%5Bx%5D=1741140433&radius%5Bd%5D=20&radius%5Bunit%5D=1000&submit%5Bview%5D=View&username=&itables%5Baddress%5D=1&itables%5Bcell%5D=1&itables%5Bcountry%5D=1&itables%5Bneighbourhood%5D=1&itables%5Bnetwork%5D=1&itables%5Bregion%5D=1&itables%5Bstreet%5D=1&itables%5Btype%5D=1 

REQUEST_TIME 	1233034772

Please can you tell me what this bug report means and how we get around 
it. Does this mean that the site is not recognising that particular 
database? Thanks


More information about the Loadstone mailing list