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

Home » FUDforum » FUDforum Installation Issues » Error
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Error [message #27149] Sun, 28 August 2005 17:23 Go to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Problem solved [message #27150 is a reply to message #27149] Sun, 28 August 2005 19:04 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I upgraded to the new release and the problem was solved.
Thanks guys!
Re: Problem solved [message #27235 is a reply to message #27150] Tue, 30 August 2005 16:46 Go to previous messageGo to next message
tymp is currently offline  tymp   United States
Messages: 13
Registered: July 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 16:47]

Report message to a moderator

Re: Problem solved [message #27236 is a reply to message #27235] Tue, 30 August 2005 16:47 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
That's the mysql thing, FUDforum has no way to control where MySQL stores temp data.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Upgrade Error (Memory?)
Next Topic: Help !
Goto Forum:
  

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

Current Time: Mon Oct 23 00:19:26 EDT 2017

Total time taken to generate the page: 0.00652 seconds