FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » Error

Show: Today's Messages :: Polls :: Message Navigator

Error [message #27149]

Sun, 28 August 2005 21:23

jkliment

Messages: 10
Registered: August 2005

Karma: 0

Junior Member

Well..
Here we go again.
After dealing with a few issues, I installed FUDFORUM again, and it has been running well for 2 weeks.
Hundreds of messages and satisfied users.
Yesterday, a user sends me an email saying that she cannot log in.
I go into the forum, login as admin, check her user name, everything seems to be ok. I ask her password, she gives it to me, and I proceed to log out from admin when I get this error:
Warning: pg_query(): Query failed: ERROR: parser: parse error at or near ")" at character 40 in /var/www/html/ibm/forumibm2/index.php on line 150

Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/ibm/forumibm2/index.php on line 90

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/html/ibm/forumibm2/index.php on line 90
(/var/www/html/ibm/forumibm2/index.php:150
/var/www/FUDforum2/include/users_adm.inc:26
/var/www/html/ibm/forumibm2/theme/default/login.php:431
/var/www/html/ibm/forumibm2/index.php:1241
) : ERROR: parser: parse error at or near ")" at character 40
Query: DELETE FROM fud26_mod WHERE user_id IN()
_GET: t=login&S=87b9a11fcf618fb6e0e77210ba21c3e4&logout=1&SQ=61212612 55a40f29b7d6beeff78de0bc&
Server Version:
[Referring Page] http://200.155.18.43:8080/ibm/forumibm2/index.php?t=msg&th=2&S=87b9 a11fcf618fb6e0e77210ba21c3e4&goto=210

Ayn attempt to logout from admin will give me the error.
I said - Fine, let's see what I can do as admin.

I ran a Forum Consistency and got this:
Disabling the forum for the duration of maintenance run
Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
OK
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
OK
Checking messages against users & threads
OK
Checking threads against forums
OK
Checking message approvals
Done: Checking message approvals
Checking threads against messages
OK
Checking thread last & first post ids
Done: Checking thread last & first post ids
Checking forum & topic relations
Done: Checking forum & topic relations
Validating Forum Order
Done: Validating Forum Order
Checking for presence of forum lock tables
Done: Checking for presence of forum lock tables
Checking thread_exchange
OK
Checking read table against users & threads
1 entries unmatched, deleted
Checking file attachments against messages

Warning: pg_query(): Query failed: ERROR: parser: parse error at or near ")" at character 38 in /var/www/FUDforum2/include/theme/default/db.inc on line 148

Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/FUDforum2/include/theme/default/db.inc on line 88

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/FUDforum2/include/theme/default/db.inc on line 88
(/var/www/FUDforum2/include/theme/default/db.inc:148
/var/www/html/ibm/forumibm2/adm/consist.php:311
) : ERROR: parser: parse error at or near ")" at character 38
Query: DELETE FROM fud26_attach WHERE id IN()
_POST: conf=Yes&S=87b9a11fcf618fb6e0e77210ba21c3e4&SQ=2f771bc47ac2b967e122 b31cc462a9b3&
Server Version:
[Referring Page] http://200.155.18.43:8080/ibm/forumibm2/adm/consist.php?S=87b9a11fcf618fb6e 0e77210ba21c3e4&SQ=2f771bc47ac2b967e122b31cc462a9b3

Not good.
Ran a Rebuild Search Index, got this:
Disabling the forum for the duration of maintenance run

Please wait while index is being rebuilt.
This may take a while depending on the size of your forum.
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/FUDforum2/include/theme/default/db.inc on line 88

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/FUDforum2/include/theme/default/db.inc on line 88
(/var/www/FUDforum2/include/theme/default/db.inc:274
/var/www/FUDforum2/include/theme/default/isearch.inc:118
/var/www/html/ibm/forumibm2/adm/indexdb.php:75
) : ERROR: current transaction is aborted, queries ignored until end of transaction block
Query: INSERT INTO fud26_index (word_id, msg_id) SELECT id, 3 FROM fud26_search WHERE word IN('font','face','Arial','color','darkred','size','mundo','narrativo','que' ,'esta','hist�ria','nos','traz','provoca','algumas','curiosidades','como',' por','exemplo','significado','palavra','ti�oeiro','qual','lugar','desse','o bjeto','naquele','tempo','espa�o','tamb�m','chama','aten��o','amizade','fid elidade','criado','para','com','seu','patr�o','mas','principalmente','faz', 'convite','img','src','images','smiley_icons','icon_smile','gif','border',' alt','Smile','Deixa','tua','imagina��o','livre','solta','responde','Que','t ipo','feito','pelo','narrador','desta')
_POST: conf=Yes&S=87b9a11fcf618fb6e0e77210ba21c3e4&SQ=2f771bc47ac2b967e122 b31cc462a9b3&
Server Version:
[Referring Page] http://200.155.18.43:8080/ibm/forumibm2/adm/indexdb.php?S=87b9a11fcf618fb6e 0e77210ba21c3e4&SQ=2f771bc47ac2b967e122b31cc462a9b3

What gives?

Report message to a moderator

Problem solved [message #27150 is a reply to message #27149]

Sun, 28 August 2005 23:04

jkliment

Messages: 10
Registered: August 2005

Karma: 0

Junior Member

I upgraded to the new release and the problem was solved.
Thanks guys!

Report message to a moderator

Re: Problem solved [message #27235 is a reply to message #27150]

Tue, 30 August 2005 20:46

tymp

Messages: 13
Registered: July 2005

Karma: 0

Junior Member

thanks! didn't realize that.

so, i get:

(/home/freegeek/public_html/forum/index.php:130
/home/freegeek/public_html/forum/theme/path_info0/index.php:188
/home/freegeek/public_html/forum/index.php:1178
) 1030: Got error 28 from table handler
Query: SELECT m.subject, m.id, m.post_stamp, u.id, u.alias, f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.post_count, f.thread_count, 0,0,g1.group_cache_opt, c.cat_opt & 4 FROM fud26_fc_view v INNER JOIN fud26_cat c ON c.id=v.c INNER JOIN fud26_forum f ON f.id=v.f INNER JOIN fud26_group_cache g1 ON g1.user_id=0 AND g1.resource_id=f.id LEFT JOIN fud26_msg m ON f.last_post_id=m.id LEFT JOIN fud26_users u ON u.id=m.poster_id WHERE (g1.group_cache_opt & 1)>0 ORDER BY v.id
Server Version: 4.0.25-standard

and error 28 is apparently out of memory... in a temp table, i assume, because there's plenty room on disk. will the temp table settings be a server thing, or does fudforum control that?

(still waiting to find out what the person was trying to do when this error happened)

thanks again,
-rob

[Updated on: Tue, 30 August 2005 20:47]

Report message to a moderator