Too late to run cleaner?

[RedTrinity]

Hi guys,

About 5 days ago I did a PHPBB3>VB import, however found the whole cleaner.php proceedure to be quite confusing so I left it be. Since then I have built the forum up, directed all of our users over and installed a few plug-ins etc. and its now in full use as our main forum.

However of course we now face the problem of all our previous posted BBcode tags being unparsed.

So my question is, would it be too late to run cleaner.php now? I still haven't removed Impex from the ACP or the server, so its still accessible.

If not, I would also appreciate some help with settings, as I don't feel confident that I know what I am doing. Is there a pre-done script or something with all the default PHPBB3 BBCode settings set into it which I can use perhaps?

Thanks in advance for any info/advice!

Regards,

Nikki :)

[Steve Machol]

No, you can still run it.

[RedTrinity]

Ok thanks Steve, may I also get an answer to this bit?


I would also appreciate some help with settings, as I don't feel confident that I know what I am doing. Is there a pre-done script or something with all the default PHPBB3 BBCode settings set into it which I can use perhaps?


Thanks again :)

[Steve Machol]

That depends on what you want to change exactly. The instructions are actually in the cleaner.php code.

[RedTrinity]

Ok, so how do I do IMG and URL tags? What should the result code be if I cannot include a universal URL for either?

These are the 2 in particular that confused me.

Cheers :)

[Steve Machol]

I do not believe that is possible. The text you want to change with cleaner.php will need to be consistent.

[RedTrinity]

So there is no way whatsoever to get it to fix IMG and URL BBcode tags? :confused: Bummer.

[Jerry]

So there is no way whatsoever to get it to fix IMG and URL BBcode tags? :confused: Bummer.

Depends on what the tags are, if there is unique id code inside the tags you'll need to use a regex (regular expression) to catch them.

[RedTrinity]

Umm I think they are just the normal PHPBB [img.][/img.] and [url.][/url.] tags. Since converting to VB the old BBcode tags in previous content are all unparsed (ie. just displaying the text instead of the url/picture).

If this can be fixed somehow, it would be fantastic.

Cheers for your help :)

[Jerry]

So the tags look ok, it's just that they are displaying the bbcode opposed to being parsed into links and pictures etc ?

[RedTrinity]

So the tags look ok, it's just that they are displaying the bbcode opposed to being parsed into links and pictures etc ?

Yep thats correct :)

A post showing these older tags can be easily fixed by hitting 'edit post' and then 'submit' so that the software re-parses them automatically, but when you have 250,000 posts its going to be impossible to do them all manually lol.

[RedTrinity]

Bump :)

[Jerry]

Is it this ?

http://www.vbulletin.com/forum/showpost.php?p=1485570&postcount=10

[RedTrinity]

Is it this ?

http://www.vbulletin.com/forum/showpost.php?p=1485570&postcount=10

Hi Jerry,

Yes that is indeed the problem I am having! Is there a PHPMyAdmin version of the fix, though? I don't use MySQL :(

Thanks again in advance for any further help :)

[Jerry]

PhpMyAdmin is just a tool that allows your to access the database, there is a tab there called "SQL" from which you can run the SQL.

[RedTrinity]

Oh ok, I must be having another problem then as I tried running those queries and got the following error:

Error SQL query:
UPDATE redrin_post SET pagetext = REPLACE( pagetext, ".", "." ) UPDATE redtrin_post SET pagetext = REPLACE( pagetext, ":", ":" )
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE redtrin_post SET pagetext=REPLACE(pagetext,":",":")' at line 2

This was after changing the table prefixes to my own, and removing the white spaces as instructed :confused:

[RedTrinity]

Bumping as I am still looking for a solution to this :)

[Jerry]

This SQL :


UPDATE redrin_post SET pagetext = REPLACE( pagetext, ".", "." ) UPDATE redtrin_post SET pagetext = REPLACE( pagetext, ":", ":" )


Has two issues, one is that you're replacing what you're finding so it's going to do nothing, replacing a full stop with a full stop and a colon with a colon. Secondly you need to either need to run the commands separately or separate them with a semi-colon.


UPDATE redrin_post SET pagetext = REPLACE(pagetext,"& #46;",".");
UPDATE redtrin_post SET pagetext = REPLACE(pagetext,"& #58;",":");

[RedTrinity]

Ok, starting to get frustrated with this :(

I have run the last SQL commands you provided (exactly as they are) and now I am getting this error...

MySQL said:
#1146 - Table 'redtrin_forums.redrin_post' doesn't exist But there IS a redtrin_post table, as you can see...

http://img.photobucket.com/albums/v630/redtrinity/screenie2.jpg

I don't get what I am doing wrong this time round :confused:

Thanks for your help.

[Jerry]

Missing the "t" :


UPDATE redtrin_post SET pagetext = REPLACE(pagetext,"& #46;",".");
UPDATE redtrin_post SET pagetext = REPLACE(pagetext,"& #58;",":");

[RedTrinity]

Thank you Jerry, problem finally solved :) Very happy!

Cheers :D