https://bugzilla.wikimedia.org/show_bug.cgi?id=67065

Umherirrender <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected],
                   |                            |[email protected]

--- Comment #2 from Umherirrender <[email protected]> ---
Table 'log_search' is a table to match a row of the logging table and
corresponding data. The ls_field is used to determine between all the given
values.

In this case the value of column ls_value (varchar(255)) is compared to the
value of column pr_id (integer) which is needed here to find all the log_ids
for protected pages.
Postgres seems to have problems with different data types. So mediawiki needs a
new column ls_value_int or a explicit database cast. Quoting is not a option
here, because that will change the meaning of the query (ls_value never
contains the word 'pr_id').

Before the use of pr_id the log_search table was only used to find user names,
so there was no cast problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to