|
|
|
Re: this is suck :( [message #18785 is a reply to message #18781] |
Wed, 09 June 2004 12:46 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
Ilia
![Canada Canada](/forum/images/flags/ca.png) 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 #18801 is a reply to message #18800] |
Thu, 10 June 2004 12:59 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
rafath
![Poland Poland](/forum/images/flags/pl.png) 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](images/smiley_icons/icon_sad.gif)
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 #18822 is a reply to message #18812] |
Thu, 10 June 2004 21:42 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
rafath
![Poland Poland](/forum/images/flags/pl.png) Messages: 14 Registered: June 2004
Karma: 0
|
Junior Member |
|
|
Unfortunatelly didnt work ![Sad](images/smiley_icons/icon_sad.gif)
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 .
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](images/smiley_icons/icon_sad.gif)
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
|
|
|
Re: this is suck :( [message #18824 is a reply to message #18822] |
Thu, 10 June 2004 21:50 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) |
Ilia
![Canada Canada](/forum/images/flags/ca.png) 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
|
|
|