Jump to content

SQL query to remove css class from post table


Day_

Recommended Posts

Posted

I've kinda borked my embeds. Been experiencing jumpy pages with multiple twitter embeds which I couldn't replicate when looking at other sites using the same software. I had restrictions on which limited embeds to 800px. I removed this thinking it could somehow be the magic trick that would fix it.

Does seem to behaving a bit better now. 

But, a member just reported a login issue when using Chrome, I use Safari myself across all devices. On opening Chrome I noticed all twitter embeds were showing as blank posts prior to this change.

I've nailed the issue down to this class ipsEmbeddedOther_limited inside the div. Remove and the tweet loads fine.

I know theres a query knocking around that can replace or remove bits of text from posts, is it possible to use one to remove this CSS class from post table, if so what would that be, thanking you!

 

Posted

It's ok, as usual find the solution 5 minutes after posting. :rofl:

UPDATE forums_posts SET post = REGEXP_REPLACE (
post,
'ipsEmbeddedOther_limited',
'');

Worked. Thanks @daveoh

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...