angle4cor Posted January 25, 2023 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
Marc Posted January 25, 2023 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
angle4cor Posted January 25, 2023 Author Posted January 25, 2023 Maybe someone with SQL knowledge could help? I've tried to Select them with "%<p></p>...%", but was unsuccessful.
Luuuk Posted January 25, 2023 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: SeNioR- and angle4cor 1 1
Marc Posted January 25, 2023 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
angle4cor Posted January 25, 2023 Author 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!
Recommended Posts