Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
2014.11
-
None
-
eZPublish Community Project 2014.11
Postgres 9.1.11
Description
The module content/search return a transaction error if there is a "large" amount of same search phrase.
This happens in a postgres environment because the scheme provides a interger type instead of bigint.
A quick and dirty solution is alter table:
ALTER TABLE ezsearch_search_phrase ALTER COLUMN phrase_count TYPE BIGINT;
ALTER TABLE ezsearch_search_phrase ALTER COLUMN result_count TYPE BIGINT;