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

Home » FUDforum » FUDforum Announcements » FUDforum 2.6.9RC1 Released
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
FUDforum 2.6.9RC1 Released [message #21330] Thu, 25 November 2004 14:13 Go to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Right on the heels of 2.6.8 here goes 2.6.9RC1. The purpose of this release is two fold, fix few small buglets I've discovered in 2.6.8 as well as introduce a few performance enchantments that should improve the speed of posting messages and reduce their overall affect on the forum's performance while this is happening.

Changes:
  1. Minor installer optimization.
  2. Unify admin checks.
  3. Make sure that for new users notifications are selected by default.
  4. Do not enable COPPA by default.
  5. Disable sign-up referrer tracking by default.
  6. Fixed bug with category cache generation.
  7. Fixed layout bug on email & message reporting forms.
  8. Disable auto-complete for admin settings.
  9. Allow admin to disable timezone settings because it seems to cause problems when Apache 2 is used in conjunction with mod_perl.
  10. Added notice about the usage of admin group manager.
  11. Do not use temporary table unless there are >250 messages inside a topic.
  12. Create special tables for locking during message write operation so that they do not interfere with reading of data from normal tables.
  13. Reduce the duration of locks during posting of a new topic and message reply.
  14. Remove the tmp column from the view table, we no longer need it.
  15. Fixed bug with PostgreSQL and compact category view.
  16. Stop usage of 1=1, which apparently causes problems for certain versions of MySQL query optimizer.
  17. Reduce the size of FUDforum archive by ~60kb (uncompressed form). This helps with memory limit situation.


FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21456 is a reply to message #21330] Tue, 30 November 2004 18:31 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

When upgrading from a 2.6.8 version, I got the following error message (is this really an error?):

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: "/var/www/fud1/fudabcNONBROWSABLE/errors/.backup/"

Beginning SQL Upgrades
SQL Upgrades Complete
Adding GLOBAL Variables
Compiling theme default
No source for quicklogin.tmpl


After that upgrade, the forum seems to work, but I can't rebuild the themes, as (at least) quicklogin.tmpl is missing.

[Updated on: Tue, 30 November 2004 18:36]

Report message to a moderator

Re: FUDforum 2.6.9RC1 Released [message #21460 is a reply to message #21456] Tue, 30 November 2004 20: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
Sounds like the quicklogin.tmpl template was not replaced on your system.

FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21465 is a reply to message #21460] Wed, 01 December 2004 08:42 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

The file quicklogin.tmpl seems to be present, I don't understand why it wouldn't find it. The access rights to it are like all the other files.

Quote:

hydro:/var/www/fud1/fudabcNONBROWSABLE/thm/default/tmpl# ll quick*
-rw------- 1 www-data www-data 1520 Nov 30 19:25 quicklogin.tmpl


(There's also the same file for the path_info theme (/thm/path_info/tmpl), with exactly the same rights)
Re: FUDforum 2.6.9RC1 Released [message #21468 is a reply to message #21330] Wed, 01 December 2004 12:27 Go to previous messageGo to next message
Anonymous   Norway
Is there a missing column "tmp" in {SQL_TABLE_PREFIX}thread_view?
(complaining when posting to a upgraded forum)
Re: FUDforum 2.6.9RC1 Released [message #21472 is a reply to message #21465] Wed, 01 December 2004 15:37 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
lstep wrote on Wed, 01 December 2004 03:42

The file quicklogin.tmpl seems to be present, I don't understand why it wouldn't find it. The access rights to it are like all the other files.

Quote:

hydro:/var/www/fud1/fudabcNONBROWSABLE/thm/default/tmpl# ll quick*
-rw------- 1 www-data www-data 1520 Nov 30 19:25 quicklogin.tmpl


(There's also the same file for the path_info theme (/thm/path_info/tmpl), with exactly the same rights)


The old quicklogin used to require quicklogin.inc.t, which is not longer necessary with the new code. Somehow the theme compiler on your system is failing to realize that and claiming it cannot find the source. Would it be possible to get admin access to the forum?


FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21473 is a reply to message #21468] Wed, 01 December 2004 15: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
sigurdne wrote on Wed, 01 December 2004 07:27

Is there a missing column "tmp" in {SQL_TABLE_PREFIX}thread_view?
(complaining when posting to a upgraded forum)


This column is no longer needed in 2.6.9RC1+ versions. Are you running a fresh install or an upgrade?


FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21515 is a reply to message #21473] Thu, 02 December 2004 11:47 Go to previous messageGo to next message
Anonymous   Norway
Ilia wrote on Wed, 01 December 2004 10:38

sigurdne wrote on Wed, 01 December 2004 07:27

Is there a missing column "tmp" in {SQL_TABLE_PREFIX}thread_view?
(complaining when posting to a upgraded forum)


This column is no longer needed in 2.6.9RC1+ versions. Are you running a fresh install or an upgrade?


I am running an upgrade (from 2.6.8 – I think).
I inserted the column "tmp"
I also had to remove a bunch of {SQL_TABLE_PREFIX}_fl_{x} to allow Consistency check (which seems to be created during the check)

Now all is running fine.
Re: FUDforum 2.6.9RC1 Released [message #21521 is a reply to message #21515] Thu, 02 December 2004 14:28 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 lock table creation had a bug in 2.3.9RC1 which was fixed in CVS.

The tmp column however really should not be need, what database system are you using?


FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21531 is a reply to message #21521] Thu, 02 December 2004 15:40 Go to previous messageGo to next message
Anonymous   Norway
Ilia wrote on Thu, 02 December 2004 09:28

The lock table creation had a bug in 2.3.9RC1 which was fixed in CVS.

The tmp column however really should not be need, what database system are you using?


MySQL-4.0.18
Re: FUDforum 2.6.9RC1 Released [message #21532 is a reply to message #21531] Thu, 02 December 2004 15: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
Could you please paste me the MySQL you are getting.

FUDforum Core Developer
Re: FUDforum 2.6.9RC1 Released [message #21534 is a reply to message #21532] Thu, 02 December 2004 16:23 Go to previous messageGo to next message
Anonymous   Norway
Sure – I will do it when I am back at work tomorrow – in about 14 hours from now.
Re: FUDforum 2.6.9RC1 Released [message #21550 is a reply to message #21534] Fri, 03 December 2004 07:46 Go to previous messageGo to next message
Anonymous   Norway
This is what I can find in the SQL Error Log:
Quote:

(/var/www/html/bbb/forum/index.php:126
/var/www/html/bbb/forum/theme/default/post.php:2862
/var/www/html/bbb/forum/theme/default/post.php:1659
/var/www/html/bbb/forum/theme/default/post.php:3917
/var/www/html/bbb/forum/index.php:1164
) 1054: Unknown column 'tmp' in 'field list'
Query: INSERT INTO fud26_thread_view (thread_id,forum_id,page,tmp) SELECT fud26_thread.id, fud26_thread.forum_id, 2147483645, CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1101894471 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END AS sort_order_fld FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=5 AND fud26_msg.apr=1 ORDER BY sort_order_fld DESC, fud26_thread.last_post_id DESC
_GET: t=post&
_POST: msg_subject=Ledermøte 091104&msg_icon=icon1.gif&fnt_size=&fnt_color=&fnt_face=&am p;msg_body=&tmp_f_val=1&msg_show_sig=Y&S=91899383bdf524cb329acc 78b4daa922&SQ=14179e600398ae9638ecc5ceb2d8518a&submitted=1&repl y_to=0&th_id=&frm_id=5&start=&msg_id=0&pl_id=0&old_ subject=&prev_loaded=1&btn_submit=1&
Server Version: 4.0.18
[Referring Page] http://172.20.35.225/bbb/forum/index.php?t=post&frm_id=5&rid=0& S=91899383bdf524cb329acc78b4daa922?SQ=2dea015585078035454a6f665f567588& S=91899383bdf524cb329acc78b4daa922
Re: FUDforum 2.6.9RC1 Released [message #21553 is a reply to message #21550] Fri, 03 December 2004 14:50 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You are clearly using an old th_adm.inc.t.

Try the upgrade script at this url:
http://bb.prohost.org/upgrade_new.tar.gz


FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: FUDforum 2.6.8 Released
Next Topic: FUDforum 2.6.9RC2 Released
Goto Forum:
  

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

Current Time: Sun Dec 22 10:26:39 GMT 2024

Total time taken to generate the page: 0.03608 seconds