FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » PostgreSQL problems in Admin Console
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
PostgreSQL problems in Admin Console [message #27229] Tue, 30 August 2005 18:19 Go to previous message
frank_s is currently offline  frank_s   United States
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: sql error message in error_log not very helpful :(
Next Topic: Bug in Polls
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 01 08:20:27 GMT 2024

Total time taken to generate the page: 0.04982 seconds