Files
web-hosts/domains/coppertone.tech/audit-reports/database-audit/sql-error-handling-20251123-124312.txt
2025-12-26 13:38:04 +01:00

76 lines
8.3 KiB
Plaintext

# SQL Error Handling Analysis - 20251123-124312
== sql.ErrNoRows handling ==
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:606: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:714: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:758: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:803: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:863: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:907: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:947: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:1033: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/forum-service/main.go:1087: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:856: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:882: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:932: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1031: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1152: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1207: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1528: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1559: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1579: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1603: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1774: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1866: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:1906: if err != nil && err != sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:2537: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:2578: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:2692: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:2768: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:2920: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/payment-service/main.go:3066: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:698: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:726: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:777: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:887: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:991: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1021: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1080: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1242: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1431: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1464: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/work-management-service/main.go:1591: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:850: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:922: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1184: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1914: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1930: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2030: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2049: } else if err != sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2116: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2135: } else if err != sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2193: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2214: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:2310: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:627: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:859: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:962: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1005: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1059: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1093: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1204: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1357: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1458: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1549: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1615: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1650: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1690: if err == sql.ErrNoRows {
/home/administrator/projects/coppertone.tech/backend/functions/contact-service/main.go:569: if err == sql.ErrNoRows {
== Generic error returns without context ==
== Error logging on DB operations ==
/home/administrator/projects/coppertone.tech/backend/functions/auth-service/main.go:1603: log.Printf("Error querying CSRF tokens: %v", err)
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:626: blog, err := scanBlog(db.QueryRow(query, slug, StatusPublished, BlogTypeSite))
/home/administrator/projects/coppertone.tech/backend/functions/blog-service/main.go:1203: blog, err := scanBlog(db.QueryRow(query, slug, StatusPublished, BlogTypeUser))
/home/administrator/projects/coppertone.tech/backend/functions/contact-service/main.go:507: log.Printf("Failed to query submissions: %v", err)