SQL Error: PROCEDURE wimo.findLocationsInRadius does not exi

YoWindow widget Questions, Suggestions and Bugs
Post Reply
User avatar
wvdkuil
Posts: 8
Joined: Sun May 04, 2014 7:34 pm
Name: Wim van der Kuil
Location: Lueven - Belgium
Contact:

SQL Error: PROCEDURE wimo.findLocationsInRadius does not exi

Post 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
Attachments
yowidget.txt
(3.37 KiB) Downloaded 348 times
Developing scripts and the Leuven-Template for weather-websites
I use myself Meteohub / Meteobridge with Vantage Pro2 UV Solar Soil Leaf
And ten other weather-programs on a Mac Mini for development. Demo at www.weerstation-leuven.be
User avatar
par
Posts: 8627
Joined: Mon Sep 21, 2009 11:56 am
Name: Pasha
Location: Saint-Petersburg, Russia
Contact:

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Post 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.
Get YoWindow weather app for your phone or tablet.

Image Image Image
User avatar
wvdkuil
Posts: 8
Joined: Sun May 04, 2014 7:34 pm
Name: Wim van der Kuil
Location: Lueven - Belgium
Contact:

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Post 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
Attachments
waiting_yowindow.jpg
waiting_yowindow.jpg (40.83 KiB) Viewed 7264 times
Developing scripts and the Leuven-Template for weather-websites
I use myself Meteohub / Meteobridge with Vantage Pro2 UV Solar Soil Leaf
And ten other weather-programs on a Mac Mini for development. Demo at www.weerstation-leuven.be
User avatar
par
Posts: 8627
Joined: Mon Sep 21, 2009 11:56 am
Name: Pasha
Location: Saint-Petersburg, Russia
Contact:

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Post 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.
Get YoWindow weather app for your phone or tablet.

Image Image Image
User avatar
wvdkuil
Posts: 8
Joined: Sun May 04, 2014 7:34 pm
Name: Wim van der Kuil
Location: Lueven - Belgium
Contact:

Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not

Post 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
Developing scripts and the Leuven-Template for weather-websites
I use myself Meteohub / Meteobridge with Vantage Pro2 UV Solar Soil Leaf
And ten other weather-programs on a Mac Mini for development. Demo at www.weerstation-leuven.be
Post Reply