Linked ticket with changeset: r6208
Action performed by Anonymous (I am too lazy to register) on Jul 24th 2006, 07:53
If I try login I get this error message
- Code: Select all
[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
- Code: Select all
return 'PostgresSQL' . ((!empty($version)) ? ' ' . $version['client'] : '';
thre is a ) missing
- Code: Select all
return 'PostgresSQL' . ((!empty($version)) ? ' ' . $version['client'] : '');
by the way, I am useing PostgreSQL
thx for helping
MfG Fide