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 | 315 views | 4 replies |

4/05/2024 2:45 pm | #1 Jay Core Global Media

Duplicate Content areas in powerCMS mysqli version

I can not figure why it is displaying double of the same area like this I downloaded the newest version of the zip file

4/06/2024 4:04 am | #2 Mags

I've got the same problem on just one PowerCMS site - I have a few sites using mySQLi and PowerCMS but this is only happening on one of them and I can't figure it out either! I'll have another look at the code and if I find out, I'll let you know.

4/08/2024 2:19 pm | #3 Jay Core Global Media

Thank you I appreciate it

4/10/2024 10:17 am | #4 Mags

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.

4/16/2024 7:41 pm | #5 Jay Core Global Media

thank you very much. this was driving me crazy!!!

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.