Hello, 

I've recently merged two Invision Community boards. I've noticed that posts on one of those have multiple "enters" typed in.

Example:

Quote

 

"

 

 

 

abcdf

 

 

 

abcdf

 

 

abcdf

 

 

 

"

 

When looking it up in the database, it looks like this:

 

"

<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> abcd </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> abcd </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p> </p>
<p></p>
<p>abcd</p>
<p></p>
<p> </p>
<p> </p>

 

What could cause this issue and how to solve it? Is there a way to remove the additional <p>< /p> tags in SQL to remove them? 

Edited January 25, 20232 yr by angle4cor

These are likely to be being caused by people on samsung devices using the samsung browser. Unfortunately there isnt anything to resolve it at present, as its genuine text they are posting

Maybe someone with SQL knowledge could help? I've tried to Select them with "%<p></p>...%", but was unsuccessful. 

@angle4cor

In the old archived topic found via Google there is a tip that to make sure the exact characters are targeted you should copy the "p" combinations directly from a database table instead of "typing" them.

BTW. A temporary "workaround" could be to use "Trim Empty Lines" plugin but the downside is that only a "view" is altered:

We are unable to advise on direct removal of items from the database, unfortunately. I have moved your topic to our community support area, in case others may be able to assist you with this

2 hours ago, Luuuk said:

@angle4cor

In the old archived topic found via Google there is a tip that to make sure the exact characters are targeted you should copy the "p" combinations directly from a database table instead of "typing" them.

BTW. A temporary "workaround" could be to use "Trim Empty Lines" plugin but the downside is that only a "view" is altered:

Thanks. I will use this widget!