Page 16 of 49

Re: Eurobilltracker-site Feedback.

Posted: Sun Aug 10, 2014 8:08 pm
by Phaseolus
When I go to my bills, and I want to click on the cities linked to my bills, it opens my profile instead of opening the profile of the city.

It's not a big deal, but I hope you appreciate I mention this.

Thank you for the job you do !

Re: Eurobilltracker-site Feedback.

Posted: Sun Aug 10, 2014 10:23 pm
by avij
klapotec was kind enough to fix the "Last 10 locations" problem. Thanks :)

Re: Eurobilltracker-site Feedback.

Posted: Sun Aug 10, 2014 10:26 pm
by avij
Phaseolus wrote:When I go to my bills, and I want to click on the cities linked to my bills, it opens my profile instead of opening the profile of the city.
Hm, I'm not seeing this. If I go to my list of notes and then click on any of the cities listed, I get the profile of the city. What kind of URL do you get in the address bar? I get https://en.eurobilltracker.com/profile/?city=38885" onclick="window.open(this.href);return false; , for example.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 12:11 am
by Raumi
That weird thing is also happening to me with the note that I've entered this afternoon in L'Aldea.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 10:28 am
by ErGo
It seems, that the "Last 10 locations"-Selection-Box is now working correctly.

Edit: :oops: - i missed the entry of avij above

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 11:22 am
by avij
The new server has enough memory to keep the entire 46GB database of EBT in RAM. This should theoretically make all kinds of searches rather quick. However, even though MariaDB is generally speaking more capable than MySQL that we used previously, MariaDB seems to have its own problems as well. Some database queries that got executed instantly on MySQL take an inexplicable amount of time to execute on MariaDB. One particular search query that we saw should get executed in a few seconds, but we witnessed it taking around half an hour to execute. We've figured out a workaround for this particular bug, but it'll need some changes to the database. This change will be implemented early tomorrow morning when there's less traffic on the site.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 3:18 pm
by tabbs
Admittedly I have no clue when it comes to the work behind the curtain ... But I do appreciate your efforts and the results they get us to. Thanks! :)

Christian

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 6:08 pm
by avij
avij wrote:
dmo11 wrote:Just entered a note in most likely a new town, it shows in statistics as a new note (went one up), but not in my list of notes entered.
It used to be in the list right away, is this maybe a new feature for notes in new places or something wrong?
Yes, there is something wrong. The code has now been fixed so that any further notes entered from that place will show up correctly. The note you entered is in the database, but with an invalid location, and notes with an invalid location won't show up on the list. Fixing the invalid locations will require a bit of work from our side, the usual support tools aren't sufficient for fixing this. This problem affects 65 note entries from 12 users. Please wait for further instructions regarding this.
The instruction emails have now been sent to the affected users. The notes are now shown on your list of notes, but possibly with an incorrect location. These notes were moved to the latest location where you have entered notes. If this is incorrect, you can edit the notes to the correct location yourself.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 9:45 pm
by Phaseolus
Phaseolus wrote:When I go to my bills, and I want to click on the cities linked to my bills, it opens my profile instead of opening the profile of the city.

It's not a big deal, but I hope you appreciate I mention this.

Thank you for the job you do !
The kind of thing happens to this bill : https://fr.eurobilltracker.com/notes/?id=142190990" onclick="window.open(this.href);return false;

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 10:22 pm
by lmviterbo
Phaseolus wrote:The kind of thing happens to this bill : https://fr.eurobilltracker.com/notes/?id=142190990" onclick="window.open(this.href);return false;
For me as a member of the geolocation team, that is behaving as if it were a new town that doesn't exist yet on EBT's database (and will only exist once someone in the geolocation does it manually). This means it is opening the city-manager online app. The town is already on the DB though, with geocoords and all.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 10:36 pm
by avij
Right, it's the ' problem again. I'll have a look.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 10:37 pm
by Phaseolus
lmviterbo wrote:
Phaseolus wrote:The kind of thing happens to this bill : https://fr.eurobilltracker.com/notes/?id=142190990" onclick="window.open(this.href);return false;
The town is already on the DB though, with geocoords and all.
And can you link it to the existing profile ? Please.

Re: Eurobilltracker-site Feedback.

Posted: Mon Aug 11, 2014 11:04 pm
by lmviterbo
Phaseolus wrote:And can you link it to the existing profile ? Please.
http://eurobilltracker.com/profile/?city=109987

Re: Eurobilltracker-site Feedback.

Posted: Tue Aug 12, 2014 1:14 am
by vermeer
Something strange is happening. After i enter notes i get this to see. Between '' can be different of course.

city2id: SELECT id, parent_id FROM locations WHERE key_city = binary 'Groningen' AND key_zip = binary '9726' AND key_country = binary 'Netherlands'

Re: Eurobilltracker-site Feedback.

Posted: Tue Aug 12, 2014 4:07 am
by Castanhola
vermeer wrote:Something strange is happening. After i enter notes i get this to see. Between '' can be different of course.

city2id: SELECT id, parent_id FROM locations WHERE key_city = binary 'Groningen' AND key_zip = binary '9726' AND key_country = binary 'Netherlands'
I have an Apple Script application to help me register notes with EBT API. It was working fine before the server upgrade but now it gives an error after registering the first note. It seems the problem its connected with this change reported by vermeer, but I must take some more time to be sure of the source of the problem.