SQL Error: PROCEDURE wimo.findLocationsInRadius does not exi
Posted: Fri Dec 12, 2014 12:09 pm
When using correct lat lon as location identifier more than 50% of the yowidget loads results in the NewYork data being shown.
The cityname displayed is then "New York City"
The resulting display looks the same as when using an unknown geoname number.
Refreshing the page results half of the times in incorrect data, half of the times in correct data.
The results seems to be better in the morning (CET) than later of the day.
When using a correct genames number the correct data is shown. It did not occur yet that invalid data whas returned, but I do not know for sure.
This is a demo site using the lat lon: http://www.weerstation-leuven.be/weather2/
This is the request as send by yowidget
Request URL:http://widget2.yowindow.com/cgi-bin/wim ... ent=hp_pal
These are the first lines of the results with the error (half of the times)
<?xml version="1.0" encoding="UTF-8"?>
<response time="0.003">
<error id="internal">SQL Error: PROCEDURE wimo.findLocationsInRadius does not exist
Trace begun at /usr/lib/cgi-bin/wimo/lib/db/Wimo.pm line 145
db::Wimo::query('db::Wimo=HASH(0x7fe4854f17f8)', 'CALL findLocationsInRadius(50.85, 4.34, 20, 32768)') called at /usr/lib/cgi-bin/wimo/lib/db/World.pm line 62
I use the lat lon as the dafault location in my templates as much users make mistakes when selecting a geoname number when installing the template. But the last few days, using lat lon seems suddenly to be resulting in much errors with all users in europe and the US.
I attached the complete error as a text file.
Wim
The cityname displayed is then "New York City"
The resulting display looks the same as when using an unknown geoname number.
Refreshing the page results half of the times in incorrect data, half of the times in correct data.
The results seems to be better in the morning (CET) than later of the day.
When using a correct genames number the correct data is shown. It did not occur yet that invalid data whas returned, but I do not know for sure.
This is a demo site using the lat lon: http://www.weerstation-leuven.be/weather2/
This is the request as send by yowidget
Request URL:http://widget2.yowindow.com/cgi-bin/wim ... ent=hp_pal
These are the first lines of the results with the error (half of the times)
<?xml version="1.0" encoding="UTF-8"?>
<response time="0.003">
<error id="internal">SQL Error: PROCEDURE wimo.findLocationsInRadius does not exist
Trace begun at /usr/lib/cgi-bin/wimo/lib/db/Wimo.pm line 145
db::Wimo::query('db::Wimo=HASH(0x7fe4854f17f8)', 'CALL findLocationsInRadius(50.85, 4.34, 20, 32768)') called at /usr/lib/cgi-bin/wimo/lib/db/World.pm line 62
I use the lat lon as the dafault location in my templates as much users make mistakes when selecting a geoname number when installing the template. But the last few days, using lat lon seems suddenly to be resulting in much errors with all users in europe and the US.
I attached the complete error as a text file.
Wim