Sponsored Content
The Lounge What is on Your Mind? Update on vB3 Migration to Discourse - Issues and Status of BBCode Transformations Post 303045639 by Neo on Sunday 5th of April 2020 10:39:09 AM
Old 04-05-2020
Well, as a update, this earlier MariaDB REGEX was flawed, my bad.

Code:
UPDATE post SET  pagetext= LOWER(REGEXP_REPLACE(pagetext,'\\[ATTACH\\](.*)\\[\\/ATTACH\\]', '[IMG]https://www.unix.com/attachment.php?attachmentid=\\1[/IMG]'));

Should have been

Code:
UPDATE post SET  pagetext= REGEXP_REPLACE(pagetext,'\\[ATTACH\\](.*?)\\[\\/ATTACH\\]', '[IMG]https://www.unix.com/attachment.php?attachmentid=\\1[/IMG]');

Using the LOWER directive not only worked on the REGEX, but on all text in the post, moving all text to lower case (unexpectedly). That will be fixed after 12 hours of rebaking the 1M posts.

In addition, my original REGEX was too greedy and I had to add the ? to make it less greedy. Somehow, I missed that during initial testing.

Thanks to @Peasant for catching that bug quickly today.

We are "mind warped" writing and rewriting all this (new to us) Ruby migration code. The extra eyes, fresh perspectives, and bug hunting all are much appreciated and valuable contributions to the final migration success (whenever that happens, LOL)
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script migration issues

Hi All, We will be doing a Solaris 8 to Solaris 10 migration migration, just wanted to know if there are any known / common issues arise from this migration from Shell script point of view. I tried searching this site but mostly post are related to SA's question and jumpstart, etc. If there's... (4 Replies)
Discussion started by: arvindcgi
4 Replies

2. HP-UX

Migration - Compiler Issues.

All, We are migrating an application from HP-UX B.11.00 to HP-UX B.11.31 and both of them have the same informix version - 7.25se. However the compilers are different on both servers. HP-UX B.11.00 - has B3913DB C.03.33 HP aC++ Compiler (S800) HP-UX B.11.31 - has PHSS_40631 1.0 HP C/aC++... (2 Replies)
Discussion started by: helper
2 Replies

3. Programming

How to track table status delete/update/insert status in DB2 V10 z/os?

Dear Team I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update ) Scenario We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted... (1 Reply)
Discussion started by: Perlbaby
1 Replies

4. What is on Your Mind?

Status of Migration of Moderation Systems

First a bit of history .... A number of years ago one of our admins built a number of plugin systems for moderation, including (1) a voting system, (2) a "user feelings" system and (3) a confidential posting system. During this time, I was busy on other projects, not very active in the forums,... (1 Reply)
Discussion started by: Neo
1 Replies

5. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Two

OK. Like we all do, we learn a lot from tests, test migrations, and so forth. Today, I started from scratch on test migration 2, armed with a lot more knowledge, The main differences are as follows: Installed discourse plugin ruby-bbcode-to-md before starting the install Modified... (30 Replies)
Discussion started by: Neo
30 Replies

6. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Four

Test Build 4 on New Server, with changes identified in discourse test builds 2 and 3, primarily: Insuring ruby-bbcode-to-markdown is enabled. Removing line breaks from ICODE to markdown in migration script. Added vbpostid to posts in discourse to setup migrating vb "thanks" to discourse... (28 Replies)
Discussion started by: Neo
28 Replies
VILISTEXTUM(1)						      General Commands Manual						    VILISTEXTUM(1)

NAME
vilistextum - html to ascii converter SYNOPSIS
vilistextum [OPTIONS] [inputfile |-] [outputfile | -] DESCRIPTION
vilistextum is a html to ascii converter specifically programmed to get the best out of incorrect html. OPTIONS
inputfile,- resp. outputfile,- replace inputfile with '-' for reading from standard input, likewise outputfile with '-' for writing to standard output. -a, --no-alt don't output anything for IMG tags even if they have an ALT attribute. Implies --no-image. -c, --convert-tags some tags will be converted to special characters. -e, --errorlevel NUMBER increase level of verbosity for error messages (0: No error messages). -i, --defimage STRING IMG tags without alt attribute are output as [STRING]. -l, --links numbers the links in the document and creates footnotes of each link at the end of the file. -k, --links-inline print the links directly after the html tag. -m, --dont-convert-characters don't convert the entities from windows1252 (&#128;-&#159; and their proper entity names) -n, --no-image don't output [Image] for IMG tags that have no ALT attribute. -p, --palm output text more suitable for reading on a PDA. -r, --remove-empty-alt if there is an empty ALT attribute in a IMG tag (eg <IMG href="..." alt="">), don't output '[]'. -s, --shrink-lines [NUMBER] if there are more than NUMBER empty lines, output only NUMBER. Default: 1. -t, --no-title don't output title. -w, --width NUMBER maximum line width. -h, --help display this help and exit -v, --version output version information and exit MULTIBYTE OPTIONS (Only available if compiled with multibyte support) -u, --output-utf-8 instead of the character set of the html document, everything will be output as utf-8. -x, --translit use the //TRANSLIT feature of libiconv. Consult the iconv manual for details. -y, --charset CHARSET if the HTML document doesn't provide a character set in the meta tags, use CHARSET. LIMITATIONS
The rendering of tables is not very good. The handling of OL is incomplete. The program treats it as UL and more than 10 nested lists confuse it. Text is never justified. REPORTING BUGS
Please report bugs to <bhaak@gmx.net>. AUTHOR
Vilistextum was written by Patric Mueller <bhaak@gmx.net> and may be freely distributed under the terms of the GNU General Public License Version 2. There is ABSOLUTELY NO WARRANTY for this program. SEE ALSO
iconv(3), lynx(1), links(1), w3m(1) 22 OCT 2006 VILISTEXTUM(1)
All times are GMT -4. The time now is 04:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy