FUDforum 2.6.9RC1 Released [message #21330] |
Thu, 25 November 2004 14:13 |
Ilia
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:
- Minor installer optimization.
- Unify admin checks.
- Make sure that for new users notifications are selected by default.
- Do not enable COPPA by default.
- Disable sign-up referrer tracking by default.
- Fixed bug with category cache generation.
- Fixed layout bug on email & message reporting forms.
- Disable auto-complete for admin settings.
- Allow admin to disable timezone settings because it seems to cause problems when Apache 2 is used in conjunction with mod_perl.
- Added notice about the usage of admin group manager.
- Do not use temporary table unless there are >250 messages inside a topic.
- Create special tables for locking during message write operation so that they do not interfere with reading of data from normal tables.
- Reduce the duration of locks during posting of a new topic and message reply.
- Remove the tmp column from the view table, we no longer need it.
- Fixed bug with PostgreSQL and compact category view.
- Stop usage of 1=1, which apparently causes problems for certain versions of MySQL query optimizer.
- 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 |
|
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 #21465 is a reply to message #21460] |
Wed, 01 December 2004 08: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)
|
|
|
|
Re: FUDforum 2.6.9RC1 Released [message #21472 is a reply to message #21465] |
Wed, 01 December 2004 15:37 |
Ilia
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 |
Ilia
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 |
Anonymous
|
|
|
|
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 |
Ilia
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 |
Anonymous
|
|
|
|
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 #21550 is a reply to message #21534] |
Fri, 03 December 2004 07:46 |
Anonymous
|
|
|
|
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
|
|
|
|
|