angle4cor Posted January 25, 2023 Share Posted January 25, 2023 (edited) 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, 2023 by angle4cor Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 25, 2023 Share Posted January 25, 2023 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 Link to comment Share on other sites More sharing options...
angle4cor Posted January 25, 2023 Author Share Posted January 25, 2023 Maybe someone with SQL knowledge could help? I've tried to Select them with "%<p></p>...%", but was unsuccessful. Link to comment Share on other sites More sharing options...
Luuuk Posted January 25, 2023 Share Posted January 25, 2023 @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: angle4cor and SeNioR- 1 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 25, 2023 Share Posted January 25, 2023 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 Link to comment Share on other sites More sharing options...
angle4cor Posted January 25, 2023 Author Share Posted January 25, 2023 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! Link to comment Share on other sites More sharing options...
Recommended Posts