#18726 closed bug (no change required)

Userguide tool: "Full edit" broken

Reported by: humdinger Owned by: waddlesplash
Priority: normal Milestone: Unscheduled
Component: Website/Userguide Translator Version: R1/beta4
Keywords: Cc:
Blocked By: Blocking:
Platform: All

Description

After submitting a change in "Full edit" mode, I only get a white background in Web+ and Web. Otter shows an error 500.

Block editing works.

Change History (2)

comment:1 by nielx, 11 months ago

Logs:

2023/12/29 14:26:39 [warn] 34#34: *138538 a client request body is buffered to a temporary file /var/cache/nginx/client_temp/0000000049, client: 10.244.2.252, server: _, request: "POST /userguide/edit.php?doc_id=44 HTTP/1.1", host: "i18n.haiku-os.org", referrer: "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "NOTICE: PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "translate_strings_doc_md5""
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "DETAIL:  Key (doc_id, source_md5)=(51, 88fa71f0a6e0dfedbb46d91cc0b37a50) already exists. in /var/app/userguide/inc/common.php:166"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "Stack trace:"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#0 /var/app/userguide/inc/common.php(166): PDOStatement->execute(Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#1 /var/app/userguide/edit.php(506): db_query('INSERT INTO tra...', Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#2 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#3 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#4 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#5 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#6 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#7 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:26:39] WARNING: [pool www] child 310 said into stderr: "#8 /var/app/userguide/edit.php(212): update_..."
2023/12/29 14:26:39 [error] 34#34: *138538 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "translate_strings_doc_md5"
DETAIL:  Key (doc_id, source_md5)=(51, 88fa71f0a6e0dfedbb46d91cc0b37a50) already exists. in /var/app/userguide/inc/common.php:166
Stack trace:
#0 /var/app/userguide/inc/common.php(166): PDOStatement->execute(Array)
#1 /var/app/userguide/edit.php(506): db_query('INSERT INTO tra...', Array)
#2 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#3 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#4 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#5 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#6 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#7 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#8 /var/app/userguide/edit.php(212): update_" while reading response header from upstream, client: 10.244.2.252, server: _, request: "POST /userguide/edit.php?doc_id=44 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "i18n.haiku-os.org", referrer: "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44"
10.244.2.252 - - [29/Dec/2023:14:26:39 +0000] "POST /userguide/edit.php?doc_id=44 HTTP/1.1" 500 5 "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44" "Mozilla/5.0 (X11; Haiku x86_64) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Safari/605.1.15"
2023/12/29 14:27:02 [warn] 34#34: *138540 a client request body is buffered to a temporary file /var/cache/nginx/client_temp/0000000050, client: 10.244.2.91, server: _, request: "POST /userguide/edit.php?doc_id=44 HTTP/1.1", host: "i18n.haiku-os.org", referrer: "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "NOTICE: PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "translate_strings_doc_md5""
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "DETAIL:  Key (doc_id, source_md5)=(51, 88fa71f0a6e0dfedbb46d91cc0b37a50) already exists. in /var/app/userguide/inc/common.php:166"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "Stack trace:"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#0 /var/app/userguide/inc/common.php(166): PDOStatement->execute(Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#1 /var/app/userguide/edit.php(506): db_query('INSERT INTO tra...', Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#2 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#3 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#4 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#5 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#6 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#7 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)"
[29-Dec-2023 14:27:02] WARNING: [pool www] child 311 said into stderr: "#8 /var/app/userguide/edit.php(212): update_..."
2023/12/29 14:27:02 [error] 34#34: *138540 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "translate_strings_doc_md5"
DETAIL:  Key (doc_id, source_md5)=(51, 88fa71f0a6e0dfedbb46d91cc0b37a50) already exists. in /var/app/userguide/inc/common.php:166
Stack trace:
#0 /var/app/userguide/inc/common.php(166): PDOStatement->execute(Array)
#1 /var/app/userguide/edit.php(506): db_query('INSERT INTO tra...', Array)
#2 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#3 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#4 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#5 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#6 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#7 /var/app/userguide/edit.php(476): update_translations(Object(DOMElement), Array)
#8 /var/app/userguide/edit.php(212): update_" while reading response header from upstream, client: 10.244.2.91, server: _, request: "POST /userguide/edit.php?doc_id=44 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "i18n.haiku-os.org", referrer: "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44"
10.244.2.91 - - [29/Dec/2023:14:27:02 +0000] "POST /userguide/edit.php?doc_id=44 HTTP/1.1" 500 5 "https://i18n.haiku-os.org/userguide/edit.php?doc_id=44" "Mozilla/5.0 (X11; Haiku x86_64) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Safari/605.1.15"

comment:2 by humdinger, 11 months ago

Resolution: no change required
Status: newclosed

Thanks for the log\\ Turns out, it was duplicated _translation_ids. I copied some paragraphs from similar (in one case identical) paragraphs of ShowImage. It'd be nice if completely identical blocks of different pages wouldn't have to be translated twice...

Plus, an error message which _translation_id causes trouble.

Note: See TracTickets for help on using tickets.