1 1
Igor

Forum upgrade

Recommended Posts

I hope you like the upgrade, which was done on urgent notice due to database failure and we started from this morning's backup. We apologise for some deleted posts and users, wrong settings and possible bugs.

Since our previous forum was 5-6 years old, upgrade is tremendous but we will try to keep it similar on function level. There was a plan for redesign but this will be done once in the future.

 

Enjoy! :)

Share this post


Link to post
Share on other sites

Hello!

 

The upgrade was just in that moment done, when I tried to sign up. Now the signup, except for the Facebook method, does not work. The security thingy does not show up.

Share this post


Link to post
Share on other sites

And I don't see any moderation options for threads, posts and users, only premod queue (I hope premod is still turned on)

 

Also "New content" will be hard to get used to...

 

And looks like hidden and queued for removal threads didn't survive the upgrade too

Edited by zador.blood.stained
Testing edit

Share this post


Link to post
Share on other sites
9 minutes ago, zador.blood.stained said:

 

And I don't see any moderation options for threads, posts and users, only premod queue (I hope premod is still turned on)

 


I see like this:
 

 Untitled-2.png

 

12 minutes ago, zador.blood.stained said:

Also "New content" will be hard to get used to...


I guess this https://forum.armbian.com/index.php?/discover/&view=condensed is closes to it. We can change that but let's wait.

Share this post


Link to post
Share on other sites

I can ask on support if they have a fix for this, otherwise ... in worst case and if content is irrelevant, we can hide it.

Share this post


Link to post
Share on other sites

To be honest, i don't like new look of the forum. It is used from some time, in some other forums i used to visit, so i have a look into this already. I can't explain it well, but the skin and arrangement itself are confusing and dysfunctional for me. The biggest problem is Unread Content/All activity. This focusing on posts and not topics itself is not comfortable for me. It is not so notably here, but in forums with more activity is madness and making following of new treads and topics impossible. Not all "improvements" are good and i can't guess who can decide this as better. But i guess you have some functional reason for this upgrade, which is downgrade in my eyes. Maybe going into some other forum platform is better idea. After all, this is me, maybe other visitors would find it better.

Share this post


Link to post
Share on other sites
21 minutes ago, zador.blood.stained said:

Also are there time&date format and timezone settings anywhere?


Automatically. But there is an option to toggle when editing user and setting it manually - without effect.

 

11 minutes ago, RagnerBG said:

Not all "improvements" are good and i can't guess who can decide this as better. But i guess you have some functional reason for this upgrade, which is downgrade in my eyes. Maybe going into some other forum platform is better idea. After all, this is me, maybe other visitors would find it better.

 

The upgrade was planned until we fix / adjust future look to be as similar as possible. We are limited with time so we can't do wonders but try to do the best. This design thing is subjective manner and it's impossible to please everyone. For this "All activity", I know it's a bit odd but let's wait a while.

Changing platform is too risky. I mean it's possible but, I would rather avoid taking more risk ... even with this upgrade we had problems. This is just a tool after all :)


Switch to other theme below to see if this is better, design wise. 

Share this post


Link to post
Share on other sites

Well, I don't like the theme too, but it's too early to say it for sure (for me) because it may be just because it is new. And it may be possible to install a different skin that is closer to the old one.

 

Functional differences are a different kind of issue. Unread content is confusing and harder to read, but it can be customized a little bit and I see a "Set as default" tick/button. No switch for BBcode view in the editor is another downgrade, but hopefully it won't be needed or can be enabled in admin preferences.

Share this post


Link to post
Share on other sites
1 hour ago, Magnets said:

The large "Quote" bar in every post is a bit annoying


True. This looks to be solvable design issue, theme depended. Added to wish list.

Share this post


Link to post
Share on other sites

Well, change from time to time are needed :beer:


The first impression (constructive suggestions :) ) :


- I do not see which topics I've read and which are not   (2017.03.01 ---- now is ok)
- Spacing between the threads and topics are to large (27-inch screen and see only a few responses - could be at least 2 times more -
too much scrolling when reading  ;)) generally large space, not enough content in it

 

lines.JPG

Edited by mariuszb
change info

Share this post


Link to post
Share on other sites
44 minutes ago, zador.blood.stained said:

... and now I don't see an option to quote the whole post, only pop-up on selection (Haze theme)

 

Well, this is feature :) It prohibits quoting everything at once -> less "walls of text", less useless text repetition, ... It's configurable per forum, unfortunately not by user groups.

The best option would be that this whole box is hidden or faded with background and available only on hover on.  So some CSS magic.

 

Selecting text with mouse+quote works fine at this forum.

Share this post


Link to post
Share on other sites
3 hours ago, martinayotte said:

Is the "like this" footer can be removed ?


Not by switch which means I have to dig into the code - so far I haven't found a proper way. There was only a plugin which removed button Quote all from that footer.

 

It annoys me to :angry:

Share this post


Link to post
Share on other sites
7 hours ago, umiddelb said:

Now, I've found the reason why feedly doesn't offer any new Armbian posts for a while


It was lost / disabled / moved to new location upon upgrade. 

 

You should see an icon in lower right corner of the forum. 

Share this post


Link to post
Share on other sites

First it's not a complaint (really). The new forum feel a little slow comparing to before. I have no way to be sure but I wonder if I'm alone here ?

Share this post


Link to post
Share on other sites
Just now, vlad59 said:

The new forum feel a little slow comparing to before. I have no way to be sure but I wonder if I'm alone here ?


Could be. It has many fancy features and I probably didn't optimise it to full degree yet. I can also double the core count and RAM in no time if that would make any diff.

Share this post


Link to post
Share on other sites

I think web server and database connection limits need to be checked first since for me ofter connection hangs for a while or even times out.

But CPU and memory load needs to be checked too since i.e. "online users" (probably DB and CPU intensive page) always loads with a noticeable delay.

Share this post


Link to post
Share on other sites
(edited)
1 hour ago, zador.blood.stained said:

 

I think web server and database connection limits need to be checked first since for me ofter connection hangs for a while or even times out.

 

 

Upgrade to 8 core and 8G memory seems to provide no change at all.

 

I suspect problem with mySQL since when I click "online users", this happens:

Spoiler


  PID USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
 1103 mysql      20   0 2785M  177M 11036 S 114.  9.5  4:35.10 /usr/sbin/mysqld 
 4347 mysql      20   0 2785M  177M 11036 R 99.6  9.5  0:25.90 /usr/sbin/mysqld 

 

 

my.conf

Spoiler

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
ft_min_word_len=3

#forum *
interactive_timeout=30
wait_timeout=30

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 256K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 200
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#slow_query_log_file = /var/log/mysql/mysql-slow.log
#slow_query_log      = 1
#long_query_time = 2
#log_queries_not_using_indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M

 


With this hardware it should be as smooth as this.


Edit:
 

This command is super slow query_time: 11.154960:  

 

SELECT count(*) FROM `armcore_sessions` AS `core_sessions` WHERE ( core_sessions.id IN(SELECT MAX(id) FROM `armcore_sessions` AS `s` WHERE s.running_time>1488722103 AND s.login_type!=3 GROUP BY `member_id`) OR ( core_sessions.member_id IS NULL AND core_sessions.login_type != 3 AND core_sessions.running_time > 1488722103) )

Edited by Igor
Add super slow mysql command

Share this post


Link to post
Share on other sites

Might need to create a new index or indexes (maybe just drop and recreate existing?) on armcore_sessions containing id, running_time, login_type, member_id, running_time.

 

What indexes exist currently?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
1 1