New forum software and technical committee

guys. we are just upgrading the software... you would probably not even notice.
matt3o
User avatar
-[°_°]-

Unread post06 Feb 2017, 07:55

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
Argh! PLEASE do something with the tables! Never seen such a pain to fill in a table!
Uploading multiple pictures at a time would be nice too!
elecplus
User avatar

Unread post06 Feb 2017, 22:27

User avatar
X
elecplus
 
Posts: 2855
Joined: 24 Jul 2014, 20:25
Location: Kerrville, TX, USA
Club member: 0082
 
I do have to hand it to phpBB for making a complete toilet of a table syntax. Last time I think I just inserted a screenshot of Excel, as it was completely impossible to make any sense out of phpBB tables. I'd have thought that you'd be able to do something similar to the list syntax, but with tags for "begin row" and "begin cell" instead of "begin list item". Tables aren't easy no matter what (MediaWiki table syntax is pretty hard to follow for all its supposed simplicity) but a list-like syntax should at least make very simple tables fairly painless.
Daniel Beardsmore
User avatar

Unread post06 Feb 2017, 23:06

User avatar
X
Daniel Beardsmore
 
Posts: 5103
Joined: 17 Aug 2011, 18:23
Location: Hertfordshire, England
Main keyboard: Filco Majestouch 1 (home)/Poker II backlit (work)
Main mouse: MS IMO 1.1
Favorite switch: Probably not whatever I wrote here
Club member: -
 
Hm. I just looked at tables for the first time. They are rather impenetrable, particularly if you just assume something simple will work... and haven't found the generator. What it needs is to assume some default values if the poster hasn't provided them. Really I (or any other HTML semi-literate who wanders along) ought to be able to do a simple table with just
Code: Select all
[table]
[tr][td]Cell1[/td][td]Cell2[/td][td]Cell3[/td][/tr]
[tr][td]A fourth cell[/td][td]Guess what[/td][td]And again[/td][/tr]
[/table]

I now understand why 7bit goes into monospace to do tables. Apart from aesthetic preference, of course. :D
citrojohn

Unread post07 Feb 2017, 00:16

X
citrojohn
 
Posts: 166
Joined: 26 Jul 2016, 13:54
Location: UK (Berkshire)
Main keyboard: Cherry G84-4400 (work) / Tipro MID (home)
Main mouse: Tiny trackball or laptop trackpad
Favorite switch: Model M, until I try something rarer ;)
 
The code isn't too bad in theory (it's just a rip-off of HTML), but it's incredibly fussy. You're not allowed one iota of whitespace, and it doesn't take too much data before the no-whitespace requirement becomes unmanageable, so much so that you can't even figure out where this bad whitespace even is, and you want to throw the whole computer out the window. Probably one of Satan's side projects when there weren't enough newcomers around.

HTML of course allows whitespace anywhere and sort-of ignores it, but that causes a load of weird problems of its own if you want readable HTML and functional presentation. Even with template-driven/code-generated HTML I still expect it to be presentable and readable. (I'd like a CSS option to turn off the useless whitespace as required.)

Lots of trade-offs with tables!
Daniel Beardsmore
User avatar

Unread post07 Feb 2017, 00:24

User avatar
X
Daniel Beardsmore
 
Posts: 5103
Joined: 17 Aug 2011, 18:23
Location: Hertfordshire, England
Main keyboard: Filco Majestouch 1 (home)/Poker II backlit (work)
Main mouse: MS IMO 1.1
Favorite switch: Probably not whatever I wrote here
Club member: -
 
elecplus wrote:Argh! PLEASE do something with the tables! Never seen such a pain to fill in a table!
Uploading multiple pictures at a time would be nice too!

Code: Select all
tables are super easy with [code][/code]
:evilgeek:
7bit
User avatar

Unread post08 Feb 2017, 12:27

User avatar
X
7bit
 
Posts: 13484
Joined: 31 Jan 2011, 23:37
Location: Berlin, DE
Main keyboard: Tipro / IBM 3270 emulator
Main mouse: Logitech granite for SGI
Favorite switch: MX Lock
Club member: 0001
 
matt3o wrote:
HuBandiT wrote:Other than that, when I browse the marketplace, sometimes I wish there was a way to catalogue buy%ell offers, so that we can put in permanent offers/interests to buy/sell (rare) X, and be automatically notified when a matching offer for X is posted even years down the road. (And I'm not saying this would be easy, or would make sense in the world of people trying to move stuff fast.)

this would fucking awesome!

if there is genuine interest, please open up a topic for it at the proper place, and let's slowly percolate ideas.
HuBandiT

Unread post15 Feb 2017, 00:50

X
HuBandiT
 
Posts: 134
Joined: 26 Oct 2015, 00:56
Location: Budapest, Hungary
Main keyboard: notebook built-in with goodness between G, H and B
Main mouse: pointing stick with a red dot, between G, H and B
Favorite switch: (newbie - jury is still out)
Club member: 0123
 
is operation "forum update" failed already? Where is my technical committee?! :P
matt3o
User avatar
-[°_°]-

Unread post03 Mar 2017, 07:00

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
I really like Discourse but it does take some getting used to. It’s modern and works well on mobile. I’m not sure how easy it is to migrate though.
Belfong
User avatar

Unread post04 Mar 2017, 06:53

User avatar
X
Belfong
 
Posts: 257
Joined: 24 Sep 2013, 11:41
Location: Malaysia
Main keyboard: HHKB Pro 2
Main mouse: Apple Magic Trackpad
Favorite switch: Topre!
Club member: -
 
In an effort to get this moving, what version of phpBB are we on currently? Are the DT-specific customizations available anywhere? A first step to upgrading would probably be running the latest locally with the DT plugins and styling, I'd imagine.

EDIT: Ahh I see in the previous page, 3.0.X is the current version. Is there an easy way for us to grab the custom plugins or whatever else is DT-specific to get it up and running locally and try a migration there?

EDIT EDIT: Here's a listing of 3.0.X tarballs: https://download.phpbb.com/pub/release/3.0/ not sure what particular patch version we're on, and apparently you can't find out without administrator rights.

It would also seem there are automatic patches between versions. If we're on 3.0.14, there is a premade patch to go from 3.0.14 to 3.2.latest. That seems like a worthwhile approach to explore, rather than attempting the earlier-mentioned manual diffing to create a patch ourselves:

https://www.phpbb.com/support/docs/en/3.../upgrade3/
pr0ximity
User avatar

Unread post12 May 2017, 03:18

User avatar
X
pr0ximity
 
Posts: 162
Joined: 18 Jul 2013, 17:07
Location: Maine, USA
Main keyboard: OTD 356 Mini V1
Main mouse: Mionix Avior 7000
Favorite switch: Beamspring
Club member: 0173
 
The upgrade docs from 3.0 -> 3.2 state: "phpBB 3.2 is not compatible with 3.0 and most of the previous files will need to be removed prior to upgrading."

So it sounds like we would basically need to re-write all of the styling and any custom plugins for 3.2. Styling doesn't sound very scary, so I suppose it will depend on what custom plugins we have and how many there are.
pr0ximity
User avatar

Unread post12 May 2017, 03:40

User avatar
X
pr0ximity
 
Posts: 162
Joined: 18 Jul 2013, 17:07
Location: Maine, USA
Main keyboard: OTD 356 Mini V1
Main mouse: Mionix Avior 7000
Favorite switch: Beamspring
Club member: 0173
 
we were able to convert the database and put a default theme over it, but we have to disable all the changes we made to the current version. Also we've found some issues in the formatting here and there and I wasn't able to pin point the problem.

The technical committee has been pretty lazy honestly, to that adds problem in my personal life and the upgrade basically stalled.... but it's still my top priority.
matt3o
User avatar
-[°_°]-

Unread post13 May 2017, 07:00

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
Cool, glad to hear there's been progress. Is there a test environment up somewhere with the converted DB and default theme? I'd be happy to help trying to get any of the DT functionality or themeing ported over.
pr0ximity
User avatar

Unread post13 May 2017, 22:19

User avatar
X
pr0ximity
 
Posts: 162
Joined: 18 Jul 2013, 17:07
Location: Maine, USA
Main keyboard: OTD 356 Mini V1
Main mouse: Mionix Avior 7000
Favorite switch: Beamspring
Club member: 0173
 
chuckdee
User avatar

Unread post14 May 2017, 00:55

User avatar
X
chuckdee
 
Posts: 671
Joined: 05 Mar 2016, 20:32
Location: USA
Main keyboard: Pok3r
Main mouse: Logitech g900
Favorite switch: Cherry MX Brown
Club member: 0151
 
chuckdee wrote:http://staging.deskthority.org/index.php

Heh, it looks like it is time to demolish that forum and pave over it with a new import / install, it seems to be infested with spammers.
JBert

Unread post14 May 2017, 13:25

X
JBert
 
Posts: 1090
Joined: 10 Mar 2011, 23:02
Location: Belgium, land of Liberty Wafles and Freedom Fries
Main keyboard: G80-3K with Clears
Favorite switch: Capacitative BS
Club member: 0049
 
OKAY!

Let's try this again.

I'll be working on the server update on and off today. I believe the previous approach was wrong.

The first thing to do is to clone 1:1 what we have now, disable all plugins we have and only then make the upgrade.

So today I'll try to do that. If anyone is around I'm also on discord ( https://discord.gg/3fbCdA ).

I'll keep you posted
matt3o
User avatar
-[°_°]-

Unread post27 Aug 2017, 08:44

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
Documenting everything I'm doing:

1) rsync from current server to staging (**** for security reasons). "w" is the wiki and we don't want that.

Code: Select all
rsync -zrp --exclude 'w' -e 'ssh -p****' ****@server.deskthority.net:/****/www/ /****/www/


2) get the latest database backup, change the db name and push it to the new server

Code: Select all
sed -i 's/old_db/staging_db/g' backup.sql
mysql -u user -p staging_db < backup.sql


3) access to myphpadmin and change any occurrence of `deskthority.net` with `staging.deskthority.org` in the phpbb_config table

4) download a copy of php3.0.13-PL1 from https://download.phpbb.com/pub/release/...13-PL1.zip

5) extract the base prosilver style and copy it to the styles directory. from the ADM panel make it the default style and deactivate all the others.

At this point you should have a pretty vanilla working phpbb forum at staging.deskthority.net. For some reasons though the .XMOD tab in the admin console is not visible.
matt3o
User avatar
-[°_°]-

Unread post27 Aug 2017, 15:19

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
Next to remove all extensions:

6) In the admin console: system > administration > module management > [disable all mods] and clear cache

7) Go to system > general tasks > language packs > [delete everything except British english]

8) check phpbb_ext and phpbb_modules tables for left overs

Time to upgrade:

9) download latest phpbb, unzip and delete config.php file and images/ files/ and store/ directories

10) move to the installation directory and delete everything apart from the above files (beware of the additional directories like the wiki and the stats)

11) move everything from the new forum directory to the installation directory

12) go to staging.deskthority.org/install and do an upgrade

If all went well you should have a working upgraded phpbb.

You can check it at staging.deskthority.org
user: dtstaging
password hint: My name is _______. You killed my father. Prepare to die.
(no spaces)

Contrary to our previous install everything seems to be working now.
matt3o
User avatar
-[°_°]-

Unread post27 Aug 2017, 16:32

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
So it seems we have to run some regex on the database to zero all the mods that have been made in the past. I'll keep you posted.

Also, our beloved duck master found a nice theme we could use as a scaffolding for the new forum https://www.phpbb.com/customise/db/styl...e/demo/3.2
matt3o
User avatar
-[°_°]-

Unread post28 Aug 2017, 07:53

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
Let's move to fixing the quotes.

13)
Code: Select all
update phpbb_posts set post_text = regexp_replace(post_text, '[[](quote=(&quot;|")[^&"]*(&quot;|"));p=([0-9]*)(:[a-z0-9A-Z]*)?[]]', '[\\1 post_id=\\4\\5]') where post_id > 169635;


That is what I came out with very quickly. It should convert from our own quote system to phpbb3.2's. I start from id 169635 because I believe that's where webwit updated the software.

14) Now it's time to reparse all bbcodes

Code: Select all
bin/phpbbcli.php reparser:reparse


Now. For some reason some of the quotes didn't actually render properly and at the moment I have to clue why that happens.

I've also updated the theme to the one we found. It looks half decent but it surely need some updates.

PLEASE check and report! (details at point #12)
matt3o
User avatar
-[°_°]-

Unread post28 Aug 2017, 14:14

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
not one single feedback? :/
matt3o
User avatar
-[°_°]-

Unread post30 Aug 2017, 22:49

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
Welcome to the Club.
Daniel Beardsmore
User avatar

Unread post30 Aug 2017, 23:04

User avatar
X
Daniel Beardsmore
 
Posts: 5103
Joined: 17 Aug 2011, 18:23
Location: Hertfordshire, England
Main keyboard: Filco Majestouch 1 (home)/Poker II backlit (work)
Main mouse: MS IMO 1.1
Favorite switch: Probably not whatever I wrote here
Club member: -
 
matt3o wrote:not one single feedback? :/

matt3o wrote:[…] You can check it at staging.deskthority.org
user: dtstaging
password hint: My name is _______. You killed my father. Prepare to die. […]

If only you had chosen such a password that the password hint would be e.g.
"quousque tandem abutere, ______" or "Delenda est ________",
I would have been able to access the site. :lol:
kbdfr
User avatar
The Tiproman

Unread post31 Aug 2017, 08:39

User avatar
X
kbdfr
The Tiproman
 
Posts: 4493
Joined: 24 Mar 2011, 13:06
Location: Berlin, Germany
Main keyboard: Tipro MID-QM-128A + two Tipro matrix modules
Main mouse: Contour Rollermouse Pro
Favorite switch: Cherry black
Club member: 0010
 
really?

Spoiler:
Screenshot_20170831_094807.png
matt3o
User avatar
-[°_°]-

Unread post31 Aug 2017, 08:47

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
I didn't want to do a Google search with such keywords like "kill" and "die",
which the algorithm would understand as an expression of interest,
thus exerting a corresponding influence on the results of future searches.
:lol:

Spoiler:
To be honest, I wanted to again criticize the ubiquitous use of war, violence and similar references.
kbdfr
User avatar
The Tiproman

Unread post31 Aug 2017, 10:13

User avatar
X
kbdfr
The Tiproman
 
Posts: 4493
Joined: 24 Mar 2011, 13:06
Location: Berlin, Germany
Main keyboard: Tipro MID-QM-128A + two Tipro matrix modules
Main mouse: Contour Rollermouse Pro
Favorite switch: Cherry black
Club member: 0010
 
kbdfr wrote:I didn't want to do a Google search with such keywords like "kill" and "die", which the algorithm would understand as an expression of interest, thus exerting a corresponding influence on the results of future searches.

105.jpg
seebart
User avatar
Offtopicthority Instigator

Unread post31 Aug 2017, 10:17

User avatar
X
seebart
Offtopicthority Instigator
 
Posts: 10507
Joined: 22 Nov 2013, 20:20
Location: Germany
Main keyboard: Rotation
Main mouse: Steelseries Sensei
Favorite switch: IBM capacitive buckling spring
Club member: 0061
 
I built a script to fix the not-parsed "quote" bbcode. All needed to do is to run it as the very last step.

Now I guess we need to fix the theme a bit and reintroduce the "spy" and whatever is needed.

Honestly, we end up with a pretty messy database... but what could you do?
matt3o
User avatar
-[°_°]-

Unread post04 Sep 2017, 11:47

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
 
This signature intentionally left blank...
All I will say is, don't bring back the abominable bump hammer mod. It seems to permanently clobber the timestamp on the most recent bug and whoever came up with that abortion should be shot. And then hanged. And shot again.
Daniel Beardsmore
User avatar

Unread post04 Sep 2017, 20:43

User avatar
X
Daniel Beardsmore
 
Posts: 5103
Joined: 17 Aug 2011, 18:23
Location: Hertfordshire, England
Main keyboard: Filco Majestouch 1 (home)/Poker II backlit (work)
Main mouse: MS IMO 1.1
Favorite switch: Probably not whatever I wrote here
Club member: -
 
both webwit and I are pretty busy these days so things are proceeding slowly. Also the technical committee bailed on us so we are alone.

sooner or later it will happen. be patient.
matt3o
User avatar
-[°_°]-

Unread post09 Sep 2017, 17:42

User avatar
X
matt3o
-[°_°]-
 
Posts: 8325
Joined: 03 Sep 2012, 15:14
Location: Italy
Main keyboard: WhiteFox
Main mouse: Anywhere MX
Favorite switch: Anything, really
Club member: 0030
 
Previous

Who is online

Users browsing this forum: No registered users and 8 guests