Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Design Extender › PowerCMS Builder › Duplicate Content areas in powerCMS mysqli version

Duplicate Content areas in powerCMS mysqli version

Thread began 4/05/2024 2:45 pm by Jay Core Global Media | Last modified 4/16/2024 7:41 pm by Jay Core Global Media | 316 views | 4 replies

4/10/2024 10:17 amMags

Hi Jay, I figured it out! I checked the recordset in the pages.php file and it's set to group by two columns:

GROUP BY ContentGroup, ContentPageSetOrder

For some reason, the value in ContentPageSetOrder has at some point changed from NULL to 0, so it was being treated as two separate 'groups' in the query (see screenshot of query attached, "About Us"). If you change the 0 values in the affected rows to NULL, you'll end up with just the one content group and it will then only display once.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.