after my database transfer

[ringnews24]

I've noticed a few things after my database transfer


1. I have a boxing video section with thousands of videos (youtube embeds/daily motion scripts etc..) Now no videos are showing

2. attachment from the old arent showing.

3. Searching the forum only shows up posts after the transfer.

[Hartmut]

From where did you import?

[ringnews24]

From where did you import?

phpbb2

[Hartmut]

Concerning your videos... I guess that the bb code is different, did you check that already?

[Lynne]

Did you Rebuild the Search Index after the import?

[ringnews24]

Did you Rebuild the Search Index after the import?

I rebuilt the search again and its now sorted.

The youtube videos were like this code.

<iframe width="560" height="315" src="http://www.youtube.com/embed/ajM3MSk6RMQ?list=UU06OTfoQi0ne7MjzkLR9qEQ&amp;hl=en_GB" frameborder="0" allowfullscreen></iframe>

The above code worked on old site but not on the new one.

[ringnews24]

Any updates or suggestions regarding the youtube videos?

Thanks

[Wayne Luke]

I rebuilt the search again and its now sorted.

The youtube videos were like this code.

<iframe width="560" height="315" src="http://www.youtube.com/embed/ajM3MSk6RMQ?list=UU06OTfoQi0ne7MjzkLR9qEQ&amp;hl=en_GB" frameborder="0" allowfullscreen></iframe>

The above code worked on old site but not on the new one.

Really depends on how you have this done. Your previous blocks and widgets are most likely not compatible and probably were not imported. If they are posts in a thread, you will need to make sure that HTML is turned on in the Forum Options within the Forum Manager. This is a security risk though and you should rebuild them with the [video] bbcode.

[ringnews24]

How high a security risk is this Lynne?

How to I rebuild them with the bbcode? Do you mean manually? I have thousands of videos.

[Wayne Luke]

I don't know of any way to automate such a conversion. You might check vBulletin.org. Maybe someone can help you write a plugin that will do it.

[Mike1969]

I'd suggest running a MySQL query on the db and do the whole thing throughout the whole database, in one or two query steps. It will work. You'll be replacing a certain set of chars with a new set of chars, to reconstruct the links to the videos.

Something like this:
UPDATE [table] SET [column] = REPLACE([column],'<iframe width="560" height="315" src="http://www.youtube.com/embed/', 'whatever the correct opening embed code is');

then run something like this:
UPDATE [table] SET [column] = REPLACE([column],'</iframe>', 'whatever the correct embed closing code is');

Be sure to backup your db before running any actual sql commands on the db.