• show all show failed

Test file	Test results	Time	%
70 files	1331 tests, 1331 ok, 0 failed, 0 todo, 0 skipped, 0 parse errors exit status: 0, wait status: 0 elapsed time: 10 wallclock secs ( 0.26 usr 0.11 sys + 1.85 cusr 0.66 csys = 2.88 CPU)	9.63s	100.0%
website/db/tests/test-00-init.sql	1..1  ok 1 - pgTAP is active!	0.04s	100.0%
website/db/tests/test-10-schema.sql	1..56  ok 1 - Schema amqp should exist  ok 2 - Schema audit should exist  ok 3 - Schema geokrety should exist  ok 4 - Schema public should exist  ok 5 - Schema secure should exist  ok 6 - There should be the correct schemas  ok 7 - Table gk_account_activation should exist  ok 8 - Table gk_awards should exist  ok 9 - Table gk_awards_group should exist  ok 10 - Table gk_awards_won should exist  ok 11 - Table gk_email_activation should exist  ok 12 - Table gk_email_revalidate should exist  ok 13 - Table gk_geokrety should exist  ok 14 - Table gk_geokrety_rating should exist  ok 15 - Table gk_labels should exist  ok 16 - Table gk_mails should exist  ok 17 - Table gk_moves should exist  ok 18 - Table gk_moves_comments should exist  ok 19 - Table gk_news should exist  ok 20 - Table gk_news_comments should exist  ok 21 - Table gk_news_comments_access should exist  ok 22 - Table gk_owner_codes should exist  ok 23 - Table gk_password_tokens should exist  ok 24 - Table gk_pictures should exist  ok 25 - Table gk_races should exist  ok 26 - Table gk_races_participants should exist  ok 27 - Table gk_site_settings should exist  ok 28 - Table gk_site_settings_parameters should exist  ok 29 - Table gk_social_auth_providers should exist  ok 30 - Table gk_statistics_counters should exist  ok 31 - Table gk_statistics_daily_counters should exist  ok 32 - Table gk_users should exist  ok 33 - Table gk_users_authentication_history should exist  ok 34 - Table gk_users_settings_parameters should exist  ok 35 - Table gk_users_social_auth should exist  ok 36 - Table gk_users_username_history should exist  ok 37 - Table gk_watched should exist  ok 38 - Table gk_waypoints_country should exist  ok 39 - Table gk_waypoints_gc should exist  ok 40 - Table gk_waypoints_oc should exist  ok 41 - Table gk_waypoints_sync should exist  ok 42 - Table gk_waypoints_types should exist  ok 43 - Table gk_yearly_ranking should exist  ok 44 - Table phinxlog should exist  ok 45 - Table scripts should exist  ok 46 - Table sessions should exist  ok 47 - Table audit.actions_logs should exist  ok 48 - Table audit.posts should exist  ok 49 - Table public.countries should exist  ok 50 - Table public.spatial_ref_sys should exist  ok 51 - Table public.srtm should exist  ok 52 - Table public.timezones should exist  ok 53 - Table secure.gpg_keys should exist  ok 54 - Schema audit should have the correct tables  ok 55 - Schema public should have the correct tables  ok 56 - Schema secure should have the correct tables	0.07s	100.0%
website/db/tests/test-100-geokret-last-log.sql	1..12  ok 1 - geokret last_log updated - 1  ok 2 - geokret last_log updated - 2  ok 3 - Added as older move has no effects  ok 4 - change move date updates geokret last_log  ok 5 - delete move updates geokret last_log  ok 6 - no move is null  ok 7 - comment null  ok 8 - removed moves is null  ok 9 - Old GeoKret new position - 1  ok 10 - New GeoKret new position - 2  ok 11 - Old GeoKret new position - 3  ok 12 - New GeoKret new position - 4	0.18s	100.0%
website/db/tests/test-100-geokret-last-position.sql	1..15  ok 1 - geokret last_position updated - 1  ok 2 - geokret last_position updated - 2  ok 3 - geokret last_position updated - 3  ok 4 - geokret last_position updated - 4  ok 5 - geokret last_position updated - 5  ok 6 - geokret last_position updated - 6  ok 7 - no move is null  ok 8 - comment null  ok 9 - comment is set  ok 10 - removed moves is null  ok 11 - Old GeoKret new position - 1  ok 12 - New GeoKret new position - 2  ok 13 - Old GeoKret new position - 3  ok 14 - New GeoKret new position - 4  ok 15 - New GeoKret new position - 4	0.19s	100.0%
website/db/tests/test-110-account-activation-token-generated.sql	1..25  ok 1 - used defaults to UNUSED  ok 2 - token is automatically added  ok 3 - Token can be manually inserted  ok 4 - Reset  ok 5 - Not null  ok 6 - threw 23502: null value in column "requesting_ip" of relation "gk_account_activation" violates not-null constraint  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25	0.07s	100.0%
website/db/tests/test-111-account-activation-token-used-validating-ip.sql	1..12  ok 1  ok 2  ok 3 - threw an exception  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11 - threw an exception  ok 12 - threw an exception	0.07s	100.0%
website/db/tests/test-120-email-activation-token-used-validating-ip.sql	1..112  ok 1 - threw an exception  ok 2 - threw an exception  ok 3 - threw an exception  ok 4 - threw an exception  ok 5 - threw an exception  ok 6 - threw an exception  ok 7 - threw an exception  ok 8  ok 9 - threw an exception  ok 10 - threw an exception  ok 11 - threw an exception  ok 12 - threw an exception  ok 13 - threw an exception  ok 14 - threw an exception  ok 15 - threw an exception  ok 16 - threw an exception  ok 17 - threw an exception  ok 18 - threw an exception  ok 19 - threw an exception  ok 20 - threw an exception  ok 21 - threw an exception  ok 22 - threw an exception  ok 23 - threw an exception  ok 24 - threw an exception  ok 25  ok 26 - threw an exception  ok 27 - threw an exception  ok 28 - threw an exception  ok 29 - threw an exception  ok 30 - threw an exception  ok 31 - threw an exception  ok 32 - threw an exception  ok 33 - threw an exception  ok 34 - threw an exception  ok 35 - threw an exception  ok 36 - threw an exception  ok 37  ok 38 - threw an exception  ok 39 - threw an exception  ok 40 - threw an exception  ok 41 - threw an exception  ok 42 - threw an exception  ok 43 - threw an exception  ok 44  ok 45 - threw an exception  ok 46 - threw an exception  ok 47 - threw an exception  ok 48 - threw an exception  ok 49 - threw an exception  ok 50 - threw an exception  ok 51 - threw an exception  ok 52 - threw an exception  ok 53 - threw an exception  ok 54 - threw an exception  ok 55 - threw an exception  ok 56  ok 57 - threw an exception  ok 58 - threw an exception  ok 59 - threw an exception  ok 60 - threw an exception  ok 61 - threw an exception  ok 62 - threw an exception  ok 63 - threw an exception  ok 64 - threw an exception  ok 65 - threw an exception  ok 66 - threw an exception  ok 67 - threw an exception  ok 68 - threw an exception  ok 69 - threw an exception  ok 70 - threw an exception  ok 71 - threw an exception  ok 72  ok 73 - threw an exception  ok 74 - threw an exception  ok 75 - threw an exception  ok 76 - threw an exception  ok 77 - threw an exception  ok 78 - threw an exception  ok 79 - threw an exception  ok 80 - threw an exception  ok 81 - threw an exception  ok 82 - threw an exception  ok 83 - threw an exception  ok 84 - threw an exception  ok 85 - threw an exception  ok 86 - threw an exception  ok 87 - threw an exception  ok 88 - threw an exception  ok 89 - threw an exception  ok 90 - threw an exception  ok 91 - threw an exception  ok 92  ok 93 - threw an exception  ok 94 - threw an exception  ok 95 - threw an exception  ok 96 - threw an exception  ok 97 - threw an exception  ok 98 - threw an exception  ok 99 - threw an exception  ok 100 - threw an exception  ok 101 - threw an exception  ok 102 - threw an exception  ok 103 - threw an exception  ok 104 - threw an exception  ok 105 - threw an exception  ok 106 - threw an exception  ok 107 - threw an exception  ok 108  ok 109 - threw an exception  ok 110 - threw an exception  ok 111 - threw an exception  ok 112 - threw an exception	0.13s	100.0%
website/db/tests/test-121-email-activation-tokens-generated.sql	1..8  ok 1 - token is automatically added  ok 2 - token is automatically added  ok 3 - Token can be manually inserted  ok 4 - Token can be manually inserted  ok 5 - Reset  ok 6 - Reset  ok 7 - Not null  ok 8 - Not null	0.06s	100.0%
website/db/tests/test-122-email-activation-tokens-email.sql	1..11  ok 1 - Email is NULL  ok 2 - Email is hashed  ok 3 - Email is crypted  ok 4 - threw 23502: null value in column "_email_crypt" of relation "gk_email_activation" violates not-null constraint  ok 5 - threw 23502: null value in column "_email_crypt" of relation "gk_email_activation" violates not-null constraint  ok 6  ok 7 - Email stay NULL  ok 8 - Email stay hashed  ok 9 - Email stay crypted  ok 10 - threw _email_hash must not be manually updated  ok 11 - threw _email_crypt must not be manually updated	0.28s	100.0%
website/db/tests/test-123-email-activation-tokens-email-used.sql	1..19  ok 1 - Email is inserted  ok 2 - used=0  ok 3 - An email activation code already exists for this user  ok 4 - used=4  ok 5 - used=0  ok 6 - An email activation code already exists for this user  ok 7 - used=4  ok 8 - used=4  ok 9 - used=0  ok 10  ok 11 - used=4  ok 12 - used=4  ok 13 - used=0  ok 14 - used=1  ok 15 - used=4  ok 16 - used=0  ok 17 - Updating to same user - fight against: tuple to be updated was already modified by an operation triggered by the current comman   ok 18 - used=0  ok 19 - threw Email address already used	0.07s	100.0%
website/db/tests/test-124-email-activation-tokens-previous-email.sql	1..10  ok 1  ok 2 - Previous email is NULL  ok 3 - Previous email is hashed  ok 4 - Previous email is crypted  ok 5  ok 6  ok 7 - Previous email stay hashed  ok 8 - Previous email stay crypted  ok 9 - threw _previous_email_hash must not be manually updated  ok 10 - threw _previous_email_crypt must not be manually updated	0.27s	100.0%
website/db/tests/test-130-mails-token-generate.sql	1..5  ok 1 - token is automatically added  ok 2 - Token can be manually inserted  ok 3 - threw an exception  ok 4 - threw an exception  ok 5 - threw an exception	0.06s	100.0%
website/db/tests/test-140-waypoint_gc.sql	1..2  ok 1 - threw an exception  ok 2	0.12s	100.0%
website/db/tests/test-141-waypoint_gc_manage_position_lat_lon.sql	1..8  ok 1 - latitude is inserted  ok 2 - longitude is inserted  ok 3 - latitude is inserted  ok 4 - latitude is inserted  ok 5 - longitude is inserted  ok 6 - update lat lon compute position  ok 7 - update position compute lat  ok 8 - update position compute lon	0.17s	100.0%
website/db/tests/test-142-waypoint_gc_from_moves.sql	1..6  ok 1 - Waypoint is inserted  ok 2 - latitude is inserted  ok 3 - longitude is inserted  ok 4 - Waypoint is inserted  ok 5 - Waypoint is not updated  ok 6 - Waypoint is inserted	0.19s	100.0%
website/db/tests/test-150-owner-code-token-generate.sql	1..6  ok 1 - token is automatically added  ok 2 - Token can be manually inserted  ok 3  ok 4 - Token can be reseted  ok 5  ok 6 - threw an exception	0.06s	100.0%
website/db/tests/test-151-owner-codes-token-used-validating-ip.sql	1..16  ok 1  ok 2 - threw an exception  ok 3 - threw an exception  ok 4 - threw an exception  ok 5 - threw an exception  ok 6 - threw an exception  ok 7 - threw an exception  ok 8 - threw an exception  ok 9 - threw an exception  ok 10 - threw an exception  ok 11 - threw an exception  ok 12 - threw an exception  ok 13 - threw an exception  ok 14  ok 15 - threw an exception  ok 16	0.07s	100.0%
website/db/tests/test-152-owner-code-only-one-active.sql	1..4  ok 1  ok 2 - threw an exception  ok 3 - threw an exception  ok 4	0.06s	100.0%
website/db/tests/test-160-password-token-generate.sql	1..5  ok 1 - token is automatically added  ok 2 - Token can be manually inserted  ok 3 - threw an exception  ok 4 - threw an exception  ok 5 - threw an exception	0.06s	100.0%
website/db/tests/test-161-password-token-used-validating-ip.sql	1..8  ok 1  ok 2 - threw an exception  ok 3 - threw an exception  ok 4 - threw an exception  ok 5 - threw an exception  ok 6 - threw an exception  ok 7 - threw an exception  ok 8	0.06s	100.0%
website/db/tests/test-171-email-revalidate-generate.sql	1..5  ok 1 - token is automatically added  ok 2 - Token can be manually inserted  ok 3  ok 4  ok 5 - threw an exception	0.06s	100.0%
website/db/tests/test-172-email-revalidate-hash.sql	1..4  ok 1 - _email is back to null  ok 2 - email is hashed  ok 3 - email is crypted  ok 4 - email has hash	0.06s	100.0%
website/db/tests/test-173-email-revalidate-only-one-active.sql	1..32  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17 - threw an exception  ok 18 - threw an exception  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26  ok 27  ok 28  ok 29  ok 30  ok 31  ok 32	0.08s	100.0%
website/db/tests/test-180-script-ack.sql	1..11  ok 1 - threw an exception  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11	0.05s	100.0%
website/db/tests/test-20-functions.sql	1..86  ok 1 - Check valid_move_types()  ok 2 - Check move_counting_kilometers()  ok 3 - Check move_requiring_coordinates()  ok 4 - Check valid_moves_comments_types()  ok 5 - Check moves_types_markable_as_missing()  ok 6 - Check moves_type_last_position()  ok 7 - Check moves_type_hold()  ok 8 - Check validate_email_revalidate_used()  ok 9 - Check validate_move_types(0)  ok 10 - Check validate_move_types(1)  ok 11 - Check validate_move_types(2)  ok 12 - Check validate_move_types(3)  ok 13 - Check validate_move_types(4)  ok 14 - Check validate_move_types(5)  ok 15 - Check validate_move_types(6)  ok 16 - Check validate_move_types(-1)  ok 17  ok 18 - threw an exception  ok 19 - Type 0 is counting KM  ok 20 - Type 1 is NOT counting KM  ok 21 - Type 2 is NOT counting KM  ok 22 - Type 3 is counting KM  ok 23 - Type 4 is NOT counting KM  ok 24 - Type 5 is counting KM  ok 25 - Check validate_moves_comments_type(0)  ok 26 - Check validate_moves_comments_type(1)  ok 27 - Check validate_moves_comments_type(2)  ok 28 - Check moves_type_waypoint(NULL)  ok 29 - Check moves_type_waypoint(NULL)  ok 30 - Check moves_type_waypoint(NULL)  ok 31 - Check moves_type_waypoint(NULL)  ok 32 - Check moves_type_waypoint(NULL)  ok 33 - Check moves_type_waypoint(NULL)  ok 34 - Check moves_type_waypoint(GC5BRQK)  ok 35 - threw an exception  ok 36 - threw an exception  ok 37 - Check moves_type_waypoint(GC5BRQK)  ok 38 - threw an exception  ok 39 - Check moves_type_waypoint(GC5BRQK)  ok 40  ok 41 - threw an exception  ok 42 - threw an exception  ok 43  ok 44 - threw an exception  ok 45  ok 46 - Check moves_check_author_username(1, NULL)  ok 47 - Check moves_check_author_username(1, EMPTY)  ok 48 - Check moves_check_author_username(1, user)  ok 49 - Check moves_check_author_username(NULL, NULL)  ok 50 - Check moves_check_author_username(NULL, EMPTY)  ok 51 - Check moves_check_author_username(1, user)  ok 52 - Check conversion coordinates to position  ok 53 - Check conversion position to coordinates  ok 54 - Secret id size  ok 55 - Secret id size  ok 56  ok 57  ok 58  ok 59  ok 60  ok 61  ok 62  ok 63  ok 64  ok 65  ok 66  ok 67  ok 68  ok 69  ok 70  ok 71  ok 72  ok 73  ok 74  ok 75  ok 76  ok 77  ok 78  ok 79  ok 80  ok 81  ok 82  ok 83  ok 84  ok 85  ok 86 - Older than 100 years	0.08s	100.0%
website/db/tests/test-200-audit-schema.sql	1..9  ok 1 - Schema audit should exist  ok 2 - Table audit.actions_logs should exist  ok 3 - Table audit.posts should exist  ok 4 - Schema audit should have the correct tables  ok 5  ok 6  ok 7  ok 8  ok 9	0.05s	100.0%
website/db/tests/test-21-stats-update.sql	1..49  ok 1 - Stat empty at begining  ok 2 - User added  ok 3 - User added  ok 4 - User added  ok 5 - User added  ok 6 - GeoKrety count  ok 7 - GeoKrety count  ok 8 - GeoKrety count  ok 9 - GeoKrety count  ok 10 - Moves count  ok 11 - Moves distance  ok 12 - Moves average  ok 13 - Moves median  ok 14 - Moves count  ok 15 - Moves distance  ok 16 - Moves average  ok 17 - Moves median  ok 18 - Moves count  ok 19 - Moves distance  ok 20 - Moves average  ok 21 - Moves median  ok 22 - Moves count  ok 23 - Moves distance  ok 24 - Moves average  ok 25 - Moves median  ok 26 - Moves count  ok 27 - Moves distance  ok 28 - Moves average  ok 29 - Moves median  ok 30 - Moves distance  ok 31 - Moves distance  ok 32 - Moves average  ok 33 - Moves median  ok 34 - Moves distance  ok 35 - Moves distance  ok 36 - Moves distance  ok 37 - Moves distance  ok 38 - Moves distance  ok 39 - Moves distance  ok 40 - Moves distance  ok 41 - Moves distance  ok 42 - Moves distance  ok 43 - Moves distance  ok 44 - GeoKrety in caches  ok 45 - GeoKrety in caches  ok 46 - Moves distance  ok 47 - distance equator  ok 48 - distance moon  ok 49 - distance sun	0.30s	100.0%
website/db/tests/test-210-previous_failed_logins.sql	1..23  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23	0.06s	100.0%
website/db/tests/test-22-sessions.sql	ok 1  1..1	0.04s	100.0%
website/db/tests/test-30-moves-author-username.sql	1..6  ok 1  ok 2 - threw 23514: new row for relation "gk_moves" violates check constraint "check_author_username"  ok 3 - threw 23514: new row for relation "gk_moves" violates check constraint "check_author_username"  ok 4 - threw 23514: new row for relation "gk_moves" violates check constraint "check_author_username"  ok 5 - threw 23514: new row for relation "gk_moves" violates check constraint "check_author_username"  ok 6	0.07s	100.0%
website/db/tests/test-30-moves-moved-on-datetime.sql	1..29  ok 1 - born_on_datetime is set to created_on_datetime on create  ok 2 - created_on_datetime can be overridden  ok 3 - born_on_datetime is set to created_on_datetime on create  ok 4 - threw an exception  ok 5 - threw an exception  ok 6  ok 7 - threw an exception  ok 8  ok 9  ok 10 - move in the right range  ok 11  ok 12 - threw an exception  ok 13  ok 14 - threw an exception  ok 15  ok 16 - threw an exception  ok 17  ok 18  ok 19 - threw an exception  ok 20  ok 21  ok 22 - threw an exception  ok 23  ok 24  ok 25 - threw an exception  ok 26  ok 27  ok 28  ok 29	0.10s	100.0%
website/db/tests/test-30-moves-waypoint.sql	1..12  ok 1 - may be null  ok 2 - may be null  ok 3  ok 4 - threw an exception  ok 5 - threw an exception  ok 6  ok 7 - threw an exception  ok 8  ok 9  ok 10 - will be saved uppercase  ok 11  ok 12	0.20s	100.0%
website/db/tests/test-30-moves_country.sql	1..9  ok 1 - nice country  ok 2 - paris country  ok 3 - berlin country  ok 4 - warsaw country  ok 5 - moscow country  ok 6 - tokyo country  ok 7 - paris country  ok 8 - berlin country  ok 9 - comments has no country	0.22s	100.0%
website/db/tests/test-30-moves_elevation.sql	1..9  ok 1 - nice elevation  ok 2 - paris elevation  ok 3 - berlin elevation  ok 4 - warsaw elevation  ok 5 - moscow elevation  ok 6 - tokyo elevation  ok 7 - paris elevation  ok 8 - berlin elevation  ok 9 - comments has no elevation	0.22s	100.0%
website/db/tests/test-30-moves_type.sql	1..88  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20 - threw an exception  ok 21 - threw an exception  ok 22 - threw an exception  ok 23 - threw an exception  ok 24 - threw an exception  ok 25 - threw an exception  ok 26  ok 27 - threw an exception  ok 28  ok 29  ok 30  ok 31  ok 32  ok 33  ok 34  ok 35  ok 36  ok 37  ok 38  ok 39  ok 40  ok 41  ok 42  ok 43  ok 44  ok 45  ok 46  ok 47  ok 48  ok 49  ok 50  ok 51  ok 52  ok 53  ok 54  ok 55  ok 56 - threw an exception  ok 57 - threw an exception  ok 58 - threw an exception  ok 59 - threw an exception  ok 60 - threw an exception  ok 61 - threw an exception  ok 62  ok 63 - threw an exception  ok 64  ok 65  ok 66  ok 67  ok 68  ok 69  ok 70  ok 71  ok 72  ok 73  ok 74  ok 75  ok 76  ok 77  ok 78 - threw an exception  ok 79 - threw an exception  ok 80 - threw an exception  ok 81 - threw an exception  ok 82 - threw an exception  ok 83 - threw an exception  ok 84  ok 85 - threw an exception  ok 86  ok 87  ok 88	0.45s	100.0%
website/db/tests/test-30-moves_update_moved_on_datetime.sql	ok 1 - manual set  ok 2 - automatic set  1..2	0.07s	100.0%
website/db/tests/test-30-moves_update_position.sql	1..4  ok 1 - Seed a GeoKret  ok 2 - Position is automatically synced  ok 3 - Lat/Lon are automatically synced  ok 4 - Position is automatically updated	0.16s	100.0%
website/db/tests/test-300-awards.sql	1..9  ok 1 - Basic award assignment should work  ok 2 - Should prevent duplicate awards to same user  ok 3 - Same award can be given to different users  ok 4 - Different awards can be given to same user  ok 5 - User 1 can get Hidden GeoKrety Finder award  ok 6 - User 2 can get Hidden GeoKrety Finder award  ok 7 - User 3 can get Hidden GeoKrety Finder award  ok 8 - Should prevent duplicate Hidden GeoKrety Finder awards to same user  ok 9 - Hidden GeoKrety Finder award exists in database	0.07s	100.0%
website/db/tests/test-31-moves-find-page.sql	ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  1..6	0.09s	100.0%
website/db/tests/test-32-moves_archive.sql	1..12  ok 1 - threw an exception  ok 2 - threw an exception  ok 3  ok 4 - threw an exception  ok 5 - threw an exception  ok 6 - threw an exception  ok 7  ok 8 - threw an exception  ok 9  ok 10  ok 11  ok 12 - threw an exception	0.08s	100.0%
website/db/tests/test-33-move-delete.sql	1..5  ok 1  ok 2  ok 3  ok 4  ok 5	0.08s	100.0%
website/db/tests/test-40-functions-update-next-move-distance_on_insert.sql	1..28  ok 1  ok 2 - GK distance is 0  ok 3  ok 4 - first move has 0 km  ok 5  ok 6 - Nice/Paris  ok 7  ok 8 - Paris/Berlin  ok 9  ok 10 - Berlin/Warsaw  ok 11  ok 12 - Warsaw/Moscow  ok 13  ok 14 - Moscow/Tokyo  ok 15  ok 16 - Tokyo/Canberra  ok 17  ok 18 - Canberra/Cape Town  ok 19  ok 20 - Cape Town/Ushuaia  ok 21  ok 22 - Ushuaia/Panama  ok 23  ok 24 - Panama/Los Angeles  ok 25  ok 26 - Los Angeles/Vancouver  ok 27  ok 28 - Vancouver/Pula	0.25s	100.0%
website/db/tests/test-41-functions-update-next-move-distance_on_update.sql	1..9  ok 1 - Moscow/Pula  ok 2 - Moscow/Tokyo  ok 3 - Moscow/Pula  ok 4 - first move has 0 km  ok 5 - Nice/Paris  ok 6 - Paris/Pula  ok 7 - Pula/Berlin  ok 8 - Berlin/Warsaw  ok 9 - Warsaw/Moscow	0.22s	100.0%
website/db/tests/test-42-functions-update-next-move-distance_on_move_type.sql	1..3  ok 1 - first move has 0 km  ok 2 - No distance count for comments  ok 3 - Nice/Berlin	0.16s	100.0%
website/db/tests/test-43-functions-update-next-move-distance_on_gk_changed.sql	1..12  ok 1 - first move has 0 km  ok 2 - first move has 0 km  ok 3 - Nice/Berlin  ok 4 - Berlin/Warsaw  ok 5 - Warsaw/Moscow  ok 6 - Moscow/Tokyo  ok 7 - first move has 0 km  ok 8 - Paris/Warsaw  ok 9 - Warsaw/Moscow  ok 10 - first move has 0 km  ok 11 - Nice/Berlin  ok 12 - Berlin/Tokyo	0.21s	100.0%
website/db/tests/test-50-geokret-tracking-code.sql	1..33  ok 1 - Automatic add tracking_code  ok 2 - Code can be manually inserted  ok 3 - Code can be manually updated  ok 4 - Set to NULL to generate a new one - 1  ok 5 - Set to NULL to generate a new one - 2  ok 6 - Tracking code is unmodified  ok 7  ok 8 - threw 23505: duplicate key value violates unique constraint "idx_geokrety_tracking_code"  ok 9 - Tracking code will be saved uppercase  ok 10 - threw an exception  ok 11 - threw an exception  ok 12 - threw an exception  ok 13 - threw an exception  ok 14 - threw an exception  ok 15 - threw an exception  ok 16 - threw an exception  ok 17 - threw an exception  ok 18 - threw an exception  ok 19 - threw an exception  ok 20 - threw an exception  ok 21 - threw an exception  ok 22 - threw an exception  ok 23 - threw an exception  ok 24 - threw an exception  ok 25 - threw an exception  ok 26 - threw an exception  ok 27 - threw an exception  ok 28 - threw an exception  ok 29 - threw an exception  ok 30 - threw an exception  ok 31 - threw an exception  ok 32 - threw an exception  ok 33 - threw an exception	0.06s	100.0%
website/db/tests/test-51-geokret-gkid.sql	1..3  ok 1 - Automatic gkid 1  ok 2 - gkid set manually  ok 3 - numbering continues	0.05s	100.0%
website/db/tests/test-52-geokret-count-distance.sql	1..13  ok 1 - Never moved  ok 2 - first move has 0 km  ok 3 - Nice/Paris  ok 4 - Nice/Paris/Berlin  ok 5 - Nice/Paris/Berlin/Warsaw  ok 6 - Nice/Paris/Berlin/Warsaw/Moscow  ok 7 - Nice/Paris/Berlin/Warsaw/Moscow/Tokyo  ok 8 - Nice/Paris/Berlin/Warsaw/Moscow  ok 9 - Nice/Paris/Berlin/Warsaw/Moscow/Tokyo  ok 10 - Nice/Paris/Berlin/Warsaw/Tokyo  ok 11 - Nice/Paris/Berlin/Warsaw  ok 12 - second GK first move  ok 13 - Never moved	0.22s	100.0%
website/db/tests/test-52-geokret-count-places.sql	1..13  ok 1 - Never moved  ok 2 - move-type 0  ok 3 - move-type 1  ok 4 - move-type 2  ok 5 - move-type 3  ok 6 - move-type 4  ok 7 - move-type 5  ok 8 - Multiple but same place  ok 9 - v  ok 10 - Multiple  ok 11 - Update - 0  ok 12 - Update - 1  ok 13 - Update - 2	0.30s	100.0%
website/db/tests/test-52-geokret-type.sql	1..26  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26 - threw an exception	0.09s	100.0%
website/db/tests/test-53-geokret-holder.sql	1..21  ok 1 - On create holder is owner  ok 2 - On create holder is owner  ok 3 - On create holder is owner  ok 4 - On create holder is owner  ok 5 - holder can not be overridden  ok 6 - holder can not be overridden  ok 7 - holder can not be overridden  ok 8 - holder can not be overridden  ok 9 - reset holder  ok 10  ok 11 - reset holder  ok 12  ok 13 - reset holder  ok 14 - holder from last position - drop  ok 15 - holder from last position - grab  ok 16 - holder from last position - seen (from cache)  ok 17 - holder from last position - seen (from hands)  ok 18 - holder from last position - seen (from hands)  ok 19 - holder from last position - comment  ok 20 - holder from last position - archive  ok 21 - holder from last position - dip	0.25s	100.0%
website/db/tests/test-54-collectible.sql	1..130  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7 - Is null by default  ok 8  ok 9 - Can be updated  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26  ok 27  ok 28  ok 29  ok 30  ok 31  ok 32  ok 33  ok 34  ok 35  ok 36 - threw an exception  ok 37  ok 38  ok 39  ok 40  ok 41  ok 42  ok 43  ok 44 - threw an exception  ok 45  ok 46  ok 47  ok 48  ok 49  ok 50  ok 51  ok 52 - threw an exception  ok 53  ok 54  ok 55  ok 56  ok 57 - threw an exception  ok 58  ok 59  ok 60  ok 61  ok 62 - threw an exception  ok 63  ok 64  ok 65  ok 66  ok 67 - threw an exception  ok 68  ok 69  ok 70  ok 71  ok 72  ok 73  ok 74  ok 75  ok 76  ok 77  ok 78  ok 79  ok 80  ok 81  ok 82  ok 83  ok 84  ok 85  ok 86 - threw an exception  ok 87  ok 88  ok 89  ok 90  ok 91  ok 92  ok 93  ok 94  ok 95  ok 96  ok 97  ok 98 - threw an exception  ok 99  ok 100  ok 101  ok 102  ok 103  ok 104  ok 105  ok 106  ok 107  ok 108  ok 109  ok 110  ok 111  ok 112  ok 113  ok 114  ok 115  ok 116 - threw an exception  ok 117  ok 118  ok 119  ok 120  ok 121  ok 122  ok 123  ok 124  ok 125 - threw an exception  ok 126  ok 127  ok 128  ok 129  ok 130 - threw an exception	0.37s	100.0%
website/db/tests/test-55-parked.sql	ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7 - Is null by default  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26  ok 27  1..27	0.08s	100.0%
website/db/tests/test-60-picture.sql	ok 1  ok 2  ok 3  ok 4 - threw 22000: One of Geokret (<NULL>), Move (<NULL>) or User (<NULL>) must be specified  ok 5 - threw an exception  ok 6 - threw an exception  ok 7 - threw an exception  ok 8 - threw an exception  ok 9 - threw an exception  ok 10 - threw an exception  ok 11  ok 12 - threw an exception  ok 13  ok 14 - threw an exception  ok 15  ok 16  ok 17 - threw an exception  ok 18 - threw an exception  ok 19 - threw 22000: Picture `type` does not match the specified arguments.  ok 20 - threw 22000: Picture type unrecognized (6)  1..20	0.14s	100.0%
website/db/tests/test-61-picture-geokret.sql	1..12  ok 1 - uploaded_date is necessary for counting  ok 2 - uploaded_date counting  ok 3 - uploaded_date back to 0  ok 4 - Pictures count is incremented 1  ok 5 - Pictures count is incremented 2  ok 6 - Pictures count is decremented  ok 7 - No pictures left  ok 8 - GK2 has now 1 picture  ok 9 - GK2 has no pictures left  ok 10  ok 11  ok 12	0.14s	100.0%
website/db/tests/test-61-picture-move.sql	1..9  ok 1 - uploaded_date is necessary for counting  ok 2 - uploaded_date counting  ok 3 - uploaded_date back to 0  ok 4 - Pictures count is incremented 1  ok 5 - Pictures count is incremented 2  ok 6 - Pictures count is decremented  ok 7 - pictures count is now on move 2  ok 8 - move 1 has now move now  ok 9 - Move 2 has no pictures left	0.16s	100.0%
website/db/tests/test-61-picture-user.sql	1..12  ok 1 - uploaded_date is necessary for counting  ok 2 - uploaded_date counting  ok 3 - uploaded_date back to 0  ok 4 - Pictures count is incremented 1  ok 5 - Pictures count is incremented 2  ok 6 - Pictures count is decremented  ok 7 - No pictures left  ok 8 - User 2 has now 1 picture  ok 9 - User 2 has no pictures left  ok 10  ok 11  ok 12	0.07s	100.0%
website/db/tests/test-62-picture-type-updater.sql	1..3  ok 1 - uploaded_date is necessary for counting  ok 2 - uploaded_date counting  ok 3 - uploaded_date back to 0	0.13s	100.0%
website/db/tests/test-63-picture-move-type-require-also-geokret.sql	1..7  ok 1  ok 2 - geokret is set automatically  ok 3  ok 4 - geokret cannot be overridden  ok 5 - no geokret for user pictures  ok 6 - geokret is set automatically  ok 7 - geokret must be updated	0.15s	100.0%
website/db/tests/test-70-username-unique.sql	ok 1 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 2 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 3 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 4 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 5 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 6 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 7 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 8 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 9 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 10 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 11 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 12 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 13 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 14 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 15 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 16 - threw 23505: duplicate key value violates unique constraint "gk_users_username_email_uniq"  ok 17  ok 18  ok 19 - threw 23505: duplicate key value violates unique constraint "gk_users_username_uniq"  ok 20  1..20	0.07s	100.0%
website/db/tests/test-71-user-secid.sql	1..19  ok 1 - Automatic add hash  ok 2 - Automatic add crypt  ok 3 - Code can be manually inserted - hash  ok 4 - Code can be manually inserted - crypt  ok 5 - threw 23505: duplicate key value violates unique constraint "gk_users_secid_uniq"  ok 6 - Set to NULL to generate a new one - 0  ok 7 - Set to NULL to generate a new one - 1  ok 8 - Set to NULL to generate a new one - 2  ok 9 - Set to NULL to generate a new one - 3  ok 10 - Set to NULL to generate a new one - 4  ok 11 - Set to NULL to generate a new one - 0  ok 12 - Set to NULL to generate a new one - 1  ok 13 - Set to NULL to generate a new one - 2  ok 14 - Set to NULL to generate a new one - 3  ok 15 - Set to NULL to generate a new one - 4  ok 16 - Secid is unmodified - hash  ok 17 - Secid is unmodified - crypt  ok 18 - threw _secid_hash must not be manually updated  ok 19 - threw _secid_crypt must not be manually updated	0.49s	100.0%
website/db/tests/test-72-user-account-valid.sql	1..6  ok 1  ok 2  ok 3  ok 4 - threw an exception  ok 5 - threw an exception  ok 6 - threw an exception	0.06s	100.0%
website/db/tests/test-73-user-email-valid.sql	1..8  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7 - threw an exception  ok 8 - threw an exception	0.06s	100.0%
website/db/tests/test-74-user-username-history.sql	1..7  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7	0.06s	100.0%
website/db/tests/test-75-user-delete.sql	ok 1  ok 2  ok 3  ok 4  ok 5  ok 6  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26  ok 27  ok 28  ok 29  ok 30  ok 31  ok 32  1..32	0.17s	100.0%
website/db/tests/test-75-user-position.sql	1..48  ok 1  ok 2  ok 3  ok 4  ok 5  ok 6 - Position is automatically synced  ok 7  ok 8  ok 9  ok 10  ok 11  ok 12 - Position is automatically synced  ok 13  ok 14  ok 15  ok 16  ok 17  ok 18  ok 19  ok 20  ok 21  ok 22  ok 23  ok 24  ok 25  ok 26  ok 27  ok 28  ok 29  ok 30  ok 31  ok 32  ok 33  ok 34  ok 35  ok 36  ok 37  ok 38  ok 39  ok 40  ok 41  ok 42  ok 43  ok 44  ok 45  ok 46  ok 47  ok 48	0.13s	100.0%
website/db/tests/test-76-user-email.sql	1..13  ok 1  ok 2  ok 3 - Automatic add crypt  ok 4  ok 5  ok 6 - Automatic add crypt  ok 7  ok 8  ok 9  ok 10  ok 11 - Automatic add crypt  ok 12 - threw _email_hash must not be manually updated  ok 13 - threw _email_crypt must not be manually updated	0.06s	100.0%
website/db/tests/test-80-moves-comments.sql	ok 1 - comments_count incremented - 1  ok 2 - comments_count incremented - 2  ok 3 - update - comments_count decremented  ok 4 - update - comments_count incremented - 1  ok 5 - update - comments_count untouched  ok 6 - delete move comments - 1  ok 7 - delete move comments - 2  ok 8 - geokret cannot be overridden - 1  ok 9 - geokret cannot be overridden - 2  ok 10 - geokret cannot be overridden - 3  ok 11 - geokret is automatically managed  ok 12 - delete move deletes moves comments  1..12	0.21s	100.0%
website/db/tests/test-81-moves-comments-missing.sql	1..24  ok 1 - GeoKret marked as missing  ok 2 - GeoKret is not missing anymore  ok 3 - GeoKret is now missing again  ok 4 - GeoKret marked as missing - delete  ok 5 - GeoKret marked as missing - insert  ok 6  ok 7  ok 8  ok 9 - threw an exception  ok 10 - threw an exception  ok 11  ok 12 - adding new move reset missing - dropped  ok 13 - adding new move reset missing - grabbed  ok 14 - adding new move reset missing - comment  ok 15 - adding new move reset missing - seen  ok 16 - adding new move reset missing - archived  ok 17 - adding new move reset missing - dipped  ok 18 - moving move reset missing  ok 19 - delete move re-set missing  ok 20 - threw an exception  ok 21 - threw an exception  ok 22  ok 23 - delete move which has `missing` also remove the missing status  ok 24 - delete move which has `missing` does not remove missing status if next move has a missing comment	0.33s	100.0%
website/db/tests/test-90-news-comments.sql	1..9  ok 1 - comments_count incremented  ok 2 - comments_count untouched  ok 3 - comments_count decremented  ok 4 - comments_count incremented on the other news  ok 5 - we have 2 comments  ok 6 - comments_count decremented on delete  ok 7 - delete news deletes news comments  ok 8  ok 9 - news comments cannot be overridden	0.06s	100.0%

Generated by TAP::Formatter::HTML v0.13 @ 2025-10-07 18:17:28