|
Logs: Trace: #1 /home/brent/myboatjourney.com/25-login.php:743 - printLogs() 12:07:10 logs deleted 05:07:10 Maintenance mode is false: No action required 05:07:10 URI: /my-boat-journey.php 05:07:10 Requests: 05:07:10 encUserName=brentbilger 05:07:10 get an array of the columns of the table 'journey_destination' that are not in the table 'destination' 05:07:10 querydb: SELECT column_name FROM information_schema.columns WHERE table_schema='brent_my-boat-journey' AND table_name='destination' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 64 05:07:10 querydb: SELECT column_name FROM information_schema.columns WHERE table_schema='brent_my-boat-journey' AND table_name='journey_destination' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 33 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SHOW COLUMNS FROM journey_destination 05:07:10 Query succeeded 05:07:10 Number of rows returned: 33 05:07:10 Returning 33 rows 05:07:10 aJourneyDestColNotInDest: u_rownum, u_seqnum, user_name, journey_name, highlight, force_visit, en_route, reserved, alt_start, add_time, slip_number, slip_type, slip_side_to, slip_end_to, slip_dock_type, engine_hour, genset_hour, fuel_indicated_pre_filling, fill_up, fuel_added, fuel_indicated_post_filling, fuel_remaining, engine_oil_changed, genset_oil_changed, zinc_changed 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM boat WHERE user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 6 05:07:10 Returning 6 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM journey_detail ORDER BY journey_name 05:07:10 Query succeeded 05:07:10 Number of rows returned: 14 05:07:10 Returning 14 rows 05:07:10 getUsersDevice() 05:07:10 '{"rownum":"1508","user_name":"brentbilger","user_type":"admin","device_id":"d128fddacb0cf244","device_type":"","device_last_login":"2026-07-16","map_today_forward":"no","map_visited":"yes","map_marinas_not_visited":"no","map_anchorages_not_visited":"yes","map_differentiate_marinas_with_fuel":"no","map_dont_cluster_destinations":"no","map_critical_locks":"no","map_locks":"no","map_critical_bridges":"no","map_bridges":"no","map_poi":"yes","map_alt_route":"no","triangle_journey":"0","triangle_view_on_map":"90","triangle_boat":"0","triangle_route":"90","triangle_from":"0","triangle_to":"0","triangle_help":"0","triangle_row_filter":"90","triangle_col_filter":"90","triangle_col_edit":"90","last_tab_displayed":"winItinerary","edit_amenities":"no","edit_capt_john":"no","edit_destination":"no","edit_distance":"yes","edit_fuel":"no","edit_lat_long":"no","edit_lock_lift":"no","edit_log":"no","edit_mile_marker":"no","edit_must_see":"no","edit_navionics":"no","edit_regions":"no","edit_town_state":"no","edit_website":"no"}' 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM col_filter_option 05:07:10 Query succeeded 05:07:10 Number of rows returned: 31 05:07:10 Returning 31 rows 05:07:10 doesRecordExit(...) 05:07:10 querydb: SELECT * FROM col_option_user WHERE user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 1 05:07:10 # rows returned = 1 05:07:10 true 05:07:10 getOneRowAssociativeArrayFromDB(...) 05:07:10 querydb: SELECT * FROM col_option_user WHERE user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 1 05:07:10 Success one row returned 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT rownum, seqnum, town, state, town_state, boat_to, direction, boat_to_type, speed_limit, no_wake, bridge_id, bridge_type, vert_cl, horz_cl, vert_open, lat, lon, route_option_tag, tag_ro, tag_mile, tag_offset, tag_dir, tag_point, phone, vhf, poi_category, poi_text, poi_keep_private, zip_code, gas, diesel, visit, nights, recommended FROM destination WHERE (validated='yes' OR boat_to_type='lock' OR boat_to_type='bridge' OR (boat_to_type='point_of_interest' AND (poi_keep_private='no' OR poi_creator='brentbilger'))) 05:07:10 Query succeeded 05:07:10 Number of rows returned: 2665 05:07:10 Returning 2665 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT rownum, seqnum, town, state, town_state, boat_to, direction, boat_to_type, speed_limit, no_wake, bridge_id, bridge_type, vert_cl, horz_cl, vert_open, lat, lon, route_option_tag, tag_ro, tag_mile, tag_offset, tag_dir, tag_point, phone, vhf, poi_category, poi_text, poi_keep_private, zip_code, gas, diesel, visit, nights, recommended, user_name FROM user_destination 05:07:10 Query succeeded 05:07:10 Number of rows returned: 127 05:07:10 Returning 127 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM journey_from WHERE user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 3 05:07:10 Returning 3 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM journey_destination WHERE user_name='brentbilger' ORDER BY u_rownum 05:07:10 Query succeeded 05:07:10 Number of rows returned: 59 05:07:10 Returning 59 rows 05:07:10 getArrayFromDB(...) 05:07:10 querydb: SELECT DISTINCT journey_name FROM journey_detail ORDER BY journey_name 05:07:10 Query succeeded 05:07:10 Number of rows returned: 14 05:07:10 Returning 14 rows 05:07:10 getOneRowAssociativeArrayFromDB(...) 05:07:10 querydb: SELECT * FROM row_filter_user WHERE user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 1 05:07:10 Success one row returned 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM town_dist WHERE user_name='brentbilger' OR user_name='brentbilger' 05:07:10 Query succeeded 05:07:10 Number of rows returned: 183 05:07:10 Returning 183 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT rownum, route_option, miles, points_array, max_lat, min_lat, max_lng, min_lng, num_connected, last_pt_connect, backtrackable FROM route_segment 05:07:10 Query succeeded 05:07:10 Number of rows returned: 517 05:07:10 Returning 517 rows 05:07:10 getArrayOfAssociativeArraysFromDB(...) 05:07:10 querydb: SELECT * FROM route_segment 05:07:11 Query succeeded 05:07:11 Number of rows returned: 517 05:07:11 Returning 517 rows 05:07:11 getArrayOfAssociativeArraysFromDB(...) 05:07:11 querydb: SELECT * FROM jr_master 05:07:11 Query succeeded 05:07:11 Number of rows returned: 846 05:07:11 Returning 846 rows 05:07:11 getArrayOfAssociativeArraysFromDB(...) 05:07:11 querydb: SELECT * FROM jr_user WHERE user_name='brentbilger' 05:07:11 Query succeeded 05:07:11 Number of rows returned: 446 05:07:11 Returning 446 rows 05:07:11 44-per-user-const.php 05:07:11 _SERVER['HTTP_HOST']=.myboatjourney.com 05:07:11 prettyPrintFromSql(M j, Y, 2026-06-24) returning Jun 24, 2026 05:07:11 prettyPrintFromSql(M j, Y, 2026-06-24) returning Jun 24, 2026 05:07:11 getArrayOfAssociativeArraysFromDB(...) 05:07:11 querydb: SELECT * FROM col_filter_option 05:07:11 Query succeeded 05:07:11 Number of rows returned: 31 05:07:11 Returning 31 rows 05:07:11 getNumberOfRows(...) 05:07:11 querydb: SELECT * FROM col_option_user WHERE user_name='brentbilger' LIMIT 1 05:07:11 Query succeeded 05:07:11 Number of rows returned: 1 05:07:11 Query returned 1 results 05:07:11 getOneRowAssociativeArrayFromDB(...) 05:07:11 querydb: SELECT * FROM col_option_user WHERE user_name='brentbilger' LIMIT 1 05:07:11 Query succeeded 05:07:11 Number of rows returned: 1 05:07:11 Success one row returned 05:07:11 getArrayOfAssociativeArraysFromDB(...) 05:07:11 querydb: SHOW COLUMNS FROM destination 05:07:11 Query succeeded 05:07:11 Number of rows returned: 64 05:07:11 Returning 64 rows 05:07:11 getValueFromDB(...) 05:07:11 querydb: SELECT friend_id FROM user WHERE user_name='brentbilger' LIMIT 1 05:07:11 Query succeeded 05:07:11 Number of rows returned: 1 05:07:11 sValue from db = 'friendId12345678' 05:07:11 _SESSION['Device']['last_tab_displayed']=winItinerary 12:07:11 sProgram=49-myboatjourney-api.php 05:07:11 Maintenance mode is false: No action required 05:07:11 querydb: SELECT table_name FROM information_schema.tables WHERE table_schema='brent_my-boat-journey' 05:07:11 Query succeeded 05:07:11 Number of rows returned: 45 05:07:11 Tables in the database: 'api_request_history', 'app_migration', 'boat', 'boat_copy', 'boat_route', 'bridge', 'captcha', 'col_edit_option', 'col_filter_option', 'col_option_user', 'col_option_user_copy', 'd', 'dest_display_option', 'destination', 'destination_copy', 'device', 'fuel_gauge', 'journey', 'journey_destination', 'journey_destination_copy', 'journey_detail', 'journey_from', 'journey_from_copy', 'journey_route', 'journey_route_master', 'journey_route_user', 'journey_route_user_copy', 'jr_master', 'jr_user', 'name_to_url', 'pacific', 'route_option_alias', 'route_segment', 'route_segment_setting', 'row_filter_user', 'row_filter_user_copy', 'signup', 'speed_limit', 'test', 'town_dist', 'town_dist_copy', 'town_no_wake', 'user', 'user_copy', 'user_destination' 05:07:11 Found a user Id, checking it 05:07:11 getOneRowAssociativeArrayFromDB(...) 05:07:11 querydb: SELECT * FROM user WHERE user_id='123456' AND user_name='brentbilger' 05:07:11 Query succeeded 05:07:11 Number of rows returned: 1 05:07:11 Success one row returned 05:07:11 querydb: INSERT INTO api_request_history (occurred_at, user_name, user_id, friend_id, user_type, action, request_uri, ip_address, user_agent, note) VALUES ('2026-07-16 17:07:11', 'brentbilger', '123456', '', 'admin', 'updateJourneyFromOption', '/49-myboatjourney-api.php?ajax=yes&sUserId=123456&encUserName=brentbilger&action=updateJourneyFromOption&option=starting_fuel&value=350', '170.203.205.178', 'Mozilla/5.0 (iPhone; CPU iPhone OS 26_5_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/149.0.7827.45 Mobile/15E148 Safari/604.1', 'authorized_api_invocation') 05:07:11 Query succeeded 05:07:11 Affected rows: 1 05:07:11 Executing API: sAction=updateJourneyFromOption 05:07:11 encUserName=brentbilger, sUserId=123456, sUserType=admin 05:07:11 querydb: UPDATE journey_from SET starting_fuel='350' WHERE user_name='brentbilger' AND last_one_selected='yes' 05:07:11 Query succeeded 05:07:11 No rows affected 05:07:11 sendJsonResponse raw data: Array ( [status] => success [message] => success: updated table 'journey_from' row 'starting_fuel' to '350' [data] => Array ( ) ) 05:07:11 json_encode did not fail 12:07:14 sProgram=49-myboatjourney-api.php 05:07:14 Maintenance mode is false: No action required 05:07:14 querydb: SELECT table_name FROM information_schema.tables WHERE table_schema='brent_my-boat-journey' 05:07:14 Query succeeded 05:07:14 Number of rows returned: 45 05:07:14 Tables in the database: 'api_request_history', 'app_migration', 'boat', 'boat_copy', 'boat_route', 'bridge', 'captcha', 'col_edit_option', 'col_filter_option', 'col_option_user', 'col_option_user_copy', 'd', 'dest_display_option', 'destination', 'destination_copy', 'device', 'fuel_gauge', 'journey', 'journey_destination', 'journey_destination_copy', 'journey_detail', 'journey_from', 'journey_from_copy', 'journey_route', 'journey_route_master', 'journey_route_user', 'journey_route_user_copy', 'jr_master', 'jr_user', 'name_to_url', 'pacific', 'route_option_alias', 'route_segment', 'route_segment_setting', 'row_filter_user', 'row_filter_user_copy', 'signup', 'speed_limit', 'test', 'town_dist', 'town_dist_copy', 'town_no_wake', 'user', 'user_copy', 'user_destination' 05:07:14 Found a user Id, checking it 05:07:14 getOneRowAssociativeArrayFromDB(...) 05:07:14 querydb: SELECT * FROM user WHERE user_id='123456' AND user_name='brentbilger' 05:07:14 Query succeeded 05:07:14 Number of rows returned: 1 05:07:14 Success one row returned 05:07:14 querydb: INSERT INTO api_request_history (occurred_at, user_name, user_id, friend_id, user_type, action, request_uri, ip_address, user_agent, note) VALUES ('2026-07-16 17:07:14', 'brentbilger', '123456', '', 'admin', 'onclickRowFilterCheckbox', '/49-myboatjourney-api.php?ajax=yes&sUserId=123456&encUserName=brentbilger&action=onclickRowFilterCheckbox&table=row_filter_user&field_id=visit_checkbox&selected=no', '170.203.205.178', 'Mozilla/5.0 (iPhone; CPU iPhone OS 26_5_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/149.0.7827.45 Mobile/15E148 Safari/604.1', 'authorized_api_invocation') 05:07:14 Query succeeded 05:07:14 Affected rows: 1 05:07:14 Executing API: sAction=onclickRowFilterCheckbox 05:07:14 encUserName=brentbilger, sUserId=123456, sUserType=admin 05:07:14 querydb: UPDATE row_filter_user SET visit_checkbox='no' WHERE user_name='brentbilger' 05:07:14 Query succeeded 05:07:14 Affected rows: 1 05:07:14 sendJsonResponse raw data: Array ( [status] => success [message] => success: updated table 'row_filter_user' row 'visit_checkbox' to 'no' [data] => Array ( ) ) 05:07:14 json_encode did not fail 12:49:50 sProgram=25-login.php 05:49:50 login.php 05:49:50 login page: session_id=8e99cdb499ea4b1fab22a629db1a88bf 05:49:50 login page: user_name=null 05:49:50 cookie brp=null 05:49:50 called from program='' 05:49:50 called from program='my-boat-journey.php' 05:49:50 No friend_id was present 05:49:50 No post of form data was present 05:49:50 No cookie was present or not valid 05:49:50 Picture to pick: iPick=1 05:49:50 getOneRowAssociativeArrayFromDB(...) 05:49:50 querydb: SELECT * FROM captcha WHERE rownum='16' 05:49:50 Query succeeded 05:49:50 Number of rows returned: 1 05:49:50 Success one row returned 05:49:50 16, Newspaper, images/captcha/1648.png 05:49:50 getOneRowAssociativeArrayFromDB(...) 05:49:50 querydb: SELECT * FROM captcha WHERE rownum='12' 05:49:50 Query succeeded 05:49:50 Number of rows returned: 1 05:49:50 Success one row returned 05:49:50 12, Microphone, images/captcha/1248.png 05:49:50 Picked: i=1, sSelectedName=Microphone, iVal=732946893 05:49:50 getOneRowAssociativeArrayFromDB(...) 05:49:50 querydb: SELECT * FROM captcha WHERE rownum='3' 05:49:50 Query succeeded 05:49:50 Number of rows returned: 1 05:49:50 Success one row returned 05:49:50 3, Clipboard, images/captcha/348.png 05:49:50 getOneRowAssociativeArrayFromDB(...) 05:49:50 querydb: SELECT * FROM captcha WHERE rownum='7' 05:49:50 Query succeeded 05:49:50 Number of rows returned: 1 05:49:50 Success one row returned 05:49:50 7, Lock, images/captcha/748.png 05:49:50 getOneRowAssociativeArrayFromDB(...) 05:49:50 querydb: SELECT * FROM captcha WHERE rownum='10' 05:49:50 Query succeeded 05:49:50 Number of rows returned: 1 05:49:50 Success one row returned 05:49:50 10, Playing Cards, images/captcha/1048.png |