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
SQL Error: PROCEDURE wimo.findLocationsInRadius does not exi
- 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
- 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
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
- par
- Posts: 8629
- Joined: Mon Sep 21, 2009 11:56 am
- Name: Pasha
- Location: Saint-Petersburg, Russia
- Contact:
Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not
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.
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.
- 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
The error with the lat-lon invalid location is gone, at least it is not there half of the time.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.
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 (40.83 KiB) Viewed 7268 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
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
- par
- Posts: 8629
- Joined: Mon Sep 21, 2009 11:56 am
- Name: Pasha
- Location: Saint-Petersburg, Russia
- Contact:
Re: SQL Error: PROCEDURE wimo.findLocationsInRadius does not
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.
Please let me know if everything is ok on your end now.
- 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
I switched the yowindow display at the website on again andpar 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.
YES
it loads as it 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
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