I recently upgraded my hosting to a new server and was getting the message that I had an incorrect use of limit and union. I believe it was because I was running an older version of Family Connections-3.2.0. I was able to upgrade to 3.7.0 but now my Home screen is mostly blank. There is the calendar, upcoming, and members online on the left, but under What's New there is nothing. I tried to add a new status and after I clicked submit nothing happened. I can't roll back to any version except 3.2.0, unless there is a way to manually upgrade my database to a version in between. I can add messages to a thread and those go through okay, but do not appear on the home page.
I did a fresh install of Family Connections 3.7 then connected it to my existing database. That seemed to resolve many of the PHP errors I was getting before. Now under What's New I see:
My own photos that have been added, but no one else's.
Notifications of someone joining the site
Videos that anyone has posted (from years ago)
Documents from 5 years ago, but there have been many documents added since then
Comments from 5 years ago, also have had many comments since then.
I'm attaching the home.php file that I am using for this install, maybe that will help. I had to rename is as a text file in order to upload it.
When I did the fresh install I created a new DB so the install would finish correctly. I changed the config file to point to a copy of my old DB for testing purposes. I had to add 2 new DB columns into user for phpass and token, then my PHP errors went away.
After sending the earlier message, I reconnected the config file to the new DB and all of the status messages are appearing as they should. I think I need to look through the DB tables and see if there is something missing between the old one and the new one. If you can think of anything off the top of your head that might not have updated properly let me know! Thanks so much for a wonderful product. Our family has been using this for 5 years now.