When opening the edit view for an article or other things like e.g. tags, a red alert popup with title "Error" and text "An error has occurred." is shown.
When saving a newly created article for the first time, another a red alert popup with title "Error" is shown with following text:
Save failed with the following error: 23502, 7, ERROR: null value in column "introtext" violates not-null
constraint DETAIL: Failing row contains (71, 0, test, test, null, , 0, 2, 2019-07-30 17:49:31, 31, ,
1970-01-01 00:00:00, 0, 0, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1970-01-01 00:00:00,
{"image_intro":"","float_intro":"","image_intro_alt":"","image_i...,
{"urla":"","urlatext":"","targeta":"","urlb":"","urlbtext":"","t...,
{"article_layout":"","show_title":"","link_titles":"","show_tags..., 1, 0, , , 1, 0,
{"robots":"","author":"","rights":""}, 0, *, ).
An error has occurred.
With an already existing article, the 2nd error does not happen.
On a MySQL database, none of these errors happens, it happens only on PostgreSQL.
No errors.
See above.
PHP 7.2
PostgreSQL 10.9
Maybe the cause of both is the same 1 error, or maybe it is 2 different errors.
Title |
|
Labels |
Added:
J4 Issue
|
Status | New | ⇒ | Discussion |
for the 2nd i'm unable to replicate with (#25752 and #25724) both applyied
just got some warning on the postgresql log
postgres@joomla WARNING: nonstandard use of \\ in a string literal at character 242 2019-07-31 19:34:32.412 CEST [5493] postgres@joomla HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
p.s
forgot to mention i'm on PostgreSQL (PDO) 11.4 (Ubuntu 11.4-1.1~build1)
Status | Discussion | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-07-31 17:49:11 |
Closed_By | ⇒ | richard67 |
@richard67 you know i usually made mistake "when on train"
for the 1st one see #25752...
i'll investigate further but later for the 2nd one