PostgreSQL problems in Admin Console [message #27229] |
Tue, 30 August 2005 18:19 |
frank_s
Messages: 5 Registered: August 2005
Karma:
|
Junior Member |
|
|
Hi,
First of all, thank you very much to the FUDforum developers for creating such a great piece of software!
I'm running FUDforum 2.7.2 with PostgreSQL 7.4.5. There are several items within the Admin Console that only throw SQL errors, such as:
Rebuild Search Index:
Please wait while index is being rebuilt.
This may take a while depending on the size of your forum.(/data/htdocs/FUDforum/include/theme/default/db.inc:222
/data/htdocs/FUDforum/include/theme/default/isearch.inc:116
/data/htdocs/lovephilosophy.com/forum/adm/indexdb.php:75
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 3 FROM fud26_search WHERE word IN('new','collection','the','tea','party')
_POST: array ( 'conf' => 'Yes', 'S' => '55661e785e8763b735a096ea6668ae82', 'SQ' => 'b80dd6b40c7012a449ae0e26aa46f374', )
Server Version:
[Referring Page]
Error Log:
There is a huge number of entries here, some typical ones being:
(/data/htdocs/lovephilosophy.com/forum/index.php:150
/data/htdocs/FUDforum/include/users_adm.inc:26
/data/htdocs/lovephilosophy.com/forum/theme/default/login.php:431
/data/htdocs/lovephilosophy.com/forum/index.php:1241
) : ERROR: syntax error at or near ")" at character 40
Query: DELETE FROM fud26_mod WHERE user_id IN()
_GET: S=4bc16bb45f968642d4506da80d3231de&t=login&
_POST: S=4bc16bb45f968642d4506da80d3231de&SQ=0&quick_login=DELETEDquick_pa ssword=DELETED&quick_use_cookies=1&quick_login_submit=Login&
Server Version:
I think this one comes from the privileged users list:
(/data/htdocs/FUDforum/include/theme/default/db.inc:98
/data/htdocs/FUDforum/include/theme/default/db.inc:92
/data/htdocs/lovephilosophy.com/forum/adm/admslist.php:19
/data/htdocs/lovephilosophy.com/forum/adm/admslist.php:45
) : ERROR: column "u.alias" must appear in the GROUP BY clause or be used in an aggregate function
Query: SELECT u.id, u.alias FROM fud26_mod m INNER JOIN fud26_users u ON u.id=m.user_id GROUP BY u.id ORDER BY u.alias
_GET: array ( 'S' => '55661e785e8763b735a096ea6668ae82', 'SQ' => '674c2c20e27ebccd5019c620f53ca430', )
Server Version:
(/data/htdocs/FUDforum/include/theme/default/db.inc:222
/data/htdocs/FUDforum/include/theme/default/isearch.inc:116
/data/htdocs/lovephilosophy.com/forum/adm/indexdb.php:75
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 3 FROM fud26_search WHERE word IN('new','collection','the','tea','party')
_POST: array ( 'conf' => 'Yes', 'S' => '55661e785e8763b735a096ea6668ae82', 'SQ' => 'b80dd6b40c7012a449ae0e26aa46f374', )
Server Version:
Compacting Messages:
This items comes back with a fatal error saying that the system ran out of disk space, even though the filesystem has several GB available.
Upgrades and consistency checks have been successful.
This is my System Info:
Database Version: PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)
PHP Version: 4.3.11
Web Server: Apache/2.0.51 (Fedora)
WebServer to PHP interface: apache2handler
Forum Version: 2.7.2
Relavent PHP Settings:
Safe Mode: OFF
Open basedir: none
Display Errors: OFF
File Uploads: ON
Magic Quotes: OFF
Register Globals: OFF
Output Buffering: No
Disabled Functions: none
PSpell Support: Yes
Zlib Support: Yes
Anything I can do to fix this?
Thanks in advance!
-Frank
|
|
|