Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Update on vB3 Migration to Discourse - Issues and Status of BBCode Transformations
The Lounge What is on Your Mind? Update on vB3 Migration to Discourse - Issues and Status of BBCode Transformations Post 303045598 by Neo on Friday 3rd of April 2020 12:05:05 AM
Old 04-03-2020
Also, I am finding, by trial and error, that even before preprocessing with the Ruby migration scripts, there are some transformations which are easily done on the copy of the vB3 MySQL DB dump; for example:

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

There was some bug in the Ruby attachment preprocessing and some attachment ids were lost, so instead of wasting time trying to find the bug in the Ruby preprocessing routine, it was easier to do the regex search and replace in the staged copy of the DB dump.

All these attachment images are automatically downloaded to the new discourse forum over time as well.

Note: Not being an expert in MariaDB REGEX_REPLACE, started with (.*) and worked my way up, and the matches only worked with the double backslashes (escapes) , would not match with single backslashes. None of the examples on the net worked (most showed no backslashes or one backslash only) in this REGEX_REPLACE expression; but I could get it to work, building it from .* up, step-by-step.

Update: This change is done and confirmed working on the staging server.
This User Gave Thanks to Neo For This Post:
vbe
 

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

LEARN ABOUT CENTOS

glframebufferrenderbuffer

GLFRAMEBUFFERRENDERB(3G)					   OpenGL Manual					  GLFRAMEBUFFERRENDERB(3G)

NAME

       glFramebufferRenderbuffer - attach a renderbuffer as a logical buffer to the currently bound framebuffer object

C SPECIFICATION

       void glFramebufferRenderbuffer(GLenum target, GLenum attachment, GLenum renderbuffertarget, GLuint renderbuffer);

PARAMETERS

       target
	   Specifies the framebuffer target.  target must be GL_DRAW_FRAMEBUFFER, GL_READ_FRAMEBUFFER, or GL_FRAMEBUFFER.  GL_FRAMEBUFFER is
	   equivalent to GL_DRAW_FRAMEBUFFER.

       attachment
	   Specifies the attachment point of the framebuffer.

       renderbuffertarget
	   Specifies the renderbuffer target and must be GL_RENDERBUFFER.

       renderbuffer
	   Specifies the name of an existing renderbuffer object of type renderbuffertarget to attach.

DESCRIPTION

       glFramebufferRenderbuffer attaches a renderbuffer as one of the logical buffers of the currently bound framebuffer object.  renderbuffer is
       the name of the renderbuffer object to attach and must be either zero, or the name of an existing renderbuffer object of type
       renderbuffertarget. If renderbuffer is not zero and if glFramebufferRenderbuffer is successful, then the renderbuffer name renderbuffer
       will be used as the logical buffer identified by attachment of the framebuffer currently bound to target.

       The value of GL_FRAMEBUFFER_ATTACHMENT_OBJECT_TYPE for the specified attachment point is set to GL_RENDERBUFFER and the value of
       GL_FRAMEBUFFER_ATTACHMENT_OBJECT_NAME is set to renderbuffer. All other state values of the attachment point specified by attachment are
       set to their default values. No change is made to the state of the renderbuuffer object and any previous attachment to the attachment
       logical buffer of the framebuffer target is broken.

       Calling glFramebufferRenderbuffer with the renderbuffer name zero will detach the image, if any, identified by attachment, in the
       framebuffer currently bound to target. All state values of the attachment point specified by attachment in the object bound to target are
       set to their default values.

       Setting attachment to the value GL_DEPTH_STENCIL_ATTACHMENT is a special case causing both the depth and stencil attachments of the
       framebuffer object to be set to renderbuffer, which should have the base internal format GL_DEPTH_STENCIL.

ERRORS

       GL_INVALID_ENUM is generated if target is not one of the accepted tokens.

       GL_INVALID_ENUM is generated if renderbuffertarget is not GL_RENDERBUFFER.

       GL_INVALID_OPERATION is generated if zero is bound to target.

SEE ALSO

       glGenFramebuffers(), glBindFramebuffer(), glGenRenderbuffers(), glFramebufferTexture(), glFramebufferTexture1D(), glFramebufferTexture2D(),
       glFramebufferTexture3D()

COPYRIGHT

       Copyright (C) 2010 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
       License, v 1.0, 8 June 1999.  http://opencontent.org/openpub/.

AUTHORS

       opengl.org

opengl.org							    06/10/2014						  GLFRAMEBUFFERRENDERB(3G)
All times are GMT -4. The time now is 07:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy