Opened 5 months ago
Closed 5 months ago
#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 , 5 months ago
comment:2 by , 5 months ago
| Resolution: | → no change required |
|---|---|
| Status: | new → closed |
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.
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"