FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » this is suck :(
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
this is suck :( [message #18779] Tue, 08 June 2004 23:44 Go to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
first of all: I have fudF 2.6.0 installed on postgres 7.4.2, when I want

1. Rebuild Search Index

I get this error:
Quote:


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.(/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/defa ult/db.inc:302
/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/ise arch.inc:110
/usr/local/apache2/htdocs/toyota.org.pl/forum/wwwroot/adm/indexdb.php:67
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO zz_title_index (word_id, msg_id) SELECT id, 103620 FROM zz_search WHERE word IN('uwaga','wrocławiacy')
Server Version:
[Referring Page] http://www.forum.toyota.org.pl/adm/indexdb.php?rid=2&S=da8bf4837777ac0e 91144b5f45bfc0db&SQ=78064fd95cc02b3b92a89bdf3a786c56



2. Next when I want upgrade to fudF 2.6.1 i have this problem:
(localhost on w2k, postgres 7.3.3)
Quote:


Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "D:/phpdev3/www/!projects/toyota.org.pl/www/forum/FUDforum/errors/.backup/"

Beginning SQL Upgrades

Warning: pg_query(): Query failed: ERROR: parser: parse error at or near "LIMIT" at character 43 . in D:\phpdev3\www\!projects\toyota.org.pl\www\forum\wwwroot\upgrade.php on line 549
PostgreSQL Error: ERROR: parser: parse error at or near "LIMIT" at character 43
Query: DELETE FROM zz_search WHERE word='czego' LIMIT 1



Is there any posibility to make search index or update FudF?

3. Where I can change template of my site, i want to add header on top or sth else - where I can do this?

Report message to a moderator

Re: this is suck :( [message #18780 is a reply to message #18779] Wed, 09 June 2004 00:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is fixed in 2.6.4 release.

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18781 is a reply to message #18780] Wed, 09 June 2004 06:32 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
but how I can update if i have this problems?
ok, when I updatig to fud forum 2.6.4 i get this:

Quote:


Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "D:/phpdev3/www/!projects/toyota.org.pl/www/forum/FUDforum/errors/.backup/"

Beginning SQL Upgrades

Warning: pg_query(): Query failed: ERROR: parser: parse error at or near "INTO" at character 57 . in D:\phpdev3\www\!projects\toyota.org.pl\www\forum\wwwroot\upgrade.php on line 556
PostgreSQL Error: ERROR: parser: parse error at or near "INTO" at character 57
Query: SELECT * FROM zz_forum_notify GROUP BY user_id,forum_id INTO zz_forum_notify_up



Unfortunatelly I cant install new fudF on another base 'couse I'll lost my topics ;(

Report message to a moderator

Re: this is suck :( [message #18785 is a reply to message #18781] Wed, 09 June 2004 12:46 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Open upgrade.php and change line 439 to
<?php
q("SELECT DISTINCT ON ({$flds}) * INTO {$tbl}_up FROM {$tbl} ORDER BY {$flds}");
?>

FUDforum Core Developer

[Updated on: Wed, 09 June 2004 13:42]

Report message to a moderator

Re: this is suck :( [message #18790 is a reply to message #18785] Wed, 09 June 2004 16:40 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
ok THX I've ugraded to FF 2.64, but sill cant rebuild search index, I have this error:

Quote:


Please wait while index is being rebuilt.
This may take a while depending on the size of your forum.(/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/defa ult/db.inc:264
/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/ise arch.inc:102
/usr/local/apache2/htdocs/toyota.org.pl/forum/wwwroot/adm/indexdb.php:70
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO zz_title_index (word_id, msg_id) SELECT id, 103620 FROM zz_search WHERE word IN('uwaga','wrocławiacy')
Server Version:
[Referring Page] http://www.forum.toyota.org.pl/adm/indexdb.php?rid=2&S=8d73b82e751d3650 2060cca4e6d75b69&SQ=3c400681601cfbd466ed93ec7aafcd80



What I can do now?

Report message to a moderator

Re: this is suck :( [message #18791 is a reply to message #18790] Wed, 09 June 2004 16:55 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Check your PostgreSQL's error log file it may have some additional information about this failure. As is it is impossible to tell what gone wrong.

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18793 is a reply to message #18791] Wed, 09 June 2004 21:12 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
OK I will check this.

Now I have another problem (FF 2.6.4), when Im in admins section, and want to choose some links for example File Manager or other links, FF moving me to the main page of forum (not admins only forums).

I can see what is in www.forum.com/adm but I cant choose any links, 'couse FF moving me to the main page. Before upgrade was everything good. What is going on???

Report message to a moderator

Re: this is suck :( [message #18794 is a reply to message #18793] Wed, 09 June 2004 22:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
No idea, haven't heard any such reports or can replicate the problem. Sounds like sequence key is not being correctly validated. Did you run consistency checker after the upgrade?

FUDforum Core Developer

Report message to a moderator

icon8.gif  Re: this is suck :( [message #18795 is a reply to message #18794] Thu, 10 June 2004 00:10 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArgh ;((((( Crying or Very Sad Crying or Very Sad Crying or Very Sad Crying or Very Sad Crying or Very Sad Crying or Very Sad

When I trying to check Forum Consistency i get this error:
Quote:


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

Warning: pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer . in /usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/db. inc on line 138
(/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/db .inc:138
/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/db. inc:132
/usr/local/apache2/htdocs/toyota.org.pl/forum/wwwroot/adm/consist.php:159
) : ERROR: argument of AND must be type boolean, not type integer
Query: SELECT pm.id FROM zz_pmsg pm LEFT JOIN zz_users u ON u.id=pm.ouser_id LEFT JOIN zz_users u2 ON u2.id=pm.duser_id WHERE (pm.pmsg_opt & 16) AND (u.id IS NULL OR u2.id IS NULL)
Server Version:
[Referring Page] http://www.forum.toyota.org.pl/adm/consist.php?rid=2&S=718cd6163531ae6c ed633ebac4ec62af



Now the moving to the main page problem is with file users.inc

Quote:


function sq_check($post, &$sq, $uid=__fud_real_user__, $ses=s)
{
	/* no sequence # check for anonymous users */
	if (!$uid) {
		return 1;
	}

	if ($post && isset($_POST['SQ'])) {
		$s = $_POST['SQ'];
	} else if (!$post && isset($_GET['SQ'])) {
		$s = $_GET['SQ'];
	} else {
		$s = 0;
	}

	if ($sq !== $s) {
		if ($GLOBALS['t'] == 'post' || $GLOBALS['t'] == 'ppost') {
			define('fud_bad_sq', 1);
			$sq = regen_sq($uid);
			return 1;
		}
		header('Location: http://www.forum.toyota.org.pl/index.php?S='.$ses);
		exit;
	}

	return 1;
}




When I comment the header end exit everything is working.

Does this forum will work better on mysql? If yes, how i can transport data to the mysql?

Report message to a moderator

Re: this is suck :( [message #18796 is a reply to message #18795] Thu, 10 June 2004 00:17 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The consistency checker can be fixed by applying the following patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2829

You can move the forum to MySQL by making a datadump (forum admin control panel) and then importing this datadump into a new forum using MySQL.

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18797 is a reply to message #18796] Thu, 10 June 2004 09:45 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
thx it worked Wink.

Unfortunatelly still have problem with search index. Do U remember, I had so many topics to import to FF, so I made it, but i cant search them (i made it with function add in imsg_edt.inc). I cant rebuild search index because have a problem with quries, is there any other posibility to make available search for topic which I imported?

Report message to a moderator

Re: this is suck :( [message #18800 is a reply to message #18797] Thu, 10 June 2004 12:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I think we should try to figure out why rebuilt search index is not working, did you have a chance to look @ the PostgreSQL log?

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18801 is a reply to message #18800] Thu, 10 June 2004 12:59 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
Unfortunatelly i cant see. But it is strange, when i copy this sql query to phpPgAdmin - everything is allright. But on FF I get error Sad

Maybe I should empty all data from those tables (where is everything storage search data), how do U think?

btw: When someone new is registering on forum and will put login which is allready on database, he doesnt get error msg from fud forum only from pgsql - in v. 2.6.0 everything was OK

[Updated on: Thu, 10 June 2004 13:03]

Report message to a moderator

Re: this is suck :( [message #18803 is a reply to message #18801] Thu, 10 June 2004 13:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The following patch will ensure that search tables are cleared prior to the execution insertion of the data.
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2830

The query itself is fine, there is nothing wrong with it. It is possible that there was a timeout? Rebuilding the search index results in a fairly big transaction especially if the forum is big.

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18804 is a reply to message #18803] Thu, 10 June 2004 13:44 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The indexing could be failing if you are hitting swap/memory limit. How many messages do you have in your forum?

Also, are you absolutely sure there is nothing inside pgsql.log if there is not, try looking @ your min_log setting inside postgresql.conf to ensure that it logs all errors.

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18812 is a reply to message #18779] Thu, 10 June 2004 16:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Finally tracked down the problem with search index rebuilding, the following patch should take care of it.
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2832

FUDforum Core Developer

Report message to a moderator

Re: this is suck :( [message #18822 is a reply to message #18812] Thu, 10 June 2004 21:42 Go to previous messageGo to next message
rafath is currently offline  rafath   Poland
Messages: 14
Registered: June 2004
Karma: 0
Junior Member
Sad Sad Sad Sad Unfortunatelly didnt work Sad
Quote:


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.(/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/defa ult/db.inc:264
/usr/local/apache2/htdocs/toyota.org.pl/forum/inc/include/theme/default/ise arch.inc:122
/usr/local/apache2/htdocs/toyota.org.pl/forum/wwwroot/adm/indexdb.php:81
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO zz_title_index (word_id, msg_id) SELECT id, 191842 FROM zz_search WHERE word IN('hit','sezonu')
Server Version:
[Referring Page] http://www.forum.toyota.org.pl/adm/indexdb.php?rid=2&S=66f42bd74e973c65 4713967c3b8d434d




I think, that I will move my imported topics to another aplication (where I can search them) - there is ca 60000 topics, so U know its little bit important to me Smile.

Another 2 problems:

1. When I'm in admins area, after choosing some links FF moving me to main page of FF (I have located where is the problem:

	
if ($sq !== $s) {
  if ($GLOBALS['t'] == 'post' || $GLOBALS['t'] == 'ppost') {
    define('fud_bad_sq', 1);
    $sq = regen_sq($uid);
    return 1;
  }
  #header('Location: http://www.forum.toyota.org.pl/index.php?S='.$ses);
  #exit;
}

What is going ON? And this is strange, 'couse sometimes everything is OK or sometime FF moving me Sad

2. When someone new is registering on forum and will put login which is allready on database, he doesnt get error msg from fud forum only from pgsql - in v. 2.6.0 everything was OK

Report message to a moderator

Re: this is suck :( [message #18824 is a reply to message #18822] Thu, 10 June 2004 21:50 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
After applying the patch did you rebuild the theme?

I've tried this on my local PostgreSQL install and it works fine.

1 & 2 I cannot replicate on my development server.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: file with the bodies of msg....
Next Topic: Disable RSS from one forum of a group
Goto Forum:
  

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

Current Time: Mon May 06 09:19:30 GMT 2024

Total time taken to generate the page: 0.02847 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software