{9} All Tickets by Time Descending (1658 matches)

This query is slow:

mysql> SELECT COUNT(distinct(members.id)) as cnt from members right join BW_ARCH.logs on members.id=BW_ARCH.logs.IdMember? and BW_ARCH.logs.type='Login' and BW_ARCH.logs.created between '2012-05-15 00:00:00' and '2012-05-16 00:00:00' and BW_ARCH.logs.Str like 'Successful login%' /* /home/bwrox/www.bewelcome.org/htdocs/bw/updatestats.php */;

I created an index on BW_ARCH.logs(created), but it didn't help. Looking at the query again, I notice that the join to the members table is probably a noop and can be dropped:

mysql> SELECT COUNT(distinct(members.id)) as cnt from members right join BW_ARCH.logs on members.id=BW_ARCH.logs.IdMember? and BW_ARCH.logs.type='Login' and BW_ARCH.logs.created between '2012-05-15 00:00:00' and '2012-05-16 00:00:00' and BW_ARCH.logs.Str like 'Successful login%' /* /home/bwrox/www.bewelcome.org/htdocs/bw/updatestats.php */; +-----+ | cnt | +-----+ | 136 | +-----+ 1 row in set (7.65 sec)

mysql> SELECT COUNT(distinct logs.IdMember?) as cnt from BW_ARCH.logs where BW_ARCH.logs.type='Login' and BW_ARCH.logs.created between '2012-05-15 00:00:00' and '2012-05-16 00:00:00' and BW_ARCH.logs.Str like 'Successful login%'; +-----+ | cnt | +-----+ | 136 | +-----+ 1 row in set (0.01 sec)

mysql> SELECT COUNT(distinct logs.IdMember?) as cnt from BW_ARCH.logs where BW_ARCH.logs.type='Login' and BW_ARCH.logs.created between '2012-05-15 00:00:00' and '2012-05-16 00:00:00' and BW_ARCH.logs.Str like 'Successful login%';

Issue:

• To solve performance issues described in #1655 we need to make Rox memcache-ready

Solution:

1. Add memcache section to config, containing:
   • use_memcache: yes/no
   • server
   • port
2. Write simple wrapper that:
   • Reads memcache config
   • Connects to memcache server on demand (consider persistent connection)
   • Sets, gets and expires/deletes keys

Clues:

• We need to decide what the wrapper should be attached to, either the Rox base model or an independent module, this needs discussion
• See tutorials at  http://code.google.com/p/memcached/wiki/TutorialCachingStory and  http://www.php.net/manual/en/memcache.examples-overview.php

Related tickets:

• #1654
• #1655
• #644

Issue:

• We have some slow SQL queries in deer:/var/log/mysql/mysql-slow.log and memcached will help to fix this

Solution:

• sudo apt-get install memcached

Clues:

• This can not be done right now, because deer is hopelessly out of date and the command above will stop with a 404 when trying to fetch packages
• Once memcached is installed we need to rewrite the sections in Rox that are causing the slow queries, see  http://code.google.com/p/memcached/wiki/TutorialCachingStory and  http://www.php.net/manual/en/memcache.examples-overview.php

Related tickets:

• #1655
• #1656

Issue:

1. "You and XXX share a special relationship now."

with a link to  http://alpha.bewelcome.org/members/202/relations/add showing "update relationship" and "relationship confirmed"

2. "XXX says you have a special relationship, now. Do you confirm this?"

with a link to  http://alpha.bewelcome.org/members/202/relations/add

Solution:
As I started the relationship I would suggest to link "1. + Show it!" to /members/XXX/relations or the /members/XXX#relationsbox

Message 2 I should not see as I started the relationship!

The "Family and close friends" box has a link at the bottom that says "Show all".

Issue:

• This link leads to a page that shows the same number of entries, because the "Family and close friends" box on the profile always shows all

Solution:

• The "Family and close friends" box makes the profile colourful, and limiting its list to 3 or 5 members is not a good idea IMHO. So this results in this solution:
  1. Remove "more" link
  2. Display "Manage friends" when looking at your own profile, link to "/editmyprofile#!specialrelations" (relations tab in edit profile form)

Issue:

• All textareas (i.e. "Profile Summary" or "I Live With") don't handle backslashes in front of single quotes well:
  • \' becomes ' after saving
  • \\\\\\\' also becomes ' after saving

Solution:

• Save information as typed in by the user, so always keep the backslashes

Clues:

• Other text fields (not textarea) save information as expected, compare data handling and display there

Related ticket:

• #1279 (see fixes in commits)

Urgency:

• Not urgent, because it's very unlikely that someone needs \' in their profile ;)

Issue:

• When clicking the "Delete" link on your own  http://www.bewelcome.org/members/<username>/relations page nothing happens

Expected behaviour:

• Relationship is deleted and notice "Relationship was removed" is shown

Related tickets:

• #1580
• #1634

Issue:

• When searching  http://www.bewelcome.org/setlocation for the town "Sighişoara" (the place I am currently at), no relevant results are found

Solution:

• Debug SQL query and display correct geonames_cache entry for Sighişoara

Clues:

• I added "Sighişoara" manually to geonames_cache table, because it wasn't there, but still it's not found. This might have to do with the special "s" in the middle, or a step that I forgot when adding the city to the db

Related tickets:

• #1615
• #1642

Issue:

• When searching for "XXXXXX" at  http://www.bewelcome.org/setlocation capital cities (Beijing, Berlin, ...) are shown as results - this is misleading

Solution:

• Show message 'No location found for "XXXXXX". Try searching for places near to this location.' instead of result list

 http://www.bewelcome.org/trip and individual trip pages (i.e.  http://www.bewelcome.org/trip/show/claudiaab) need to be migrated to OpenStreetMap

related ticket:

• #1635

blog posts with geo information will show a map. examples:

•  http://www.bewelcome.org/blog/claudiaab/ (click "map")
•  http://www.bewelcome.org/blog/claudiaab/1133

they need to be migrated to OpenStreetMap

related ticket:

• #1635

 http://www.bewelcome.org/signup/3 needs to be migrated to OpenStreetMap

related ticket:

• #1635

Issue:
Delete link jumps to old layout:  http://www.bewelcome.org/bw/editmyprofile.php?action=delrelation&Username=xxx

Check the tab on the edit profile form:

 http://gitorious.org/bewelcome/rox/blobs/master/build/members/templates/editprofile_form.php#line549

Solution:

Replace link with something like:  http://www.bewelcome.org/members/matthias/relations/delete

After confirmation move back to edit profile page. (tab relations)

It seems that some group member settings have changed to "no email".

Let's try to track this bug:
Check how many group/members/forum topics are affected.
Is it an ongoing bug or did it happen just once?

Reported in the "open hosts requests in toulouse" in thhis thread:  http://www.bewelcome.org/forums/s2349-bug__receive_the_posts_from_the_forum__open_hosts_requests_

Some members from the Munich group told me the same and I was quite sure that I had a subscription for the Munich group too, which was gone.

Crumbking came up with the idea to replace the " X/0 members found." with:

not logged in:

0 members found. Try it with the [map search]. 0 public members found. [Log in] to see X non public members. Or try it with the [map search]. X public members found. [Log in] to see additional X non public members. Or try it with the [map search]. logged in: 0 members found. Try it with the [map search] X members found. Try it with the [map search], too!

With this information we help the user to find profiles around some places. (map search) And we attract potential users to signup!

general purpose message boxes (called "flash" in other mvc frameworks) that can be set after an action has been completed are missing in rox.

this is needed for #1587, so i will implement notice and error message flashes which they can be simply called in each controller.

This is a ticket to change the default search parameters: A search will return

• only people who can host and have a profile picture
• people who last logged in will be first

At the moment the default parameters are : active (logged in at least once in the last 3-4 years), no matter if there is a profile picture and if the person can host or not. Default sort order is newest member first. The current default search results can still be found with the advanced search settings.

related bw forum discussion:  http://www.bewelcome.org/forums/s2289-Empty_profiles_are_useless

It's great if someone has created a nice, active group, but we don't want to see the profile picture of that person again and again forever on top of the group start page.

It would be enough to have small text at the bottom with the username of the founder / without profile picture.

related discussion in the BW forum:  http://www.bewelcome.org/forums/s1414-Explaining_the_title___Founder_of_this_group__and___no_owner_

The reference database for local installations of BWRox is missing some stored functions/procedures. E.g. it is not possible to create new posts or reply to a forum post without the db function Next_Forum_trads_IdTrad().

Jean Yves has written to the bw-dev mailinglist how to create this stored function. I copy&paste his message here:

Hello, I just checked this stored function is really needed for the forum to work. Here is the code to run on mysql to create it:

CREATE FUNCTION `Next_Forum_trads_IdTrad`() RETURNS int(11)
    DETERMINISTIC
BEGIN
     DECLARE res INT;
select max(IdTrad)+1 from translations into res ;
               RETURN res;
    END

It should be added on the reference test database Greetings Jean Yves

As this is a dead link I changed the link to wiki/BeVolunteer

see:  http://gitorious.org/bewelcome/rox/commit/95aaf5742700205f9bbbf527b700962a2e0aa425

add member info to the sidebar on the image-view and add a link to a username

see:  http://gitorious.org/bewelcome/rox/commit/00ce983f304aa947ca14c1f3ae5c639a099b3807

Issue:

• after switching the language of the site and visiting the profile page creates a (unwanted) profile translation. It even switch to this (unwanted) profile translation. It's even getting better: If you hit the edit button of the (unwanted) translation change XY and click the save button it shows changes are saved and it opens the other version of your translated profile and for the user it seems like the changes are not saved.

Solution:

• Stop the automatic creation of a profile translation while surfing in another languages
• Check if the code jumps to the right profile translation after hitting the save button in the "edit profile page"
• add a message above the edit profile form: "You are editing the XYlanguage of your profile."

Alternative:

• Get rid of the whole profile translation thing ;-)

Issue:

• We have places in geonames_cache that have a parentCountryId=0, although a fk_countrycode is set
• This leads to unexpected behaviour during sign-up and possibly in member search

Solution:

1. Add missing parentCountryId values via SQL query
2. Fix geonames import script

Clues:

• Find broken locations via:

  SELECT * 
  FROM geonames_cache
  WHERE parentCountryId = 0
  AND fcode NOT LIKE  "PC%"
  

• Make sure manual fixes of geonames_cache are not overwritten by geonames import script
• Compare geonames_cache with geonames_countries
• Priority is low, because this only hits very few members

Related ticket:

• #1586

Hello,

a user suggest to activate the google custom search pagination.
[See  http://www.bewelcome.org/forums/s2171-google_custom_search__no_scrollbar ]

As you can see on this page: It is somehow possible to activate it.

 http://www.umweltv.at/

Issue:

• "Please log in to see the thread" appears when opening a forum thread that is hidden/group-only - this is misleading

Solution:

• Display this error message: "This page is only visible to members of the group Example. Please join this group to access this page."

User feedback:

I guess it is not a bug, but I would like to point out that the impossibility to create clickable links on the groups description, and even the facts that  http://-like links are inactive is really annoying, and definitely not user-friendly.

The "Add a note" function (available on every profile, in the menu on the left) is not maintained, and buggy. I remember I found some while ago a link to :

"My notes page"  http://www.bewelcome.org/bw/mycontacts.php

I cannot find it any longer.

We should remove the function if we do not fix it and/or rewrite it.

on the profiles, when you pick Latvian, in french it appears as "Lituanien" instead of "Letton"

When a member is banned using the Banned status in the members table, his potential current session isn't affected, so he can keep using the website f.ex. spamming until his session expires.

Issue:

• The number of comments displayed next to a blog post preview also counts comments of members that were banned

Solution:

• Only count comments of active members

Clues:

• Meinhard started working on this via #1572, but the resulting SQL query (9+ joins!) became really slow, so work needs to be picked up from there

Issue:

• At signup (/signup) you type in any username and get a green check symbol as soon as it is long enough - you assume the name is available
• You finish the sign-up process until the last step and if the username is taken, you will be notified - this is disappointing

Solutions:

1. AJAX check of username availability when leaving username field
2. Check for username after completing step 1

Priority:

• Not too low, because a perfect sign-up procedure gives the user a good first impression about BW

Issue:

• The zoom effects of images in the gallery and profile picture don't work in various versions of Internet Exploder, due to JS incompatibilities

Solutions:

1. Update zoom script to latest versions and see if this fixes the issue
2. Use a different zoom solution, i.e. fancybox ( http://fancybox.net/), which seems to have decent x-browser support

Related ticket:

• #1593

Currently the donation bar  http://www.bewelcome.org/donate shows that BeVolunteer needs 180€ per month.

As on the GA 2012 it was agreed to ask run only one donation campaign, the donation page needs to be changed like this:

• Display the info that BeVolunteer asks for 1000€ this year
• Make the "Help the project" tab the default tab on the main page, so that people notice the "donation thermometer"

Solution:

• Hide when no visitors are expected in user's city

Issue:

• When visiting a profile a logged-in user is tracked and the profile owner will see the user's visit on  http://www.bewelcome.org/main and  http://www.bewelcome.org/myvisitors
• Some (a lot of?) users see this as a breach of their privacy and would like to be able to switch it off

Solution:

1. Add preference "Show my profile visits to profile owners" or "Track my profile visits"
2. Add preference "Display 'Recent visitors of your profile' on my start page"
3. Implement code that reads these preferences in different modules

Issue:

• We have abusers that sign up and send hundreds of scam/spam messages within hours

Solution:

• Limit number of messages people can send per time frame (per minute, per 15 minutes, per hour, per day), possibly in combination with member status and number of friends
• Make limits easily configurable (default.ini?), so we can fine-tune later

Clues:

• We should identify a typical abuser profile and set limits accordingly. I.e. a typical abuser probably has 0 comments/friends, just signed up, has not received any messages,
• Maybe we can have a score system to calculate the likelihood of an abuser (i.e. no comments: 10 points, no messages received: 10 points, newly sign-up 5 points)
• If a flag mechanism for users exists, we should also consider this
• Messages could be held for moderation instead of being rejected
• Akismet-like text recognition could also be implemented - there is so much anti-spam software out there! :)
• A captcha however is no solution IMHO, because it will only protect us from automated message sending, which we don't have. Solving our simple captcha takes 2 seconds, nothing that will stop a dedicated spammer

Related tickets:

• #1569
• #1595

Issue:

• About 1% of new members have broken location data (ADM1 location class instead of PPL location class)
• Currently about 50 people with this problem are pending to be accepted

Reproduce:

• This issue can not be reproduced by us yet

Solution:

1. Make sure people can only continue sign-up if a PPL class location has been selected
2. Automatically sanitise broken location (preferred)

Clues:

• Check  http://alpha.bewelcome.org/bw/admin/adminaccepter.php for pending members with empty addresses and "no region defined" to find faulty sign-ups

Related ticket:

• #1147

from :  http://www.bewelcome.org/forums/s1959-What_about_gender_/

Since "gender" is a box that allows users to search for hosts/guests based on their gender, I feel that we should offer the following :

1. have three options (one - and only one - should be compulsory) : Male - Female - Other

AND

2. provide a free text field with the "other" so that members can write about their particular situation. Since this is a free text field, you can write "i don't tell" or "i'm a transsexual" or "I don't believe in gender-discrimination" or whatever you want to say about your gender views.

This way members can still use the search function and those members who don't want to put their gender have a way of expressing that.

At the moment, there is no way to display gender informations on profiles. Of course, we have to make it possible to display. I guess next to the "age" info would be fine.

As requested by the community we should enable links in forms like in the profile page.

See  http://www.bewelcome.org/forums/s1907

Issue:

• Next to the profile pictures of close friends it says either 0 or some 6 digit number, example:  http://www.bewelcome.org/members/Sasa/relations/

Solution:

• Show relation text or nothing

 http://www.bewelcome.org/main

On the main BeWelcome page, the "Recent forum posts" is displayin the last active threads I subscibed to => Then it displays all the last active threads of the groups I joined.

The problem is that it keeps displaying the threads of the groups I left.

For example : I joined the Berlin group, then I left it, but the "Recent forum posts" keeps displaying recent threads from this group on my main page. (hopefully) I do not receive email notifications though.

Issue:

There seems to be an inconsitency for pending members: Some profiles are not shown in bw/admin/adminaccepter.php, but are displayed in the new (not ready) version of it: build/admin/accepter

Example:  http://www.bewelcome.org/members/zackskerritt

Clue:

All profiles that are not shown in bw/admin/adminaccepter.php have no region or country information

Possible related ticket: #1147

If a member is banned because of abusing the rules of bewelcome (spamming, etc), all the comments he/she left for other members are still visible on their profiles.

It's not possible for admins to delete blog posts and comments from other users. While blog posts from banned users are not shown anymore, their comments are still visible:

 http://www.bewelcome.org/blog/planetcruiser/1029#comments

Quick solution:

• show only comments from active members

Issue:

• When form input errors occur, a language that has been added to the profile is not being saved
• A notice like this is shown: "Notice: Undefined property: stdClass::$Name in /home/www/www.bewelcome.org-4634187/build/members/templates/editprofile_form.php on line 77"

Reproduce:

1. Edit profile  http://www.bewelcome.org/editmyprofile
2. At "Spoken language" select a new language
3. Click "Add Language"
4. Empty "Birth date" field (or any other mandatory field)
5. Press "Submit"
6. Added language is not displayed, instead PHP notice is shown

Solution:

• Display newly added language, also when form validation errors occur

Issue:

•  http://www.bewelcome.org/feedback offers 9 (soon 10) different options
• that's too many, users will have a hard time to differentiate between them

Current categories:

1. Bug problem
2. Abuse report
3. Signup problem
4. Comment problem
5. Media issue
6. Forum Issue
7. Suggestion
8. I want to help!
9. Donations (soon), see #1273
10. Other

I suggest to reduce to:

1. Don't know (preselected)
2. Bug or technical problem
3. Suggestion
4. I want to get involved!
5. Donation (soon), see #1273
6. Media/press
7. Abuse

Also a radio button list would be nicer, it saves one click.

Issue:

• Entering a date as a YYYY-MM-DD string is not very usable
• It's inconsistent with sign-up (there it's selects)

Reproduce:

1. Edit profile
2. Enter a date, submit
3. Most likely, unless you are a programmer, you will get it wrong ;)

Solution:

• Use same type of select fields as during sign-up

The current chat does not really work.

Therefore an first idea is to go for another solution: jappix mini chat ( https://gitorious.org/bewelcome/rox/commits)  https://gitorious.org/bewelcome/rox/commit/de3a74d85f9b98e5681e0187f233e977d2a1cfe

Feedback from drdave Category BugProblem?

Browsing to the page:  http://www.bewelcome.org/donate/done

yields a massive, very user-unfriendly error... Probably due to missing URL parameters.

Not entirely sure how this URL appeared along my browsing (might have been while returning from the Paypal page).

BW Rox Version: 4634187 Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit?/534.51.22 (KHTML, like Gecko) Version/5.1.1 Safari/534.51.22 Languages: en-gb

Issue:

•  http://www.bewelcome.org/people/USERNAME and  http://www.bewelcome.org/members/USERNAME lead to the same page. this is confusing and also might influence search engine ranking due to duplicate content

Solution: "drop /people/"

1. Change any occurrence of /people/ to /members/ in the source code
2. Redirect /people/ -> /members/ on web server level

Related ticket:

• #1512