| PostgreSQL problems in Admin Console [message #27229] |
Tue, 30 August 2005 18:19  |
frank_s
Messages: 5
Registered: August 2005
Karma: 0
|
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
|
|
|
|
|
|
| Re: PostgreSQL problems in Admin Console [message #27237 is a reply to message #27234] |
Tue, 30 August 2005 22:15  |
frank_s
Messages: 5
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
Applied the patch, the same query generates a different error now:
(/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:53
) : ERROR: argument of WHERE must be type boolean, not type integer
Query: SELECT u.id, u.alias FROM fud26_group_members g INNER JOIN fud26_users u ON u.id=g.user_id WHERE group_members_opt & 131072 GROUP BY u.id, u.alias ORDER BY u.alias
_GET: array ( 'S' => 'a7b3cfb027d395efe5e60fd290d360a4', 'SQ' => 'dd950379f1a3d93da97f428bcb3b4c5c', )
Server Version:
The other errors haven't been affected either. Is there anything else I can do to help diagnose the problem?
By the way, I noticed that Googlebot had a hard time crawling the forum in path_info mode. It ended up creating about 700 "guest users" and crawled the same pages over and over for a long time. Very odd, other search engine crawlers did not seem to have that problem. I just applied the robots.txt entries recommended elsewhere on this board in order to at least keep the crawlers out of the less useful pages, hopefully that will lessen this issue.
-Frank
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]