-
Bug
-
Resolution: Fixed
-
None
-
3.0.x
-
None
-
PHP Environment:
Database:
Hi, I am new here but I must disturb you with my problems 
If I try login I get this error message
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 2242: Undefined index: file
|
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 2268: Undefined index: line
|
Return to forum index
|
General Error
|
SQL ERROR [ postgres ]
|
|
ERROR: column "w.word_text" must appear in the GROUP BY clause or be used in an aggregate function []
|
|
SQL
|
|
SELECT w.word_id, w.word_text FROM phpbb_search_wordlist w LEFT JOIN phpbb_search_wordmatch m ON (w.word_id = m.word_id) WHERE w.word_common = 0 AND m.word_id IS NULL GROUP BY w.word_id
|
|
BACKTRACE
|
|
FILE: includes/db/postgres.php
|
LINE: 144
|
CALL: dbal_postgres->sql_error()
|
|
FILE: includes/search/fulltext_native.php
|
LINE: 1010
|
CALL: dbal_postgres->sql_query()
|
|
FILE:
|
LINE:
|
CALL: fulltext_native->tidy()
|
My second Problem is, if I try to log in at the admin control panel I get a white window, after getting a error message like above
the third Problem is a fix
in includes/db/postgres.php Line 94
return 'PostgresSQL' . ((!empty($version)) ? ' ' . $version['client'] : '';
|
thre is a ) missing
return 'PostgresSQL' . ((!empty($version)) ? ' ' . $version['client'] : '');
|
by the way, I am useing PostgreSQL
thx for helping
MfG Fide