Page 1 of 1

SQL Error: PROCEDURE wimo.findLocationsInRadius does not exi

Posted: Fri Dec 12, 2014 12:09 pm
by wvdkuil
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

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Posted: Sat Dec 13, 2014 8:16 am
by par
Hey, Wim!
Recently we had a major server software update.
There were a number of errors, including the one you reported about.
I just have tested your case again.
Seems to be working.
So I hope I have fixed this error.
Let me know if you still experience the problem.

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Posted: Sat Dec 13, 2014 11:01 am
by wvdkuil
par wrote:Hey, Wim!
Recently we had a major server software update.
There were a number of errors, including the one you reported about.
I just have tested your case again.
Seems to be working.
So I hope I have fixed this error.
Let me know if you still experience the problem.
The error with the lat-lon invalid location is gone, at least it is not there half of the time.

But now this request takes "forever" reporting in chrome waiting 36.68 seconds
http://widget2.yowindow.com/cgi-bin/wim ... ent=hp_pal

This one never finishes end in Failed to load resource: net::ERR_CONNECTION_RESET
http://widget1.yowindow.com/cgi-bin/wim ... ent=hp_pal

This one also extremely long returns net::ERR_CONNECTION_TIMED_OUT
http://widget1.yowindow.com/cgi-bin/wim ... ent=hp_pal

But this is not as severe as the data is after some waiting displayed and is correct so visitors to the sites see a "nearly" complete screen with a small message "updating weather"

Wim

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Posted: Sun Dec 21, 2014 11:44 am
by par
I have fixed the weather delay problem as well a couple of days ago.
Please let me know if everything is ok on your end now.

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Posted: Sun Dec 21, 2014 11:48 am
by wvdkuil
par wrote:I have fixed the weather delay problem as well a couple of days ago.
Please let me know if everything is ok on your end now.
I switched the yowindow display at the website on again and
YES
it loads as it :good: should.

Wim