location_postal needs to accept NULL

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'location_postal' cannot be null: UPDATE "visitors" SET "location_continent_code"=:db_update_placeholder_0 , "location_country_code"=:db_update_placeholder_1, "location_country_name"=:db_update_placeholder_2, "location_region"=:db_update_placeholder_3, "location_city"=:db_u pdate_placeholder_4, "location_postal"=:db_update_placeholder_5, "location_latitude"=:db_update_placeholder_6, "location_longitude"=:db_update_placeholder_7, "location _area_code"=:db_update_placeholder_8 WHERE ("visitors_ip" = :db_condition_placeholder_0) AND ("location_latitude" IS NULL); Array ( [:db_update_placeholder_0] => EU [:db_update_placeholder_1] => BA [:db_update_placeholder_2] => Bosnia and Herzegovina [:db_update_placeholder_3] => BIH [:db_update_placeholder_4] => Novi Travnik [:db_update_placeholder_5] => [:db_update_placeholder_6] => 44.1678 [:db_update_placeholder_7] => 17.6563 [:db_update_placeholder_8] => [:db_condition_placeholder_0] => 185.99.3.203 )

Comments & Activities

Issue created by @duckydan
Assigned to bluegeek9
Comment 5 months ago →
🇺🇸United States bluegeek9
Thank you for reporting this bug. I hope to have a fix soon.
Comment 5 months ago →
🇮🇳India ayush.pandey
The issue is reproducible when visiting the website with country with no postal code (tested with Benin). And the patch fixes the issue. Just the impact on the analytics might need to be refactored, if the results on the analytics has dependency on the postal codes. @bluegeek9, you can move this to RTBC, if need no other work.
Merge request !136Issue #3454502 by bluegeek9: location_postal needs to accept NULL → (Merged) created by bluegeek9
Pipeline finished with Skipped
5 months ago
#198964
Comment 5 months ago →
System Message

bluegeek9 → committed a9d4ec43 on 8.x-2.x
Issue #3454502: location_postal needs to accept NULL
Issue was unassigned.
Status changed to Fixed 5 months ago1:18pm 14 June 2024
Comment 5 months ago →
🇺🇸United States bluegeek9
Comment 5 months ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

location_postal needs to accept NULL

Merge Requests

!136location_postal needs to accept NULL
Merged

Comments & Activities

location_postal needs to accept NULL

Merge Requests

!136location_postal needs to accept NULLMerged

Comments & Activities

!136location_postal needs to accept NULL
Merged